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

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ Timestamp Price
101 101 1508914800 8.52
102 102 1508828400 8.35
103 103 1508742000 7.49
104 104 1508655600 8.28
105 105 1508569200 7.61
106 106 1508482800 8.01
107 107 1508396400 8.23
108 108 1508310000 8.66
109 109 1508223600 8.89
110 110 1508137200 10.6
111 111 1508050800 8.61
112 112 1507964400 9.24
113 113 1507878000 9.28
114 114 1507791600 8.53
115 115 1507705200 7.96
116 116 1507618800 7.67
117 117 1507532400 7.85
118 118 1507446000 8.14
119 119 1507359600 9.39
120 120 1507273200 9.58
121 121 1507186800 9.68
122 122 1507100400 9.14
123 123 1507014000 9.73
124 124 1506927600 10.31
125 125 1506841200 10.64
126 126 1506754800 11.57
127 127 1506668400 9.96
128 128 1506582000 9.92
129 129 1506495600 10.4
130 130 1506409200 10.03
131 131 1506322800 9.97
132 132 1506236400 9.94
133 133 1506150000 10.01
134 134 1506063600 9.67
135 135 1505977200 9.47
136 136 1505890800 10.72
137 137 1505804400 11.71
138 138 1505718000 12.19
139 139 1505631600 11.91
140 140 1505545200 10.42
141 141 1505458800 10.27
142 142 1505372400 8.91
143 143 1505286000 11.94
144 144 1505199600 13.03
145 145 1505113200 12.87
146 146 1505026800 11.31
147 147 1504940400 12.24
148 148 1504854000 11.64
149 149 1504767600 13.38
150 150 1504681200 13.64
151 151 1504594800 13.56
152 152 1504508400 12.18
153 153 1504422000 13.96
154 154 1504335600 14.87
155 155 1504249200 16.11
156 156 1504162800 14.9
157 157 1504076400 15.6
158 158 1503990000 14.48
159 159 1503903600 17.07
160 160 1503817200 18.54
161 161 1503730800 22.42
162 162 1503644400 14.93
163 163 1503558000 16.46
164 164 1503471600 16.23
165 165 1503385200 15.96
166 166 1503298800 15.92
167 167 1503212400 17.07
168 168 1503126000 12.08
169 169 1503039600 11.14
170 170 1502953200 12.61
171 171 1502866800 12.15
172 172 1502780400 13.32
173 173 1502694000 12.08
174 174 1502607600 9.98
175 175 1502521200 10.55
176 176 1502434800 10.18
177 177 1502348400 11.33
178 178 1502262000 11.91
179 179 1502175600 10.2
180 180 1502089200 10.48
181 181 1502002800 10.69
182 182 1501916400 10.53
183 183 1501830000 9.37
184 184 1501743600 10.21
185 185 1501657200 9.22
186 186 1501570800 9.44
187 187 1501484400 8.48
188 188 1501398000 8.89
189 189 1501311600 8.89
190 190 1501225200 9.42
191 191 1501138800 9.46
192 192 1501052400 8.29
193 193 1500966000 8.79
194 194 1500879600 11.1
195 195 1500793200 12.04
196 196 1500706800 11.98
197 197 1500620400 10.39
198 198 1500534000 9.76
199 199 1500447600 7.58
200 200 1500361200 7.98

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