PREVIEW / futures_daily / 2016-06-20

all futures daily files

  file:    by_date/futures_daily/2016/2016-06-20.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-06-20	ES	Futures	2236.04	2259.25	2235.23	2239.55	1598465.0
2016-06-20	NQ	Futures	5166.4	5229.75	5166.4	5174.65	195423.0
2016-06-20	YM	Futures	18424.3	18648.8	18424.3	18500.5	145413.0
2016-06-20	CL	Futures	57.02	58.08	56.59	58.03	453610.0
2016-06-20	GC	Futures	1663.5	1668.3	1647.8	1662.3	193799.0
2016-06-20	ZN	Futures	126.973487	127.124395	126.777307	126.958396	1004678.0
2016-06-20	A6	Futures	0.75289	0.75869	0.75106	0.75595	80077.0
2016-06-20	AD	Futures	0.79639	0.8013	0.79557	0.79966	50484.0
2016-06-20	ALI	Futures	2153.81	2153.81	2153.81	2153.81	0.0
2016-06-20	B	Futures	40.06	41.08	39.91	41.05	244410.0
2016-06-20	B6	Futures	1.5251	1.5529	1.5227	1.5499	177248.0
2016-06-20	BR	Futures	0.19188	0.19211	0.19188	0.19211	5.0
2016-06-20	BZ	Futures	40.01	40.98	39.83	40.95	21739.0
2016-06-20	C	Futures	2374.0	2383.0	2362.0	2367.0	3141.0
2016-06-20	CB	Futures	286.604	288.07	284.846	285.989	36.0
2016-06-20	CC	Futures	2285.0	2297.0	2273.0	2290.0	17034.0
2016-06-20	CSC	Futures	3.561	3.631	3.561	3.631	121.0
2016-06-20	CT	Futures	73.43	74.34	72.73	73.24	4270.0
2016-06-20	DC	Futures	28.6	29.25	28.58	29.21	240.0
2016-06-20	DX	Futures	87.481	87.481	87.002	87.131	20688.0
2016-06-20	E1	Futures	1.30685	1.31398	1.30184	1.30735	20021.0
2016-06-20	E6	Futures	1.32176	1.32944	1.31995	1.32153	141250.0
2016-06-20	E7	Futures	1.3153	1.3223	1.313	1.3145	2831.0
2016-06-20	EBM	Futures	196.07	197.87	194.87	197.57	8214.0
2016-06-20	ED	Futures	95.7714	95.7714	95.7473	95.7522	233732.0
2016-06-20	ER	Futures	98.269	98.274	98.264	98.269	59300.0
2016-06-20	EW	Futures	1569.4	1592.0	1569.3	1580.7	18401.0
2016-06-20	FBON	Futures	119.42	119.75	119.3	119.67	315.0
2016-06-20	FBTP	Futures	107.14	107.46	106.93	107.37	105905.0
2016-06-20	FBTS	Futures	101.015	101.114	101.015	101.096	35777.0
2016-06-20	FCE	Futures	3743.3	3784.2	3730.6	3775.1	94905.0
2016-06-20	FDAX	Futures	10497.7	10625.4	10469.0	10589.8	102917.0
2016-06-20	FDIV	Futures	129.47	129.7	129.47	129.7	45.0
2016-06-20	FDXM	Futures	10214.8	10356.9	10204.5	10322.2	21061.0
2016-06-20	FESX	Futures	2288.3	2306.3	2277.4	2299.3	1352079.0
2016-06-20	FEU3	Futures	98.922	98.922	98.922	98.922	20.0
2016-06-20	FGBL	Futures	148.09	148.22	147.7	147.79	606941.0
2016-06-20	FGBM	Futures	128.38	128.4	128.26	128.28	484800.0
2016-06-20	FGBS	Futures	111.822	111.832	111.768	111.793	279416.0
2016-06-20	FGBX	Futures	182.23	182.33	180.09	180.29	41464.0
2016-06-20	FMWO	Futures	5550.7	5576.2	5548.3	5575.0	460.0
2016-06-20	FOAT	Futures	135.01	135.32	134.8	135.12	103417.0
2016-06-20	FTDX	Futures	1556.6	1563.3	1546.9	1559.5	126.0
2016-06-20	FTI	Futures	387.29	393.37	387.29	392.11	33665.0
2016-06-20	FTUK	Futures	5056.3	5156.0	5055.5	5131.0	137001.0
2016-06-20	FVSA	Futures	2836.74	2851.91	2594.02	2679.98	29172.0
2016-06-20	FXXP	Futures	269.0	272.1	267.5	271.6	55916.0
2016-06-20	G	Futures	111.1	111.17	110.44	110.56	150250.0
2016-06-20	GF	Futures	275.613	275.663	268.075	272.917	5340.0
2016-06-20	GSCI	Futures	550.73	555.88	549.94	555.3	447.0

> showing 50 of 109 rows — these rows as CSV

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