PREVIEW / futures_daily / 2018-10-24

all futures daily files

  file:    by_date/futures_daily/2018/2018-10-24.parquet
  size:    10 KB
  rows:    116

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-10-24	ES	Futures	2977.25	2982.41	2876.4	2889.41	2856919.0
2018-10-24	NQ	Futures	8288.94	8333.95	7881.82	7940.48	895420.0
2018-10-24	YM	Futures	26578.8	26682.0	25811.1	25921.7	348985.0
2018-10-24	CL	Futures	68.96	70.57	68.83	69.64	775963.0
2018-10-24	GC	Futures	1563.7	1569.1	1556.8	1560.3	211477.0
2018-10-24	ZN	Futures	117.783132	118.390101	117.752006	118.156652	2709457.0
2018-10-24	A6	Futures	0.72922	0.73158	0.72685	0.72737	91619.0
2018-10-24	AD	Futures	0.77355	0.78043	0.77249	0.7776	131902.0
2018-10-24	B	Futures	56.1	56.99	55.19	55.97	366652.0
2018-10-24	B6	Futures	1.3381	1.3392	1.3264	1.3279	95400.0
2018-10-24	BR	Futures	0.2057	0.20609	0.20315	0.2035	683.0
2018-10-24	BTC	Futures	9228.2	9358.4	9213.7	9286.1	814.0
2018-10-24	BZ	Futures	55.56	56.56	54.79	55.55	57413.0
2018-10-24	C	Futures	1519.0	1535.0	1495.0	1497.0	7827.0
2018-10-24	CB	Futures	267.121	268.263	267.121	267.662	7.0
2018-10-24	CC	Futures	1529.0	1556.0	1490.0	1492.0	21251.0
2018-10-24	CNH	Futures	6.9953	7.0086	6.9904	7.0044	554.0
2018-10-24	CSC	Futures	3.034	3.034	2.97	3.002	209.0
2018-10-24	CT	Futures	88.71	89.24	86.43	86.51	22829.0
2018-10-24	DC	Futures	25.28	25.28	24.64	24.94	746.0
2018-10-24	DX	Futures	90.923	91.488	90.88	91.371	28403.0
2018-10-24	E1	Futures	1.19663	1.19781	1.19177	1.19402	29703.0
2018-10-24	E6	Futures	1.28061	1.28134	1.27044	1.27144	254644.0
2018-10-24	E7	Futures	1.2742	1.275	1.2642	1.2652	4762.0
2018-10-24	EBM	Futures	208.46	209.24	207.94	208.46	16183.0
2018-10-24	ED	Futures	94.9841	94.9987	94.9597	94.9792	525845.0
2018-10-24	ER	Futures	98.377	98.381	98.372	98.377	138871.0
2018-10-24	EW	Futures	1944.2	1947.0	1879.9	1881.7	26282.0
2018-10-24	FBON	Futures	126.21	126.89	126.18	126.76	767.0
2018-10-24	FBTP	Futures	103.31	103.86	102.84	103.02	85063.0
2018-10-24	FBTS	Futures	101.694	101.9	101.497	101.591	62891.0
2018-10-24	FCE	Futures	4491.9	4513.0	4387.6	4431.9	123859.0
2018-10-24	FDAX	Futures	11945.9	11970.6	11610.0	11752.4	152614.0
2018-10-24	FDIV	Futures	135.58	135.58	135.49	135.49	1.0
2018-10-24	FDXM	Futures	11739.6	11764.4	11406.8	11548.9	80649.0
2018-10-24	FESX	Futures	2653.7	2668.9	2594.9	2621.8	1441370.0
2018-10-24	FEU3	Futures	99.001	99.001	98.996	98.996	200.0
2018-10-24	FGBL	Futures	152.81	153.46	152.8	153.3	730327.0
2018-10-24	FGBM	Futures	130.88	131.19	130.88	131.13	448564.0
2018-10-24	FGBS	Futures	112.678	112.739	112.668	112.724	308646.0
2018-10-24	FGBX	Futures	177.75	178.74	177.67	178.42	85655.0
2018-10-24	FMWO	Futures	6750.4	6777.0	6589.3	6692.5	2056.0
2018-10-24	FOAT	Futures	139.99	140.34	139.98	140.31	118230.0
2018-10-24	FTDX	Futures	2519.4	2532.2	2429.1	2483.6	480.0
2018-10-24	FTI	Futures	479.46	479.46	467.14	472.1	36650.0
2018-10-24	FTUK	Futures	6241.6	6276.9	6135.2	6203.1	114610.0
2018-10-24	FVSA	Futures	350.09	380.53	348.19	368.16	39201.0
2018-10-24	FXXP	Futures	308.0	309.5	301.5	305.1	120390.0
2018-10-24	G	Futures	114.7	115.05	114.62	114.96	239097.0
2018-10-24	GF	Futures	324.42	326.187	323.017	324.212	2593.0

> showing 50 of 116 rows — these rows as CSV

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