PREVIEW / futures_daily / 2019-11-07

all futures daily files

  file:    by_date/futures_daily/2019/2019-11-07.parquet
  size:    10 KB
  rows:    119

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-07	ES	Futures	3331.33	3352.71	3323.75	3340.8	1353330.0
2019-11-07	NQ	Futures	9465.7	9544.64	9438.33	9485.0	366403.0
2019-11-07	YM	Futures	28821.0	29120.2	28753.8	29044.6	159355.0
2019-11-07	CL	Futures	57.57	59.13	57.49	58.39	678165.0
2019-11-07	GC	Futures	1840.6	1842.4	1802.7	1808.9	674982.0
2019-11-07	ZN	Futures	128.040603	128.210932	126.832819	127.235414	2622358.0
2019-11-07	A6	Futures	0.70676	0.70994	0.70471	0.70861	126124.0
2019-11-07	AD	Futures	0.76403	0.76554	0.76333	0.76423	71074.0
2019-11-07	ALI	Futures	2209.77	2221.91	2208.86	2218.27	154.0
2019-11-07	B	Futures	49.24	50.16	49.17	49.68	261072.0
2019-11-07	B6	Futures	1.3086	1.3108	1.3019	1.305	101770.0
2019-11-07	BR	Futures	0.19853	0.19962	0.19598	0.19748	9044.0
2019-11-07	BTC	Futures	13610.3	13660.8	13177.1	13314.3	3323.0
2019-11-07	BZ	Futures	48.6	49.48	48.49	49.01	33158.0
2019-11-07	C	Futures	1662.0	1664.0	1655.0	1660.0	5226.0
2019-11-07	CB	Futures	245.651	246.803	245.651	246.212	20.0
2019-11-07	CC	Futures	1616.0	1621.0	1593.0	1603.0	38312.0
2019-11-07	CNH	Futures	7.0041	7.0114	6.9457	6.9635	1108.0
2019-11-07	CSC	Futures	3.541	3.546	3.406	3.435	269.0
2019-11-07	CT	Futures	61.94	63.12	61.77	62.64	29235.0
2019-11-07	DC	Futures	29.6	29.6	28.35	28.61	870.0
2019-11-07	DX	Futures	94.507	94.792	94.391	94.709	16094.0
2019-11-07	E1	Futures	1.16197	1.16358	1.15599	1.15852	35195.0
2019-11-07	E6	Futures	1.20239	1.20494	1.19887	1.20011	189456.0
2019-11-07	E7	Futures	1.1962	1.1987	1.1925	1.1939	2856.0
2019-11-07	EBM	Futures	195.91	196.19	194.0	195.09	20898.0
2019-11-07	ED	Futures	95.3277	95.3375	95.3132	95.3229	280088.0
2019-11-07	ER	Futures	98.396	98.401	98.382	98.386	141096.0
2019-11-07	EW	Futures	2092.3	2111.9	2088.4	2093.2	10505.0
2019-11-07	FBON	Futures	144.66	144.66	143.44	143.73	973.0
2019-11-07	FBTP	Futures	130.66	130.93	129.02	129.5	147019.0
2019-11-07	FBTS	Futures	108.423	108.471	108.201	108.259	62290.0
2019-11-07	FCE	Futures	5324.4	5362.0	5324.4	5347.5	69854.0
2019-11-07	FDAX	Futures	13899.0	14031.5	13883.2	14004.6	100907.0
2019-11-07	FDIV	Futures	162.84	163.12	162.79	163.02	61.0
2019-11-07	FDXM	Futures	13708.7	13848.3	13702.5	13821.7	40659.0
2019-11-07	FESX	Futures	3229.0	3250.0	3225.5	3242.1	816255.0
2019-11-07	FGBL	Futures	165.06	165.16	163.42	163.81	1143061.0
2019-11-07	FGBM	Futures	133.96	133.96	133.39	133.55	675784.0
2019-11-07	FGBS	Futures	112.724	112.724	112.634	112.654	435795.0
2019-11-07	FGBX	Futures	214.51	214.67	209.4	210.34	73428.0
2019-11-07	FMWO	Futures	7521.2	7587.1	7521.2	7571.2	3029.0
2019-11-07	FOAT	Futures	152.56	152.71	151.13	151.5	247473.0
2019-11-07	FTDX	Futures	2871.0	2893.2	2868.1	2886.8	54.0
2019-11-07	FTI	Futures	566.63	569.97	566.63	568.78	24858.0
2019-11-07	FTUK	Futures	6833.4	6872.3	6827.8	6838.9	93437.0
2019-11-07	FVSA	Futures	146.54	147.07	142.82	144.41	23808.0
2019-11-07	FXXP	Futures	365.9	368.0	365.9	366.9	83703.0
2019-11-07	G	Futures	120.54	120.73	119.78	120.28	219936.0
2019-11-07	GF	Futures	308.281	309.118	306.658	307.286	1863.0

> showing 50 of 119 rows — these rows as CSV

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