PREVIEW / futures_daily / 2020-03-17

all futures daily files

  file:    by_date/futures_daily/2020/2020-03-17.parquet
  size:    10 KB
  rows:    120

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2020-03-17	ES	Futures	2663.31	2813.52	2602.45	2750.17	3788132.0
2020-03-17	NQ	Futures	8066.64	8640.72	7946.26	8474.77	563210.0
2020-03-17	YM	Futures	21610.0	22672.7	21059.4	22258.7	255851.0
2020-03-17	CL	Futures	28.73	30.34	26.82	27.09	520078.0
2020-03-17	GC	Futures	1844.5	1895.1	1786.9	1860.3	434508.0
2020-03-17	ZN	Futures	136.404603	136.45091	133.456399	134.243616	1821733.0
2020-03-17	A6	Futures	0.6273	0.63151	0.6121	0.6158	99607.0
2020-03-17	AD	Futures	0.72338	0.72627	0.71036	0.71315	86476.0
2020-03-17	ALI	Futures	2028.89	2028.89	2004.01	2021.91	305.0
2020-03-17	B	Futures	25.64	26.58	24.24	24.44	270240.0
2020-03-17	B6	Futures	1.2476	1.2487	1.2207	1.2305	121333.0
2020-03-17	BFX	Futures	3049.5	3049.5	2986.3	2986.3	1.0
2020-03-17	BR	Futures	0.16177	0.16374	0.16156	0.16374	135.0
2020-03-17	BTC	Futures	7264.3	8067.3	7059.8	7855.6	6875.0
2020-03-17	BZ	Futures	24.59	25.85	23.56	23.79	32969.0
2020-03-17	C	Futures	1698.0	1718.0	1659.0	1710.0	10241.0
2020-03-17	CB	Futures	207.06	207.06	201.372	201.372	54.0
2020-03-17	CC	Futures	1516.0	1523.0	1473.0	1518.0	35997.0
2020-03-17	CNH	Futures	6.951	6.9833	6.9447	6.9732	475.0
2020-03-17	CSC	Futures	3.051	3.053	3.036	3.051	170.0
2020-03-17	CT	Futures	56.57	57.45	55.71	55.76	19127.0
2020-03-17	DC	Futures	25.05	25.05	24.73	24.75	254.0
2020-03-17	DX	Futures	94.981	96.77	94.865	96.508	26897.0
2020-03-17	E1	Futures	1.21403	1.21426	1.18864	1.19205	31402.0
2020-03-17	E6	Futures	1.20841	1.20847	1.18278	1.18756	196868.0
2020-03-17	E7	Futures	1.2017	1.2021	1.1766	1.1814	12712.0
2020-03-17	EBM	Futures	196.26	201.29	195.98	200.73	13577.0
2020-03-17	ED	Futures	96.3098	96.3533	96.2034	96.2276	789754.0
2020-03-17	ER	Futures	98.382	98.391	98.377	98.382	99391.0
2020-03-17	ESG	Futures	228.46	228.46	228.46	228.46	2002.0
2020-03-17	EW	Futures	1410.4	1492.3	1376.1	1482.8	42556.0
2020-03-17	FBON	Futures	137.73	138.61	135.28	136.21	979.0
2020-03-17	FBTP	Futures	117.89	120.09	115.77	116.81	132932.0
2020-03-17	FBTS	Futures	104.834	105.431	104.228	104.401	77950.0
2020-03-17	FCE	Futures	3821.1	3941.2	3626.5	3849.2	114465.0
2020-03-17	FDAX	Futures	9220.5	9658.4	8901.1	9400.3	36713.0
2020-03-17	FDIV	Futures	97.05	100.49	97.05	100.49	100.0
2020-03-17	FDXM	Futures	9224.2	9719.4	8935.1	9445.2	4516.0
2020-03-17	FESX	Futures	2188.1	2306.5	2109.2	2244.1	2715479.0
2020-03-17	FGBL	Futures	167.19	167.65	166.12	167.12	782128.0
2020-03-17	FGBM	Futures	134.69	134.76	134.38	134.58	446016.0
2020-03-17	FGBS	Futures	113.207	113.283	113.132	113.182	326348.0
2020-03-17	FGBX	Futures	231.66	233.03	227.46	231.38	42114.0
2020-03-17	FMWO	Futures	6398.1	6398.1	5593.0	5882.2	41075.0
2020-03-17	FOAT	Futures	149.14	149.52	147.68	148.88	194692.0
2020-03-17	FTDX	Futures	2275.3	2306.1	2229.3	2306.1	549.0
2020-03-17	FTI	Futures	394.37	404.68	375.29	395.81	18641.0
2020-03-17	FTUK	Futures	4833.1	5048.1	4675.6	4960.9	356289.0
2020-03-17	FVSA	Futures	481.6	546.87	458.65	503.66	41835.0
2020-03-17	FXXP	Futures	263.1	285.1	246.4	262.7	258097.0

> showing 50 of 120 rows — these rows as CSV

> unlock the full archive -- $79 one-time