PREVIEW / futures_daily / 2017-07-26

all futures daily files

  file:    by_date/futures_daily/2017/2017-07-26.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-07-26	ES	Futures	2690.16	2695.05	2686.08	2687.98	972444.0
2017-07-26	NQ	Futures	6975.37	7003.87	6967.43	6992.12	190190.0
2017-07-26	YM	Futures	22794.4	22925.5	22777.5	22882.2	103284.0
2017-07-26	CL	Futures	49.9	50.27	49.23	50.15	887864.0
2017-07-26	GC	Futures	1598.4	1615.7	1589.7	1597.6	95791.0
2017-07-26	ZN	Futures	123.611384	124.165419	123.595994	124.119249	1384097.0
2017-07-26	A6	Futures	0.81482	0.82262	0.80876	0.81862	140917.0
2017-07-26	AD	Futures	0.81377	0.81992	0.81143	0.8155	96763.0
2017-07-26	ALI	Futures	2561.32	2561.32	2561.32	2561.32	0.0
2017-07-26	B	Futures	35.49	35.81	35.14	35.74	295738.0
2017-07-26	B6	Futures	1.3639	1.3739	1.3608	1.3708	104775.0
2017-07-26	BR	Futures	0.23303	0.23503	0.23225	0.23429	9887.0
2017-07-26	BZ	Futures	35.27	35.51	34.84	35.44	17716.0
2017-07-26	C	Futures	1533.0	1541.0	1514.0	1518.0	8122.0
2017-07-26	CB	Futures	319.92	323.812	319.92	321.745	224.0
2017-07-26	CC	Futures	1455.0	1473.0	1443.0	1452.0	18785.0
2017-07-26	CNH	Futures	6.9972	6.9981	6.9847	6.9847	25.0
2017-07-26	CSC	Futures	3.526	3.526	3.499	3.507	16.0
2017-07-26	CT	Futures	81.11	81.52	79.64	80.55	200.0
2017-07-26	DC	Futures	29.18	29.42	29.13	29.22	260.0
2017-07-26	DX	Futures	87.732	87.881	87.046	87.312	30052.0
2017-07-26	E1	Futures	1.29409	1.29728	1.28439	1.29299	41524.0
2017-07-26	E6	Futures	1.33821	1.34887	1.33426	1.34463	267201.0
2017-07-26	E7	Futures	1.3311	1.3417	1.3273	1.3375	4614.0
2017-07-26	EBM	Futures	187.06	188.73	187.06	187.06	14553.0
2017-07-26	ED	Futures	95.5644	95.5935	95.5644	95.5886	192593.0
2017-07-26	ER	Futures	98.337	98.342	98.337	98.342	25086.0
2017-07-26	EW	Futures	1902.6	1905.5	1885.4	1886.2	11463.0
2017-07-26	FBON	Futures	124.1	124.23	123.86	123.93	316.0
2017-07-26	FBTP	Futures	108.12	108.34	107.94	108.07	73416.0
2017-07-26	FBTS	Futures	102.881	102.936	102.881	102.9	33281.0
2017-07-26	FCE	Futures	4629.8	4676.9	4627.5	4659.9	83801.0
2017-07-26	FDAX	Futures	12896.6	12992.4	12881.3	12944.5	69661.0
2017-07-26	FDXM	Futures	12818.8	12908.8	12802.1	12864.8	20639.0
2017-07-26	FESX	Futures	2828.3	2852.8	2827.5	2842.2	678375.0
2017-07-26	FEU3	Futures	99.011	99.016	99.011	99.016	7.0
2017-07-26	FGBL	Futures	146.9	147.26	146.84	146.97	486607.0
2017-07-26	FGBM	Futures	128.62	128.77	128.62	128.69	291166.0
2017-07-26	FGBS	Futures	112.202	112.247	112.202	112.232	202517.0
2017-07-26	FGBX	Futures	163.33	163.92	162.81	163.33	31283.0
2017-07-26	FMWO	Futures	6549.6	6561.5	6549.6	6553.1	37.0
2017-07-26	FOAT	Futures	134.88	135.09	134.8	134.86	91730.0
2017-07-26	FTDX	Futures	2265.7	2281.2	2263.1	2279.7	39.0
2017-07-26	FTI	Futures	481.87	485.24	481.73	484.64	20771.0
2017-07-26	FTUK	Futures	6376.1	6414.6	6368.8	6383.9	80448.0
2017-07-26	FVSA	Futures	431.63	431.63	416.8	421.25	10305.0
2017-07-26	FXXP	Futures	323.3	325.8	323.2	324.8	23521.0
2017-07-26	G	Futures	114.22	114.45	114.16	114.4	107525.0
2017-07-26	GF	Futures	322.473	325.82	318.137	321.54	5134.0
2017-07-26	GSCI	Futures	462.8	463.22	462.8	463.22	621.0

> showing 50 of 109 rows — these rows as CSV

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