PREVIEW / futures_daily / 2017-01-17

all futures daily files

  file:    by_date/futures_daily/2017/2017-01-17.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-01-17	ES	Futures	2461.18	2461.45	2447.08	2453.05	1540220.0
2017-01-17	NQ	Futures	5959.34	5962.58	5922.51	5940.48	198098.0
2017-01-17	YM	Futures	20884.8	20886.9	20747.9	20795.2	140716.0
2017-01-17	CL	Futures	57.05	58.13	56.61	57.0	424660.0
2017-01-17	GC	Futures	1540.3	1565.3	1538.5	1557.6	381417.0
2017-01-17	ZN	Futures	121.965901	122.668875	121.950619	122.485491	1592429.0
2017-01-17	A6	Futures	0.76573	0.77423	0.76276	0.77361	123765.0
2017-01-17	AD	Futures	0.77847	0.78501	0.77485	0.78302	90042.0
2017-01-17	ALI	Futures	2460.38	2460.38	2451.4	2453.64	12.0
2017-01-17	B	Futures	41.53	42.43	41.27	41.33	335727.0
2017-01-17	B6	Futures	1.2655	1.3039	1.2588	1.3019	335663.0
2017-01-17	BFX	Futures	4353.6	4360.8	4349.9	4349.9	3.0
2017-01-17	BR	Futures	0.2181	0.21899	0.21796	0.21892	121.0
2017-01-17	BZ	Futures	41.15	42.13	40.82	41.02	44899.0
2017-01-17	C	Futures	1854.0	1863.0	1828.0	1858.0	13384.0
2017-01-17	CB	Futures	274.294	275.545	274.294	275.545	6.0
2017-01-17	CC	Futures	1664.0	1714.0	1647.0	1701.0	26358.0
2017-01-17	CNH	Futures	7.319	7.319	7.2289	7.2289	186.0
2017-01-17	CSC	Futures	4.025	4.098	4.025	4.038	109.0
2017-01-17	CT	Futures	83.02	83.71	82.49	82.84	16410.0
2017-01-17	DC	Futures	33.21	33.9	33.21	33.42	220.0
2017-01-17	DX	Futures	94.561	94.612	93.328	93.407	61480.0
2017-01-17	E1	Futures	1.2307	1.24372	1.22636	1.24049	35241.0
2017-01-17	E6	Futures	1.23015	1.24113	1.22478	1.23986	313999.0
2017-01-17	E7	Futures	1.2237	1.2347	1.2186	1.2335	6187.0
2017-01-17	EBM	Futures	193.42	194.84	193.13	194.56	21347.0
2017-01-17	ED	Futures	95.5665	95.5762	95.5617	95.5713	262031.0
2017-01-17	ER	Futures	98.308	98.313	98.308	98.313	25580.0
2017-01-17	EW	Futures	1793.0	1794.4	1775.4	1778.5	18901.0
2017-01-17	FBON	Futures	122.64	123.4	122.64	122.79	819.0
2017-01-17	FBTP	Futures	106.53	106.91	106.19	106.45	114210.0
2017-01-17	FBTS	Futures	101.837	101.873	101.837	101.864	26377.0
2017-01-17	FCE	Futures	4293.7	4305.2	4263.8	4279.2	136255.0
2017-01-17	FDAX	Futures	12180.8	12231.5	12058.3	12200.3	109424.0
2017-01-17	FDXM	Futures	12138.0	12182.2	12010.8	12151.2	29651.0
2017-01-17	FESX	Futures	2624.7	2633.5	2605.5	2624.7	1033808.0
2017-01-17	FEU3	Futures	98.976	98.981	98.976	98.981	4.0
2017-01-17	FGBL	Futures	147.66	148.31	147.64	147.81	877153.0
2017-01-17	FGBM	Futures	129.12	129.34	129.06	129.15	560294.0
2017-01-17	FGBS	Futures	112.157	112.187	112.152	112.172	291057.0
2017-01-17	FGBX	Futures	167.95	169.93	167.89	168.45	47831.0
2017-01-17	FMWO	Futures	5947.9	5969.6	5947.9	5961.2	776.0
2017-01-17	FOAT	Futures	132.86	133.56	132.79	133.11	139327.0
2017-01-17	FTDX	Futures	1815.1	1815.1	1798.0	1800.9	65.0
2017-01-17	FTI	Futures	439.41	440.14	436.99	438.0	32470.0
2017-01-17	FTUK	Futures	6147.9	6155.1	6063.5	6073.7	140242.0
2017-01-17	FVSA	Futures	873.95	892.9	862.11	871.58	31693.0
2017-01-17	FXXP	Futures	299.3	300.5	297.7	299.4	41592.0
2017-01-17	G	Futures	112.0	112.41	111.66	111.91	193593.0
2017-01-17	GF	Futures	295.169	296.708	294.314	296.48	3690.0

> showing 50 of 110 rows — these rows as CSV

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