PREVIEW / futures_daily / 2017-05-17

all futures daily files

  file:    by_date/futures_daily/2017/2017-05-17.parquet
  size:    10 KB
  rows:    111

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-17	ES	Futures	2602.7	2602.97	2557.36	2560.35	2814349.0
2017-05-17	NQ	Futures	6741.08	6741.67	6565.88	6570.59	506880.0
2017-05-17	YM	Futures	22091.0	22091.0	21716.4	21741.7	246950.0
2017-05-17	CL	Futures	50.27	51.62	50.1	51.18	418356.0
2017-05-17	GC	Futures	1582.1	1613.2	1581.0	1609.6	377872.0
2017-05-17	ZN	Futures	123.444193	124.335265	123.444193	124.304538	2428546.0
2017-05-17	A6	Futures	0.76172	0.76367	0.75802	0.76172	104489.0
2017-05-17	AD	Futures	0.74993	0.75182	0.74794	0.74881	78936.0
2017-05-17	ALI	Futures	2559.17	2559.17	2559.17	2559.17	0.0
2017-05-17	B	Futures	36.72	37.73	36.6	37.44	331361.0
2017-05-17	B6	Futures	1.3554	1.3632	1.3541	1.3594	120020.0
2017-05-17	BFX	Futures	4833.3	4833.3	4703.7	4703.7	19.0
2017-05-17	BR	Futures	0.23241	0.2331	0.23002	0.23111	2739.0
2017-05-17	BZ	Futures	36.48	37.45	36.35	37.18	32800.0
2017-05-17	C	Futures	1597.0	1610.0	1572.0	1608.0	10658.0
2017-05-17	CB	Futures	292.938	299.072	287.904	295.38	24.0
2017-05-17	CC	Futures	1557.0	1576.0	1532.0	1570.0	19626.0
2017-05-17	CNH	Futures	7.1814	7.1833	7.1762	7.1763	29.0
2017-05-17	CSC	Futures	3.654	3.665	3.621	3.639	104.0
2017-05-17	CT	Futures	90.06	91.97	88.19	88.79	23677.0
2017-05-17	DC	Futures	30.76	30.89	30.28	30.56	489.0
2017-05-17	DX	Futures	91.294	91.312	90.679	90.802	29335.0
2017-05-17	E1	Futures	1.2559	1.26652	1.25577	1.26442	44337.0
2017-05-17	E6	Futures	1.27857	1.28779	1.27828	1.28617	241181.0
2017-05-17	E7	Futures	1.2719	1.2812	1.2719	1.2796	5194.0
2017-05-17	EBM	Futures	185.39	186.23	184.56	185.67	14652.0
2017-05-17	ED	Futures	95.5978	95.6317	95.5978	95.6268	470871.0
2017-05-17	ER	Futures	98.342	98.342	98.337	98.337	30451.0
2017-05-17	EW	Futures	1835.1	1835.5	1797.4	1798.9	26120.0
2017-05-17	FBON	Futures	122.82	123.26	122.67	123.13	724.0
2017-05-17	FBTP	Futures	106.51	107.09	106.31	106.82	105376.0
2017-05-17	FBTS	Futures	102.408	102.589	102.399	102.489	92558.0
2017-05-17	FCE	Futures	4796.4	4804.9	4693.1	4734.0	218501.0
2017-05-17	FDAX	Futures	13460.3	13499.9	13243.3	13331.5	112508.0
2017-05-17	FDIV	Futures	152.33	152.33	151.1	151.1	30.0
2017-05-17	FDXM	Futures	13344.1	13380.7	13127.5	13214.4	37552.0
2017-05-17	FESX	Futures	2944.2	2950.8	2885.5	2907.5	1483324.0
2017-05-17	FEU3	Futures	99.011	99.011	99.011	99.011	114.0
2017-05-17	FGBL	Futures	147.58	148.49	147.48	148.02	883942.0
2017-05-17	FGBM	Futures	128.98	129.43	128.94	129.21	554288.0
2017-05-17	FGBS	Futures	112.187	112.287	112.182	112.232	411099.0
2017-05-17	FGBX	Futures	164.85	167.19	164.75	166.17	65659.0
2017-05-17	FMWO	Futures	6391.6	6391.6	6338.6	6349.5	483.0
2017-05-17	FOAT	Futures	133.95	134.47	133.89	134.25	123867.0
2017-05-17	FTDX	Futures	2175.9	2186.7	2127.8	2151.9	150.0
2017-05-17	FTI	Futures	487.72	488.96	479.6	483.27	45055.0
2017-05-17	FTUK	Futures	6384.0	6415.7	6344.2	6387.5	135269.0
2017-05-17	FVSA	Futures	523.13	570.54	518.05	550.22	34608.0
2017-05-17	FXXP	Futures	331.5	332.3	326.1	328.1	33071.0
2017-05-17	G	Futures	115.58	116.09	115.44	115.91	170555.0

> showing 50 of 111 rows — these rows as CSV

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