PREVIEW / futures_daily / 2019-11-12

all futures daily files

  file:    by_date/futures_daily/2019/2019-11-12.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-11-12	ES	Futures	3342.7	3358.12	3335.66	3347.3	1101243.0
2019-11-12	NQ	Futures	9511.22	9565.38	9482.69	9536.28	316729.0
2019-11-12	YM	Futures	29035.1	29112.8	28971.1	29040.4	134410.0
2019-11-12	CL	Futures	58.12	58.8	57.76	58.03	586568.0
2019-11-12	GC	Futures	1795.9	1802.6	1784.0	1793.2	429612.0
2019-11-12	ZN	Futures	127.235414	127.421227	126.987663	127.374773	1365009.0
2019-11-12	A6	Futures	0.70327	0.7042	0.70163	0.70286	89064.0
2019-11-12	AD	Futures	0.76126	0.76227	0.7599	0.76166	59903.0
2019-11-12	ALI	Futures	2173.95	2184.27	2171.82	2180.63	113.0
2019-11-12	B	Futures	49.54	50.13	49.31	49.5	238171.0
2019-11-12	B6	Futures	1.3085	1.3103	1.3042	1.3086	83354.0
2019-11-12	BFX	Futures	4671.2	4685.0	4671.2	4685.0	50.0
2019-11-12	BR	Futures	0.19441	0.19481	0.19279	0.19388	8464.0
2019-11-12	BTC	Futures	12613.9	12873.8	12354.0	12758.3	3545.0
2019-11-12	BZ	Futures	48.91	49.45	48.62	48.82	30687.0
2019-11-12	C	Futures	1713.0	1791.0	1708.0	1787.0	13517.0
2019-11-12	CB	Futures	249.194	249.194	248.338	248.574	29.0
2019-11-12	CC	Futures	1639.0	1725.0	1636.0	1714.0	52070.0
2019-11-12	CNH	Futures	6.9968	7.0159	6.9854	7.0104	900.0
2019-11-12	CSC	Futures	3.456	3.464	3.379	3.379	117.0
2019-11-12	CT	Futures	62.39	63.1	62.31	63.02	25686.0
2019-11-12	DC	Futures	28.88	28.88	28.01	28.05	693.0
2019-11-12	DX	Futures	94.792	94.981	94.773	94.866	8449.0
2019-11-12	E1	Futures	1.16094	1.16209	1.15726	1.16186	22162.0
2019-11-12	E6	Futures	1.19843	1.19892	1.19502	1.19605	126709.0
2019-11-12	E7	Futures	1.1922	1.1928	1.1889	1.1898	2282.0
2019-11-12	EBM	Futures	194.0	195.64	193.72	195.09	17951.0
2019-11-12	ED	Futures	95.318	95.3229	95.3083	95.3132	163283.0
2019-11-12	ER	Futures	98.386	98.391	98.386	98.391	22724.0
2019-11-12	EW	Futures	2096.0	2104.2	2088.1	2091.7	9147.0
2019-11-12	FBON	Futures	143.1	143.1	142.82	142.86	512.0
2019-11-12	FBTP	Futures	128.13	128.86	127.97	128.78	99314.0
2019-11-12	FBTS	Futures	108.009	108.153	107.989	108.124	47344.0
2019-11-12	FCE	Futures	5350.7	5360.2	5329.4	5349.8	176184.0
2019-11-12	FDAX	Futures	13920.7	14040.4	13910.1	14023.6	84521.0
2019-11-12	FDIV	Futures	162.65	163.3	162.65	163.16	60.0
2019-11-12	FDXM	Futures	13749.3	13856.6	13730.6	13840.4	33794.0
2019-11-12	FESX	Futures	3237.8	3257.0	3235.1	3254.4	724437.0
2019-11-12	FGBL	Futures	163.9	164.06	163.51	163.78	576490.0
2019-11-12	FGBM	Futures	133.54	133.64	133.48	133.56	317702.0
2019-11-12	FGBS	Futures	112.664	112.689	112.659	112.674	301650.0
2019-11-12	FGBX	Futures	210.63	211.25	208.92	210.21	39661.0
2019-11-12	FMWO	Futures	7565.5	7582.6	7553.0	7576.9	3464.0
2019-11-12	FOAT	Futures	151.2	151.55	151.14	151.36	132260.0
2019-11-12	FTDX	Futures	2999.8	2999.8	2904.6	2914.0	63.0
2019-11-12	FTI	Futures	572.05	573.58	570.66	572.33	30204.0
2019-11-12	FTUK	Futures	6781.0	6832.0	6769.0	6818.1	75866.0
2019-11-12	FVSA	Futures	144.94	145.45	142.92	143.42	7634.0
2019-11-12	FXXP	Futures	367.2	368.3	366.0	368.1	68480.0
2019-11-12	G	Futures	119.73	120.03	119.6	119.85	138375.0

> showing 50 of 120 rows — these rows as CSV

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