PREVIEW / futures_daily / 2017-07-27

all futures daily files

  file:    by_date/futures_daily/2017/2017-07-27.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
2017-07-27	ES	Futures	2689.34	2695.86	2670.32	2686.63	1647577.0
2017-07-27	NQ	Futures	7007.4	7048.25	6870.74	6946.86	539445.0
2017-07-27	YM	Futures	22871.6	22992.1	22867.4	22984.7	145893.0
2017-07-27	CL	Futures	50.09	50.65	49.63	50.44	880757.0
2017-07-27	GC	Futures	1611.9	1617.6	1603.6	1611.5	161442.0
2017-07-27	ZN	Futures	124.05769	124.150029	123.765282	123.934571	1528350.0
2017-07-27	A6	Futures	0.82252	0.82807	0.81687	0.8181	120559.0
2017-07-27	AD	Futures	0.8185	0.81987	0.80929	0.81057	99548.0
2017-07-27	ALI	Futures	2573.68	2581.93	2561.95	2562.9	40.0
2017-07-27	B	Futures	35.67	36.14	35.38	36.04	308648.0
2017-07-27	B6	Futures	1.3735	1.3775	1.3662	1.3685	121155.0
2017-07-27	BR	Futures	0.23459	0.23462	0.23362	0.23377	7487.0
2017-07-27	BZ	Futures	35.35	35.83	35.09	35.73	24210.0
2017-07-27	C	Futures	1514.0	1581.0	1514.0	1577.0	18621.0
2017-07-27	CB	Futures	325.394	327.796	324.177	327.614	77.0
2017-07-27	CC	Futures	1458.0	1533.0	1458.0	1528.0	36493.0
2017-07-27	CNH	Futures	6.9789	6.9854	6.9659	6.9854	9.0
2017-07-27	CSC	Futures	3.507	3.534	3.493	3.534	120.0
2017-07-27	CT	Futures	80.91	84.05	80.91	82.28	256.0
2017-07-27	DC	Futures	29.25	29.48	29.06	29.44	322.0
2017-07-27	DX	Futures	87.144	87.727	86.84	87.508	33805.0
2017-07-27	E1	Futures	1.29642	1.29827	1.27505	1.27763	47270.0
2017-07-27	E6	Futures	1.34967	1.35288	1.33833	1.34217	274483.0
2017-07-27	E7	Futures	1.3423	1.3457	1.3313	1.3351	6494.0
2017-07-27	EBM	Futures	187.62	188.73	187.34	187.9	8919.0
2017-07-27	ED	Futures	95.5935	95.5935	95.5838	95.5886	169924.0
2017-07-27	ER	Futures	98.337	98.342	98.337	98.337	33946.0
2017-07-27	EW	Futures	1887.3	1891.7	1870.7	1880.8	14061.0
2017-07-27	FBON	Futures	124.3	124.38	124.2	124.37	540.0
2017-07-27	FBTP	Futures	108.26	108.72	108.25	108.42	68920.0
2017-07-27	FBTS	Futures	102.927	102.963	102.918	102.945	36179.0
2017-07-27	FCE	Futures	4649.1	4685.5	4623.1	4656.3	81329.0
2017-07-27	FDAX	Futures	12925.0	12938.7	12780.3	12833.4	90601.0
2017-07-27	FDIV	Futures	144.56	144.6	144.52	144.6	10.0
2017-07-27	FDXM	Futures	12841.8	12859.6	12701.6	12754.4	27843.0
2017-07-27	FESX	Futures	2840.6	2857.7	2825.9	2841.4	794663.0
2017-07-27	FEU3	Futures	99.016	99.016	99.016	99.016	7.0
2017-07-27	FGBL	Futures	147.18	147.62	147.12	147.38	572932.0
2017-07-27	FGBM	Futures	128.72	128.89	128.7	128.86	339543.0
2017-07-27	FGBS	Futures	112.242	112.267	112.217	112.257	245038.0
2017-07-27	FGBX	Futures	163.94	164.73	163.37	163.88	38795.0
2017-07-27	FMWO	Futures	6576.9	6576.9	6562.7	6562.7	5307.0
2017-07-27	FOAT	Futures	135.07	135.38	134.92	135.13	97365.0
2017-07-27	FTDX	Futures	2278.7	2284.2	2272.7	2280.7	76.0
2017-07-27	FTI	Futures	483.39	487.51	483.25	487.09	25873.0
2017-07-27	FTUK	Futures	6384.4	6393.9	6342.9	6376.1	75675.0
2017-07-27	FVSA	Futures	419.77	440.53	412.35	416.8	11403.0
2017-07-27	FXXP	Futures	324.6	325.6	323.0	324.3	20486.0
2017-07-27	G	Futures	114.69	114.83	114.47	114.72	145214.0
2017-07-27	GF	Futures	323.076	327.028	320.332	324.503	7105.0

> showing 50 of 111 rows — these rows as CSV

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