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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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