PREVIEW / futures_daily / 2017-11-27

all futures daily files

  file:    by_date/futures_daily/2017/2017-11-27.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-11-27	ES	Futures	2829.09	2833.99	2824.2	2829.91	960112.0
2017-11-27	NQ	Futures	7534.25	7546.29	7511.35	7533.08	204123.0
2017-11-27	YM	Futures	24831.7	24938.4	24789.5	24881.3	101427.0
2017-11-27	CL	Futures	59.01	59.05	57.61	58.17	690078.0
2017-11-27	GC	Futures	1638.0	1652.4	1636.3	1646.7	144649.0
2017-11-27	ZN	Futures	123.224075	123.378124	123.08543	123.362719	2900454.0
2017-11-27	A6	Futures	0.783	0.7864	0.78105	0.78259	92050.0
2017-11-27	AD	Futures	0.80063	0.80257	0.79682	0.79748	65237.0
2017-11-27	B	Futures	45.17	45.17	44.54	45.03	265922.0
2017-11-27	B6	Futures	1.3905	1.3962	1.3885	1.3894	104181.0
2017-11-27	BR	Futures	0.23317	0.23317	0.23317	0.23317	1018.0
2017-11-27	BZ	Futures	44.77	44.78	44.2	44.68	26720.0
2017-11-27	C	Futures	1497.0	1503.0	1468.0	1471.0	5683.0
2017-11-27	CB	Futures	283.069	283.069	282.915	282.915	27.0
2017-11-27	CC	Futures	1572.0	1578.0	1536.0	1542.0	20895.0
2017-11-27	CNH	Futures	6.7747	6.7811	6.7737	6.7737	42.0
2017-11-27	CSC	Futures	3.398	3.413	3.381	3.381	49.0
2017-11-27	CT	Futures	84.07	84.55	83.15	83.42	23432.0
2017-11-27	DC	Futures	27.2	27.2	26.94	26.94	109.0
2017-11-27	DX	Futures	86.657	86.844	86.437	86.806	22703.0
2017-11-27	E1	Futures	1.24998	1.25193	1.24668	1.2479	20371.0
2017-11-27	E6	Futures	1.36325	1.36639	1.35886	1.35937	198729.0
2017-11-27	E7	Futures	1.3564	1.3591	1.3517	1.3523	3829.0
2017-11-27	EBM	Futures	169.92	169.92	169.11	169.38	18833.0
2017-11-27	ED	Futures	95.4552	95.4576	95.4503	95.4527	160317.0
2017-11-27	ER	Futures	98.342	98.347	98.342	98.342	14064.0
2017-11-27	EW	Futures	1975.0	1979.3	1971.0	1971.6	10724.0
2017-11-27	FBON	Futures	126.52	126.59	126.19	126.27	277.0
2017-11-27	FBTP	Futures	112.88	113.21	112.77	113.09	86832.0
2017-11-27	FBTS	Futures	103.86	103.869	103.805	103.814	55523.0
2017-11-27	FCE	Futures	4813.2	4844.1	4797.5	4799.7	60296.0
2017-11-27	FDAX	Futures	13698.0	13785.2	13645.5	13657.5	97382.0
2017-11-27	FDXM	Futures	13589.7	13667.9	13531.3	13542.3	38762.0
2017-11-27	FESX	Futures	2910.7	2931.9	2903.4	2905.8	902920.0
2017-11-27	FGBL	Futures	150.58	150.91	150.49	150.82	642166.0
2017-11-27	FGBM	Futures	129.94	130.1	129.92	130.06	414412.0
2017-11-27	FGBS	Futures	112.472	112.507	112.472	112.497	301770.0
2017-11-27	FGBX	Futures	170.5	171.38	170.4	171.09	49669.0
2017-11-27	FMWO	Futures	6844.3	6859.6	6834.8	6834.8	835.0
2017-11-27	FOAT	Futures	139.06	139.33	138.98	139.27	84882.0
2017-11-27	FTDX	Futures	2557.4	2572.3	2545.4	2545.9	180.0
2017-11-27	FTI	Futures	501.15	504.17	499.39	499.62	25210.0
2017-11-27	FTUK	Futures	6442.5	6455.1	6404.8	6411.3	84466.0
2017-11-27	FVSA	Futures	312.23	321.62	311.05	318.1	26028.0
2017-11-27	FXXP	Futures	327.7	329.4	326.8	327.0	19697.0
2017-11-27	G	Futures	114.79	114.86	114.52	114.63	257389.0
2017-11-27	GF	Futures	331.489	335.381	330.3	333.921	4798.0
2017-11-27	GSCI	Futures	500.86	502.26	499.05	501.56	353.0
2017-11-27	HE	Futures	92.976	93.677	92.776	93.51	11279.0
2017-11-27	HG	Futures	3.8264	3.8276	3.7629	3.7797	64583.0

> showing 50 of 109 rows — these rows as CSV

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