PREVIEW / futures_daily / 2017-03-21

all futures daily files

  file:    by_date/futures_daily/2017/2017-03-21.parquet
  size:    9 KB
  rows:    108

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
2017-03-21	ES	Futures	2572.84	2583.43	2539.17	2543.78	2567939.0
2017-03-21	NQ	Futures	6378.61	6408.35	6277.62	6287.33	414738.0
2017-03-21	YM	Futures	22005.5	22071.0	21739.6	21765.0	266691.0
2017-03-21	CL	Futures	51.26	51.86	50.3	50.56	628119.0
2017-03-21	GC	Futures	1576.7	1593.9	1567.0	1592.4	285634.0
2017-03-21	ZN	Futures	121.984678	122.353398	121.692776	122.199765	1789403.0
2017-03-21	A6	Futures	0.79231	0.79426	0.78738	0.78933	113497.0
2017-03-21	AD	Futures	0.76467	0.76982	0.7639	0.76518	71924.0
2017-03-21	ALI	Futures	2578.95	2578.95	2578.95	2578.95	0.0
2017-03-21	B	Futures	37.75	38.13	37.04	37.21	291705.0
2017-03-21	B6	Futures	1.2989	1.3129	1.2969	1.3109	136570.0
2017-03-21	BR	Futures	0.23169	0.23169	0.23067	0.23089	541.0
2017-03-21	BZ	Futures	37.55	37.95	36.88	37.04	30377.0
2017-03-21	C	Futures	1793.0	1825.0	1772.0	1795.0	15089.0
2017-03-21	CB	Futures	265.445	266.086	264.865	265.964	42.0
2017-03-21	CC	Futures	1644.0	1670.0	1619.0	1644.0	32199.0
2017-03-21	CNH	Futures	7.2388	7.2388	7.2138	7.2168	3.0
2017-03-21	CSC	Futures	3.596	3.67	3.596	3.67	69.0
2017-03-21	CT	Futures	86.19	86.36	85.47	85.65	19048.0
2017-03-21	DC	Futures	29.25	30.0	29.04	29.88	480.0
2017-03-21	DX	Futures	93.329	93.334	92.663	92.807	33893.0
2017-03-21	E1	Futures	1.24379	1.25231	1.24193	1.24885	21363.0
2017-03-21	E6	Futures	1.2424	1.25185	1.24021	1.24949	239602.0
2017-03-21	E7	Futures	1.2361	1.2455	1.2342	1.2432	4821.0
2017-03-21	EBM	Futures	191.54	191.82	189.58	191.26	30872.0
2017-03-21	ED	Futures	95.5349	95.5397	95.5252	95.5349	350113.0
2017-03-21	ER	Futures	98.303	98.308	98.303	98.308	28393.0
2017-03-21	EW	Futures	1829.9	1837.8	1791.7	1792.7	26010.0
2017-03-21	FBON	Futures	119.81	120.28	119.69	120.19	1001.0
2017-03-21	FBTP	Futures	102.93	103.37	102.86	103.22	108089.0
2017-03-21	FBTS	Futures	101.528	101.601	101.519	101.564	45845.0
2017-03-21	FCE	Futures	4420.4	4453.1	4386.0	4405.9	101613.0
2017-03-21	FDAX	Futures	12770.9	12818.4	12587.7	12654.8	112785.0
2017-03-21	FDXM	Futures	12656.6	12704.7	12476.6	12543.6	37968.0
2017-03-21	FESX	Futures	2746.7	2772.8	2723.0	2734.5	1261152.0
2017-03-21	FGBL	Futures	146.76	146.9	146.24	146.64	880963.0
2017-03-21	FGBM	Futures	128.82	128.88	128.51	128.66	634755.0
2017-03-21	FGBS	Futures	112.312	112.317	112.187	112.222	416594.0
2017-03-21	FGBX	Futures	165.37	165.99	164.05	165.39	51096.0
2017-03-21	FMWO	Futures	6247.1	6257.9	6170.0	6198.9	370.0
2017-03-21	FOAT	Futures	130.12	130.43	129.73	130.15	133427.0
2017-03-21	FTDX	Futures	1958.7	1958.7	1901.9	1929.8	77.0
2017-03-21	FTI	Futures	467.02	470.25	463.34	465.34	34845.0
2017-03-21	FTUK	Futures	6290.3	6305.7	6221.4	6253.5	108927.0
2017-03-21	FVSA	Futures	637.78	644.71	622.53	639.17	35631.0
2017-03-21	FXXP	Futures	313.0	314.4	310.1	311.4	33433.0
2017-03-21	G	Futures	113.76	113.91	113.21	113.72	227795.0
2017-03-21	GF	Futures	306.154	307.422	304.078	305.866	4442.0
2017-03-21	GSCI	Futures	487.77	488.34	483.12	483.56	63.0
2017-03-21	HE	Futures	87.744	88.252	86.848	87.027	58.0

> showing 50 of 108 rows — these rows as CSV

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