PREVIEW / futures_daily / 2017-03-02

all futures daily files

  file:    by_date/futures_daily/2017/2017-03-02.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-03-02	ES	Futures	2593.44	2595.61	2577.99	2582.33	1744834.0
2017-03-02	NQ	Futures	6344.15	6357.12	6312.92	6322.94	206020.0
2017-03-02	YM	Futures	22197.2	22256.2	22089.8	22125.6	151866.0
2017-03-02	CL	Futures	56.97	57.09	55.75	55.82	638390.0
2017-03-02	GC	Futures	1596.7	1597.9	1572.7	1575.0	272763.0
2017-03-02	ZN	Futures	121.568569	121.629697	121.217082	121.35462	62582.0
2017-03-02	A6	Futures	0.78652	0.78652	0.77382	0.77484	121362.0
2017-03-02	AD	Futures	0.76647	0.76647	0.76213	0.76279	66658.0
2017-03-02	ALI	Futures	2569.12	2569.12	2569.12	2569.12	0.0
2017-03-02	B	Futures	41.12	41.21	40.18	40.22	350118.0
2017-03-02	B6	Futures	1.2906	1.2912	1.2843	1.2863	117496.0
2017-03-02	BR	Futures	0.22821	0.22821	0.22459	0.22571	24.0
2017-03-02	BZ	Futures	40.93	41.03	39.99	40.04	34925.0
2017-03-02	C	Futures	1586.0	1629.0	1575.0	1618.0	7738.0
2017-03-02	CB	Futures	277.163	277.163	275.85	275.881	23.0
2017-03-02	CC	Futures	1448.0	1481.0	1427.0	1472.0	28677.0
2017-03-02	CNH	Futures	7.2648	7.2736	7.2648	7.2733	8.0
2017-03-02	CSC	Futures	3.706	3.717	3.692	3.71	76.0
2017-03-02	CT	Futures	86.61	88.26	85.07	85.58	32449.0
2017-03-02	DC	Futures	30.18	30.44	30.01	30.33	128.0
2017-03-02	DX	Futures	94.794	95.222	94.775	95.161	30509.0
2017-03-02	E1	Futures	1.22921	1.22946	1.22202	1.22277	19171.0
2017-03-02	E6	Futures	1.21872	1.21912	1.2126	1.21335	195151.0
2017-03-02	E7	Futures	1.2127	1.2127	1.2064	1.2072	2827.0
2017-03-02	EBM	Futures	199.11	199.97	198.55	199.4	6876.0
2017-03-02	ED	Futures	95.4916	95.4965	95.4796	95.4916	466899.0
2017-03-02	ER	Futures	98.308	98.308	98.303	98.303	61775.0
2017-03-02	EW	Futures	1868.4	1871.6	1847.4	1849.7	15017.0
2017-03-02	FBON	Futures	121.11	121.24	120.83	121.13	1624.0
2017-03-02	FBTP	Futures	104.94	105.0	104.55	104.81	212306.0
2017-03-02	FBTS	Futures	101.728	101.791	101.71	101.773	73864.0
2017-03-02	FCE	Futures	4365.8	4375.5	4358.8	4366.7	69915.0
2017-03-02	FDAX	Futures	12744.0	12761.4	12707.6	12729.2	55263.0
2017-03-02	FDXM	Futures	12695.3	12708.9	12655.3	12677.9	19491.0
2017-03-02	FESX	Futures	2713.5	2715.1	2701.5	2708.7	854103.0
2017-03-02	FEU3	Futures	98.971	98.976	98.971	98.976	76.0
2017-03-02	FGBL	Futures	148.8	148.8	148.28	148.45	1290576.0
2017-03-02	FGBM	Futures	129.73	129.81	129.59	129.64	915373.0
2017-03-02	FGBS	Futures	112.377	112.427	112.367	112.377	595845.0
2017-03-02	FGBX	Futures	168.57	168.59	167.12	167.64	95005.0
2017-03-02	FMWO	Futures	6215.7	6215.7	6190.4	6195.2	817.0
2017-03-02	FOAT	Futures	131.99	132.14	131.69	132.03	370251.0
2017-03-02	FTDX	Futures	1897.9	1897.9	1882.3	1889.1	138.0
2017-03-02	FTI	Futures	459.11	460.02	456.48	457.66	22949.0
2017-03-02	FTUK	Futures	6240.7	6257.7	6238.2	6249.2	85438.0
2017-03-02	FVSA	Futures	698.91	705.19	690.54	696.82	12364.0
2017-03-02	FXXP	Futures	311.5	311.9	310.8	311.3	37805.0
2017-03-02	G	Futures	114.09	114.59	114.04	114.16	200414.0
2017-03-02	GF	Futures	283.485	283.599	280.693	281.433	3973.0
2017-03-02	GSCI	Futures	516.71	516.71	509.5	509.5	505.0

> showing 50 of 109 rows — these rows as CSV

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