PREVIEW / futures_daily / 2017-09-11

all futures daily files

  file:    by_date/futures_daily/2017/2017-09-11.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-09-11	ES	Futures	2682.28	2705.1	2682.28	2703.47	1333316.0
2017-09-11	NQ	Futures	6969.49	7043.55	6969.49	7032.67	160000.0
2017-09-11	YM	Futures	23057.6	23272.0	23038.6	23249.8	127443.0
2017-09-11	CL	Futures	48.83	49.54	48.24	49.34	774468.0
2017-09-11	GC	Futures	1706.9	1710.9	1693.1	1699.6	303112.0
2017-09-11	ZN	Futures	125.4886	125.51941	125.088072	125.211311	975119.0
2017-09-11	A6	Futures	0.82807	0.82817	0.82406	0.82529	26192.0
2017-09-11	AD	Futures	0.83752	0.84133	0.83625	0.84037	15856.0
2017-09-11	ALI	Futures	2765.93	2765.93	2756.81	2756.81	5.0
2017-09-11	B	Futures	37.74	37.97	37.19	37.76	276434.0
2017-09-11	B6	Futures	1.3798	1.3827	1.3763	1.3777	50727.0
2017-09-11	BR	Futures	0.24399	0.24399	0.24098	0.24098	7.0
2017-09-11	BZ	Futures	37.37	37.62	36.88	37.43	30263.0
2017-09-11	C	Futures	1447.0	1456.0	1428.0	1444.0	11068.0
2017-09-11	CB	Futures	305.454	305.485	303.973	303.973	39.0
2017-09-11	CC	Futures	1437.0	1443.0	1420.0	1436.0	16670.0
2017-09-11	CNH	Futures	6.7183	6.7406	6.7135	6.7406	414.0
2017-09-11	CSC	Futures	3.383	3.387	3.373	3.373	48.0
2017-09-11	CT	Futures	88.2	88.2	84.72	86.03	72.0
2017-09-11	DC	Futures	27.78	27.89	27.43	27.45	238.0
2017-09-11	DX	Futures	85.277	85.787	85.254	85.677	20373.0
2017-09-11	E1	Futures	1.30023	1.30023	1.28593	1.28923	6440.0
2017-09-11	E6	Futures	1.3786	1.37968	1.37027	1.37204	95260.0
2017-09-11	E7	Futures	1.3714	1.3721	1.3632	1.3649	818.0
2017-09-11	EBM	Futures	171.54	181.52	171.27	171.54	16661.0
2017-09-11	ED	Futures	95.62	95.6248	95.5957	95.6006	255383.0
2017-09-11	ER	Futures	98.342	98.347	98.342	98.347	30886.0
2017-09-11	EW	Futures	1825.0	1851.3	1825.0	1847.6	37611.0
2017-09-11	FBON	Futures	125.17	125.37	124.92	125.0	201.0
2017-09-11	FBTP	Futures	110.1	110.36	109.86	110.08	66331.0
2017-09-11	FBTS	Futures	103.283	103.32	103.274	103.292	33390.0
2017-09-11	FCE	Futures	4592.4	4643.8	4591.9	4630.4	183550.0
2017-09-11	FDAX	Futures	13023.0	13170.9	13023.0	13125.6	111436.0
2017-09-11	FDXM	Futures	12872.7	13021.7	12872.7	12980.0	1847.0
2017-09-11	FESX	Futures	2813.6	2848.7	2813.6	2837.3	1083930.0
2017-09-11	FGBL	Futures	150.58	150.61	150.38	150.5	458612.0
2017-09-11	FGBM	Futures	130.1	130.15	130.06	130.11	295835.0
2017-09-11	FGBS	Futures	112.522	112.532	112.507	112.532	144463.0
2017-09-11	FGBX	Futures	170.52	170.52	169.85	170.2	33325.0
2017-09-11	FMWO	Futures	6598.4	6622.2	6598.4	6615.0	9514.0
2017-09-11	FOAT	Futures	137.42	137.54	137.31	137.42	99891.0
2017-09-11	FTDX	Futures	2334.8	2359.2	2334.8	2354.7	1257.0
2017-09-11	FTI	Futures	480.42	483.56	480.42	482.27	10727.0
2017-09-11	FTUK	Futures	6377.0	6417.8	6375.3	6393.9	302946.0
2017-09-11	FVSA	Futures	478.63	480.2	453.43	459.73	27839.0
2017-09-11	FXXP	Futures	319.8	322.1	319.6	320.9	95861.0
2017-09-11	G	Futures	116.7	116.78	116.41	116.46	134902.0
2017-09-11	GF	Futures	324.212	326.722	323.721	325.958	7044.0
2017-09-11	GSCI	Futures	463.3	464.62	463.18	464.62	2453.0
2017-09-11	HE	Futures	86.535	87.165	85.73	86.185	26815.0

> showing 50 of 108 rows — these rows as CSV

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