PREVIEW / futures_daily / 2019-04-30

all futures daily files

  file:    by_date/futures_daily/2019/2019-04-30.parquet
  size:    10 KB
  rows:    115

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
2019-04-30	ES	Futures	3178.42	3193.54	3160.59	3184.9	1491268.0
2019-04-30	NQ	Futures	8993.25	9052.87	8918.06	8987.2	463833.0
2019-04-30	YM	Futures	28037.7	28133.8	27864.6	28060.9	186152.0
2019-04-30	CL	Futures	65.28	66.48	64.99	65.61	750494.0
2019-04-30	GC	Futures	1595.5	1603.3	1595.0	1600.2	239444.0
2019-04-30	ZN	Futures	122.839591	123.041604	122.637578	122.994986	1897188.0
2019-04-30	A6	Futures	0.72797	0.72951	0.7256	0.72755	96014.0
2019-04-30	AD	Futures	0.75206	0.75645	0.75084	0.75575	99641.0
2019-04-30	B	Futures	52.64	53.64	52.46	53.1	365522.0
2019-04-30	B6	Futures	1.3279	1.34	1.3274	1.3387	135890.0
2019-04-30	BFX	Futures	4362.8	4362.8	4359.8	4359.8	10.0
2019-04-30	BR	Futures	0.20264	0.20396	0.20112	0.2036	2943.0
2019-04-30	BTC	Futures	7949.0	8173.2	7871.6	8088.1	4094.0
2019-04-30	BZ	Futures	52.56	53.48	52.31	52.95	43783.0
2019-04-30	C	Futures	1695.0	1725.0	1690.0	1723.0	7257.0
2019-04-30	CB	Futures	279.022	279.321	278.603	279.321	28.0
2019-04-30	CC	Futures	1604.0	1621.0	1583.0	1588.0	24178.0
2019-04-30	CNH	Futures	6.7477	6.7572	6.7447	6.7464	177.0
2019-04-30	CSC	Futures	2.971	2.971	2.945	2.95	142.0
2019-04-30	CT	Futures	80.49	80.95	80.13	80.37	13647.0
2019-04-30	DC	Futures	25.03	25.06	24.8	24.83	301.0
2019-04-30	DX	Futures	93.527	93.575	93.139	93.169	16347.0
2019-04-30	E1	Futures	1.14952	1.15197	1.1487	1.15057	27973.0
2019-04-30	E6	Futures	1.23245	1.23744	1.23146	1.23651	243558.0
2019-04-30	E7	Futures	1.2263	1.2313	1.2254	1.2304	5586.0
2019-04-30	EBM	Futures	193.96	194.75	193.69	193.96	13078.0
2019-04-30	ED	Futures	95.155	95.1697	95.1502	95.1648	156909.0
2019-04-30	ER	Futures	98.411	98.416	98.411	98.416	21889.0
2019-04-30	EW	Futures	2098.5	2102.1	2075.0	2094.2	17505.0
2019-04-30	FBON	Futures	136.23	136.32	135.82	136.21	575.0
2019-04-30	FBTP	Futures	115.53	115.85	114.98	115.68	109285.0
2019-04-30	FBTS	Futures	105.779	105.941	105.703	105.874	54418.0
2019-04-30	FCE	Futures	4976.3	5006.4	4963.7	4994.3	65813.0
2019-04-30	FDAX	Futures	12980.1	13047.4	12942.2	13001.1	95848.0
2019-04-30	FDIV	Futures	149.52	149.85	149.43	149.85	65.0
2019-04-30	FDXM	Futures	12877.0	12934.4	12831.1	12888.5	35094.0
2019-04-30	FESX	Futures	3009.1	3030.9	2996.9	3017.0	1090709.0
2019-04-30	FGBL	Futures	159.71	159.91	159.09	159.55	941869.0
2019-04-30	FGBM	Futures	132.99	133.06	132.79	132.96	570321.0
2019-04-30	FGBS	Futures	112.744	112.769	112.724	112.754	363390.0
2019-04-30	FGBX	Futures	193.22	193.92	191.57	192.96	46094.0
2019-04-30	FMWO	Futures	7300.6	7319.1	7278.6	7290.2	1079.0
2019-04-30	FOAT	Futures	146.84	146.9	146.23	146.66	168658.0
2019-04-30	FTDX	Futures	2868.1	2875.0	2866.1	2872.5	91.0
2019-04-30	FTI	Futures	534.9	540.4	534.19	538.91	24234.0
2019-04-30	FTUK	Futures	6791.2	6794.0	6735.3	6760.5	80821.0
2019-04-30	FVSA	Futures	196.9	198.3	194.11	197.6	19460.0
2019-04-30	FXXP	Futures	345.8	347.2	345.1	346.4	45054.0
2019-04-30	G	Futures	117.63	117.78	117.06	117.42	234853.0
2019-04-30	GF	Futures	299.071	299.279	294.491	294.803	1787.0

> showing 50 of 115 rows — these rows as CSV

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