PREVIEW / futures_daily / 2020-06-23

all futures daily files

  file:    by_date/futures_daily/2020/2020-06-23.parquet
  size:    10 KB
  rows:    120

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-06-23	ES	Futures	3502.55	3540.82	3444.3	3510.14	1528485.0
2020-06-23	NQ	Futures	11747.41	11950.23	11574.19	11833.88	406477.0
2020-06-23	YM	Futures	27815.7	28179.1	27343.1	27885.4	200223.0
2020-06-23	CL	Futures	29.49	30.18	28.82	29.27	368730.0
2020-06-23	GC	Futures	2119.0	2145.3	2111.0	2139.5	194678.0
2020-06-23	ZN	Futures	137.39731	137.660553	137.273431	137.505704	957624.0
2020-06-23	A6	Futures	0.71103	0.71761	0.70568	0.7136	102166.0
2020-06-23	AD	Futures	0.75094	0.75281	0.74814	0.74977	57889.0
2020-06-23	ALI	Futures	1953.46	1961.32	1948.02	1951.65	317.0
2020-06-23	B	Futures	28.28	28.76	27.63	27.9	183029.0
2020-06-23	B6	Futures	1.2668	1.2731	1.2631	1.2721	88584.0
2020-06-23	BR	Futures	0.1515	0.15392	0.1515	0.15392	126.0
2020-06-23	BTC	Futures	13525.8	13567.5	13352.0	13435.4	3811.0
2020-06-23	BZ	Futures	27.6	28.09	26.99	27.25	27036.0
2020-06-23	C	Futures	1726.0	1747.0	1720.0	1731.0	2120.0
2020-06-23	CB	Futures	207.023	207.692	203.278	207.692	64.0
2020-06-23	CC	Futures	1491.0	1519.0	1475.0	1502.0	11380.0
2020-06-23	CNH	Futures	6.9858	7.0135	6.9752	6.9818	450.0
2020-06-23	CSC	Futures	3.876	3.878	3.823	3.854	147.0
2020-06-23	CT	Futures	60.94	61.55	60.19	61.45	5025.0
2020-06-23	DC	Futures	32.22	32.35	31.62	31.91	327.0
2020-06-23	DX	Futures	93.541	93.903	93.039	93.317	21212.0
2020-06-23	E1	Futures	1.20161	1.20877	1.19934	1.2057	20573.0
2020-06-23	E6	Futures	1.21069	1.22013	1.20763	1.21605	161289.0
2020-06-23	E7	Futures	1.2047	1.214	1.2016	1.21	6191.0
2020-06-23	EBM	Futures	213.47	214.96	211.37	211.97	19192.0
2020-06-23	ED	Futures	96.3847	96.3895	96.3798	96.3895	86317.0
2020-06-23	ER	Futures	98.372	98.372	98.352	98.362	51794.0
2020-06-23	ESG	Futures	284.08	285.17	282.98	282.98	259.0
2020-06-23	EW	Futures	1903.5	1933.6	1865.0	1901.3	14424.0
2020-06-23	FBON	Futures	144.75	144.98	144.55	144.62	326.0
2020-06-23	FBTP	Futures	129.68	130.25	129.59	130.0	58451.0
2020-06-23	FBTS	Futures	108.376	108.483	108.367	108.444	46858.0
2020-06-23	FCE	Futures	4837.9	4914.4	4827.1	4885.5	61918.0
2020-06-23	FDAX	Futures	13123.6	13376.5	12886.7	13298.4	96866.0
2020-06-23	FDIV	Futures	145.69	145.69	145.59	145.59	200.0
2020-06-23	FDXM	Futures	13068.9	13326.1	12846.6	13250.4	50394.0
2020-06-23	FESX	Futures	2999.2	3044.4	2948.4	3030.6	950140.0
2020-06-23	FGBL	Futures	168.02	168.28	167.63	167.79	559797.0
2020-06-23	FGBM	Futures	134.73	134.79	134.59	134.64	305500.0
2020-06-23	FGBS	Futures	112.79	112.795	112.734	112.744	281440.0
2020-06-23	FGBX	Futures	225.05	226.17	222.31	223.03	58340.0
2020-06-23	FMWO	Futures	7744.6	7886.8	7744.6	7875.0	6084.0
2020-06-23	FOAT	Futures	155.31	155.37	154.94	155.06	147769.0
2020-06-23	FTDX	Futures	3052.1	3068.5	3046.0	3058.8	105.0
2020-06-23	FTI	Futures	525.8	533.82	524.96	531.58	25648.0
2020-06-23	FTUK	Futures	5911.8	5956.7	5811.2	5943.0	81820.0
2020-06-23	FVSA	Futures	280.75	282.1	268.64	271.33	14232.0
2020-06-23	FXXP	Futures	334.3	338.5	334.1	337.5	78523.0
2020-06-23	G	Futures	126.74	126.88	126.64	126.76	186580.0

> showing 50 of 120 rows — these rows as CSV

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