PREVIEW / futures_daily / 2017-04-20

all futures daily files

  file:    by_date/futures_daily/2017/2017-04-20.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-04-20	ES	Futures	2534.01	2561.16	2533.2	2554.37	1468523.0
2017-04-20	NQ	Futures	6357.71	6424.55	6353.59	6410.41	231392.0
2017-04-20	YM	Futures	21456.8	21701.6	21449.5	21660.5	149080.0
2017-04-20	CL	Futures	53.24	53.61	52.69	52.91	606263.0
2017-04-20	GC	Futures	1639.7	1643.5	1634.3	1641.7	245618.0
2017-04-20	ZN	Futures	124.104815	124.227722	123.720732	123.843639	1205793.0
2017-04-20	A6	Futures	0.7688	0.77393	0.76839	0.77198	77057.0
2017-04-20	AD	Futures	0.75712	0.75845	0.75605	0.75753	59911.0
2017-04-20	ALI	Futures	2558.05	2558.05	2558.05	2558.05	0.0
2017-04-20	B	Futures	38.5	38.84	38.21	38.43	401851.0
2017-04-20	B6	Futures	1.342	1.3488	1.341	1.3458	100973.0
2017-04-20	BFX	Futures	4479.0	4494.1	4474.1	4479.6	41.0
2017-04-20	BR	Futures	0.22865	0.22894	0.22694	0.22749	294.0
2017-04-20	BZ	Futures	38.37	38.72	38.11	38.32	48381.0
2017-04-20	C	Futures	1487.0	1492.0	1386.0	1437.0	12512.0
2017-04-20	CB	Futures	256.962	256.962	256.962	256.962	2.0
2017-04-20	CC	Futures	1401.0	1414.0	1343.0	1375.0	37124.0
2017-04-20	CNH	Futures	7.198	7.198	7.1969	7.1977	26.0
2017-04-20	CSC	Futures	3.498	3.511	3.498	3.502	4.0
2017-04-20	CT	Futures	86.57	89.92	86.57	89.25	5683.0
2017-04-20	DC	Futures	28.63	29.04	28.63	29.01	239.0
2017-04-20	DX	Futures	92.887	92.943	92.505	92.873	22304.0
2017-04-20	E1	Futures	1.24218	1.24712	1.24132	1.24181	19724.0
2017-04-20	E6	Futures	1.23699	1.24476	1.23693	1.2382	162009.0
2017-04-20	E7	Futures	1.231	1.2384	1.2307	1.2319	3474.0
2017-04-20	EBM	Futures	183.98	183.98	182.86	182.86	27129.0
2017-04-20	ED	Futures	95.5881	95.5881	95.5688	95.5736	235052.0
2017-04-20	ER	Futures	98.323	98.328	98.323	98.328	61708.0
2017-04-20	EW	Futures	1808.4	1830.2	1808.4	1827.9	15349.0
2017-04-20	FBON	Futures	121.85	121.85	121.26	121.6	1112.0
2017-04-20	FBTP	Futures	105.27	105.27	104.75	105.21	104658.0
2017-04-20	FBTS	Futures	101.909	101.927	101.855	101.9	55788.0
2017-04-20	FCE	Futures	4396.9	4488.7	4388.9	4471.8	130913.0
2017-04-20	FDAX	Futures	12689.6	12758.8	12628.9	12726.6	82382.0
2017-04-20	FDXM	Futures	12569.7	12647.2	12517.4	12614.7	23744.0
2017-04-20	FESX	Futures	2732.0	2761.4	2724.7	2755.7	1152576.0
2017-04-20	FEU3	Futures	99.001	99.001	98.991	99.001	73.0
2017-04-20	FGBL	Futures	150.16	150.21	149.36	149.57	709940.0
2017-04-20	FGBM	Futures	129.95	129.99	129.64	129.77	477878.0
2017-04-20	FGBS	Futures	112.492	112.512	112.417	112.462	296577.0
2017-04-20	FGBX	Futures	175.06	175.34	172.76	173.4	38044.0
2017-04-20	FMWO	Futures	6167.6	6192.9	6167.6	6190.5	3018.0
2017-04-20	FOAT	Futures	132.54	132.88	132.31	132.86	163323.0
2017-04-20	FTDX	Futures	1975.4	1986.2	1973.4	1981.3	76.0
2017-04-20	FTI	Futures	462.4	466.21	461.58	464.01	25377.0
2017-04-20	FTUK	Futures	6033.2	6051.6	6024.2	6046.0	121685.0
2017-04-20	FVSA	Futures	697.93	699.72	680.04	692.56	31000.0
2017-04-20	FXXP	Futures	313.3	315.7	312.9	315.0	24416.0
2017-04-20	G	Futures	116.0	116.11	115.55	115.84	150595.0
2017-04-20	GF	Futures	323.296	327.649	319.916	320.203	9984.0

> showing 50 of 111 rows — these rows as CSV

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