PREVIEW / futures_daily / 2019-01-09

all futures daily files

  file:    by_date/futures_daily/2019/2019-01-09.parquet
  size:    10 KB
  rows:    117

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-01-09	ES	Futures	2781.92	2811.42	2780.84	2795.99	1596941.0
2019-01-09	NQ	Futures	7579.52	7693.27	7579.52	7646.67	496789.0
2019-01-09	YM	Futures	25023.4	25278.6	25010.7	25135.2	235891.0
2019-01-09	CL	Futures	52.23	55.15	52.14	54.92	891922.0
2019-01-09	GC	Futures	1620.5	1631.7	1613.9	1627.9	245969.0
2019-01-09	ZN	Futures	121.160258	121.362555	121.004645	121.222503	1428110.0
2019-01-09	A6	Futures	0.73631	0.74187	0.73621	0.74053	117970.0
2019-01-09	AD	Futures	0.76395	0.76936	0.7639	0.76698	100756.0
2019-01-09	B	Futures	42.7	44.54	42.63	44.36	329048.0
2019-01-09	B6	Futures	1.3102	1.3192	1.3098	1.3183	102840.0
2019-01-09	BFX	Futures	3967.6	3982.3	3967.6	3982.3	5.0
2019-01-09	BR	Futures	0.21421	0.21604	0.21421	0.21544	2018.0
2019-01-09	BTC	Futures	5833.2	5891.7	5774.7	5833.2	3683.0
2019-01-09	BZ	Futures	41.99	44.16	41.97	43.98	38989.0
2019-01-09	C	Futures	1513.0	1516.0	1490.0	1496.0	8809.0
2019-01-09	CB	Futures	271.225	272.44	270.952	272.44	52.0
2019-01-09	CC	Futures	1639.0	1645.0	1616.0	1620.0	15548.0
2019-01-09	CNH	Futures	6.8666	6.8684	6.8243	6.8243	643.0
2019-01-09	CSC	Futures	2.795	2.799	2.778	2.786	101.0
2019-01-09	CT	Futures	78.04	80.22	78.04	79.66	16726.0
2019-01-09	DC	Futures	23.94	23.96	23.81	23.86	166.0
2019-01-09	DX	Futures	90.978	91.093	90.253	90.401	29000.0
2019-01-09	E1	Futures	1.20558	1.21581	1.20523	1.21346	30478.0
2019-01-09	E6	Futures	1.27138	1.28442	1.2711	1.28276	254788.0
2019-01-09	E7	Futures	1.2653	1.278	1.2648	1.2766	6003.0
2019-01-09	EBM	Futures	212.31	212.83	210.77	211.03	10082.0
2019-01-09	ED	Futures	94.9988	95.0086	94.9842	95.0037	443960.0
2019-01-09	ER	Futures	98.396	98.401	98.391	98.396	46680.0
2019-01-09	EW	Futures	1840.9	1868.9	1840.3	1863.3	13229.0
2019-01-09	FBON	Futures	128.68	129.06	128.62	129.02	216.0
2019-01-09	FBTP	Futures	110.14	110.63	109.61	110.48	63794.0
2019-01-09	FBTS	Futures	104.613	104.764	104.462	104.736	52548.0
2019-01-09	FCE	Futures	4271.0	4299.0	4260.8	4271.9	78679.0
2019-01-09	FDAX	Futures	11412.8	11512.6	11382.3	11449.1	98297.0
2019-01-09	FDIV	Futures	133.61	133.61	133.61	133.61	1.0
2019-01-09	FDXM	Futures	11376.1	11484.1	11354.1	11421.2	44186.0
2019-01-09	FESX	Futures	2612.4	2630.4	2604.7	2617.6	911579.0
2019-01-09	FEU3	Futures	98.996	98.996	98.996	98.996	100.0
2019-01-09	FGBL	Futures	155.66	156.04	155.44	155.89	656645.0
2019-01-09	FGBM	Futures	131.94	132.08	131.85	132.04	392425.0
2019-01-09	FGBS	Futures	112.678	112.708	112.668	112.708	296968.0
2019-01-09	FGBX	Futures	183.62	184.65	183.09	184.22	40361.0
2019-01-09	FMWO	Futures	6523.8	6575.0	6523.8	6555.2	3540.0
2019-01-09	FOAT	Futures	141.19	141.52	140.94	141.4	141983.0
2019-01-09	FTDX	Futures	2529.9	2549.3	2517.0	2531.4	511.0
2019-01-09	FTI	Futures	465.09	466.92	462.85	464.22	21458.0
2019-01-09	FTUK	Futures	6230.3	6271.2	6220.2	6245.3	104870.0
2019-01-09	FVSA	Futures	391.01	399.13	383.9	389.99	23428.0
2019-01-09	FXXP	Futures	303.7	305.6	302.8	304.0	50851.0
2019-01-09	G	Futures	116.71	117.11	116.51	117.0	182444.0

> showing 50 of 117 rows — these rows as CSV

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