home / fivethirtyeight

Rare Pepes: pepecash_prices.csv

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

491 rows

View and edit SQL

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

Next page

Advanced export

JSON shape: default, array

CSV options:

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