PREVIEW / futures_daily / 2020-04-21

all futures daily files

  file:    by_date/futures_daily/2020/2020-04-21.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-04-21	ES	Futures	3105.91	3134.95	3006.6	3022.92	1969844.0
2020-04-21	NQ	Futures	9968.29	10046.25	9563.6	9666.49	582449.0
2020-04-21	YM	Futures	25029.9	25269.9	24343.7	24466.5	249722.0
2020-04-21	CL	Futures	15.87	16.81	4.84	8.61	2288230.0
2020-04-21	GC	Futures	2077.8	2083.5	2020.6	2046.8	248629.0
2020-04-21	ZN	Futures	137.531403	137.994472	137.392483	137.701195	1092690.0
2020-04-21	A6	Futures	0.65083	0.65216	0.64251	0.64569	74772.0
2020-04-21	AD	Futures	0.7173	0.71827	0.71056	0.71381	77052.0
2020-04-21	ALI	Futures	1822.72	1833.48	1811.67	1817.64	136.0
2020-04-21	B	Futures	20.17	20.3	13.41	14.81	637214.0
2020-04-21	B6	Futures	1.263	1.2636	1.2437	1.2469	82313.0
2020-04-21	BR	Futures	0.15325	0.15325	0.15263	0.15267	87.0
2020-04-21	BTC	Futures	9752.2	9872.7	9617.4	9773.5	2879.0
2020-04-21	BZ	Futures	19.29	20.23	13.02	14.36	83111.0
2020-04-21	C	Futures	1738.0	1777.0	1733.0	1766.0	3110.0
2020-04-21	CB	Futures	150.569	150.569	146.944	146.944	35.0
2020-04-21	CC	Futures	1529.0	1534.0	1499.0	1515.0	11487.0
2020-04-21	CNH	Futures	7.0305	7.049	7.0284	7.0456	832.0
2020-04-21	CSC	Futures	2.266	2.266	2.189	2.189	191.0
2020-04-21	CT	Futures	52.09	52.09	50.06	51.33	3470.0
2020-04-21	DC	Futures	18.56	18.56	17.75	17.75	619.0
2020-04-21	DX	Futures	96.751	97.307	96.727	97.059	16307.0
2020-04-21	E1	Futures	1.17896	1.17975	1.17258	1.17611	16308.0
2020-04-21	E6	Futures	1.16962	1.17101	1.16403	1.1679	136304.0
2020-04-21	E7	Futures	1.1634	1.1648	1.158	1.1618	7294.0
2020-04-21	EBM	Futures	226.77	230.13	226.77	228.17	11497.0
2020-04-21	ED	Futures	96.2034	96.2228	96.1744	96.2131	256246.0
2020-04-21	ER	Futures	98.2	98.2	98.161	98.166	121579.0
2020-04-21	ESG	Futures	250.58	250.58	245.95	246.93	141.0
2020-04-21	EW	Futures	1617.5	1632.0	1563.6	1575.2	11989.0
2020-04-21	FBON	Futures	138.28	138.8	136.89	137.34	579.0
2020-04-21	FBTP	Futures	121.97	122.14	119.15	119.59	142900.0
2020-04-21	FBTS	Futures	106.2	106.219	105.402	105.585	86479.0
2020-04-21	FCE	Futures	4259.4	4309.3	4182.9	4192.6	45831.0
2020-04-21	FDAX	Futures	11162.9	11234.3	10812.8	10842.4	104148.0
2020-04-21	FDIV	Futures	115.98	115.98	113.85	113.85	301.0
2020-04-21	FDXM	Futures	11227.4	11285.8	10863.9	10894.2	71000.0
2020-04-21	FESX	Futures	2606.6	2620.4	2520.4	2529.5	1397845.0
2020-04-21	FEU3	Futures	98.922	98.922	98.902	98.902	267.0
2020-04-21	FGBL	Futures	167.72	168.42	167.63	168.08	528411.0
2020-04-21	FGBM	Futures	134.5	134.74	134.46	134.63	309580.0
2020-04-21	FGBS	Futures	112.84	112.89	112.815	112.86	402385.0
2020-04-21	FGBX	Futures	226.33	229.11	225.95	227.92	38996.0
2020-04-21	FMWO	Futures	6855.1	6865.7	6665.7	6682.1	4492.0
2020-04-21	FOAT	Futures	151.61	152.07	151.29	151.46	105873.0
2020-04-21	FTDX	Futures	2901.6	2918.3	2862.2	2862.7	135.0
2020-04-21	FTI	Futures	468.3	471.73	459.77	461.16	31157.0
2020-04-21	FTUK	Futures	5392.3	5428.2	5292.4	5307.9	105960.0
2020-04-21	FVSA	Futures	347.03	389.33	344.32	381.68	11820.0
2020-04-21	FXXP	Futures	303.3	305.5	296.7	297.9	105697.0

> showing 50 of 120 rows — these rows as CSV

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