PREVIEW / futures_daily / 2017-05-02

all futures daily files

  file:    by_date/futures_daily/2017/2017-05-02.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-05-02	ES	Futures	2591.57	2594.29	2586.68	2591.03	958983.0
2017-05-02	NQ	Futures	6629.78	6644.79	6622.12	6642.44	169050.0
2017-05-02	YM	Futures	22022.4	22046.7	21985.5	22016.1	75155.0
2017-05-02	CL	Futures	50.9	51.42	49.4	49.73	702375.0
2017-05-02	GC	Futures	1608.0	1609.8	1601.8	1607.5	181512.0
2017-05-02	ZN	Futures	123.428829	123.705369	123.24447	123.597826	997048.0
2017-05-02	A6	Futures	0.77178	0.77506	0.77034	0.77249	70585.0
2017-05-02	AD	Futures	0.74601	0.74753	0.74167	0.74376	77346.0
2017-05-02	ALI	Futures	2579.77	2579.77	2579.77	2579.77	0.0
2017-05-02	B	Futures	36.86	37.41	35.96	36.19	364060.0
2017-05-02	B6	Futures	1.3525	1.3584	1.3505	1.3574	88216.0
2017-05-02	BR	Futures	0.22636	0.22839	0.22481	0.22828	1830.0
2017-05-02	BZ	Futures	36.59	37.13	35.72	35.93	38556.0
2017-05-02	C	Futures	1443.0	1469.0	1434.0	1436.0	4500.0
2017-05-02	CC	Futures	1388.0	1411.0	1370.0	1380.0	19130.0
2017-05-02	CNH	Futures	7.2221	7.2221	7.2114	7.2114	128.0
2017-05-02	CSC	Futures	3.509	3.509	3.504	3.504	47.0
2017-05-02	CT	Futures	87.57	87.97	86.8	87.9	12005.0
2017-05-02	DC	Futures	28.89	29.17	28.8	29.03	290.0
2017-05-02	DX	Futures	92.17	92.314	92.025	92.075	19825.0
2017-05-02	E1	Futures	1.24416	1.25021	1.24342	1.24861	24230.0
2017-05-02	E6	Futures	1.2583	1.26222	1.25703	1.26152	124484.0
2017-05-02	E7	Futures	1.252	1.2558	1.2506	1.2551	2522.0
2017-05-02	EBM	Futures	190.98	192.1	189.3	189.86	20320.0
2017-05-02	ED	Futures	95.5542	95.5688	95.5397	95.5639	147902.0
2017-05-02	ER	Futures	98.332	98.342	98.332	98.337	181851.0
2017-05-02	EW	Futures	1845.5	1850.2	1836.9	1841.2	11314.0
2017-05-02	FBON	Futures	121.95	122.06	121.59	121.94	209.0
2017-05-02	FBTP	Futures	105.94	105.96	104.94	105.44	80790.0
2017-05-02	FBTS	Futures	102.072	102.099	102.027	102.081	19847.0
2017-05-02	FCE	Futures	4647.8	4693.8	4647.0	4682.6	75187.0
2017-05-02	FDAX	Futures	13165.7	13240.2	13135.6	13208.5	66639.0
2017-05-02	FDXM	Futures	13046.9	13125.4	13021.8	13092.4	16505.0
2017-05-02	FESX	Futures	2858.5	2883.8	2856.9	2878.1	731670.0
2017-05-02	FGBL	Futures	148.61	148.71	148.38	148.6	472969.0
2017-05-02	FGBM	Futures	129.4	129.42	129.26	129.32	355674.0
2017-05-02	FGBS	Futures	112.312	112.327	112.277	112.292	186045.0
2017-05-02	FGBX	Futures	168.57	169.15	167.91	168.69	37199.0
2017-05-02	FMWO	Futures	6329.0	6339.8	6326.6	6330.2	3072.0
2017-05-02	FOAT	Futures	134.35	134.35	133.92	134.33	81740.0
2017-05-02	FTDX	Futures	2067.5	2094.5	2048.9	2086.2	123.0
2017-05-02	FTI	Futures	474.33	478.73	474.19	477.95	23217.0
2017-05-02	FTUK	Futures	6132.9	6172.2	6127.3	6157.7	97633.0
2017-05-02	FVSA	Futures	572.66	585.19	570.87	574.45	18098.0
2017-05-02	FXXP	Futures	323.6	325.9	323.2	325.4	20367.0
2017-05-02	G	Futures	115.66	115.74	115.38	115.62	139315.0
2017-05-02	GF	Futures	340.481	350.791	338.991	342.829	3626.0
2017-05-02	GSCI	Futures	481.53	481.53	473.74	473.74	248.0
2017-05-02	HE	Futures	79.523	80.577	79.387	80.226	17088.0
2017-05-02	HG	Futures	3.2633	3.2646	3.2143	3.2308	88303.0

> showing 50 of 108 rows — these rows as CSV

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