PREVIEW / futures_daily / 2020-10-06

all futures daily files

  file:    by_date/futures_daily/2020/2020-10-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-10-06	ES	Futures	3810.85	3844.27	3741.75	3767.31	1701062.0
2020-10-06	NQ	Futures	13282.4	13342.02	12963.45	13051.72	612278.0
2020-10-06	YM	Futures	30155.0	30394.0	29639.3	29821.2	287020.0
2020-10-06	CL	Futures	28.25	29.34	28.07	29.2	400531.0
2020-10-06	GC	Futures	2264.9	2275.8	2218.2	2254.3	219440.0
2020-10-06	ZN	Futures	137.629327	138.047747	137.582836	137.908274	1619887.0
2020-10-06	A6	Futures	0.73728	0.74026	0.72896	0.73102	102295.0
2020-10-06	AD	Futures	0.7643	0.76536	0.76105	0.76207	70587.0
2020-10-06	ALI	Futures	2146.59	2146.89	2122.53	2124.31	175.0
2020-10-06	B	Futures	26.13	27.03	26.01	26.91	291684.0
2020-10-06	B6	Futures	1.3167	1.3194	1.305	1.3086	114577.0
2020-10-06	BR	Futures	0.14167	0.14274	0.14006	0.14006	140.0
2020-10-06	BTC	Futures	14531.5	14632.2	14195.6	14282.9	4093.0
2020-10-06	BZ	Futures	25.69	26.51	25.5	26.39	37426.0
2020-10-06	C	Futures	1537.0	1537.0	1501.0	1509.0	9145.0
2020-10-06	CB	Futures	163.893	163.893	162.902	163.232	47.0
2020-10-06	CC	Futures	1619.0	1624.0	1589.0	1600.0	17157.0
2020-10-06	CNH	Futures	6.6137	6.6333	6.6053	6.6308	340.0
2020-10-06	CSC	Futures	3.485	3.502	3.476	3.483	230.0
2020-10-06	CT	Futures	64.88	66.16	64.88	66.07	15025.0
2020-10-06	DC	Futures	28.49	28.75	28.46	28.52	655.0
2020-10-06	DX	Futures	90.274	90.718	90.197	90.553	26656.0
2020-10-06	E1	Futures	1.23911	1.24216	1.23582	1.23752	17495.0
2020-10-06	E6	Futures	1.26413	1.2667	1.25845	1.26075	169097.0
2020-10-06	E7	Futures	1.2576	1.2601	1.2521	1.2544	5779.0
2020-10-06	EBM	Futures	238.09	242.31	237.79	241.11	35148.0
2020-10-06	ED	Futures	96.4939	96.4987	96.489	96.4939	125347.0
2020-10-06	ER	Futures	98.44	98.445	98.44	98.445	17113.0
2020-10-06	ESG	Futures	314.57	317.46	310.89	311.47	1480.0
2020-10-06	EW	Futures	2073.2	2114.8	2055.7	2066.2	20725.0
2020-10-06	FBON	Futures	147.79	148.34	147.79	148.12	856.0
2020-10-06	FBTP	Futures	135.86	136.28	135.81	136.12	102416.0
2020-10-06	FBTS	Futures	109.498	109.556	109.489	109.537	43979.0
2020-10-06	FCE	Futures	4733.2	4776.3	4699.7	4745.8	55398.0
2020-10-06	FDAX	Futures	13703.0	13806.9	13602.7	13753.1	77476.0
2020-10-06	FDIV	Futures	148.25	149.48	148.25	148.96	345.0
2020-10-06	FDXM	Futures	13636.5	13737.3	13534.7	13683.7	47322.0
2020-10-06	FESX	Futures	2976.9	2998.2	2951.0	2983.4	777581.0
2020-10-06	FGBL	Futures	169.39	169.85	169.36	169.48	666262.0
2020-10-06	FGBM	Futures	135.05	135.18	135.03	135.07	274100.0
2020-10-06	FGBS	Futures	112.739	112.759	112.734	112.744	237805.0
2020-10-06	FGBX	Futures	231.24	232.64	231.03	231.41	64074.0
2020-10-06	FMWO	Futures	8434.3	8475.7	8349.0	8448.5	1783.0
2020-10-06	FOAT	Futures	157.64	157.98	157.58	157.75	155320.0
2020-10-06	FTDX	Futures	3218.6	3221.1	3184.6	3198.0	58.0
2020-10-06	FTI	Futures	521.44	522.28	512.73	517.37	22244.0
2020-10-06	FTUK	Futures	5660.5	5680.6	5613.2	5654.3	77482.0
2020-10-06	FVSA	Futures	201.7	203.19	191.67	195.01	9664.0
2020-10-06	FXXP	Futures	338.3	339.5	335.0	338.1	36413.0
2020-10-06	G	Futures	126.14	126.26	125.96	126.11	285992.0

> showing 50 of 120 rows — these rows as CSV

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