PREVIEW / futures_daily / 2020-08-17

all futures daily files

  file:    by_date/futures_daily/2020/2020-08-17.parquet
  size:    10 KB
  rows:    119

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-08-17	ES	Futures	3788.73	3807.58	3787.32	3804.2	759304.0
2020-08-17	NQ	Futures	12935.33	13115.81	12932.14	13099.85	246403.0
2020-08-17	YM	Futures	29835.9	29930.2	29724.4	29766.2	111616.0
2020-08-17	CL	Futures	30.7	31.28	30.44	31.22	193105.0
2020-08-17	GC	Futures	2310.5	2363.0	2290.1	2360.5	289437.0
2020-08-17	ZN	Futures	137.908311	138.218008	137.861856	138.078644	1000368.0
2020-08-17	A6	Futures	0.73798	0.74353	0.73777	0.74158	62858.0
2020-08-17	AD	Futures	0.76581	0.76951	0.76535	0.76921	40713.0
2020-08-17	ALI	Futures	2115.31	2115.31	2097.14	2104.88	382.0
2020-08-17	B	Futures	28.92	29.27	28.71	29.25	164226.0
2020-08-17	B6	Futures	1.3301	1.3325	1.3277	1.3305	51166.0
2020-08-17	BR	Futures	0.14587	0.14639	0.14362	0.14381	4522.0
2020-08-17	BTC	Futures	16348.4	17285.6	16286.9	17080.3	8883.0
2020-08-17	BZ	Futures	28.3	28.59	28.01	28.56	19441.0
2020-08-17	C	Futures	1537.0	1543.0	1488.0	1513.0	4198.0
2020-08-17	CC	Futures	1606.0	1615.0	1586.0	1595.0	22112.0
2020-08-17	CNH	Futures	6.8456	6.8491	6.8392	6.8412	515.0
2020-08-17	CSC	Futures	3.593	3.597	3.426	3.437	111.0
2020-08-17	CT	Futures	63.59	63.59	63.33	63.33	3.0
2020-08-17	DC	Futures	29.16	29.35	27.73	27.97	621.0
2020-08-17	DX	Futures	89.866	89.943	89.59	89.684	12464.0
2020-08-17	E1	Futures	1.25033	1.25567	1.24954	1.25408	15885.0
2020-08-17	E6	Futures	1.27147	1.2756	1.26997	1.27394	128995.0
2020-08-17	E7	Futures	1.2654	1.2692	1.2636	1.2676	4545.0
2020-08-17	EBM	Futures	218.56	221.55	217.06	221.25	16625.0
2020-08-17	ED	Futures	96.433	96.4427	96.4282	96.4403	151923.0
2020-08-17	ER	Futures	98.396	98.401	98.396	98.396	45435.0
2020-08-17	ESG	Futures	307.44	307.65	307.21	307.44	609.0
2020-08-17	EW	Futures	2070.5	2083.0	2068.9	2076.8	9687.0
2020-08-17	FBON	Futures	146.37	146.82	146.17	146.81	130.0
2020-08-17	FBTP	Futures	132.9	133.74	132.9	133.72	41954.0
2020-08-17	FBTS	Futures	108.909	109.055	108.909	109.055	50720.0
2020-08-17	FCE	Futures	4821.1	4859.6	4803.6	4834.2	25181.0
2020-08-17	FDAX	Futures	13676.1	13766.4	13639.4	13739.8	45746.0
2020-08-17	FDXM	Futures	13628.9	13716.7	13587.6	13690.3	29450.0
2020-08-17	FESX	Futures	3044.4	3062.0	3029.6	3052.7	473354.0
2020-08-17	FEU3	Futures	99.149	99.149	99.144	99.144	100.0
2020-08-17	FGBL	Futures	167.79	168.42	167.72	168.36	470775.0
2020-08-17	FGBM	Futures	134.52	134.72	134.51	134.69	302069.0
2020-08-17	FGBS	Futures	112.674	112.709	112.669	112.689	197592.0
2020-08-17	FGBX	Futures	224.66	227.1	224.5	226.91	30144.0
2020-08-17	FMWO	Futures	8372.7	8413.0	8359.7	8411.8	2964.0
2020-08-17	FOAT	Futures	155.59	156.15	155.59	156.12	103884.0
2020-08-17	FTDX	Futures	3152.8	3172.7	3152.8	3170.7	18.0
2020-08-17	FTI	Futures	521.2	524.97	520.36	523.94	3450.0
2020-08-17	FTUK	Futures	5743.1	5794.2	5714.8	5790.8	64790.0
2020-08-17	FVSA	Futures	212.05	213.3	200.43	203.34	17324.0
2020-08-17	FXXP	Futures	339.4	340.9	337.5	340.8	33329.0
2020-08-17	G	Futures	126.49	126.76	126.39	126.68	132020.0
2020-08-17	GF	Futures	279.334	279.667	274.29	274.861	4885.0

> showing 50 of 119 rows — these rows as CSV

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