PREVIEW / futures_daily / 2020-07-09

all futures daily files

  file:    by_date/futures_daily/2020/2020-07-09.parquet
  size:    10 KB
  rows:    119

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-07-09	ES	Futures	3563.89	3568.96	3495.23	3535.47	1881833.0
2020-07-09	NQ	Futures	12388.96	12505.02	12256.35	12450.76	607385.0
2020-07-09	YM	Futures	27858.6	27895.1	27217.7	27404.2	239986.0
2020-07-09	CL	Futures	29.63	29.72	28.47	28.72	367386.0
2020-07-09	GC	Futures	2183.7	2191.7	2160.6	2165.7	283371.0
2020-07-09	ZN	Futures	137.830886	138.279948	137.815401	138.248978	993559.0
2020-07-09	A6	Futures	0.71823	0.72028	0.71504	0.71668	87411.0
2020-07-09	AD	Futures	0.75104	0.75246	0.74677	0.74759	66623.0
2020-07-09	ALI	Futures	2048.99	2052.92	2003.94	2014.22	321.0
2020-07-09	B	Futures	28.21	28.34	27.32	27.59	237751.0
2020-07-09	B6	Futures	1.281	1.2869	1.2798	1.2819	98738.0
2020-07-09	BR	Futures	0.15059	0.15059	0.14734	0.14754	44.0
2020-07-09	BTC	Futures	13091.1	13146.2	12657.2	12746.8	5931.0
2020-07-09	BZ	Futures	27.63	27.71	26.71	26.97	23249.0
2020-07-09	C	Futures	1429.0	1435.0	1403.0	1419.0	480.0
2020-07-09	CB	Futures	195.575	195.575	194.719	195.254	6.0
2020-07-09	CC	Futures	1392.0	1410.0	1375.0	1409.0	14208.0
2020-07-09	CNH	Futures	6.9167	6.9183	6.9003	6.9149	639.0
2020-07-09	CSC	Futures	3.995	4.094	3.995	4.094	84.0
2020-07-09	CT	Futures	65.61	65.83	65.06	65.07	34.0
2020-07-09	DC	Futures	32.58	33.8	32.41	33.8	454.0
2020-07-09	DX	Futures	93.13	93.483	92.903	93.38	21922.0
2020-07-09	E1	Futures	1.21274	1.21535	1.20911	1.21013	24486.0
2020-07-09	E6	Futures	1.21787	1.22179	1.21208	1.21385	208374.0
2020-07-09	E7	Futures	1.2117	1.2156	1.206	1.2078	6062.0
2020-07-09	EBM	Futures	226.04	226.34	224.24	224.84	21792.0
2020-07-09	ED	Futures	96.4088	96.4185	96.4088	96.4137	143701.0
2020-07-09	ER	Futures	98.372	98.377	98.367	98.372	70420.0
2020-07-09	ESG	Futures	288.65	288.65	283.7	286.72	603.0
2020-07-09	EW	Futures	1888.1	1889.3	1831.3	1855.0	12934.0
2020-07-09	FBON	Futures	145.67	145.86	145.61	145.86	133.0
2020-07-09	FBTP	Futures	130.67	130.7	130.35	130.58	60325.0
2020-07-09	FBTS	Futures	108.502	108.522	108.444	108.502	27514.0
2020-07-09	FCE	Futures	4911.4	4919.8	4797.7	4815.4	67172.0
2020-07-09	FDAX	Futures	13391.4	13487.0	13205.4	13253.3	97257.0
2020-07-09	FDIV	Futures	143.13	143.13	142.75	142.75	100.0
2020-07-09	FDXM	Futures	13351.5	13440.4	13157.8	13205.4	50365.0
2020-07-09	FESX	Futures	3051.8	3064.7	2989.0	3001.0	857988.0
2020-07-09	FEU3	Futures	99.119	99.119	99.119	99.119	100.0
2020-07-09	FGBL	Futures	168.17	168.74	168.12	168.66	443337.0
2020-07-09	FGBM	Futures	134.64	134.83	134.63	134.8	313179.0
2020-07-09	FGBS	Futures	112.724	112.764	112.724	112.754	162744.0
2020-07-09	FGBX	Futures	226.23	228.66	225.9	227.94	39939.0
2020-07-09	FMWO	Futures	7905.8	7925.9	7784.9	7800.3	4309.0
2020-07-09	FOAT	Futures	155.56	155.91	155.48	155.84	128382.0
2020-07-09	FTDX	Futures	3115.5	3133.9	3095.0	3102.7	51.0
2020-07-09	FTI	Futures	534.1	534.66	524.69	526.1	24727.0
2020-07-09	FTUK	Futures	5823.0	5836.2	5667.0	5684.5	90701.0
2020-07-09	FVSA	Futures	253.39	272.23	250.7	268.64	13379.0
2020-07-09	FXXP	Futures	339.4	339.5	333.5	334.3	54741.0

> showing 50 of 119 rows — these rows as CSV

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