fivethirtyeight: rare-pepes/ordermatches

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

26,038 rows

descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link	rowid ▼	Block	ForwardAsset	ForwardQuantity	BackwardAsset	BackwardQuantity
1	1	428940	RAREPEPE	1.0	XCP	2.0
2	2	429221	SHITCOINCARD	230.0	XCP	13.8
3	3	429221	RAREPEPE	10.0	XCP	15.0
4	4	429228	SHITCOINCARD	3.0	XCP	0.18
5	5	429228	RAREPEPE	1.0	XCP	1.5
6	6	429398	SHITCOINCARD	12.0	XCP	0.72
7	7	429398	RAREPEPE	2.0	XCP	3.0
8	8	429403	RAREPEPE	1.0	XCP	1.5
9	9	429403	SHITCOINCARD	755.0	XCP	45.3
10	10	429466	RAREPEPE	1.0	XCP	1.5
11	11	429480	RAREPEPE	45.0	XCP	67.5
12	12	429481	RAREPEPE	1.0	XCP	1.5
13	13	429482	RAREPEPE	5.0	XCP	7.5
14	14	429509	RAREPEPE	10.0	XCP	15.0
15	15	429509	SHITCOINCARD	10.0	XCP	0.9
16	16	429512	SHITCOINCARD	10.0	XCP	0.9
17	17	429512	RAREPEPE	10.0	XCP	15.0
18	18	429516	SHITCOINCARD	22.0	XCP	1.98
19	19	429533	RAREPEPE	6.0	XCP	9.0
20	20	429534	SHITCOINCARD	5.0	XCP	0.45
21	21	429535	SHITCOINCARD	8.0	XCP	0.72
22	22	429550	SHITCOINCARD	22.0	XCP	1.98
23	23	429550	RAREPEPE	2.0	XCP	3.0
24	24	429557	RAREPEPE	3.0	XCP	4.5
25	25	429557	SHITCOINCARD	40.0	XCP	3.6
26	26	429557	RAREPEPE	3.0	XCP	4.5
27	27	429558	SHITCOINCARD	75.0	XCP	6.75
28	28	429558	RAREPEPE	15.0	XCP	22.5
29	29	429560	RAREPEPE	22.0	XCP	33.0
30	30	429560	RAREPEPE	10.0	XCP	15.0
31	31	429574	RAREPEPE	10.0	XCP	20.0
32	32	429575	SHITCOINCARD	35.0	XCP	3.15
33	33	429577	SHITCOINCARD	773.0	XCP	69.57
34	34	429577	RAREPEPE	39.0	XCP	78.0
35	35	429605	GOXPEPE	1.0	XCP	0.3
36	36	429605	GOXPEPE	75.0	XCP	22.5
37	37	429680	GOXPEPE	1.0	XCP	0.3
38	38	429686	RAREPEPE	5.0	XCP	10.0
39	39	429770	GURUPEPE	4.0	XCP	1.0
40	40	429779	RAREPEPE	12.0	XCP	24.0
41	41	429784	RAREPEPE	82.0	XCP	164.0
42	42	429786	RAREPEPE	1.0	XCP	2.0
43	43	429859	GOXPEPE	2.0	XCP	0.6
44	44	429956	XCP	2.5	RAREPEPE	1.0
45	45	429980	PEPENATION	3.0	XCP	0.3
46	46	429997	DANKPEPE	2.0	XCP	1.0
47	47	430003	DANKPEPE	1.0	XCP	0.5
48	48	430075	GOXPEPE	3.0	XCP	0.9
49	49	430091	DANKPEPE	1.0	XCP	0.125
50	50	430110	PEPENATION	10.0	XCP	1.0
51	51	430123	XCP	1.75	RAREPEPE	1.0
52	52	430123	XCP	1.75	RAREPEPE	1.0
53	53	430155	RAREPEPE	2.0	XCP	3.5
54	54	430167	XCP	0.2	PEPEPARTY	1.0
55	55	430253	GOXPEPE	1.0	XCP	0.3
56	56	430253	PEPENATION	1.0	XCP	0.1
57	57	430253	DANKPEPE	1.0	XCP	0.125
58	58	430253	GURUPEPE	1.0	XCP	0.25
59	59	430253	PEPEPARTY	1.0	XCP	0.2
60	60	430404	BUPEPE	10.0	XCP	0.1
61	61	430525	LOVEPEPETATO	1.0	XCP	1.0
62	62	430533	RAREPEPE	1.0	XCP	2.25
63	63	430534	GOXPEPE	1.0	XCP	0.3
64	64	430534	TRUMPRARE	1.0	XCP	0.02
65	65	430546	GOXPEPE	200.0	XCP	60.0
66	66	430547	SHITCOINCARD	400.0	XCP	48.0
67	67	430548	KEISERPEPE	1.0	XCP	0.3
68	68	430553	SHITCOINCARD	1.0	XCP	0.12
69	69	430575	RAREPEPE	2.0	XCP	7.0
70	70	430575	RAREPEPE	1.0	XCP	3.5
71	71	430576	DANKPEPE	5.0	XCP	0.625
72	72	430576	TRUMPRARE	5.0	XCP	0.95
73	73	430576	GOXPEPE	5.0	XCP	1.5
74	74	430576	SHITCOINCARD	10.0	XCP	1.2
75	75	430576	LOVEPEPETATO	3.0	XCP	3.0
76	76	430577	BUPEPE	200.0	XCP	2.0
77	77	430577	PEPENATION	5.0	XCP	0.5
78	78	430577	PEPEPARTY	5.0	XCP	1.0
79	79	430579	GOXPEPE	10.0	XCP	3.0
80	80	430597	KEISERPEPE	5.0	XCP	1.5
81	81	430684	HYIPPEPE	5.0	XCP	0.5
82	82	430686	BUPEPE	1.0	XCP	0.01
83	83	430696	RAREPEPE	1.0	XCP	2.0
84	84	430759	HYIPPEPE	45.0	XCP	4.5
85	85	430965	RAREPEPE	10.0	XCP	25.0
86	86	430966	SHITCOINCARD	21.0	XCP	2.31
87	87	430985	LOVEPEPETATO	2.0	XCP	2.0
88	88	430985	HYIPPEPE	10.0	XCP	1.45
89	89	430986	PEPEJOINTSPH	1000.0	XCP	3.1
90	90	430986	STILLPEPE	50.0	XCP	5.0
91	91	430986	PEPEPARTY	93.0	XCP	18.6
92	92	430986	PEPETRATION	1.0	XCP	0.75
93	93	430996	LOVEPEPETATO	1.0	XCP	1.0
94	94	430996	PEPETRATION	3.0	XCP	2.25
95	95	430997	RAREPEPE	1.0	XCP	3.0
96	96	430998	HYIPPEPE	2.0	XCP	0.29
97	97	430999	HYIPPEPE	20.0	XCP	2.9
98	98	430999	RAREPEPE	1.0	XCP	3.0
99	99	430999	PEPEPARTY	2.0	XCP	1.0
100	100	431001	HYIPPEPE	45.0	XCP	6.75

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "rare-pepes/ordermatches_all" (
"Block" INTEGER,
  "ForwardAsset" TEXT,
  "ForwardQuantity" REAL,
  "BackwardAsset" TEXT,
  "BackwardQuantity" REAL
);

Rare Pepes: ordermatches_all.csv

26,038 rows

Advanced export