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

Link rowid ▼ Timestamp Price
1 1517558400 0.052494
2 1517472000 0.041177
3 1517385600 0.062411
4 1517299200 0.064185
5 1517212800 0.071138
6 1517126400 0.073951
7 1517040000 0.074749
8 1516953600 0.068029
9 1516867200 0.083559
10 1516780800 0.080997
11 1516694400 0.08114
12 1516608000 0.083045
13 1516521600 0.081705
14 1516435200 0.090579
15 1516348800 0.080852
16 1516262400 0.078178
17 1516176000 0.072366
18 1516089600 0.07412
19 1516003200 0.095134
20 1515916800 0.102838
21 1515830400 0.106787
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.102534
39 1514275200 0.09547
40 1514188800 0.084246
41 1514102400 0.084107
42 1514016000 0.090594
43 1513929600 0.089341
44 1513843200 0.111803
45 1513756800 0.106039
46 1513670400 0.109168
47 1513584000 0.125219
48 1513497600 0.104159
49 1513411200 0.107783
50 1513324800 0.099389
51 1513238400 0.100423
52 1513152000 0.088593
53 1513065600 0.105514
54 1512979200 0.118943
55 1512892800 0.101724
56 1512806400 0.103959
57 1512720000 0.107952
58 1512633600 0.097956
59 1512547200 0.054051
60 1512460800 0.054997
61 1512374400 0.035017
62 1512288000 0.0316
63 1512201600 0.027274
64 1512115200 0.028664
65 1512028800 0.026556
66 1511942400 0.026631
67 1511856000 0.030907
68 1511769600 0.02816
69 1511683200 0.027919
70 1511596800 0.025108
71 1511510400 0.025555
72 1511424000 0.025915
73 1511337600 0.023768
74 1511251200 0.025279
75 1511164800 0.027414
76 1511078400 0.027287
77 1510992000 0.028152
78 1510905600 0.026247
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.019067
88 1510041600 0.01991
89 1509955200 0.018745
90 1509865200 0.017852
91 1509778800 0.017368
92 1509692400 0.017605
93 1509606000 0.020957
94 1509519600 0.019657
95 1509433200 0.020507
96 1509346800 0.019744
97 1509260400 0.021732
98 1509174000 0.019559
99 1509087600 0.021037
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
);