PREVIEW / futures_daily / 2017-09-15

all futures daily files

  file:    by_date/futures_daily/2017/2017-09-15.parquet
  size:    9 KB
  rows:    108

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-09-15	ES	Futures	2712.44	2719.24	2705.1	2716.24	1367390.0
2017-09-15	NQ	Futures	7014.49	7066.17	6986.59	7042.09	268013.0
2017-09-15	YM	Futures	23416.7	23480.0	23367.0	23463.1	102050.0
2017-09-15	CL	Futures	50.86	51.28	50.54	51.11	396714.0
2017-09-15	GC	Futures	1697.0	1702.7	1683.4	1686.2	320508.0
2017-09-15	ZN	Futures	124.718354	124.779973	124.42566	124.533494	1127267.0
2017-09-15	A6	Futures	0.82262	0.82591	0.82076	0.8222	105648.0
2017-09-15	AD	Futures	0.83614	0.83991	0.83289	0.83569	112731.0
2017-09-15	B	Futures	38.77	39.17	38.47	39.0	271070.0
2017-09-15	B6	Futures	1.4009	1.4234	1.399	1.4188	223894.0
2017-09-15	BZ	Futures	38.43	38.83	38.15	38.67	22004.0
2017-09-15	C	Futures	1441.0	1457.0	1428.0	1452.0	15978.0
2017-09-15	CB	Futures	312.729	315.563	312.729	314.933	56.0
2017-09-15	CC	Futures	1455.0	1498.0	1452.0	1492.0	25875.0
2017-09-15	CNH	Futures	6.7561	6.7592	6.7531	6.7542	225.0
2017-09-15	CSC	Futures	3.4	3.404	3.387	3.391	37.0
2017-09-15	CT	Futures	81.64	82.0	81.64	81.85	4.0
2017-09-15	DC	Futures	27.7	27.89	27.61	27.63	65.0
2017-09-15	DX	Futures	85.824	85.979	85.436	85.71	33902.0
2017-09-15	E1	Futures	1.27639	1.28568	1.2748	1.28226	31370.0
2017-09-15	E6	Futures	1.36628	1.37449	1.36451	1.36896	254934.0
2017-09-15	E7	Futures	1.359	1.3672	1.3574	1.3618	5598.0
2017-09-15	EBM	Futures	175.32	176.4	174.78	176.13	14964.0
2017-09-15	ED	Futures	95.557	95.5667	95.5473	95.5521	282503.0
2017-09-15	ER	Futures	98.342	98.347	98.332	98.337	264076.0
2017-09-15	EW	Futures	1856.9	1866.3	1851.8	1864.6	11975.0
2017-09-15	FBON	Futures	124.89	124.89	124.66	124.76	420.0
2017-09-15	FBTP	Futures	109.18	109.3	108.88	108.95	77802.0
2017-09-15	FBTS	Futures	103.173	103.21	103.127	103.182	34876.0
2017-09-15	FCE	Futures	4670.7	4681.9	4649.6	4671.6	94292.0
2017-09-15	FDAX	Futures	13204.6	13229.9	13179.3	13208.2	6781.0
2017-09-15	FDXM	Futures	13053.0	13082.2	13020.7	13039.4	22370.0
2017-09-15	FESX	Futures	2863.4	2869.9	2849.5	2854.4	979470.0
2017-09-15	FEU3	Futures	99.006	99.016	99.006	99.006	66.0
2017-09-15	FGBL	Futures	149.58	149.62	148.93	149.04	675626.0
2017-09-15	FGBM	Futures	129.8	129.82	129.45	129.51	440766.0
2017-09-15	FGBS	Futures	112.472	112.482	112.397	112.412	315860.0
2017-09-15	FGBX	Futures	167.44	167.73	166.73	166.99	42299.0
2017-09-15	FMWO	Futures	6629.3	6629.3	6629.3	6629.3	0.0
2017-09-15	FOAT	Futures	136.67	136.74	136.31	136.38	97855.0
2017-09-15	FTDX	Futures	2358.2	2366.2	2357.7	2362.2	508.0
2017-09-15	FTI	Futures	486.64	486.96	484.29	485.35	31043.0
2017-09-15	FTUK	Futures	6283.7	6295.0	6207.4	6221.2	142674.0
2017-09-15	FVSA	Futures	449.8	452.64	441.29	445.54	12583.0
2017-09-15	FXXP	Futures	322.9	323.2	321.5	322.1	29490.0
2017-09-15	G	Futures	114.48	114.61	113.5	113.65	328957.0
2017-09-15	GF	Futures	327.322	329.232	324.921	328.795	4705.0
2017-09-15	GSCI	Futures	472.99	472.99	472.15	472.99	388.0
2017-09-15	HE	Futures	82.021	85.66	81.881	85.345	30431.0
2017-09-15	HG	Futures	3.5786	3.5944	3.5406	3.5623	108324.0

> showing 50 of 108 rows — these rows as CSV

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