PREVIEW / futures_daily / 2019-10-24

all futures daily files

  file:    by_date/futures_daily/2019/2019-10-24.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
2019-10-24	ES	Futures	3254.2	3264.21	3246.35	3252.3	1061278.0
2019-10-24	NQ	Futures	9130.34	9200.93	9119.39	9136.68	380967.0
2019-10-24	YM	Futures	28154.3	28210.0	27982.2	28113.4	152055.0
2019-10-24	CL	Futures	57.11	57.73	56.61	57.45	480764.0
2019-10-24	GC	Futures	1844.3	1858.8	1838.5	1856.1	305012.0
2019-10-24	ZN	Futures	128.65998	128.892246	128.474167	128.675464	1318699.0
2019-10-24	A6	Futures	0.7042	0.70461	0.69989	0.70112	73046.0
2019-10-24	AD	Futures	0.77103	0.77199	0.76967	0.77093	67930.0
2019-10-24	ALI	Futures	2106.86	2110.2	2104.43	2105.95	112.0
2019-10-24	B	Futures	48.32	49.04	48.04	48.85	215542.0
2019-10-24	B6	Futures	1.3152	1.3188	1.3025	1.3103	112156.0
2019-10-24	BR	Futures	0.19986	0.20164	0.19954	0.19982	21881.0
2019-10-24	BTC	Futures	10751.0	10881.0	10650.0	10830.5	1547.0
2019-10-24	BZ	Futures	47.72	48.36	47.38	48.17	35367.0
2019-10-24	C	Futures	1668.0	1702.0	1667.0	1697.0	11840.0
2019-10-24	CB	Futures	243.555	243.555	243.555	243.555	5.0
2019-10-24	CC	Futures	1616.0	1640.0	1601.0	1616.0	22318.0
2019-10-24	CNH	Futures	7.0564	7.0666	7.0467	7.0642	634.0
2019-10-24	CSC	Futures	3.292	3.328	3.289	3.32	105.0
2019-10-24	CT	Futures	63.27	63.81	62.88	62.93	12270.0
2019-10-24	DC	Futures	27.45	27.83	27.38	27.74	474.0
2019-10-24	DX	Futures	93.961	94.29	93.806	94.145	18182.0
2019-10-24	E1	Futures	1.16531	1.16738	1.16289	1.16393	21536.0
2019-10-24	E6	Futures	1.21068	1.21393	1.20634	1.20813	187670.0
2019-10-24	E7	Futures	1.2045	1.2076	1.1999	1.2019	3781.0
2019-10-24	EBM	Futures	198.1	198.37	196.73	197.01	21200.0
2019-10-24	ED	Futures	95.3472	95.352	95.3326	95.3375	202503.0
2019-10-24	ER	Futures	98.406	98.416	98.406	98.406	53431.0
2019-10-24	EW	Futures	2050.8	2056.8	2037.7	2047.5	6625.0
2019-10-24	FBON	Futures	145.19	145.28	144.77	145.23	293.0
2019-10-24	FBTP	Futures	131.27	131.82	131.15	131.71	83677.0
2019-10-24	FBTS	Futures	108.346	108.471	108.346	108.423	33499.0
2019-10-24	FCE	Futures	5144.2	5164.6	5133.3	5156.9	66448.0
2019-10-24	FDAX	Futures	13527.1	13620.5	13503.4	13578.3	95587.0
2019-10-24	FDIV	Futures	158.43	158.71	158.43	158.71	45.0
2019-10-24	FDXM	Futures	13344.2	13442.1	13326.5	13401.0	36965.0
2019-10-24	FESX	Futures	3160.6	3172.9	3153.6	3166.7	854792.0
2019-10-24	FGBL	Futures	165.72	166.12	165.34	165.99	706081.0
2019-10-24	FGBM	Futures	134.14	134.28	134.03	134.24	402466.0
2019-10-24	FGBS	Futures	112.764	112.8	112.749	112.795	295391.0
2019-10-24	FGBX	Futures	217.21	218.43	215.84	218.02	43334.0
2019-10-24	FMWO	Futures	7384.7	7393.8	7365.4	7381.3	3573.0
2019-10-24	FOAT	Futures	153.08	153.57	152.8	153.48	114200.0
2019-10-24	FTDX	Futures	2773.8	2793.0	2767.4	2792.0	95.0
2019-10-24	FTI	Futures	548.21	554.32	547.98	553.63	28195.0
2019-10-24	FTUK	Futures	6713.8	6782.4	6697.1	6769.4	93059.0
2019-10-24	FVSA	Futures	159.81	162.47	156.63	158.75	16753.0
2019-10-24	FXXP	Futures	356.8	358.9	356.7	358.5	44345.0
2019-10-24	G	Futures	121.14	121.82	120.78	121.63	204213.0
2019-10-24	GF	Futures	303.047	303.727	301.267	301.843	1795.0

> showing 50 of 120 rows — these rows as CSV

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