PREVIEW / futures_daily / 2017-03-28

all futures daily files

  file:    by_date/futures_daily/2017/2017-03-28.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-28	ES	Futures	2541.88	2563.6	2534.28	2553.83	1623900.0
2017-03-28	NQ	Futures	6339.45	6389.21	6317.07	6365.95	245032.0
2017-03-28	YM	Futures	21657.3	21818.8	21587.7	21762.8	158903.0
2017-03-28	CL	Futures	50.19	51.08	50.1	50.7	502377.0
2017-03-28	GC	Futures	1607.6	1613.1	1599.2	1609.8	111014.0
2017-03-28	ZN	Futures	122.553121	122.737481	122.184401	122.276581	1345398.0
2017-03-28	A6	Futures	0.7806	0.78461	0.77773	0.78266	85826.0
2017-03-28	AD	Futures	0.76288	0.76462	0.7611	0.76314	48898.0
2017-03-28	ALI	Futures	2589.51	2589.51	2589.51	2589.51	0.0
2017-03-28	B	Futures	36.97	37.71	36.93	37.29	293774.0
2017-03-28	B6	Futures	1.3193	1.3231	1.3069	1.3079	102203.0
2017-03-28	BR	Futures	0.22749	0.22825	0.22738	0.22774	44.0
2017-03-28	BZ	Futures	36.86	37.6	36.84	37.19	24604.0
2017-03-28	C	Futures	1793.0	1793.0	1762.0	1772.0	9454.0
2017-03-28	CB	Futures	262.729	263.034	261.844	263.034	7.0
2017-03-28	CC	Futures	1650.0	1652.0	1612.0	1625.0	15380.0
2017-03-28	CNH	Futures	7.2	7.2097	7.195	7.2097	86.0
2017-03-28	CSC	Futures	3.571	3.621	3.567	3.607	46.0
2017-03-28	CT	Futures	85.83	86.4	85.49	85.69	13920.0
2017-03-28	DC	Futures	29.36	29.79	29.19	29.73	218.0
2017-03-28	DX	Futures	92.286	92.812	92.16	92.746	26358.0
2017-03-28	E1	Futures	1.25998	1.26306	1.24997	1.25157	22677.0
2017-03-28	E6	Futures	1.25634	1.25726	1.24874	1.24983	167224.0
2017-03-28	E7	Futures	1.2498	1.2507	1.2425	1.2435	3392.0
2017-03-28	EBM	Futures	185.94	187.62	185.66	186.78	20428.0
2017-03-28	ED	Futures	95.5639	95.5688	95.5446	95.5494	247925.0
2017-03-28	ER	Futures	98.323	98.328	98.318	98.323	119234.0
2017-03-28	EW	Futures	1799.6	1814.3	1790.5	1811.3	14986.0
2017-03-28	FBON	Futures	121.29	121.77	121.22	121.59	692.0
2017-03-28	FBTP	Futures	104.16	104.83	103.99	104.74	106853.0
2017-03-28	FBTS	Futures	101.773	101.845	101.746	101.827	33917.0
2017-03-28	FCE	Futures	4434.1	4464.1	4413.4	4446.9	74375.0
2017-03-28	FDAX	Futures	12763.5	12895.5	12742.9	12864.3	82675.0
2017-03-28	FDXM	Futures	12648.2	12796.8	12631.5	12751.3	23777.0
2017-03-28	FESX	Futures	2755.7	2776.9	2745.1	2767.9	935636.0
2017-03-28	FEU3	Futures	98.996	99.001	98.996	99.001	6.0
2017-03-28	FGBL	Futures	147.25	147.7	147.18	147.6	672586.0
2017-03-28	FGBM	Futures	128.7	128.97	128.67	128.9	400229.0
2017-03-28	FGBS	Futures	112.152	112.222	112.142	112.202	289632.0
2017-03-28	FGBX	Futures	166.87	167.91	166.61	167.47	37565.0
2017-03-28	FMWO	Futures	6191.7	6217.0	6188.0	6215.7	100.0
2017-03-28	FOAT	Futures	131.34	131.99	131.3	131.73	86000.0
2017-03-28	FTDX	Futures	1965.6	1982.7	1959.7	1981.8	199.0
2017-03-28	FTI	Futures	463.56	466.16	461.56	464.52	23822.0
2017-03-28	FTUK	Futures	6195.8	6240.3	6170.5	6221.4	76628.0
2017-03-28	FVSA	Futures	654.42	657.19	632.24	640.55	16444.0
2017-03-28	FXXP	Futures	312.3	313.9	311.2	312.9	19571.0
2017-03-28	G	Futures	114.55	114.66	114.33	114.47	138805.0
2017-03-28	GF	Futures	306.731	308.345	305.75	306.615	2570.0
2017-03-28	GSCI	Futures	482.48	486.49	482.48	484.45	161.0

> showing 50 of 109 rows — these rows as CSV

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