home / fivethirtyeight

Rare Pepes: xcp_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

520 rows

View and edit SQL

Link rowid Timestamp Price
101 1508914800 8.52
102 1508828400 8.35
103 1508742000 7.49
104 1508655600 8.28
105 1508569200 7.61
106 1508482800 8.01
107 1508396400 8.23
108 1508310000 8.66
109 1508223600 8.89
110 1508137200 10.6
111 1508050800 8.61
112 1507964400 9.24
113 1507878000 9.28
114 1507791600 8.53
115 1507705200 7.96
116 1507618800 7.67
117 1507532400 7.85
118 1507446000 8.14
119 1507359600 9.39
120 1507273200 9.58
121 1507186800 9.68
122 1507100400 9.14
123 1507014000 9.73
124 1506927600 10.31
125 1506841200 10.64
126 1506754800 11.57
127 1506668400 9.96
128 1506582000 9.92
129 1506495600 10.4
130 1506409200 10.03
131 1506322800 9.97
132 1506236400 9.94
133 1506150000 10.01
134 1506063600 9.67
135 1505977200 9.47
136 1505890800 10.72
137 1505804400 11.71
138 1505718000 12.19
139 1505631600 11.91
140 1505545200 10.42
141 1505458800 10.27
142 1505372400 8.91
143 1505286000 11.94
144 1505199600 13.03
145 1505113200 12.87
146 1505026800 11.31
147 1504940400 12.24
148 1504854000 11.64
149 1504767600 13.38
150 1504681200 13.64
151 1504594800 13.56
152 1504508400 12.18
153 1504422000 13.96
154 1504335600 14.87
155 1504249200 16.11
156 1504162800 14.9
157 1504076400 15.6
158 1503990000 14.48
159 1503903600 17.07
160 1503817200 18.54
161 1503730800 22.42
162 1503644400 14.93
163 1503558000 16.46
164 1503471600 16.23
165 1503385200 15.96
166 1503298800 15.92
167 1503212400 17.07
168 1503126000 12.08
169 1503039600 11.14
170 1502953200 12.61
171 1502866800 12.15
172 1502780400 13.32
173 1502694000 12.08
174 1502607600 9.98
175 1502521200 10.55
176 1502434800 10.18
177 1502348400 11.33
178 1502262000 11.91
179 1502175600 10.2
180 1502089200 10.48
181 1502002800 10.69
182 1501916400 10.53
183 1501830000 9.37
184 1501743600 10.21
185 1501657200 9.22
186 1501570800 9.44
187 1501484400 8.48
188 1501398000 8.89
189 1501311600 8.89
190 1501225200 9.42
191 1501138800 9.46
192 1501052400 8.29
193 1500966000 8.79
194 1500879600 11.1
195 1500793200 12.04
196 1500706800 11.98
197 1500620400 10.39
198 1500534000 9.76
199 1500447600 7.58
200 1500361200 7.98

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 · Query took 4.855ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub