home / fivethirtyeight

Menu
  • GraphQL API

Rare Pepes: xcp_prices.csv

Table actions
  • GraphQL API for rare-pepes/xcp_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

520 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ Timestamp Price
1 1 1517558400 32.75
2 2 1517472000 33.52
3 3 1517385600 43.16
4 4 1517299200 44.83
5 5 1517212800 53.25
6 6 1517126400 59.47
7 7 1517040000 56.05
8 8 1516953600 50.57
9 9 1516867200 56.33
10 10 1516780800 59.29
11 11 1516694400 57.63
12 12 1516608000 59.23
13 13 1516521600 56.1
14 14 1516435200 56.71
15 15 1516348800 57.08
16 16 1516262400 54.16
17 17 1516176000 46.49
18 18 1516089600 44.83
19 19 1516003200 57.68
20 20 1515916800 65.2
21 21 1515830400 70.9
22 22 1515744000 74.57
23 23 1515657600 87.81
24 24 1515571200 88.93
25 25 1515484800 62.46
26 26 1515398400 60.1
27 27 1515312000 60.24
28 28 1515225600 56.14
29 29 1515139200 44.15
30 30 1515052800 46.58
31 31 1514966400 38.46
32 32 1514880000 39.83
33 33 1514793600 32.15
34 34 1514707200 32.86
35 35 1514620800 30.23
36 36 1514534400 35.4
37 37 1514448000 30.53
38 38 1514361600 31.1
39 39 1514275200 31.63
40 40 1514188800 33.72
41 41 1514102400 31.67
42 42 1514016000 34.19
43 43 1513929600 29.53
44 44 1513843200 35.28
45 45 1513756800 33.24
46 46 1513670400 36.33
47 47 1513584000 34.27
48 48 1513497600 32.43
49 49 1513411200 31.83
50 50 1513324800 27.29
51 51 1513238400 29.0
52 52 1513152000 25.43
53 53 1513065600 23.39
54 54 1512979200 23.24
55 55 1512892800 20.92
56 56 1512806400 23.1
57 57 1512720000 24.33
58 58 1512633600 26.48
59 59 1512547200 26.87
60 60 1512460800 32.28
61 61 1512374400 25.78
62 62 1512288000 23.98
63 63 1512201600 22.4
64 64 1512115200 21.64
65 65 1512028800 21.5
66 66 1511942400 21.91
67 67 1511856000 29.04
68 68 1511769600 25.77
69 69 1511683200 19.93
70 70 1511596800 19.33
71 71 1511510400 17.18
72 72 1511424000 15.8
73 73 1511337600 14.12
74 74 1511251200 13.82
75 75 1511164800 14.78
76 76 1511078400 15.34
77 77 1510992000 16.19
78 78 1510905600 15.09
79 79 1510819200 15.58
80 80 1510732800 15.1
81 81 1510646400 15.46
82 82 1510560000 13.96
83 83 1510473600 13.14
84 84 1510387200 13.95
85 85 1510300800 15.15
86 86 1510214400 13.35
87 87 1510128000 14.47
88 88 1510041600 11.94
89 89 1509955200 11.88
90 90 1509865200 11.25
91 91 1509778800 10.59
92 92 1509692400 9.83
93 93 1509606000 9.43
94 94 1509519600 10.04
95 95 1509433200 9.58
96 96 1509346800 10.12
97 97 1509260400 9.88
98 98 1509174000 11.16
99 99 1509087600 8.52
100 100 1509001200 8.31

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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