PREVIEW / futures_daily / 2020-11-06

all futures daily files

  file:    by_date/futures_daily/2020/2020-11-06.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-11-06	ES	Futures	3942.01	3953.53	3883.59	3933.03	1640000.0
2020-11-06	NQ	Futures	13994.96	14018.7	13739.98	13979.34	552483.0
2020-11-06	YM	Futures	30487.6	30636.2	30107.6	30363.8	207262.0
2020-11-06	CL	Futures	27.47	27.52	26.42	26.47	411026.0
2020-11-06	GC	Futures	2303.0	2316.9	2287.9	2305.0	246779.0
2020-11-06	ZN	Futures	137.830789	137.892777	137.257398	137.412368	1489220.0
2020-11-06	A6	Futures	0.7457	0.74816	0.74323	0.74621	110519.0
2020-11-06	AD	Futures	0.7763	0.77843	0.77382	0.77803	68205.0
2020-11-06	ALI	Futures	2285.72	2285.72	2268.54	2278.02	85.0
2020-11-06	B	Futures	25.6	25.64	24.79	24.86	255440.0
2020-11-06	B6	Futures	1.3329	1.3364	1.3278	1.3347	90718.0
2020-11-06	BR	Futures	0.14226	0.14655	0.14057	0.14517	6568.0
2020-11-06	BTC	Futures	20699.9	21320.2	20257.8	20627.3	8143.0
2020-11-06	BZ	Futures	25.15	25.15	24.26	24.33	33078.0
2020-11-06	C	Futures	1424.0	1435.0	1416.0	1418.0	3713.0
2020-11-06	CB	Futures	154.009	156.524	154.009	156.524	15.0
2020-11-06	CC	Futures	1531.0	1543.0	1522.0	1537.0	20352.0
2020-11-06	CNH	Futures	6.48	6.5045	6.4626	6.4638	1706.0
2020-11-06	CSC	Futures	3.716	3.728	3.569	3.619	76.0
2020-11-06	CT	Futures	69.18	69.44	67.75	67.81	28448.0
2020-11-06	DC	Futures	30.47	30.69	29.32	29.78	698.0
2020-11-06	DX	Futures	89.583	89.666	89.028	89.086	32881.0
2020-11-06	E1	Futures	1.25326	1.26187	1.25156	1.26006	24918.0
2020-11-06	E6	Futures	1.26761	1.27479	1.2645	1.27382	195510.0
2020-11-06	E7	Futures	1.261	1.2683	1.2581	1.2674	10209.0
2020-11-06	EBM	Futures	252.26	254.06	251.05	251.65	24701.0
2020-11-06	ED	Futures	96.4939	96.5035	96.4939	96.5035	128714.0
2020-11-06	ER	Futures	98.455	98.46	98.45	98.455	175652.0
2020-11-06	ESG	Futures	324.34	331.28	324.21	326.72	893.0
2020-11-06	EW	Futures	2176.7	2183.8	2146.5	2162.8	9772.0
2020-11-06	FBON	Futures	150.12	150.28	149.91	150.0	202.0
2020-11-06	FBTP	Futures	138.01	138.43	137.86	137.97	95114.0
2020-11-06	FBTS	Futures	109.884	109.981	109.884	109.904	67910.0
2020-11-06	FCE	Futures	4778.8	4830.5	4748.8	4794.8	63500.0
2020-11-06	FDAX	Futures	13329.3	13418.8	13176.3	13295.2	72106.0
2020-11-06	FDIV	Futures	145.31	145.55	144.83	145.45	140.0
2020-11-06	FDXM	Futures	13267.4	13351.2	13111.4	13228.1	61682.0
2020-11-06	FESX	Futures	2955.6	2977.8	2924.2	2956.6	1177681.0
2020-11-06	FGBL	Futures	171.57	171.64	171.03	171.19	591309.0
2020-11-06	FGBM	Futures	135.79	135.8	135.62	135.68	303913.0
2020-11-06	FGBS	Futures	112.925	112.925	112.88	112.895	313110.0
2020-11-06	FGBX	Futures	239.42	239.84	237.21	237.65	65254.0
2020-11-06	FMWO	Futures	8642.8	8726.8	8595.4	8688.9	1644.0
2020-11-06	FOAT	Futures	159.51	159.64	159.14	159.27	120385.0
2020-11-06	FTDX	Futures	3109.0	3113.6	3076.1	3096.1	239.0
2020-11-06	FTI	Futures	526.83	533.0	523.95	530.97	25087.0
2020-11-06	FTUK	Futures	5601.2	5667.7	5576.4	5624.6	93827.0
2020-11-06	FVSA	Futures	187.52	195.39	176.07	182.15	30824.0
2020-11-06	FXXP	Futures	338.0	340.8	335.9	338.7	70216.0
2020-11-06	G	Futures	126.72	126.97	126.17	126.27	217909.0

> showing 50 of 120 rows — these rows as CSV

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