PREVIEW / futures_daily / 2019-10-07

all futures daily files

  file:    by_date/futures_daily/2019/2019-10-07.parquet
  size:    10 KB
  rows:    119

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-10-07	ES	Futures	3171.65	3203.86	3169.76	3180.04	1266872.0
2019-10-07	NQ	Futures	8888.04	8988.59	8853.47	8919.74	381262.0
2019-10-07	YM	Futures	27685.1	27940.2	27650.4	27755.4	155862.0
2019-10-07	CL	Futures	54.1	55.5	53.99	54.16	549019.0
2019-10-07	GC	Futures	1873.3	1873.5	1842.1	1855.8	257779.0
2019-10-07	ZN	Futures	130.719406	130.796828	130.223905	130.332296	1084278.0
2019-10-07	A6	Futures	0.69547	0.69578	0.69199	0.69229	72275.0
2019-10-07	AD	Futures	0.75663	0.75839	0.75612	0.75728	53393.0
2019-10-07	ALI	Futures	2081.65	2128.44	2081.35	2111.23	155.0
2019-10-07	B	Futures	45.96	47.28	45.96	46.22	228408.0
2019-10-07	B6	Futures	1.2557	1.2574	1.2522	1.2536	59570.0
2019-10-07	BR	Futures	0.19869	0.19869	0.19635	0.19667	106.0
2019-10-07	BTC	Futures	11362.3	12009.5	11139.4	11872.9	5782.0
2019-10-07	BZ	Futures	45.07	46.61	45.07	45.58	28765.0
2019-10-07	C	Futures	1722.0	1725.0	1679.0	1692.0	15078.0
2019-10-07	CB	Futures	253.77	253.77	252.589	252.589	3.0
2019-10-07	CC	Futures	1621.0	1621.0	1572.0	1589.0	31565.0
2019-10-07	CNH	Futures	7.1035	7.1356	7.1035	7.1274	465.0
2019-10-07	CSC	Futures	3.105	3.134	3.105	3.129	71.0
2019-10-07	CT	Futures	60.42	60.61	59.76	60.18	11082.0
2019-10-07	DC	Futures	26.13	26.4	26.1	26.31	161.0
2019-10-07	DX	Futures	95.222	95.401	95.13	95.362	9103.0
2019-10-07	E1	Futures	1.16255	1.16519	1.16059	1.16266	20458.0
2019-10-07	E6	Futures	1.19556	1.19805	1.19383	1.19507	107878.0
2019-10-07	E7	Futures	1.1896	1.1919	1.1877	1.1889	2199.0
2019-10-07	EBM	Futures	192.63	193.45	192.08	193.18	17304.0
2019-10-07	ED	Futures	95.3958	95.4201	95.3618	95.3763	244708.0
2019-10-07	ER	Futures	98.475	98.475	98.465	98.47	25796.0
2019-10-07	EW	Futures	1986.0	2004.7	1985.4	1990.7	9655.0
2019-10-07	FBON	Futures	146.46	146.5	146.15	146.19	82.0
2019-10-07	FBTP	Futures	132.36	132.66	132.14	132.24	37183.0
2019-10-07	FBTS	Futures	108.606	108.635	108.51	108.529	24741.0
2019-10-07	FCE	Futures	4959.2	5013.3	4941.8	4997.4	63406.0
2019-10-07	FDAX	Futures	12682.4	12798.0	12613.3	12741.5	99023.0
2019-10-07	FDIV	Futures	144.37	145.58	144.37	145.53	50.0
2019-10-07	FDXM	Futures	12518.4	12630.9	12447.6	12575.2	37731.0
2019-10-07	FESX	Futures	3016.8	3042.2	3000.1	3029.9	809464.0
2019-10-07	FGBL	Futures	168.61	168.78	168.25	168.39	337410.0
2019-10-07	FGBM	Futures	135.3	135.36	135.21	135.23	187149.0
2019-10-07	FGBS	Futures	113.041	113.056	113.021	113.026	175300.0
2019-10-07	FGBX	Futures	226.03	226.93	224.83	225.47	24582.0
2019-10-07	FMWO	Futures	7167.5	7202.7	7150.4	7191.4	3918.0
2019-10-07	FOAT	Futures	155.14	155.4	154.98	155.05	60625.0
2019-10-07	FTDX	Futures	2872.0	2872.0	2722.0	2745.2	89.0
2019-10-07	FTI	Futures	535.42	541.82	534.47	540.08	24358.0
2019-10-07	FTUK	Futures	6607.2	6658.7	6580.4	6640.6	81858.0
2019-10-07	FVSA	Futures	198.16	200.41	189.74	193.11	21704.0
2019-10-07	FXXP	Futures	342.6	346.3	341.9	345.0	53777.0
2019-10-07	G	Futures	123.53	123.67	123.36	123.49	116395.0
2019-10-07	GF	Futures	297.761	298.023	295.511	296.61	1450.0

> showing 50 of 119 rows — these rows as CSV

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