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

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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