PREVIEW / futures_daily / 2017-08-07

all futures daily files

  file:    by_date/futures_daily/2017/2017-08-07.parquet
  size:    9 KB
  rows:    107

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-08-07	ES	Futures	2686.9	2693.42	2686.63	2692.6	599701.0
2017-08-07	NQ	Futures	6935.69	6980.07	6933.34	6975.66	165201.0
2017-08-07	YM	Futures	23279.6	23342.0	23276.5	23321.9	58492.0
2017-08-07	CL	Futures	51.01	51.15	49.93	50.8	831374.0
2017-08-07	GC	Futures	1608.7	1610.4	1604.9	1609.2	123206.0
2017-08-07	ZN	Futures	124.196198	124.319317	124.0423	124.273148	699883.0
2017-08-07	A6	Futures	0.81667	0.81677	0.81102	0.81245	55799.0
2017-08-07	AD	Futures	0.80543	0.80584	0.8004	0.80258	48012.0
2017-08-07	ALI	Futures	2546.41	2565.76	2546.41	2565.76	10.0
2017-08-07	B	Futures	36.65	36.74	35.93	36.63	260937.0
2017-08-07	B6	Futures	1.365	1.3666	1.3619	1.3637	68297.0
2017-08-07	BR	Futures	0.23566	0.23674	0.23537	0.2367	959.0
2017-08-07	BZ	Futures	36.33	36.45	35.63	36.32	29496.0
2017-08-07	C	Futures	1582.0	1605.0	1575.0	1596.0	14692.0
2017-08-07	CB	Futures	330.655	330.655	327.218	328.739	110.0
2017-08-07	CC	Futures	1514.0	1535.0	1500.0	1516.0	35839.0
2017-08-07	CNH	Futures	6.9661	6.9661	6.9636	6.9636	4.0
2017-08-07	CSC	Futures	3.497	3.507	3.466	3.483	26.0
2017-08-07	CT	Futures	82.85	83.47	82.85	83.12	11.0
2017-08-07	DC	Futures	29.06	29.22	28.83	28.95	467.0
2017-08-07	DX	Futures	87.195	87.228	87.004	87.129	13479.0
2017-08-07	E1	Futures	1.26547	1.26781	1.26326	1.26523	17103.0
2017-08-07	E6	Futures	1.35145	1.35654	1.35133	1.35425	145226.0
2017-08-07	E7	Futures	1.3451	1.3493	1.3446	1.3471	2466.0
2017-08-07	EBM	Futures	182.05	182.05	180.38	180.38	10538.0
2017-08-07	ED	Futures	95.5935	95.5983	95.5935	95.5983	48090.0
2017-08-07	ER	Futures	98.342	98.342	98.337	98.337	23074.0
2017-08-07	EW	Futures	1860.5	1865.8	1854.7	1860.4	10600.0
2017-08-07	FBON	Futures	124.68	124.92	124.56	124.85	60.0
2017-08-07	FBTP	Futures	109.29	109.58	109.2	109.51	39938.0
2017-08-07	FBTS	Futures	102.972	103.0	102.963	103.0	17465.0
2017-08-07	FCE	Futures	4671.1	4687.7	4663.9	4673.8	45335.0
2017-08-07	FDAX	Futures	12946.6	12983.5	12860.8	12891.3	50685.0
2017-08-07	FDXM	Futures	12873.2	12903.6	12783.2	12812.0	16408.0
2017-08-07	FESX	Futures	2863.4	2870.0	2852.0	2857.7	474913.0
2017-08-07	FGBL	Futures	148.16	148.42	147.93	148.35	324000.0
2017-08-07	FGBM	Futures	129.11	129.21	129.0	129.19	220102.0
2017-08-07	FGBS	Futures	112.287	112.307	112.252	112.297	128922.0
2017-08-07	FGBX	Futures	166.69	167.11	166.06	166.93	17942.0
2017-08-07	FMWO	Futures	6580.5	6586.5	6574.6	6576.9	412.0
2017-08-07	FOAT	Futures	135.76	135.93	135.55	135.83	69166.0
2017-08-07	FTDX	Futures	2292.7	2292.7	2277.2	2286.2	136.0
2017-08-07	FTI	Futures	488.15	490.28	487.78	489.82	15007.0
2017-08-07	FTUK	Futures	6453.1	6466.0	6445.7	6459.5	48226.0
2017-08-07	FVSA	Futures	416.8	424.22	413.83	416.8	14782.0
2017-08-07	FXXP	Futures	325.1	325.6	323.9	324.4	24364.0
2017-08-07	G	Futures	115.01	115.41	114.91	115.35	83541.0
2017-08-07	GF	Futures	328.18	328.235	319.784	321.046	4518.0
2017-08-07	GSCI	Futures	466.38	466.8	466.38	466.8	2396.0
2017-08-07	HE	Futures	93.708	95.913	93.253	95.353	22640.0

> showing 50 of 107 rows — these rows as CSV

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