PREVIEW / futures_daily / 2020-03-31

all futures daily files

  file:    by_date/futures_daily/2020/2020-03-31.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-03-31	ES	Futures	2891.52	2916.42	2827.9	2843.39	2248012.0
2020-03-31	NQ	Futures	9007.29	9165.79	8882.04	8926.47	424386.0
2020-03-31	YM	Futures	23673.6	23887.0	23092.1	23209.5	173680.0
2020-03-31	CL	Futures	20.05	21.69	19.83	20.3	660082.0
2020-03-31	GC	Futures	1993.0	1995.7	1926.0	1936.2	176554.0
2020-03-31	ZN	Futures	136.790493	137.361612	136.667009	137.006592	1527275.0
2020-03-31	A6	Futures	0.63357	0.6385	0.62402	0.6311	112852.0
2020-03-31	AD	Futures	0.71624	0.72379	0.70666	0.71994	91472.0
2020-03-31	ALI	Futures	1864.14	1864.14	1845.93	1845.93	10.0
2020-03-31	B	Futures	20.24	21.38	19.68	20.18	367505.0
2020-03-31	B6	Futures	1.2584	1.268	1.2445	1.2644	101715.0
2020-03-31	BR	Futures	0.15681	0.15788	0.15681	0.15734	357.0
2020-03-31	BTC	Futures	9227.3	9447.2	8993.3	9184.8	2305.0
2020-03-31	BZ	Futures	19.66	20.74	19.1	19.58	40694.0
2020-03-31	C	Futures	1633.0	1644.0	1616.0	1618.0	6787.0
2020-03-31	CB	Futures	163.758	164.343	160.607	160.886	24.0
2020-03-31	CC	Futures	1478.0	1485.0	1458.0	1473.0	14106.0
2020-03-31	CNH	Futures	7.0411	7.0435	7.0179	7.0287	361.0
2020-03-31	CSC	Futures	2.64	2.664	2.567	2.609	140.0
2020-03-31	CT	Futures	48.62	49.8	47.62	49.23	15783.0
2020-03-31	DC	Futures	21.09	21.18	20.29	20.77	658.0
2020-03-31	DX	Futures	96.006	96.818	95.61	95.82	18579.0
2020-03-31	E1	Futures	1.19308	1.19308	1.18009	1.18636	38633.0
2020-03-31	E6	Futures	1.191	1.19154	1.17784	1.18756	205731.0
2020-03-31	E7	Futures	1.1848	1.1854	1.1718	1.1814	9146.0
2020-03-31	EBM	Futures	220.05	220.61	218.93	219.77	12737.0
2020-03-31	ED	Futures	96.1406	96.1889	96.1309	96.1744	377064.0
2020-03-31	ER	Futures	98.318	98.333	98.308	98.323	71616.0
2020-03-31	EW	Futures	1540.6	1551.3	1500.7	1523.7	10942.0
2020-03-31	FBON	Futures	142.28	142.44	140.73	141.25	307.0
2020-03-31	FBTP	Futures	126.91	127.49	126.23	126.35	96233.0
2020-03-31	FBTS	Futures	107.412	107.643	107.278	107.316	48281.0
2020-03-31	FCE	Futures	4259.9	4328.1	4162.5	4256.5	61244.0
2020-03-31	FDAX	Futures	10435.8	10653.6	10232.2	10478.6	106697.0
2020-03-31	FDIV	Futures	113.11	113.85	112.09	112.09	300.0
2020-03-31	FDXM	Futures	10488.8	10705.6	10280.5	10528.7	100971.0
2020-03-31	FESX	Futures	2517.6	2558.9	2464.4	2521.3	1474241.0
2020-03-31	FGBL	Futures	168.01	168.32	167.51	167.69	509365.0
2020-03-31	FGBM	Futures	134.61	134.81	134.47	134.56	301846.0
2020-03-31	FGBS	Futures	112.92	112.951	112.845	112.885	166064.0
2020-03-31	FGBX	Futures	224.62	225.82	222.35	222.58	45093.0
2020-03-31	FMWO	Futures	6485.7	6517.4	6369.2	6511.6	4384.0
2020-03-31	FOAT	Futures	153.22	153.42	152.33	152.5	93969.0
2020-03-31	FTDX	Futures	2657.5	2668.1	2614.5	2619.0	24.0
2020-03-31	FTI	Futures	446.13	455.04	441.44	452.58	30587.0
2020-03-31	FTUK	Futures	5259.8	5368.3	5187.7	5314.5	171737.0
2020-03-31	FVSA	Futures	409.59	422.64	386.63	394.74	14393.0
2020-03-31	FXXP	Futures	288.8	294.2	286.7	292.7	102570.0
2020-03-31	G	Futures	124.76	125.24	123.94	124.75	223803.0
2020-03-31	GF	Futures	249.272	255.501	242.108	253.165	1328.0

> showing 50 of 119 rows — these rows as CSV

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