PREVIEW / futures_daily / 2016-04-22

all futures daily files

  file:    by_date/futures_daily/2016/2016-04-22.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-22	ES	Futures	2233.06	2243.0	2227.96	2239.78	1497994.0
2016-04-22	NQ	Futures	5273.73	5289.59	5206.46	5247.29	285544.0
2016-04-22	YM	Futures	18598.1	18664.6	18535.7	18629.2	140151.0
2016-04-22	CL	Futures	51.73	52.95	51.36	52.09	575107.0
2016-04-22	GC	Futures	1609.2	1616.6	1583.5	1585.4	209494.0
2016-04-22	ZN	Futures	125.223249	125.313772	124.906419	125.012029	1012534.0
2016-04-22	A6	Futures	0.78134	0.78508	0.77699	0.7785	102354.0
2016-04-22	AD	Futures	0.80304	0.8101	0.8014	0.80611	82082.0
2016-04-22	ALI	Futures	2237.21	2237.21	2237.21	2237.21	0.0
2016-04-22	B	Futures	37.27	38.23	36.89	37.57	272848.0
2016-04-22	B6	Futures	1.5077	1.5219	1.5072	1.5171	98800.0
2016-04-22	BFX	Futures	4029.5	4029.7	4024.2	4029.7	2.0
2016-04-22	BR	Futures	0.17957	0.18051	0.17892	0.18002	252.0
2016-04-22	BZ	Futures	36.82	37.83	36.52	37.19	35201.0
2016-04-22	C	Futures	2380.0	2399.0	2376.0	2395.0	7221.0
2016-04-22	CB	Futures	254.866	254.957	254.256	254.866	13.0
2016-04-22	CC	Futures	2283.0	2311.0	2277.0	2308.0	21281.0
2016-04-22	CNH	Futures	7.0643	7.0848	7.064	7.0848	679.0
2016-04-22	CSC	Futures	3.556	3.561	3.541	3.551	46.0
2016-04-22	CT	Futures	73.14	73.99	71.44	72.45	3845.0
2016-04-22	DC	Futures	27.91	27.97	27.74	27.85	144.0
2016-04-22	DX	Futures	88.202	88.738	88.043	88.644	21344.0
2016-04-22	E1	Futures	1.2909	1.29353	1.28499	1.28637	19848.0
2016-04-22	E6	Futures	1.31797	1.32077	1.31016	1.31138	152035.0
2016-04-22	E7	Futures	1.3109	1.3136	1.3032	1.3043	3143.0
2016-04-22	EBM	Futures	194.31	195.59	193.02	193.66	27698.0
2016-04-22	ED	Futures	95.7015	95.7063	95.6919	95.6967	173718.0
2016-04-22	ER	Futures	98.254	98.264	98.249	98.254	23424.0
2016-04-22	EW	Futures	1545.0	1560.2	1544.4	1558.2	16793.0
2016-04-22	FBON	Futures	117.88	118.1	117.72	117.77	589.0
2016-04-22	FBTP	Futures	106.2	106.3	105.94	105.98	66698.0
2016-04-22	FBTS	Futures	100.979	101.006	100.961	100.988	12219.0
2016-04-22	FCE	Futures	3829.3	3842.1	3812.3	3827.6	63246.0
2016-04-22	FDAX	Futures	11201.8	11238.3	11125.5	11167.9	91676.0
2016-04-22	FDXM	Futures	10783.3	10820.6	10713.0	10754.4	15182.0
2016-04-22	FESX	Futures	2399.3	2407.8	2386.0	2393.8	1051453.0
2016-04-22	FGBL	Futures	145.41	145.5	145.2	145.33	550735.0
2016-04-22	FGBM	Futures	127.39	127.52	127.35	127.44	321611.0
2016-04-22	FGBS	Futures	111.643	111.678	111.628	111.653	158286.0
2016-04-22	FGBX	Futures	171.08	171.56	170.01	170.32	29044.0
2016-04-22	FMWO	Futures	5734.8	5736.0	5708.6	5708.6	9.0
2016-04-22	FOAT	Futures	133.17	133.3	132.95	133.08	65438.0
2016-04-22	FTDX	Futures	1578.5	1579.9	1567.1	1567.1	70.0
2016-04-22	FTI	Futures	403.44	404.48	400.82	402.76	29176.0
2016-04-22	FTUK	Futures	5198.4	5218.2	5150.1	5159.2	123026.0
2016-04-22	FVSA	Futures	2445.05	2487.02	2424.06	2439.8	10070.0
2016-04-22	FXXP	Futures	276.1	276.7	274.8	275.5	42865.0
2016-04-22	G	Futures	107.32	107.49	107.03	107.18	162080.0
2016-04-22	GF	Futures	290.935	291.884	281.746	284.543	4880.0
2016-04-22	GSCI	Futures	513.05	517.97	510.48	510.48	203.0

> showing 50 of 109 rows — these rows as CSV

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