Rare Pepes: blocks_timestamps.csv

Table actions

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

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "rare-pepes/blocks_timestamps" (
"Block" INTEGER,
  " Timestamp" INTEGER
);