PREVIEW / futures_daily / 2020-07-06

all futures daily files

  file:    by_date/futures_daily/2020/2020-07-06.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-07-06	ES	Futures	3517.74	3573.18	3495.79	3570.36	1459512.0
2020-07-06	NQ	Futures	12014.94	12319.61	11964.74	12301.04	486369.0
2020-07-06	YM	Futures	27567.1	28075.1	27261.7	28055.8	255602.0
2020-07-06	CL	Futures	29.27	29.78	28.88	29.45	373236.0
2020-07-06	GC	Futures	2146.6	2159.9	2136.1	2153.3	184653.0
2020-07-06	ZN	Futures	137.908311	137.985735	137.521189	137.737977	832208.0
2020-07-06	A6	Futures	0.71226	0.71895	0.71133	0.71782	96053.0
2020-07-06	AD	Futures	0.74845	0.75094	0.74754	0.74972	53245.0
2020-07-06	ALI	Futures	1974.02	1988.23	1973.41	1984.6	171.0
2020-07-06	B	Futures	27.88	28.48	27.85	28.08	185020.0
2020-07-06	B6	Futures	1.2665	1.2719	1.2634	1.2696	92840.0
2020-07-06	BR	Futures	0.14821	0.14972	0.14698	0.1477	109.0
2020-07-06	BTC	Futures	12622.8	12994.7	12478.2	12884.5	6890.0
2020-07-06	BZ	Futures	27.27	27.84	26.96	27.45	28969.0
2020-07-06	C	Futures	1500.0	1502.0	1472.0	1476.0	1075.0
2020-07-06	CB	Futures	203.653	203.733	200.63	202.877	14.0
2020-07-06	CC	Futures	1415.0	1427.0	1403.0	1411.0	18648.0
2020-07-06	CNH	Futures	6.9879	6.9879	6.9319	6.9349	710.0
2020-07-06	CSC	Futures	3.919	3.944	3.897	3.944	24.0
2020-07-06	CT	Futures	64.16	64.98	64.07	64.29	17.0
2020-07-06	DC	Futures	32.3	32.8	32.3	32.66	332.0
2020-07-06	DX	Futures	93.879	93.879	93.212	93.388	20094.0
2020-07-06	E1	Futures	1.20377	1.21274	1.20172	1.20888	30629.0
2020-07-06	E6	Futures	1.20779	1.21938	1.2057	1.2161	245504.0
2020-07-06	E7	Futures	1.2018	1.2132	1.1996	1.2101	10308.0
2020-07-06	EBM	Futures	218.85	219.45	217.36	218.56	9539.0
2020-07-06	ED	Futures	96.4088	96.4137	96.3992	96.4088	145186.0
2020-07-06	ER	Futures	98.386	98.386	98.377	98.377	50327.0
2020-07-06	ESG	Futures	287.27	288.35	287.27	288.35	75.0
2020-07-06	EW	Futures	1889.7	1932.0	1871.5	1907.4	12486.0
2020-07-06	FBON	Futures	144.92	145.45	144.92	145.31	243.0
2020-07-06	FBTP	Futures	130.21	130.57	129.94	130.29	50939.0
2020-07-06	FBTS	Futures	108.444	108.463	108.367	108.405	26512.0
2020-07-06	FCE	Futures	4988.3	5004.5	4940.3	4962.9	51414.0
2020-07-06	FDAX	Futures	13384.5	13633.6	13382.9	13527.4	85000.0
2020-07-06	FDXM	Futures	13316.6	13581.2	13316.6	13478.6	51275.0
2020-07-06	FESX	Futures	3046.3	3103.5	3046.3	3083.2	917444.0
2020-07-06	FEU3	Futures	99.129	99.129	99.129	99.129	350.0
2020-07-06	FGBL	Futures	168.05	168.3	167.8	168.12	407785.0
2020-07-06	FGBM	Futures	134.72	134.81	134.66	134.73	263427.0
2020-07-06	FGBS	Futures	112.764	112.79	112.749	112.759	201715.0
2020-07-06	FGBX	Futures	224.09	225.05	223.03	224.44	26378.0
2020-07-06	FMWO	Futures	7923.5	7946.1	7903.4	7943.7	2452.0
2020-07-06	FOAT	Futures	155.19	155.57	155.11	155.47	89495.0
2020-07-06	FTDX	Futures	3123.7	3123.7	3068.0	3095.0	64.0
2020-07-06	FTI	Futures	536.6	538.37	532.01	536.41	22695.0
2020-07-06	FTUK	Futures	5820.1	5924.6	5810.7	5904.3	78039.0
2020-07-06	FVSA	Futures	248.01	257.43	242.63	248.01	10722.0
2020-07-06	FXXP	Futures	342.1	342.6	339.1	341.2	92110.0
2020-07-06	G	Futures	126.88	126.91	126.66	126.88	114282.0

> showing 50 of 120 rows — these rows as CSV

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