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
101 429025 1473452288
102 429026 1473452804
103 429027 1473453496
104 429028 1473454139
105 429029 1473454862
106 429030 1473454892
107 429031 1473455483
108 429032 1473456697
109 429033 1473457126
110 429034 1473457274
111 429035 1473457294
112 429036 1473458877
113 429037 1473459138
114 429038 1473459191
115 429039 1473459626
116 429040 1473460085
117 429041 1473460140
118 429042 1473461110
119 429043 1473461257
120 429044 1473461768
121 429045 1473463631
122 429046 1473464015
123 429047 1473464142
124 429048 1473465327
125 429049 1473466627
126 429050 1473466725
127 429051 1473466948
128 429052 1473467594
129 429053 1473467182
130 429054 1473468595
131 429055 1473469213
132 429056 1473469244
133 429057 1473470362
134 429058 1473470420
135 429059 1473470439
136 429060 1473470534
137 429061 1473471111
138 429062 1473471823
139 429063 1473471967
140 429064 1473472462
141 429065 1473473151
142 429066 1473473389
143 429067 1473473706
144 429068 1473474883
145 429069 1473476662
146 429070 1473478453
147 429071 1473478743
148 429072 1473480110
149 429073 1473481267
150 429074 1473481491
151 429075 1473481672
152 429076 1473483441
153 429077 1473483629
154 429078 1473484420
155 429079 1473486039
156 429080 1473486247
157 429081 1473486758
158 429082 1473486852
159 429083 1473487240
160 429084 1473487257
161 429085 1473487934
162 429086 1473488721
163 429087 1473488789
164 429088 1473489285
165 429089 1473489523
166 429090 1473489741
167 429091 1473490246
168 429092 1473490403
169 429093 1473490460
170 429094 1473490693
171 429095 1473492127
172 429096 1473492447
173 429097 1473493993
174 429098 1473493871
175 429099 1473494496
176 429100 1473494758
177 429101 1473495038
178 429102 1473495514
179 429103 1473496884
180 429104 1473497119
181 429105 1473498004
182 429106 1473498437
183 429107 1473499428
184 429108 1473499670
185 429109 1473499970
186 429110 1473500615
187 429111 1473501189
188 429112 1473501268
189 429113 1473501574
190 429114 1473501621
191 429115 1473501652
192 429116 1473502378
193 429117 1473502498
194 429118 1473502933
195 429119 1473503108
196 429120 1473503677
197 429121 1473505887
198 429122 1473506930
199 429123 1473507249
200 429124 1473507921

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 4.983ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub