PREVIEW / futures_daily / 2017-05-16

all futures daily files

  file:    by_date/futures_daily/2017/2017-05-16.parquet
  size:    9 KB
  rows:    112

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-16	ES	Futures	2606.23	2611.39	2599.72	2603.25	1071111.0
2017-05-16	NQ	Futures	6719.29	6745.5	6708.98	6741.96	183423.0
2017-05-16	YM	Futures	22095.2	22153.3	22046.7	22089.9	101235.0
2017-05-16	CL	Futures	50.88	51.47	50.25	50.75	293864.0
2017-05-16	GC	Futures	1574.0	1584.6	1572.9	1581.1	204211.0
2017-05-16	ZN	Futures	123.33665	123.613189	123.183017	123.444193	1287954.0
2017-05-16	A6	Futures	0.76048	0.76305	0.75864	0.76202	78423.0
2017-05-16	AD	Futures	0.7485	0.75167	0.74703	0.75131	72575.0
2017-05-16	ALI	Futures	2556.63	2556.63	2556.63	2556.63	0.0
2017-05-16	B	Futures	37.21	37.55	36.65	37.04	340962.0
2017-05-16	B6	Futures	1.3533	1.3598	1.35	1.3559	112570.0
2017-05-16	BFX	Futures	4848.5	4848.5	4843.0	4843.0	5.0
2017-05-16	BR	Futures	0.23245	0.23364	0.2323	0.2331	4165.0
2017-05-16	BZ	Futures	36.93	37.28	36.45	36.78	29359.0
2017-05-16	C	Futures	1612.0	1626.0	1558.0	1597.0	15884.0
2017-05-16	CB	Futures	290.711	297.546	290.711	297.546	62.0
2017-05-16	CC	Futures	1565.0	1571.0	1510.0	1555.0	26428.0
2017-05-16	CNH	Futures	7.189	7.189	7.1794	7.1794	45.0
2017-05-16	CSC	Futures	3.65	3.677	3.645	3.654	58.0
2017-05-16	CT	Futures	94.29	94.34	90.06	90.06	29632.0
2017-05-16	DC	Futures	30.78	30.93	30.61	30.76	398.0
2017-05-16	DX	Futures	92.011	92.02	91.275	91.301	32800.0
2017-05-16	E1	Futures	1.24292	1.25713	1.24231	1.25689	33523.0
2017-05-16	E6	Futures	1.26665	1.2803	1.26642	1.28001	228579.0
2017-05-16	E7	Futures	1.26	1.2738	1.26	1.2735	5589.0
2017-05-16	EBM	Futures	186.23	186.23	184.83	185.11	16512.0
2017-05-16	ED	Futures	95.6002	95.6026	95.593	95.5978	197954.0
2017-05-16	ER	Futures	98.337	98.342	98.332	98.337	85627.0
2017-05-16	EW	Futures	1838.3	1841.7	1825.7	1836.6	13539.0
2017-05-16	FBON	Futures	122.55	122.91	122.48	122.75	685.0
2017-05-16	FBTP	Futures	106.03	106.48	105.92	106.36	98490.0
2017-05-16	FBTS	Futures	102.299	102.399	102.272	102.38	69901.0
2017-05-16	FCE	Futures	4807.2	4822.9	4796.0	4812.1	225713.0
2017-05-16	FDAX	Futures	13514.1	13556.3	13483.5	13513.6	63577.0
2017-05-16	FDIV	Futures	152.9	152.99	152.86	152.99	45.0
2017-05-16	FDXM	Futures	13398.5	13436.2	13366.1	13394.9	17904.0
2017-05-16	FESX	Futures	2950.0	2962.2	2945.9	2955.7	730677.0
2017-05-16	FEU3	Futures	99.011	99.016	99.011	99.016	13.0
2017-05-16	FGBL	Futures	147.61	147.63	147.2	147.49	700543.0
2017-05-16	FGBM	Futures	129.02	129.05	128.89	128.96	415934.0
2017-05-16	FGBS	Futures	112.212	112.222	112.162	112.187	163883.0
2017-05-16	FGBX	Futures	164.87	165.17	163.97	164.79	55350.0
2017-05-16	FMWO	Futures	6401.3	6424.1	6400.1	6410.9	2478.0
2017-05-16	FOAT	Futures	133.94	133.95	133.65	133.82	170373.0
2017-05-16	FTDX	Futures	2183.7	2193.5	2167.1	2184.2	386.0
2017-05-16	FTI	Futures	489.23	489.83	487.86	489.37	34394.0
2017-05-16	FTUK	Futures	6354.1	6416.5	6343.8	6407.6	110473.0
2017-05-16	FVSA	Futures	524.83	528.21	512.98	518.05	46276.0
2017-05-16	FXXP	Futures	332.5	333.1	331.5	332.7	21170.0
2017-05-16	G	Futures	115.1	115.48	114.92	115.46	249308.0

> showing 50 of 112 rows — these rows as CSV

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