PREVIEW / futures_daily / 2018-10-31

all futures daily files

  file:    by_date/futures_daily/2018/2018-10-31.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-10-31	ES	Futures	2918.15	2968.58	2908.66	2940.11	2469662.0
2018-10-31	NQ	Futures	7964.58	8176.27	7917.83	8102.22	755201.0
2018-10-31	YM	Futures	26201.8	26645.2	26139.7	26407.2	246406.0
2018-10-31	CL	Futures	69.11	69.82	67.54	68.06	666487.0
2018-10-31	GC	Futures	1552.2	1552.6	1537.9	1539.9	247057.0
2018-10-31	ZN	Futures	118.187778	118.203342	117.892076	117.969892	1956359.0
2018-10-31	A6	Futures	0.73138	0.73169	0.72757	0.72819	107750.0
2018-10-31	AD	Futures	0.77178	0.77208	0.76834	0.76844	83123.0
2018-10-31	B	Futures	56.42	57.01	55.12	55.46	334197.0
2018-10-31	B6	Futures	1.3097	1.3223	1.3088	1.316	165117.0
2018-10-31	BR	Futures	0.20456	0.20605	0.203	0.20487	4872.0
2018-10-31	BTC	Futures	9054.5	9177.5	8931.4	9112.4	3161.0
2018-10-31	BZ	Futures	55.97	56.6	54.77	55.09	38445.0
2018-10-31	C	Futures	1576.0	1579.0	1547.0	1570.0	11962.0
2018-10-31	CB	Futures	269.044	269.855	269.044	269.164	132.0
2018-10-31	CC	Futures	1550.0	1567.0	1529.0	1560.0	21946.0
2018-10-31	CNH	Futures	7.0247	7.0294	7.0202	7.0265	222.0
2018-10-31	CSC	Futures	3.042	3.072	3.032	3.072	115.0
2018-10-31	CT	Futures	86.17	86.47	85.86	86.27	13106.0
2018-10-31	DC	Futures	25.06	25.39	25.01	25.31	305.0
2018-10-31	DX	Futures	91.939	92.129	91.82	92.054	22884.0
2018-10-31	E1	Futures	1.18406	1.18608	1.17885	1.18027	38785.0
2018-10-31	E6	Futures	1.26599	1.26766	1.26116	1.26255	252900.0
2018-10-31	E7	Futures	1.2596	1.2614	1.2549	1.2564	4976.0
2018-10-31	EBM	Futures	206.64	206.9	205.6	206.38	20995.0
2018-10-31	ED	Futures	94.989	94.989	94.9743	94.9792	212341.0
2018-10-31	ER	Futures	98.381	98.386	98.377	98.381	85093.0
2018-10-31	EW	Futures	1916.2	1936.4	1912.2	1918.8	26577.0
2018-10-31	FBON	Futures	127.52	127.71	127.39	127.66	278.0
2018-10-31	FBTP	Futures	104.52	104.93	104.37	104.72	71503.0
2018-10-31	FBTS	Futures	102.171	102.471	102.106	102.359	62641.0
2018-10-31	FCE	Futures	4512.5	4569.8	4505.8	4557.7	108929.0
2018-10-31	FDAX	Futures	12025.8	12085.3	11971.2	12047.9	118893.0
2018-10-31	FDXM	Futures	11817.1	11876.0	11763.3	11839.3	59891.0
2018-10-31	FESX	Futures	2668.9	2689.9	2664.7	2683.1	1427483.0
2018-10-31	FGBL	Futures	153.31	153.48	153.13	153.37	660228.0
2018-10-31	FGBM	Futures	131.13	131.18	131.05	131.13	354737.0
2018-10-31	FGBS	Futures	112.708	112.718	112.688	112.708	286922.0
2018-10-31	FGBX	Futures	177.98	178.62	177.57	178.54	68546.0
2018-10-31	FMWO	Futures	6695.9	6770.1	6692.5	6731.9	5243.0
2018-10-31	FOAT	Futures	140.44	140.6	140.36	140.55	128702.0
2018-10-31	FTDX	Futures	2559.2	2606.4	2558.7	2591.6	747.0
2018-10-31	FTI	Futures	479.18	483.98	479.18	482.26	29509.0
2018-10-31	FTUK	Futures	6303.2	6378.3	6301.9	6355.1	150354.0
2018-10-31	FVSA	Futures	371.97	373.87	361.5	368.16	40319.0
2018-10-31	FXXP	Futures	310.8	313.3	310.2	312.5	53387.0
2018-10-31	G	Futures	115.21	115.34	114.84	115.11	361510.0
2018-10-31	GF	Futures	317.143	319.482	316.883	319.118	3500.0
2018-10-31	GSCI	Futures	525.08	525.88	520.11	520.23	164.0
2018-10-31	HE	Futures	80.129	80.8	78.115	78.451	25697.0

> showing 50 of 114 rows — these rows as CSV

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