PREVIEW / futures_daily / 2020-01-22

all futures daily files

  file:    by_date/futures_daily/2020/2020-01-22.parquet
  size:    10 KB
  rows:    122

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-01-22	ES	Futures	3587.0	3604.55	3580.52	3585.38	1505107.0
2020-01-22	NQ	Futures	10529.06	10614.52	10523.04	10547.7	519015.0
2020-01-22	YM	Futures	30641.8	30780.5	30553.6	30603.0	192697.0
2020-01-22	CL	Futures	59.75	59.87	57.46	58.19	620119.0
2020-01-22	GC	Futures	1917.9	1919.0	1906.9	1915.2	286081.0
2020-01-22	ZN	Futures	128.381337	128.474255	128.226474	128.396823	1349211.0
2020-01-22	A6	Futures	0.70235	0.70378	0.70081	0.70245	87192.0
2020-01-22	AD	Futures	0.77093	0.773	0.7661	0.7667	142283.0
2020-01-22	ALI	Futures	2220.38	2224.27	2195.5	2197.29	118.0
2020-01-22	B	Futures	52.79	52.8	51.2	51.68	273296.0
2020-01-22	B6	Futures	1.3249	1.336	1.324	1.3341	112718.0
2020-01-22	BFX	Futures	4725.0	4744.5	4725.0	4744.5	15.0
2020-01-22	BR	Futures	0.19267	0.19405	0.19267	0.19356	2481.0
2020-01-22	BTC	Futures	13301.7	13438.2	13036.5	13157.7	4717.0
2020-01-22	BZ	Futures	52.02	52.06	50.4	50.95	35127.0
2020-01-22	C	Futures	1924.0	1937.0	1898.0	1900.0	7360.0
2020-01-22	CB	Futures	236.311	236.635	235.102	235.22	42.0
2020-01-22	CC	Futures	1844.0	1870.0	1824.0	1834.0	19306.0
2020-01-22	CNH	Futures	6.8785	6.8878	6.8687	6.8816	849.0
2020-01-22	CSC	Futures	3.431	3.498	3.431	3.47	56.0
2020-01-22	CT	Futures	65.65	67.82	65.36	67.66	32181.0
2020-01-22	DC	Futures	28.72	29.32	28.72	29.03	426.0
2020-01-22	DX	Futures	94.516	94.594	94.293	94.434	12487.0
2020-01-22	E1	Futures	1.18347	1.18461	1.17833	1.18404	25829.0
2020-01-22	E6	Futures	1.19779	1.19963	1.1965	1.19898	172395.0
2020-01-22	E7	Futures	1.1917	1.1933	1.1903	1.1928	2202.0
2020-01-22	EBM	Futures	219.24	219.51	214.84	215.12	38316.0
2020-01-22	ED	Futures	95.3277	95.3277	95.3132	95.318	172010.0
2020-01-22	ER	Futures	98.372	98.372	98.367	98.367	38785.0
2020-01-22	ESG	Futures	297.14	297.65	296.63	297.25	81.0
2020-01-22	EW	Futures	2195.0	2207.7	2188.9	2193.0	13895.0
2020-01-22	FBON	Futures	143.28	143.56	143.09	143.44	457.0
2020-01-22	FBTP	Futures	127.8	128.55	127.2	128.31	142937.0
2020-01-22	FBTS	Futures	107.941	108.086	107.855	108.038	79062.0
2020-01-22	FCE	Futures	5498.8	5501.1	5434.4	5445.3	72709.0
2020-01-22	FDAX	Futures	14314.6	14423.5	14251.2	14279.2	98531.0
2020-01-22	FDIV	Futures	160.33	160.33	159.82	159.82	1.0
2020-01-22	FDXM	Futures	14123.5	14240.4	14072.3	14100.0	50407.0
2020-01-22	FESX	Futures	3323.3	3345.3	3304.8	3310.9	908501.0
2020-01-22	FEU3	Futures	99.08	99.08	99.08	99.08	40.0
2020-01-22	FGBL	Futures	164.33	164.76	164.2	164.6	584939.0
2020-01-22	FGBM	Futures	133.6	133.73	133.55	133.67	374913.0
2020-01-22	FGBS	Futures	112.608	112.624	112.598	112.613	230857.0
2020-01-22	FGBX	Futures	211.31	212.77	211.0	212.31	46659.0
2020-01-22	FMWO	Futures	8060.6	8060.6	8035.7	8040.2	5006.0
2020-01-22	FOAT	Futures	151.96	152.43	151.92	152.28	125258.0
2020-01-22	FTDX	Futures	3192.6	3198.6	3178.0	3190.1	57.0
2020-01-22	FTI	Futures	585.96	586.48	582.17	584.58	29267.0
2020-01-22	FTUK	Futures	7070.5	7106.6	7032.5	7036.7	99899.0
2020-01-22	FVSA	Futures	111.81	115.64	110.96	114.37	31396.0

> showing 50 of 122 rows — these rows as CSV

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