PREVIEW / futures_daily / 2017-05-10

all futures daily files

  file:    by_date/futures_daily/2017/2017-05-10.parquet
  size:    9 KB
  rows:    109

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-10	ES	Futures	2597.54	2603.25	2592.93	2601.34	998859.0
2017-05-10	NQ	Futures	6688.08	6689.55	6664.23	6684.54	174081.0
2017-05-10	YM	Futures	22043.5	22089.9	21990.8	22045.6	95700.0
2017-05-10	CL	Futures	48.18	49.85	48.01	49.38	819796.0
2017-05-10	GC	Futures	1562.8	1567.6	1557.0	1558.7	194715.0
2017-05-10	ZN	Futures	122.798934	123.075473	122.691391	122.722117	1182375.0
2017-05-10	A6	Futures	0.7532	0.75853	0.75268	0.75535	97091.0
2017-05-10	AD	Futures	0.74386	0.74764	0.743	0.74621	70619.0
2017-05-10	ALI	Futures	2498.97	2498.97	2498.97	2498.97	0.0
2017-05-10	B	Futures	35.11	36.31	35.01	36.02	368112.0
2017-05-10	B6	Futures	1.3577	1.3631	1.3568	1.3582	94848.0
2017-05-10	BR	Futures	0.22625	0.2285	0.22625	0.22781	1468.0
2017-05-10	BZ	Futures	34.88	36.04	34.78	35.76	37961.0
2017-05-10	C	Futures	1551.0	1558.0	1533.0	1547.0	7248.0
2017-05-10	CB	Futures	263.645	269.32	263.645	266.055	32.0
2017-05-10	CC	Futures	1501.0	1505.0	1482.0	1494.0	14242.0
2017-05-10	CNH	Futures	7.2228	7.2228	7.2221	7.2226	4.0
2017-05-10	CSC	Futures	3.554	3.609	3.547	3.598	71.0
2017-05-10	CT	Futures	85.86	85.91	84.57	84.71	23626.0
2017-05-10	DC	Futures	29.62	30.09	29.53	30.03	403.0
2017-05-10	DX	Futures	92.551	92.798	92.468	92.756	21260.0
2017-05-10	E1	Futures	1.22908	1.23242	1.22661	1.22711	33633.0
2017-05-10	E6	Futures	1.25513	1.25761	1.25242	1.2534	146673.0
2017-05-10	E7	Futures	1.2488	1.2512	1.246	1.2471	2897.0
2017-05-10	EBM	Futures	188.45	189.29	188.17	189.01	8197.0
2017-05-10	ED	Futures	95.5688	95.5833	95.5639	95.5784	307415.0
2017-05-10	ER	Futures	98.337	98.337	98.332	98.337	18284.0
2017-05-10	EW	Futures	1832.3	1848.0	1827.2	1845.9	11451.0
2017-05-10	FBON	Futures	122.49	122.78	122.36	122.6	387.0
2017-05-10	FBTP	Futures	105.6	106.06	105.6	105.92	77487.0
2017-05-10	FBTS	Futures	102.235	102.281	102.226	102.272	22996.0
2017-05-10	FCE	Futures	4785.1	4798.0	4772.2	4792.7	76043.0
2017-05-10	FDAX	Futures	13450.2	13500.9	13426.0	13476.1	56495.0
2017-05-10	FDIV	Futures	152.11	152.42	152.11	152.42	50.0
2017-05-10	FDXM	Futures	13331.6	13380.7	13307.5	13357.7	15351.0
2017-05-10	FESX	Futures	2941.0	2950.0	2934.5	2943.4	820140.0
2017-05-10	FGBL	Futures	147.42	147.81	147.25	147.6	646697.0
2017-05-10	FGBM	Futures	128.94	129.04	128.86	128.93	582168.0
2017-05-10	FGBS	Futures	112.192	112.212	112.167	112.182	244068.0
2017-05-10	FGBX	Futures	165.05	166.47	164.67	165.93	55050.0
2017-05-10	FMWO	Futures	6362.7	6371.1	6355.5	6366.3	487.0
2017-05-10	FOAT	Futures	133.94	134.42	133.87	134.21	108857.0
2017-05-10	FTDX	Futures	2105.3	2114.1	2094.0	2110.2	127.0
2017-05-10	FTI	Futures	488.46	488.87	487.31	488.41	1031.0
2017-05-10	FTUK	Futures	6228.3	6289.5	6221.9	6280.1	98832.0
2017-05-10	FVSA	Futures	527.92	533.29	520.76	527.92	24201.0
2017-05-10	FXXP	Futures	330.8	332.7	330.7	332.1	21424.0
2017-05-10	G	Futures	114.6	114.94	114.53	114.87	140746.0
2017-05-10	GF	Futures	331.144	331.638	323.406	326.918	11190.0
2017-05-10	GSCI	Futures	462.94	463.37	462.27	462.45	2214.0

> showing 50 of 109 rows — these rows as CSV

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