PREVIEW / futures_daily / 2018-11-19

all futures daily files

  file:    by_date/futures_daily/2018/2018-11-19.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
2018-11-19	ES	Futures	2963.97	2980.24	2908.12	2924.11	1988117.0
2018-11-19	NQ	Futures	7985.49	8054.6	7703.53	7749.7	743936.0
2018-11-19	YM	Futures	26731.5	26844.2	26210.3	26356.6	248295.0
2018-11-19	CL	Futures	60.34	60.92	58.49	60.52	699684.0
2018-11-19	GC	Futures	1549.5	1554.5	1544.3	1553.0	198385.0
2018-11-19	ZN	Futures	118.779184	118.903691	118.545735	118.825874	1666762.0
2018-11-19	A6	Futures	0.75299	0.75412	0.74908	0.75041	76326.0
2018-11-19	AD	Futures	0.7692	0.76981	0.76622	0.76758	53706.0
2018-11-19	B	Futures	49.51	49.99	48.24	49.37	262545.0
2018-11-19	B6	Futures	1.3213	1.3267	1.3175	1.3237	99866.0
2018-11-19	BR	Futures	0.20319	0.20342	0.2019	0.20224	1519.0
2018-11-19	BTC	Futures	7961.6	7983.3	6600.8	6998.9	11321.0
2018-11-19	BZ	Futures	49.19	49.64	47.91	49.03	29353.0
2018-11-19	C	Futures	1500.0	1501.0	1470.0	1479.0	2146.0
2018-11-19	CB	Futures	268.683	270.155	267.271	267.782	89.0
2018-11-19	CC	Futures	1549.0	1556.0	1504.0	1520.0	18565.0
2018-11-19	CNH	Futures	6.9669	6.9813	6.9631	6.9732	603.0
2018-11-19	CSC	Futures	2.964	3.012	2.926	2.936	91.0
2018-11-19	CT	Futures	85.78	86.3	84.84	85.17	10480.0
2018-11-19	DC	Futures	24.76	24.81	24.36	24.46	519.0
2018-11-19	DX	Futures	91.46	91.611	91.184	91.261	15656.0
2018-11-19	E1	Futures	1.18892	1.1971	1.18726	1.19556	26449.0
2018-11-19	E6	Futures	1.27216	1.27739	1.26949	1.27622	145884.0
2018-11-19	E7	Futures	1.266	1.271	1.2634	1.27	2766.0
2018-11-19	EBM	Futures	207.42	207.42	204.04	204.56	29418.0
2018-11-19	ED	Futures	95.0012	95.0036	94.9865	94.9987	406008.0
2018-11-19	ER	Futures	98.386	98.386	98.381	98.386	23988.0
2018-11-19	EW	Futures	1959.4	1967.7	1927.5	1934.6	17199.0
2018-11-19	FBON	Futures	126.99	127.07	126.7	126.82	402.0
2018-11-19	FBTP	Futures	104.7	104.98	103.53	103.76	78055.0
2018-11-19	FBTS	Futures	102.443	102.555	102.181	102.246	65966.0
2018-11-19	FCE	Futures	4490.2	4518.4	4432.0	4449.0	76496.0
2018-11-19	FDAX	Futures	11931.7	12003.2	11763.0	11810.3	97194.0
2018-11-19	FDXM	Futures	11739.6	11796.4	11558.7	11605.7	45633.0
2018-11-19	FESX	Futures	2665.5	2687.3	2636.1	2647.0	921570.0
2018-11-19	FEU3	Futures	99.001	99.011	99.001	99.011	1.0
2018-11-19	FGBL	Futures	153.82	153.82	153.35	153.7	613084.0
2018-11-19	FGBM	Futures	131.43	131.43	131.21	131.34	341321.0
2018-11-19	FGBS	Futures	112.734	112.734	112.678	112.713	273224.0
2018-11-19	FGBX	Futures	178.24	178.24	177.07	177.71	41532.0
2018-11-19	FMWO	Futures	6779.4	6801.4	6668.1	6711.0	2269.0
2018-11-19	FOAT	Futures	140.68	140.68	140.26	140.36	130466.0
2018-11-19	FTDX	Futures	2536.1	2550.4	2476.2	2479.2	267.0
2018-11-19	FTI	Futures	485.43	488.31	479.21	481.3	28538.0
2018-11-19	FTUK	Futures	6269.7	6314.8	6224.1	6254.1	100262.0
2018-11-19	FVSA	Futures	326.59	346.75	324.57	334.65	40225.0
2018-11-19	FXXP	Futures	309.5	311.7	305.7	307.2	38597.0
2018-11-19	G	Futures	115.35	115.82	115.22	115.71	242780.0
2018-11-19	GF	Futures	316.109	317.293	313.365	317.024	3715.0
2018-11-19	GSCI	Futures	492.58	492.58	491.56	491.56	1.0

> showing 50 of 115 rows — these rows as CSV

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