PREVIEW / futures_daily / 2017-05-11

all futures daily files

  file:    by_date/futures_daily/2017/2017-05-11.parquet
  size:    9 KB
  rows:    110

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-11	ES	Futures	2601.07	2601.34	2583.7	2596.73	1356242.0
2017-05-11	NQ	Futures	6683.66	6685.43	6638.32	6678.95	238806.0
2017-05-11	YM	Futures	22039.3	22050.9	21905.3	22021.4	125739.0
2017-05-11	CL	Futures	49.45	50.31	49.39	49.9	661783.0
2017-05-11	GC	Futures	1559.1	1570.0	1556.2	1565.5	237710.0
2017-05-11	ZN	Futures	122.706754	122.952567	122.629937	122.82966	1273761.0
2017-05-11	A6	Futures	0.75484	0.7574	0.75278	0.75628	104045.0
2017-05-11	AD	Futures	0.74657	0.74657	0.74101	0.74504	77307.0
2017-05-11	ALI	Futures	2509.51	2509.51	2509.51	2509.51	20.0
2017-05-11	B	Futures	36.06	36.69	36.04	36.41	315588.0
2017-05-11	B6	Futures	1.3575	1.3588	1.3484	1.3528	129324.0
2017-05-11	BR	Futures	0.22749	0.22955	0.22749	0.22861	989.0
2017-05-11	BZ	Futures	35.8	36.42	35.77	36.15	31243.0
2017-05-11	C	Futures	1551.0	1559.0	1539.0	1548.0	17393.0
2017-05-11	CB	Futures	272.189	277.04	272.189	276.461	21.0
2017-05-11	CC	Futures	1493.0	1502.0	1484.0	1492.0	12342.0
2017-05-11	CNH	Futures	7.223	7.223	7.211	7.211	1.0
2017-05-11	CSC	Futures	3.63	3.661	3.63	3.656	149.0
2017-05-11	CT	Futures	84.55	87.72	84.36	87.69	43612.0
2017-05-11	DC	Futures	30.09	30.59	30.05	30.57	646.0
2017-05-11	DX	Futures	92.761	92.947	92.584	92.705	18322.0
2017-05-11	E1	Futures	1.22748	1.23131	1.22587	1.22921	30234.0
2017-05-11	E6	Futures	1.25398	1.25686	1.2507	1.25381	134104.0
2017-05-11	E7	Futures	1.2474	1.2504	1.2442	1.2474	2753.0
2017-05-11	EBM	Futures	189.57	190.12	188.73	189.29	9631.0
2017-05-11	ED	Futures	95.5784	95.5881	95.5736	95.5833	221356.0
2017-05-11	ER	Futures	98.337	98.337	98.332	98.337	36083.0
2017-05-11	EW	Futures	1844.0	1844.1	1820.2	1834.9	12894.0
2017-05-11	FBON	Futures	122.48	122.54	122.24	122.36	942.0
2017-05-11	FBTP	Futures	105.76	105.84	105.51	105.65	111550.0
2017-05-11	FBTS	Futures	102.226	102.272	102.217	102.253	50385.0
2017-05-11	FCE	Futures	4797.1	4802.5	4753.0	4777.5	95332.0
2017-05-11	FDAX	Futures	13480.3	13492.5	13372.6	13415.9	81697.0
2017-05-11	FDIV	Futures	152.24	152.24	151.58	151.58	33.0
2017-05-11	FDXM	Futures	13365.0	13374.5	13255.2	13298.1	25912.0
2017-05-11	FESX	Futures	2948.3	2951.6	2914.9	2926.3	1205020.0
2017-05-11	FEU3	Futures	99.011	99.011	99.011	99.011	3.0
2017-05-11	FGBL	Futures	147.32	147.56	147.05	147.43	726854.0
2017-05-11	FGBM	Futures	128.86	128.97	128.73	128.92	474521.0
2017-05-11	FGBS	Futures	112.162	112.197	112.127	112.182	321515.0
2017-05-11	FGBX	Futures	165.03	165.73	164.53	165.35	55397.0
2017-05-11	FMWO	Futures	6368.7	6369.9	6332.6	6344.6	1466.0
2017-05-11	FOAT	Futures	133.99	134.1	133.71	133.76	132663.0
2017-05-11	FTDX	Futures	2107.3	2124.4	2099.9	2107.7	226.0
2017-05-11	FTI	Futures	489.01	489.83	486.16	487.12	46.0
2017-05-11	FTUK	Futures	6283.0	6302.7	6273.6	6290.8	129710.0
2017-05-11	FVSA	Futures	526.13	538.66	513.61	533.29	20507.0
2017-05-11	FXXP	Futures	332.3	332.5	330.0	330.6	30878.0
2017-05-11	G	Futures	114.69	115.0	114.61	114.9	163896.0
2017-05-11	GF	Futures	328.235	329.058	317.534	323.406	9563.0

> showing 50 of 110 rows — these rows as CSV

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