PREVIEW / futures_daily / 2017-05-22

all futures daily files

  file:    by_date/futures_daily/2017/2017-05-22.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-05-22	ES	Futures	2586.68	2600.26	2582.88	2598.63	1113022.0
2017-05-22	NQ	Futures	6657.75	6718.41	6653.04	6715.76	198203.0
2017-05-22	YM	Futures	21934.8	22045.6	21911.6	22029.8	99247.0
2017-05-22	CL	Futures	52.75	53.27	52.57	52.96	564310.0
2017-05-22	GC	Futures	1608.1	1614.6	1600.6	1613.1	205212.0
2017-05-22	ZN	Futures	124.120178	124.150905	123.935819	124.012635	986022.0
2017-05-22	A6	Futures	0.76428	0.76839	0.76285	0.76705	68496.0
2017-05-22	AD	Futures	0.75518	0.75656	0.7535	0.75529	45921.0
2017-05-22	ALI	Futures	2563.93	2563.93	2563.93	2563.93	0.0
2017-05-22	B	Futures	38.62	38.99	38.48	38.63	379122.0
2017-05-22	B6	Futures	1.3662	1.3684	1.3603	1.3635	98789.0
2017-05-22	BFX	Futures	4714.0	4720.0	4714.0	4720.0	1.0
2017-05-22	BR	Futures	0.221	0.22144	0.21771	0.21984	3915.0
2017-05-22	BZ	Futures	38.36	38.71	38.2	38.36	41324.0
2017-05-22	C	Futures	1587.0	1602.0	1567.0	1584.0	9213.0
2017-05-22	CB	Futures	295.044	296.017	290.726	292.702	41.0
2017-05-22	CC	Futures	1555.0	1573.0	1540.0	1556.0	21402.0
2017-05-22	CNH	Futures	7.1797	7.1808	7.1771	7.1801	26.0
2017-05-22	CSC	Futures	3.632	3.643	3.614	3.618	31.0
2017-05-22	CT	Futures	88.05	88.05	86.72	86.82	14069.0
2017-05-22	DC	Futures	30.35	30.61	30.31	30.41	198.0
2017-05-22	DX	Futures	90.399	90.684	90.092	90.261	24308.0
2017-05-22	E1	Futures	1.27233	1.27703	1.26739	1.27147	26250.0
2017-05-22	E6	Futures	1.29245	1.29913	1.28733	1.29597	206695.0
2017-05-22	E7	Futures	1.2859	1.2926	1.2809	1.2894	3750.0
2017-05-22	EBM	Futures	185.39	186.78	185.39	186.23	7951.0
2017-05-22	ED	Futures	95.5905	95.593	95.5833	95.5857	208877.0
2017-05-22	ER	Futures	98.332	98.337	98.332	98.337	17154.0
2017-05-22	EW	Futures	1820.4	1829.9	1816.5	1827.1	13801.0
2017-05-22	FBON	Futures	123.17	123.17	122.82	122.91	714.0
2017-05-22	FBTP	Futures	107.14	107.36	106.99	107.16	73477.0
2017-05-22	FBTS	Futures	102.516	102.535	102.498	102.507	21227.0
2017-05-22	FCE	Futures	4743.9	4753.7	4730.4	4737.6	51339.0
2017-05-22	FDAX	Futures	13370.5	13393.2	13264.4	13322.0	68182.0
2017-05-22	FDXM	Futures	13248.9	13275.0	13149.5	13204.9	18354.0
2017-05-22	FESX	Futures	2917.3	2921.4	2900.2	2906.7	621188.0
2017-05-22	FGBL	Futures	148.17	148.4	147.77	147.96	550312.0
2017-05-22	FGBM	Futures	129.23	129.31	129.04	129.16	365572.0
2017-05-22	FGBS	Futures	112.252	112.262	112.202	112.222	212773.0
2017-05-22	FGBX	Futures	166.09	166.53	164.77	165.37	36345.0
2017-05-22	FMWO	Futures	6374.8	6408.5	6374.8	6402.5	3479.0
2017-05-22	FOAT	Futures	134.67	134.83	134.16	134.39	121360.0
2017-05-22	FTDX	Futures	2183.2	2187.6	2167.5	2174.9	174.0
2017-05-22	FTI	Futures	483.36	484.37	482.49	483.36	20463.0
2017-05-22	FTUK	Futures	6400.7	6419.5	6388.3	6399.9	83181.0
2017-05-22	FVSA	Futures	538.37	548.53	528.21	531.6	8794.0
2017-05-22	FXXP	Futures	330.3	330.5	328.7	329.0	18574.0
2017-05-22	G	Futures	115.76	115.99	115.6	115.84	120345.0
2017-05-22	GF	Futures	331.692	337.071	330.101	335.369	4769.0
2017-05-22	GSCI	Futures	483.75	485.53	483.32	485.1	20.0

> showing 50 of 108 rows — these rows as CSV

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