PREVIEW / futures_daily / 2016-04-27

all futures daily files

  file:    by_date/futures_daily/2016/2016-04-27.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
2016-04-27	ES	Futures	2235.75	2248.36	2229.31	2244.88	1420203.0
2016-04-27	NQ	Futures	5175.91	5209.69	5137.42	5197.94	306378.0
2016-04-27	YM	Futures	18590.8	18721.8	18548.1	18677.1	160324.0
2016-04-27	CL	Futures	53.18	54.35	52.14	54.0	648028.0
2016-04-27	GC	Futures	1605.6	1617.1	1599.2	1611.7	171510.0
2016-04-27	ZN	Futures	124.725374	125.404295	124.710287	125.313772	1143464.0
2016-04-27	A6	Futures	0.78245	0.78437	0.76241	0.76535	152477.0
2016-04-27	AD	Futures	0.81122	0.81337	0.80529	0.8102	78368.0
2016-04-27	ALI	Futures	2222.67	2222.67	2222.67	2222.67	0.0
2016-04-27	B	Futures	38.26	39.18	37.72	38.95	288965.0
2016-04-27	B6	Futures	1.5351	1.5398	1.5242	1.5311	97062.0
2016-04-27	BFX	Futures	4028.9	4037.7	4027.7	4027.7	2.0
2016-04-27	BR	Futures	0.18275	0.18327	0.18119	0.18301	14620.0
2016-04-27	BZ	Futures	38.15	39.02	37.6	38.83	19870.0
2016-04-27	C	Futures	2414.0	2420.0	2395.0	2404.0	5622.0
2016-04-27	CB	Futures	254.866	254.866	254.866	254.866	1.0
2016-04-27	CC	Futures	2347.0	2355.0	2323.0	2333.0	16340.0
2016-04-27	CNH	Futures	7.0796	7.0848	7.0796	7.0848	18.0
2016-04-27	CSC	Futures	3.489	3.51	3.479	3.496	116.0
2016-04-27	CT	Futures	72.73	73.11	72.13	72.97	14685.0
2016-04-27	DC	Futures	27.35	27.54	27.23	27.43	438.0
2016-04-27	DX	Futures	88.099	88.402	87.726	87.98	26139.0
2016-04-27	E1	Futures	1.29291	1.30057	1.29052	1.29668	15840.0
2016-04-27	E6	Futures	1.31949	1.32695	1.31628	1.32263	180385.0
2016-04-27	E7	Futures	1.3123	1.32	1.309	1.3155	3119.0
2016-04-27	EBM	Futures	194.95	195.92	193.99	194.63	15361.0
2016-04-27	ED	Futures	95.7015	95.7208	95.6726	95.716	433060.0
2016-04-27	ER	Futures	98.264	98.264	98.259	98.259	17441.0
2016-04-27	EW	Futures	1565.2	1572.2	1558.6	1570.6	11435.0
2016-04-27	FBON	Futures	117.45	118.01	117.38	117.59	782.0
2016-04-27	FBTP	Futures	105.57	105.96	105.44	105.77	104701.0
2016-04-27	FBTS	Futures	100.979	101.042	100.961	101.015	22340.0
2016-04-27	FCE	Futures	3801.3	3843.8	3796.1	3827.6	73742.0
2016-04-27	FDAX	Futures	11046.0	11148.6	11012.7	11094.9	98597.0
2016-04-27	FDXM	Futures	10641.6	10740.9	10605.4	10684.0	16494.0
2016-04-27	FESX	Futures	2380.5	2403.9	2375.9	2390.7	986786.0
2016-04-27	FGBL	Futures	144.58	145.03	144.48	144.76	614207.0
2016-04-27	FGBM	Futures	127.24	127.41	127.22	127.31	377128.0
2016-04-27	FGBS	Futures	111.638	111.668	111.633	111.643	169925.0
2016-04-27	FGBX	Futures	168.22	168.65	167.1	167.91	43816.0
2016-04-27	FMWO	Futures	5716.1	5721.1	5707.4	5717.3	1187.0
2016-04-27	FOAT	Futures	132.3	132.44	132.09	132.3	88448.0
2016-04-27	FTDX	Futures	1559.9	1592.3	1555.2	1584.2	176.0
2016-04-27	FTI	Futures	398.83	403.53	398.29	401.63	21779.0
2016-04-27	FTUK	Futures	5148.4	5195.9	5121.2	5172.8	114619.0
2016-04-27	FVSA	Futures	2387.33	2429.31	2345.36	2397.83	5756.0
2016-04-27	FXXP	Futures	274.8	277.2	274.4	276.2	32547.0
2016-04-27	G	Futures	106.84	107.14	106.76	107.03	173435.0
2016-04-27	GF	Futures	290.086	293.432	286.79	289.786	4020.0
2016-04-27	GSCI	Futures	521.05	523.62	515.03	522.3	205.0

> showing 50 of 109 rows — these rows as CSV

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