PREVIEW / futures_daily / 2020-03-06

all futures daily files

  file:    by_date/futures_daily/2020/2020-03-06.parquet
  size:    10 KB
  rows:    121

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-03-06	ES	Futures	3266.23	3280.0	3129.88	3201.16	3163400.0
2020-03-06	NQ	Futures	9952.69	10009.46	9532.3	9753.39	1097279.0
2020-03-06	YM	Futures	27455.5	27601.5	26457.8	27083.7	581213.0
2020-03-06	CL	Futures	47.06	47.36	41.91	42.15	1276180.0
2020-03-06	GC	Futures	2039.9	2064.0	2002.5	2039.1	659625.0
2020-03-06	ZN	Futures	135.582462	137.254981	135.489544	136.821365	12490.0
2020-03-06	A6	Futures	0.67805	0.68256	0.67518	0.68072	134421.0
2020-03-06	AD	Futures	0.75144	0.7532	0.74982	0.75053	102168.0
2020-03-06	ALI	Futures	2059.79	2061.59	2025.78	2026.39	138.0
2020-03-06	B	Futures	42.74	42.91	38.43	38.51	636391.0
2020-03-06	B6	Futures	1.3143	1.3239	1.3133	1.3201	155863.0
2020-03-06	BR	Futures	0.1757	0.17607	0.17459	0.17607	428.0
2020-03-06	BTC	Futures	13345.8	13506.4	13229.0	13382.3	1827.0
2020-03-06	BZ	Futures	41.5	41.75	37.39	37.48	69464.0
2020-03-06	C	Futures	1769.0	1772.0	1743.0	1759.0	2529.0
2020-03-06	CB	Futures	218.604	218.632	217.21	217.321	11.0
2020-03-06	CC	Futures	1696.0	1701.0	1674.0	1677.0	23420.0
2020-03-06	CNH	Futures	6.9033	6.9271	6.8899	6.8965	1094.0
2020-03-06	CSC	Futures	3.176	3.176	3.172	3.176	77.0
2020-03-06	CT	Futures	60.66	60.92	60.03	60.45	17203.0
2020-03-06	DC	Futures	26.27	26.29	26.16	26.21	98.0
2020-03-06	DX	Futures	93.803	93.813	92.871	93.113	42506.0
2020-03-06	E1	Futures	1.20917	1.22642	1.20723	1.22013	87511.0
2020-03-06	E6	Futures	1.21078	1.22386	1.20824	1.21972	424461.0
2020-03-06	E7	Futures	1.2043	1.2175	1.202	1.2133	16524.0
2020-03-06	EBM	Futures	205.77	206.05	202.69	203.53	33319.0
2020-03-06	ED	Futures	96.0552	96.2541	96.0358	96.094	948906.0
2020-03-06	ER	Futures	98.455	98.47	98.435	98.465	118771.0
2020-03-06	ESG	Futures	262.7	266.25	262.21	266.25	61.0
2020-03-06	EW	Futures	1925.7	1933.5	1846.7	1890.7	31371.0
2020-03-06	FBON	Futures	146.44	146.71	145.79	146.7	1394.0
2020-03-06	FBTP	Futures	130.58	131.42	129.86	131.06	183576.0
2020-03-06	FBTS	Futures	108.076	108.201	107.893	108.086	135827.0
2020-03-06	FCE	Futures	4745.3	4779.3	4590.7	4647.2	205008.0
2020-03-06	FDAX	Futures	12516.8	12544.3	12074.3	12209.1	212677.0
2020-03-06	FDIV	Futures	136.86	137.23	135.93	135.98	160.0
2020-03-06	FDXM	Futures	12359.7	12390.0	11922.2	12055.8	183815.0
2020-03-06	FESX	Futures	2927.8	2936.6	2812.4	2847.6	3348464.0
2020-03-06	FGBL	Futures	171.02	171.88	170.99	171.58	1064725.0
2020-03-06	FGBM	Futures	135.9	136.12	135.85	135.97	620714.0
2020-03-06	FGBS	Futures	113.227	113.283	113.182	113.222	614667.0
2020-03-06	FGBX	Futures	234.69	240.25	234.69	238.76	100787.0
2020-03-06	FMWO	Futures	7277.0	7277.0	7027.5	7112.6	25677.0
2020-03-06	FOAT	Futures	157.29	157.44	156.7	157.33	298348.0
2020-03-06	FTDX	Futures	2868.5	2878.0	2802.2	2833.3	97.0
2020-03-06	FTI	Futures	518.29	521.8	504.33	509.66	74689.0
2020-03-06	FTUK	Futures	6229.0	6230.8	6002.4	6063.8	207937.0
2020-03-06	FVSA	Futures	243.23	299.36	242.01	285.53	126670.0
2020-03-06	FXXP	Futures	340.1	341.7	330.8	334.5	170674.0
2020-03-06	G	Futures	125.59	126.64	125.49	126.49	341848.0

> showing 50 of 121 rows — these rows as CSV

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