PREVIEW / futures_daily / 2018-11-30

all futures daily files

  file:    by_date/futures_daily/2018/2018-11-30.parquet
  size:    10 KB
  rows:    114

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-11-30	ES	Futures	2973.73	2998.4	2959.63	2991.35	1475346.0
2018-11-30	NQ	Futures	8017.14	8092.64	7981.42	8072.02	485575.0
2018-11-30	YM	Futures	26724.1	26960.0	26560.9	26893.7	167055.0
2018-11-30	CL	Futures	54.25	54.8	52.53	53.89	796714.0
2018-11-30	GC	Futures	1549.7	1551.2	1539.5	1544.8	170448.0
2018-11-30	ZN	Futures	118.997071	119.292773	118.981507	119.074887	312021.0
2018-11-30	A6	Futures	0.75309	0.75401	0.7498	0.75165	80572.0
2018-11-30	AD	Futures	0.76152	0.76202	0.75798	0.76106	85412.0
2018-11-30	B	Futures	43.88	44.36	42.62	43.66	372803.0
2018-11-30	B6	Futures	1.3155	1.3183	1.3105	1.3114	93205.0
2018-11-30	BR	Futures	0.2048	0.20571	0.2048	0.20503	186.0
2018-11-30	BTC	Futures	6416.2	6507.8	5851.6	5996.6	5068.0
2018-11-30	BZ	Futures	43.29	43.79	42.08	43.1	39344.0
2018-11-30	C	Futures	1452.0	1463.0	1434.0	1455.0	7298.0
2018-11-30	CB	Futures	269.008	270.436	269.008	270.405	24.0
2018-11-30	CC	Futures	1494.0	1523.0	1477.0	1518.0	18980.0
2018-11-30	CNH	Futures	6.9729	6.9957	6.9729	6.9871	324.0
2018-11-30	CSC	Futures	2.903	2.918	2.881	2.888	86.0
2018-11-30	CT	Futures	85.73	86.4	85.46	85.96	10951.0
2018-11-30	DC	Futures	24.21	24.23	24.0	24.04	144.0
2018-11-30	DX	Futures	91.868	92.376	91.801	92.334	17870.0
2018-11-30	E1	Futures	1.19129	1.19248	1.18608	1.18703	20819.0
2018-11-30	E6	Futures	1.26777	1.26899	1.25838	1.25882	202672.0
2018-11-30	E7	Futures	1.2615	1.2627	1.2522	1.2526	3633.0
2018-11-30	EBM	Futures	207.42	209.5	206.9	209.24	20048.0
2018-11-30	ED	Futures	94.9353	94.9499	94.9304	94.9328	260842.0
2018-11-30	ER	Futures	98.386	98.391	98.386	98.391	31008.0
2018-11-30	EW	Futures	1964.9	1980.4	1954.9	1976.3	19863.0
2018-11-30	FBON	Futures	128.44	128.64	128.43	128.64	629.0
2018-11-30	FBTP	Futures	107.52	107.52	106.98	107.23	173362.0
2018-11-30	FBTS	Futures	103.642	103.679	103.454	103.529	86744.0
2018-11-30	FCE	Futures	4479.0	4485.7	4440.0	4466.9	67886.0
2018-11-30	FDAX	Futures	11914.9	11914.9	11780.8	11827.6	93469.0
2018-11-30	FDXM	Futures	11709.6	11709.6	11577.3	11622.8	41030.0
2018-11-30	FESX	Futures	2669.7	2671.4	2647.0	2657.1	986853.0
2018-11-30	FEU3	Futures	99.016	99.016	99.016	99.016	2.0
2018-11-30	FGBL	Futures	154.38	154.64	154.34	154.6	849022.0
2018-11-30	FGBM	Futures	131.6	131.69	131.56	131.66	777321.0
2018-11-30	FGBS	Futures	112.744	112.754	112.729	112.739	829562.0
2018-11-30	FGBX	Futures	179.61	180.28	179.41	180.26	96081.0
2018-11-30	FMWO	Futures	6762.0	6796.7	6743.4	6758.5	567.0
2018-11-30	FOAT	Futures	141.41	141.65	141.38	141.6	266556.0
2018-11-30	FTDX	Futures	2553.8	2553.8	2538.1	2541.1	387.0
2018-11-30	FTI	Futures	483.57	483.99	479.44	481.89	21153.0
2018-11-30	FTUK	Futures	6301.9	6301.9	6220.6	6228.2	157638.0
2018-11-30	FVSA	Futures	334.65	342.72	323.57	331.63	27226.0
2018-11-30	FXXP	Futures	310.4	310.7	308.1	309.3	39197.0
2018-11-30	G	Futures	116.18	116.34	116.03	116.27	218650.0
2018-11-30	GF	Futures	314.226	316.217	312.181	312.611	7983.0
2018-11-30	GSCI	Futures	456.07	460.47	454.55	458.27	15.0

> showing 50 of 114 rows — these rows as CSV

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