home / fivethirtyeight

Menu
  • GraphQL API

Rare Pepes: pepecash_prices.csv

Table actions
  • GraphQL API for rare-pepes/pepecash_prices

This table contains data behind the story Can The Blockchain Turn Pepe The Frog Into Modern Art? There are four data files, described below. You can also find further information about individual Rare Pepe assets at Rare Pepe Wallet.

ordermatches_all.csv contains all Rare Pepe order matches from the beginning of the project, in late 2016, until Feb. 3. All order matches include a pair of assets (a “forward asset” and a “backward asset”) one of which is a Rare Pepe and the other of which is either XCP, the native Counterparty token, or Pepe Cash. The time of the order match can be determined by the block.

Header Definition
Block The block number
ForwardAsset The type of forward asset
ForwardQuantity The quantity of forward asset
BackwardAsset The type of backward asset
BackwardQuantity The quantity of backward asset

blocks_timestamps.csv is a pairing of block and timestamp. This can be used to determine the actual time an order match occurred, which can then be used to determine the dollar value of Pepe Cash or XCP at the time of the trade.

Header Definition
Block The block number
Timestamp A Unix timestamp

pepecash_prices.csv contains the dollar price of Pepe Cash over time.

Header Definition
Timestamp A Unix timestamp
Price The price of Pepe Cash in dollars

xcp_prices.csv contains the dollar price of XCP over time.

Header Definition
Timestamp A Unix timestamp
Price The price of XCP in dollars

Source: Rare Pepe Foundation

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

491 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ Timestamp Price
1 1 1517558400 0.052494
2 2 1517472000 0.041177
3 3 1517385600 0.062411
4 4 1517299200 0.064185
5 5 1517212800 0.071138
6 6 1517126400 0.073951
7 7 1517040000 0.074749
8 8 1516953600 0.068029
9 9 1516867200 0.083559
10 10 1516780800 0.080997
11 11 1516694400 0.08114
12 12 1516608000 0.083045
13 13 1516521600 0.081705
14 14 1516435200 0.090579
15 15 1516348800 0.080852
16 16 1516262400 0.078178
17 17 1516176000 0.072366
18 18 1516089600 0.07412
19 19 1516003200 0.095134
20 20 1515916800 0.102838
21 21 1515830400 0.106787
22 22 1515744000 0.115223
23 23 1515657600 0.109222
24 24 1515571200 0.106706
25 25 1515484800 0.116976
26 26 1515398400 0.110266
27 27 1515312000 0.120229
28 28 1515225600 0.108051
29 29 1515139200 0.088338
30 30 1515052800 0.079675
31 31 1514966400 0.081996
32 32 1514880000 0.086743
33 33 1514793600 0.086812
34 34 1514707200 0.088227
35 35 1514620800 0.079904
36 36 1514534400 0.090827
37 37 1514448000 0.093548
38 38 1514361600 0.102534
39 39 1514275200 0.09547
40 40 1514188800 0.084246
41 41 1514102400 0.084107
42 42 1514016000 0.090594
43 43 1513929600 0.089341
44 44 1513843200 0.111803
45 45 1513756800 0.106039
46 46 1513670400 0.109168
47 47 1513584000 0.125219
48 48 1513497600 0.104159
49 49 1513411200 0.107783
50 50 1513324800 0.099389
51 51 1513238400 0.100423
52 52 1513152000 0.088593
53 53 1513065600 0.105514
54 54 1512979200 0.118943
55 55 1512892800 0.101724
56 56 1512806400 0.103959
57 57 1512720000 0.107952
58 58 1512633600 0.097956
59 59 1512547200 0.054051
60 60 1512460800 0.054997
61 61 1512374400 0.035017
62 62 1512288000 0.0316
63 63 1512201600 0.027274
64 64 1512115200 0.028664
65 65 1512028800 0.026556
66 66 1511942400 0.026631
67 67 1511856000 0.030907
68 68 1511769600 0.02816
69 69 1511683200 0.027919
70 70 1511596800 0.025108
71 71 1511510400 0.025555
72 72 1511424000 0.025915
73 73 1511337600 0.023768
74 74 1511251200 0.025279
75 75 1511164800 0.027414
76 76 1511078400 0.027287
77 77 1510992000 0.028152
78 78 1510905600 0.026247
79 79 1510819200 0.027382
80 80 1510732800 0.025205
81 81 1510646400 0.023224
82 82 1510560000 0.022858
83 83 1510473600 0.021749
84 84 1510387200 0.022281
85 85 1510300800 0.02283
86 86 1510214400 0.027705
87 87 1510128000 0.019067
88 88 1510041600 0.01991
89 89 1509955200 0.018745
90 90 1509865200 0.017852
91 91 1509778800 0.017368
92 92 1509692400 0.017605
93 93 1509606000 0.020957
94 94 1509519600 0.019657
95 95 1509433200 0.020507
96 96 1509346800 0.019744
97 97 1509260400 0.021732
98 98 1509174000 0.019559
99 99 1509087600 0.021037
100 100 1509001200 0.021923

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "rare-pepes/pepecash_prices" (
"Timestamp" INTEGER,
  "Price" REAL
);
Powered by Datasette · Queries took 5.126ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette