PREVIEW / futures_daily / 2019-09-24

all futures daily files

  file:    by_date/futures_daily/2019/2019-09-24.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
2019-09-24	ES	Futures	3248.78	3260.96	3202.78	3215.5	1936806.0
2019-09-24	NQ	Futures	9068.4	9109.6	8875.66	8914.26	609261.0
2019-09-24	YM	Futures	28350.7	28461.9	28014.7	28153.3	240008.0
2019-09-24	CL	Futures	60.0	60.05	58.2	58.82	591529.0
2019-09-24	GC	Futures	1887.1	1903.7	1878.4	1899.9	424860.0
2019-09-24	ZN	Futures	128.799339	129.604529	128.752886	129.542591	1689336.0
2019-09-24	A6	Futures	0.69732	0.70019	0.69588	0.69948	87917.0
2019-09-24	AD	Futures	0.76056	0.76222	0.75975	0.76197	65128.0
2019-09-24	ALI	Futures	2164.06	2165.87	2142.02	2145.34	48.0
2019-09-24	B	Futures	49.74	49.89	48.12	48.74	216276.0
2019-09-24	B6	Futures	1.2679	1.2753	1.2662	1.2745	125425.0
2019-09-24	BR	Futures	0.19497	0.19497	0.19275	0.19303	19.0
2019-09-24	BTC	Futures	14008.7	14202.9	11570.9	12124.6	2747.0
2019-09-24	BZ	Futures	49.07	49.1	47.44	48.01	30503.0
2019-09-24	C	Futures	1659.0	1662.0	1634.0	1646.0	10128.0
2019-09-24	CB	Futures	257.43	257.43	255.039	255.6	43.0
2019-09-24	CC	Futures	1614.0	1623.0	1597.0	1601.0	18723.0
2019-09-24	CNH	Futures	7.1147	7.119	7.1003	7.1069	1192.0
2019-09-24	CSC	Futures	3.115	3.129	3.107	3.107	48.0
2019-09-24	CT	Futures	59.08	59.34	58.06	58.79	15020.0
2019-09-24	DC	Futures	26.36	26.46	26.13	26.16	239.0
2019-09-24	DX	Futures	94.985	95.029	94.604	94.649	14590.0
2019-09-24	E1	Futures	1.17003	1.17681	1.16818	1.17532	31360.0
2019-09-24	E6	Futures	1.19859	1.20228	1.19757	1.20152	153767.0
2019-09-24	E7	Futures	1.1926	1.1961	1.1915	1.1953	2967.0
2019-09-24	EBM	Futures	187.16	187.7	186.33	186.33	24538.0
2019-09-24	ED	Futures	95.2549	95.2937	95.2354	95.2792	418346.0
2019-09-24	ER	Futures	98.445	98.45	98.44	98.45	32111.0
2019-09-24	EW	Futures	2054.5	2059.9	2019.0	2024.6	14972.0
2019-09-24	FBON	Futures	146.06	146.64	145.88	146.61	416.0
2019-09-24	FBTP	Futures	132.31	132.6	132.19	132.53	57001.0
2019-09-24	FBTS	Futures	108.404	108.519	108.404	108.5	34822.0
2019-09-24	FCE	Futures	5103.8	5106.5	5058.1	5087.5	59739.0
2019-09-24	FDAX	Futures	13068.1	13079.7	12889.3	12978.9	92787.0
2019-09-24	FDIV	Futures	148.18	148.18	147.62	147.76	21.0
2019-09-24	FDXM	Futures	12887.1	12913.1	12720.4	12809.5	31222.0
2019-09-24	FESX	Futures	3100.9	3102.7	3066.7	3085.2	737286.0
2019-09-24	FGBL	Futures	168.27	168.94	168.12	168.79	578044.0
2019-09-24	FGBM	Futures	134.99	135.14	134.92	135.1	345498.0
2019-09-24	FGBS	Futures	112.956	112.971	112.92	112.961	214089.0
2019-09-24	FGBX	Futures	226.14	229.4	225.82	228.52	43930.0
2019-09-24	FMWO	Futures	7338.1	7341.5	7247.1	7310.8	2997.0
2019-09-24	FOAT	Futures	155.12	155.48	154.88	155.43	106187.0
2019-09-24	FTDX	Futures	2794.5	2814.7	2793.0	2806.4	100.0
2019-09-24	FTI	Futures	546.37	546.89	541.77	545.07	22281.0
2019-09-24	FTUK	Futures	6789.4	6790.8	6680.5	6721.7	90495.0
2019-09-24	FVSA	Futures	183.01	193.67	178.52	186.37	21360.0
2019-09-24	FXXP	Futures	352.1	352.3	348.9	351.0	33454.0
2019-09-24	G	Futures	122.33	122.69	121.99	122.59	265402.0
2019-09-24	GF	Futures	295.616	297.238	294.151	296.505	3843.0

> showing 50 of 120 rows — these rows as CSV

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