PREVIEW / futures_daily / 2016-03-17

all futures daily files

  file:    by_date/futures_daily/2016/2016-03-17.parquet
  size:    9 KB
  rows:    111

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-03-17	ES	Futures	2165.69	2186.89	2153.61	2179.92	2136877.0
2016-03-17	NQ	Futures	5155.64	5185.01	5122.74	5161.81	269816.0
2016-03-17	YM	Futures	17919.1	18120.8	17828.6	18076.1	163702.0
2016-03-17	CL	Futures	48.63	50.63	48.55	50.57	442919.0
2016-03-17	GC	Futures	1621.6	1634.3	1612.8	1625.4	208124.0
2016-03-17	ZN	Futures	124.58959	125.072378	124.559415	124.665025	1259842.0
2016-03-17	A6	Futures	0.76211	0.77182	0.75938	0.77132	119765.0
2016-03-17	AD	Futures	0.77973	0.78995	0.7785	0.78699	77627.0
2016-03-17	ALI	Futures	2093.41	2093.41	2093.41	2093.41	0.0
2016-03-17	B	Futures	33.69	34.65	33.65	34.6	249228.0
2016-03-17	B6	Futures	1.5012	1.5276	1.4979	1.525	135679.0
2016-03-17	BFX	Futures	3974.5	3986.8	3974.5	3986.8	1.0
2016-03-17	BR	Futures	0.17391	0.17566	0.17391	0.1754	798.0
2016-03-17	BZ	Futures	33.14	34.29	33.14	34.25	32670.0
2016-03-17	C	Futures	2379.0	2390.0	2345.0	2384.0	8629.0
2016-03-17	CB	Futures	245.11	246.939	245.11	246.025	24.0
2016-03-17	CC	Futures	2252.0	2288.0	2237.0	2282.0	20540.0
2016-03-17	CNH	Futures	7.0842	7.0842	7.0393	7.0393	35.0
2016-03-17	CSC	Futures	3.532	3.541	3.508	3.52	28.0
2016-03-17	CT	Futures	67.04	67.64	66.87	67.03	12613.0
2016-03-17	DC	Futures	27.76	28.03	27.51	27.7	168.0
2016-03-17	DX	Futures	89.292	89.376	88.267	88.384	30539.0
2016-03-17	E1	Futures	1.29002	1.3066	1.28851	1.30421	24623.0
2016-03-17	E6	Futures	1.31126	1.32619	1.3101	1.32339	255304.0
2016-03-17	E7	Futures	1.3044	1.3189	1.3032	1.3162	5020.0
2016-03-17	EBM	Futures	201.38	201.71	196.88	197.52	33987.0
2016-03-17	ED	Futures	95.6774	95.6919	95.6581	95.6678	271284.0
2016-03-17	ER	Futures	98.244	98.254	98.244	98.249	41217.0
2016-03-17	EW	Futures	1480.6	1501.3	1472.0	1497.4	16752.0
2016-03-17	FBON	Futures	118.35	118.52	118.3	118.41	651.0
2016-03-17	FBTP	Futures	107.31	107.66	107.3	107.53	93190.0
2016-03-17	FBTS	Futures	100.979	101.015	100.979	100.997	32165.0
2016-03-17	FCE	Futures	3728.0	3745.1	3629.2	3693.8	94154.0
2016-03-17	FDAX	Futures	10825.8	10859.1	10510.0	10642.1	84792.0
2016-03-17	FDIV	Futures	129.1	129.1	127.11	127.11	130.0
2016-03-17	FDXM	Futures	10428.5	10456.5	10118.2	10245.4	6498.0
2016-03-17	FESX	Futures	2343.9	2351.7	2268.2	2305.7	1509618.0
2016-03-17	FEU3	Futures	98.902	98.907	98.902	98.907	5.0
2016-03-17	FGBL	Futures	144.85	145.32	144.79	145.18	673964.0
2016-03-17	FGBM	Futures	127.12	127.2	127.04	127.14	555827.0
2016-03-17	FGBS	Futures	111.588	111.608	111.588	111.598	232972.0
2016-03-17	FGBX	Futures	168.86	170.59	168.51	170.13	44993.0
2016-03-17	FMWO	Futures	5549.4	5570.6	5495.9	5561.9	4114.0
2016-03-17	FOAT	Futures	132.55	132.98	132.52	132.86	83278.0
2016-03-17	FTDX	Futures	1561.4	1561.4	1516.6	1523.3	805.0
2016-03-17	FTI	Futures	394.82	396.37	385.72	393.13	17390.0
2016-03-17	FTUK	Futures	5061.4	5091.9	5003.6	5055.2	134480.0
2016-03-17	FVSA	Futures	2760.69	2931.85	2727.56	2760.69	16277.0
2016-03-17	FXXP	Futures	269.8	270.2	263.4	267.6	69356.0
2016-03-17	G	Futures	108.53	108.62	107.92	108.22	168811.0

> showing 50 of 111 rows — these rows as CSV

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