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 sorted by rowid descending

View and edit SQL

Link rowid ▲ Timestamp Price
520 1472713200 3.25
519 1472799600 3.51
518 1472886000 3.57
517 1472972400 3.48
516 1473058800 3.55
515 1473145200 3.28
514 1473231600 3.14
513 1473318000 3.33
512 1473404400 3.32
511 1473490800 3.26
510 1473577200 3.46
509 1473663600 3.77
508 1473750000 3.83
507 1473836400 4.81
506 1473922800 4.43
505 1474009200 5.35
504 1474095600 5.25
503 1474182000 4.84
502 1474268400 4.33
501 1474354800 5.24
500 1474441200 5.6
499 1474527600 5.13
498 1474614000 5.3
497 1474700400 5.05
496 1474786800 5.05
495 1474873200 4.43
494 1474959600 4.64
493 1475046000 4.33
492 1475132400 4.18
491 1475218800 4.22
490 1475305200 3.65
489 1475391600 4.06
488 1475478000 3.85
487 1475564400 3.74
486 1475650800 4.38
485 1475737200 4.35
484 1475823600 4.12
483 1475910000 4.16
482 1475996400 4.2
481 1476082800 4.11
480 1476169200 4.72
479 1476255600 4.71
478 1476342000 4.46
477 1476428400 4.5
476 1476514800 4.26
475 1476601200 4.07
474 1476687600 4.23
473 1476774000 4.15
472 1476860400 4.11
471 1476946800 3.81
470 1477033200 3.67
469 1477119600 4.11
468 1477206000 3.88
467 1477292400 3.83
466 1477378800 3.85
465 1477465200 3.47
464 1477551600 3.77
463 1477638000 3.54
462 1477724400 3.15
461 1477810800 3.09
460 1477897200 2.89
459 1477983600 2.82
458 1478070000 2.72
457 1478156400 2.89
456 1478242800 2.62
455 1478329200 2.67
454 1478415600 2.94
453 1478505600 2.7
452 1478592000 2.81
451 1478678400 2.81
450 1478764800 2.59
449 1478851200 2.71
448 1478937600 2.61
447 1479024000 2.69
446 1479110400 2.59
445 1479196800 2.44
444 1479283200 2.21
443 1479369600 2.37
442 1479456000 2.24
441 1479542400 2.25
440 1479628800 2.21
439 1479715200 2.22
438 1479801600 2.09
437 1479888000 2.17
436 1479974400 2.05
435 1480060800 2.11
434 1480147200 2.22
433 1480233600 2.51
432 1480320000 2.36
431 1480406400 2.29
430 1480492800 2.27
429 1480579200 2.04
428 1480665600 1.99
427 1480752000 2.03
426 1480838400 1.94
425 1480924800 1.88
424 1481011200 1.81
423 1481097600 2.14
422 1481184000 2.01
421 1481270400 2.03

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "rare-pepes/xcp_prices" (
"Timestamp" INTEGER,
  "Price" REAL
);