PREVIEW / futures_daily / 2017-08-15

all futures daily files

  file:    by_date/futures_daily/2017/2017-08-15.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-08-15	ES	Futures	2678.47	2687.98	2673.58	2677.66	1060173.0
2017-08-15	NQ	Futures	6951.56	6988.59	6930.4	6949.8	249827.0
2017-08-15	YM	Futures	23210.9	23292.3	23195.1	23232.1	100758.0
2017-08-15	CL	Futures	48.88	49.32	48.4	48.96	313076.0
2017-08-15	GC	Futures	1637.6	1638.5	1619.4	1628.3	287561.0
2017-08-15	ZN	Futures	124.642504	124.657894	124.119249	124.257758	1206856.0
2017-08-15	A6	Futures	0.80629	0.80876	0.80177	0.8028	93553.0
2017-08-15	AD	Futures	0.79958	0.79999	0.79623	0.79745	61787.0
2017-08-15	ALI	Futures	2654.85	2654.85	2654.85	2654.85	0.0
2017-08-15	B	Futures	35.43	35.78	34.99	35.53	334161.0
2017-08-15	B6	Futures	1.356	1.357	1.344	1.3457	121313.0
2017-08-15	BR	Futures	0.23147	0.2337	0.23084	0.23191	2082.0
2017-08-15	BZ	Futures	35.13	35.44	34.7	35.23	35111.0
2017-08-15	C	Futures	1505.0	1505.0	1467.0	1470.0	8901.0
2017-08-15	CB	Futures	326.884	326.884	322.353	322.353	69.0
2017-08-15	CC	Futures	1418.0	1422.0	1374.0	1385.0	30061.0
2017-08-15	CNH	Futures	6.9189	6.9272	6.9169	6.9261	42.0
2017-08-15	CSC	Futures	3.585	3.585	3.528	3.53	136.0
2017-08-15	CT	Futures	79.7	79.7	78.98	78.99	7.0
2017-08-15	DC	Futures	29.86	29.89	29.27	29.32	661.0
2017-08-15	DX	Futures	87.209	87.811	87.158	87.546	23005.0
2017-08-15	E1	Futures	1.26597	1.26842	1.26105	1.26474	25613.0
2017-08-15	E6	Futures	1.35173	1.35357	1.34142	1.34675	191384.0
2017-08-15	E7	Futures	1.3446	1.3464	1.3343	1.3397	3708.0
2017-08-15	EBM	Futures	177.04	178.43	176.2	177.6	10729.0
2017-08-15	ED	Futures	95.591	95.591	95.5862	95.5862	127572.0
2017-08-15	ER	Futures	98.342	98.342	98.337	98.337	27542.0
2017-08-15	EW	Futures	1837.7	1845.1	1826.3	1827.6	9916.0
2017-08-15	FBON	Futures	125.11	125.11	124.52	124.79	30.0
2017-08-15	FBTP	Futures	109.26	109.47	108.77	109.1	52107.0
2017-08-15	FBTS	Futures	103.073	103.082	103.018	103.045	22163.0
2017-08-15	FCE	Futures	4591.9	4615.6	4582.1	4597.7	186662.0
2017-08-15	FDAX	Futures	12850.8	12877.7	12790.8	12816.6	73632.0
2017-08-15	FDXM	Futures	12767.5	12798.9	12713.1	12737.7	19389.0
2017-08-15	FESX	Futures	2821.8	2835.7	2817.7	2825.9	666119.0
2017-08-15	FEU3	Futures	99.011	99.016	99.011	99.016	30.0
2017-08-15	FGBL	Futures	148.93	149.06	148.48	148.85	522482.0
2017-08-15	FGBM	Futures	129.46	129.5	129.27	129.38	361472.0
2017-08-15	FGBS	Futures	112.357	112.372	112.337	112.357	168877.0
2017-08-15	FGBX	Futures	168.34	168.63	167.09	168.06	34319.0
2017-08-15	FMWO	Futures	6524.5	6525.7	6503.1	6513.8	1066.0
2017-08-15	FOAT	Futures	135.96	136.21	135.65	136.01	84930.0
2017-08-15	FTDX	Futures	2263.6	2278.7	2256.1	2263.1	229.0
2017-08-15	FTI	Futures	483.06	484.08	481.72	483.29	39828.0
2017-08-15	FTUK	Futures	6356.7	6397.3	6340.7	6371.4	74193.0
2017-08-15	FVSA	Futures	508.54	508.54	494.37	500.67	27317.0
2017-08-15	FXXP	Futures	320.5	321.6	319.7	320.3	27133.0
2017-08-15	G	Futures	115.76	115.97	115.61	115.91	160252.0
2017-08-15	GF	Futures	312.811	322.787	310.18	321.746	6562.0
2017-08-15	GSCI	Futures	449.01	450.56	449.01	450.56	537.0

> showing 50 of 110 rows — these rows as CSV

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