home / fivethirtyeight

Menu
  • GraphQL API

Rare Pepes: blocks_timestamps.csv

Table actions
  • GraphQL API for rare-pepes/blocks_timestamps

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

78,265 rows sorted by rowid descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▲ Block Timestamp
78265 78265 507189 1517535635
78264 78264 507188 1517535610
78263 78263 507187 1517535355
78262 78262 507186 1517535116
78261 78261 507185 1517534266
78260 78260 507184 1517533848
78259 78259 507183 1517533232
78258 78258 507182 1517533091
78257 78257 507181 1517532997
78256 78256 507180 1517532463
78255 78255 507179 1517532137
78254 78254 507178 1517531919
78253 78253 507177 1517530634
78252 78252 507176 1517529654
78251 78251 507175 1517529330
78250 78250 507174 1517528857
78249 78249 507173 1517528312
78248 78248 507172 1517528270
78247 78247 507171 1517527382
78246 78246 507170 1517525970
78245 78245 507169 1517525761
78244 78244 507168 1517525641
78243 78243 507167 1517525533
78242 78242 507166 1517525368
78241 78241 507165 1517524910
78240 78240 507164 1517523579
78239 78239 507163 1517523540
78238 78238 507162 1517523237
78237 78237 507161 1517522932
78236 78236 507160 1517522596
78235 78235 507159 1517521921
78234 78234 507158 1517521427
78233 78233 507157 1517520654
78232 78232 507156 1517519553
78231 78231 507155 1517518765
78230 78230 507154 1517518330
78229 78229 507153 1517517861
78228 78228 507152 1517517522
78227 78227 507151 1517517355
78226 78226 507150 1517517305
78225 78225 507149 1517517091
78224 78224 507148 1517516528
78223 78223 507147 1517516446
78222 78222 507146 1517516376
78221 78221 507145 1517515234
78220 78220 507144 1517514724
78219 78219 507143 1517514558
78218 78218 507142 1517514214
78217 78217 507141 1517513981
78216 78216 507140 1517513736
78215 78215 507139 1517513640
78214 78214 507138 1517513288
78213 78213 507137 1517512524
78212 78212 507136 1517509833
78211 78211 507135 1517509486
78210 78210 507134 1517507866
78209 78209 507133 1517507658
78208 78208 507132 1517507512
78207 78207 507131 1517505871
78206 78206 507130 1517505661
78205 78205 507129 1517505648
78204 78204 507128 1517505401
78203 78203 507127 1517505020
78202 78202 507126 1517504621
78201 78201 507125 1517504148
78200 78200 507124 1517504071
78199 78199 507123 1517503904
78198 78198 507122 1517503547
78197 78197 507121 1517503297
78196 78196 507120 1517502618
78195 78195 507119 1517501795
78194 78194 507118 1517499705
78193 78193 507117 1517499222
78192 78192 507116 1517497990
78191 78191 507115 1517497827
78190 78190 507114 1517497782
78189 78189 507113 1517497619
78188 78188 507112 1517497512
78187 78187 507111 1517497377
78186 78186 507110 1517495711
78185 78185 507109 1517495427
78184 78184 507108 1517495441
78183 78183 507107 1517495320
78182 78182 507106 1517494533
78181 78181 507105 1517494414
78180 78180 507104 1517493316
78179 78179 507103 1517492685
78178 78178 507102 1517492222
78177 78177 507101 1517491639
78176 78176 507100 1517491491
78175 78175 507099 1517490964
78174 78174 507098 1517490421
78173 78173 507097 1517490049
78172 78172 507096 1517489713
78171 78171 507095 1517489411
78170 78170 507094 1517488794
78169 78169 507093 1517488048
78168 78168 507092 1517488016
78167 78167 507091 1517487671
78166 78166 507090 1517486643

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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