PREVIEW / futures_daily / 2020-11-09

all futures daily files

  file:    by_date/futures_daily/2020/2020-11-09.parquet
  size:    10 KB
  rows:    123

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
2020-11-09	ES	Futures	3957.46	4120.93	3949.88	3981.62	2605322.0
2020-11-09	NQ	Futures	14053.72	14365.72	13675.15	13684.7	731881.0
2020-11-09	YM	Futures	30559.8	32297.4	30497.3	31272.5	313050.0
2020-11-09	CL	Futures	26.62	29.46	26.49	28.72	622921.0
2020-11-09	GC	Futures	2310.1	2322.0	2182.5	2190.1	496088.0
2020-11-09	ZN	Futures	137.365877	137.629327	136.281083	136.451551	2778418.0
2020-11-09	A6	Futures	0.74734	0.7537	0.74611	0.74878	161477.0
2020-11-09	AD	Futures	0.77696	0.78395	0.77691	0.78061	99122.0
2020-11-09	ALI	Futures	2281.27	2302.89	2267.35	2272.09	142.0
2020-11-09	B	Futures	24.98	27.4	24.86	26.72	393050.0
2020-11-09	B6	Futures	1.3349	1.3397	1.3305	1.3356	116095.0
2020-11-09	BR	Futures	0.14667	0.1504	0.1449	0.14525	18425.0
2020-11-09	BTC	Futures	20673.5	21122.2	19637.5	20389.8	12353.0
2020-11-09	BZ	Futures	24.49	26.82	24.43	26.15	55156.0
2020-11-09	C	Futures	1425.0	1451.0	1417.0	1444.0	3295.0
2020-11-09	CB	Futures	156.524	156.524	156.524	156.524	5.0
2020-11-09	CC	Futures	1538.0	1593.0	1533.0	1572.0	31774.0
2020-11-09	CNH	Futures	6.4638	6.5201	6.4261	6.4934	3454.0
2020-11-09	CSC	Futures	3.564	3.688	3.542	3.685	109.0
2020-11-09	CT	Futures	67.85	69.61	67.81	69.18	30760.0
2020-11-09	DC	Futures	29.73	30.52	28.94	30.36	714.0
2020-11-09	DX	Futures	89.091	89.806	88.985	89.559	45985.0
2020-11-09	E1	Futures	1.25972	1.26153	1.23956	1.24228	38210.0
2020-11-09	E6	Futures	1.27436	1.27789	1.26439	1.26841	247147.0
2020-11-09	E7	Futures	1.2677	1.2714	1.258	1.2619	13288.0
2020-11-09	EBM	Futures	250.45	253.16	250.15	252.26	9274.0
2020-11-09	ED	Futures	96.5035	96.5035	96.4939	96.4987	131328.0
2020-11-09	ER	Futures	98.455	98.46	98.445	98.45	93312.0
2020-11-09	ESG	Futures	332.28	341.37	327.57	329.39	2120.0
2020-11-09	EW	Futures	2177.5	2342.4	2172.3	2224.3	18631.0
2020-11-09	FBON	Futures	150.26	150.44	148.75	148.85	965.0
2020-11-09	FBTP	Futures	138.25	138.61	136.78	136.92	167908.0
2020-11-09	FBTS	Futures	109.923	109.991	109.74	109.778	102438.0
2020-11-09	FCE	Futures	4867.3	5208.1	4851.8	5158.8	194023.0
2020-11-09	FDAX	Futures	13431.1	14170.0	13431.1	13980.7	141963.0
2020-11-09	FDIV	Futures	147.87	153.93	147.87	153.74	652.0
2020-11-09	FDXM	Futures	13346.9	14101.1	13346.9	13910.2	127171.0
2020-11-09	FESX	Futures	2985.2	3181.2	2985.2	3148.9	2620092.0
2020-11-09	FEU3	Futures	99.193	99.193	99.188	99.188	1.0
2020-11-09	FGBL	Futures	171.25	171.61	169.47	169.57	1190873.0
2020-11-09	FGBM	Futures	135.7	135.8	135.15	135.18	639678.0
2020-11-09	FGBS	Futures	112.895	112.92	112.78	112.785	752758.0
2020-11-09	FGBX	Futures	237.38	239.03	230.84	231.41	112517.0
2020-11-09	FMWO	Futures	8764.7	9096.4	8764.7	8947.2	6591.0
2020-11-09	FOAT	Futures	159.41	159.74	157.84	157.92	225356.0
2020-11-09	FTDX	Futures	3138.8	3190.3	3045.2	3062.2	563.0
2020-11-09	FTI	Futures	538.01	555.92	537.5	550.6	60081.0
2020-11-09	FTUK	Futures	5684.4	5964.0	5680.6	5903.7	204912.0
2020-11-09	FVSA	Futures	175.0	177.14	161.04	163.54	55694.0
2020-11-09	FXXP	Futures	343.9	357.6	343.1	353.0	242642.0

> showing 50 of 123 rows — these rows as CSV

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