home / fivethirtyeight

Rare Pepes: blocks_timestamps.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

78,265 rows

View and edit SQL

Link rowid Block Timestamp
1 428925 1473387721
2 428926 1473388413
3 428927 1473391665
4 428928 1473391811
5 428929 1473393165
6 428930 1473394241
7 428931 1473396044
8 428932 1473397906
9 428933 1473398672
10 428934 1473399792
11 428935 1473401155
12 428936 1473402841
13 428937 1473403001
14 428938 1473403071
15 428939 1473403613
16 428940 1473403689
17 428941 1473404254
18 428942 1473404851
19 428943 1473405217
20 428944 1473405921
21 428945 1473407731
22 428946 1473407805
23 428947 1473408172
24 428948 1473408235
25 428949 1473409465
26 428950 1473409681
27 428951 1473409998
28 428952 1473413124
29 428953 1473414547
30 428954 1473414896
31 428955 1473415104
32 428956 1473416117
33 428957 1473416134
34 428958 1473416259
35 428959 1473416527
36 428960 1473416720
37 428961 1473417496
38 428962 1473418020
39 428963 1473418142
40 428964 1473418412
41 428965 1473418503
42 428966 1473418716
43 428967 1473418950
44 428968 1473419428
45 428969 1473420396
46 428970 1473420456
47 428971 1473422628
48 428972 1473422771
49 428973 1473425745
50 428974 1473426323
51 428975 1473426415
52 428976 1473426538
53 428977 1473426962
54 428978 1473427722
55 428979 1473428351
56 428980 1473428867
57 428981 1473428881
58 428982 1473429423
59 428983 1473429452
60 428984 1473429522
61 428985 1473429581
62 428986 1473429840
63 428987 1473430176
64 428988 1473430942
65 428989 1473431321
66 428990 1473431918
67 428991 1473432276
68 428992 1473432394
69 428993 1473433919
70 428994 1473434423
71 428995 1473434754
72 428996 1473434763
73 428997 1473435862
74 428998 1473436124
75 428999 1473436172
76 429000 1473436287
77 429001 1473437140
78 429002 1473437501
79 429003 1473437535
80 429004 1473439272
81 429005 1473439404
82 429006 1473440455
83 429007 1473440658
84 429008 1473440866
85 429009 1473440882
86 429010 1473441432
87 429011 1473441448
88 429012 1473441843
89 429013 1473442925
90 429014 1473443544
91 429015 1473444367
92 429016 1473444999
93 429017 1473446025
94 429018 1473448241
95 429019 1473449542
96 429020 1473449744
97 429021 1473449850
98 429022 1473450037
99 429023 1473450111
100 429024 1473452049

Next page

Advanced export

JSON shape: default, array

CSV options:

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