PREVIEW / futures_daily / 2018-04-17

all futures daily files

  file:    by_date/futures_daily/2018/2018-04-17.parquet
  size:    10 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
2018-04-17	ES	Futures	2913.6	2951.12	2913.05	2943.23	1251766.0
2018-04-17	NQ	Futures	7846.88	8011.32	7840.15	7992.6	325724.0
2018-04-17	YM	Futures	25871.5	26152.8	25861.0	26026.4	176912.0
2018-04-17	CL	Futures	66.64	66.96	65.83	66.75	471089.0
2018-04-17	GC	Futures	1722.4	1726.3	1711.0	1722.9	276632.0
2018-04-17	ZN	Futures	119.540151	119.66422	119.416082	119.66422	994110.0
2018-04-17	A6	Futures	0.79998	0.80121	0.79792	0.79884	72452.0
2018-04-17	AD	Futures	0.80599	0.80857	0.80518	0.80675	64946.0
2018-04-17	B	Futures	52.08	52.26	51.48	52.03	315036.0
2018-04-17	B6	Futures	1.4887	1.4927	1.4828	1.4832	121502.0
2018-04-17	BR	Futures	0.22212	0.22368	0.22212	0.22304	30.0
2018-04-17	BTC	Futures	11382.6	11616.9	11084.3	11197.9	2676.0
2018-04-17	BZ	Futures	51.37	51.57	50.82	51.36	36784.0
2018-04-17	C	Futures	1671.0	1677.0	1656.0	1669.0	4050.0
2018-04-17	CB	Futures	291.563	292.798	291.563	292.798	23.0
2018-04-17	CC	Futures	1963.0	1988.0	1957.0	1971.0	24390.0
2018-04-17	CNH	Futures	6.3735	6.3797	6.3709	6.377	32.0
2018-04-17	CSC	Futures	3.392	3.423	3.392	3.415	85.0
2018-04-17	CT	Futures	95.73	96.07	94.32	95.55	9763.0
2018-04-17	DC	Futures	27.21	27.58	27.21	27.51	196.0
2018-04-17	DX	Futures	84.047	84.302	83.887	84.154	14989.0
2018-04-17	E1	Futures	1.2609	1.26331	1.25055	1.25284	25219.0
2018-04-17	E6	Futures	1.40079	1.40462	1.39578	1.39938	191809.0
2018-04-17	E7	Futures	1.3931	1.3972	1.3884	1.3919	2772.0
2018-04-17	EBM	Futures	176.13	177.2	176.13	176.66	22880.0
2018-04-17	ED	Futures	94.9452	94.9549	94.9354	94.9452	236766.0
2018-04-17	ER	Futures	98.337	98.342	98.337	98.337	30794.0
2018-04-17	EW	Futures	2016.8	2037.9	2016.0	2032.3	12064.0
2018-04-17	FBON	Futures	129.85	130.14	129.81	130.12	202.0
2018-04-17	FBTP	Futures	115.55	116.03	115.52	115.94	83462.0
2018-04-17	FBTS	Futures	104.176	104.278	104.167	104.25	54804.0
2018-04-17	FCE	Futures	4698.7	4735.7	4688.0	4719.7	157007.0
2018-04-17	FDAX	Futures	12953.3	13122.1	12909.6	13099.3	101481.0
2018-04-17	FDXM	Futures	12834.8	13003.7	12794.7	12982.6	30734.0
2018-04-17	FESX	Futures	2813.1	2842.3	2807.3	2838.1	1021575.0
2018-04-17	FGBL	Futures	149.71	150.05	149.58	149.95	585247.0
2018-04-17	FGBM	Futures	129.61	129.75	129.57	129.71	369784.0
2018-04-17	FGBS	Futures	112.507	112.522	112.497	112.512	226279.0
2018-04-17	FGBX	Futures	169.97	171.07	169.85	170.7	38511.0
2018-04-17	FMWO	Futures	6991.2	7044.9	6991.2	7030.9	6503.0
2018-04-17	FOAT	Futures	138.82	139.26	138.81	139.17	100118.0
2018-04-17	FTDX	Futures	2589.0	2624.1	2584.5	2623.6	182.0
2018-04-17	FTI	Futures	500.74	504.02	499.17	503.01	21755.0
2018-04-17	FTUK	Futures	6306.4	6348.4	6294.9	6337.8	81655.0
2018-04-17	FVSA	Futures	358.2	359.34	338.68	340.97	31950.0
2018-04-17	FXXP	Futures	322.6	325.0	322.0	324.9	55996.0
2018-04-17	G	Futures	113.37	113.68	113.06	113.51	185156.0
2018-04-17	GF	Futures	301.926	305.261	300.258	301.818	6237.0
2018-04-17	GSCI	Futures	522.63	523.64	520.94	523.19	19.0
2018-04-17	HE	Futures	79.454	79.803	78.525	78.873	274.0

> showing 50 of 111 rows — these rows as CSV

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