PREVIEW / futures_daily / 2020-03-19

all futures daily files

  file:    by_date/futures_daily/2020/2020-03-19.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-19	ES	Futures	2658.33	2721.95	2517.25	2643.39	3127808.0
2020-03-19	NQ	Futures	8293.63	8601.17	7880.91	8338.63	516046.0
2020-03-19	YM	Futures	21234.4	21760.4	20096.9	21207.7	239922.0
2020-03-19	CL	Futures	22.62	28.03	21.58	25.68	1191520.0
2020-03-19	GC	Futures	1813.3	1832.3	1780.2	1803.6	325286.0
2020-03-19	ZN	Futures	132.838974	134.320794	132.036322	133.579884	2057363.0
2020-03-19	A6	Futures	0.59443	0.61271	0.56607	0.59391	126826.0
2020-03-19	AD	Futures	0.69906	0.70332	0.69111	0.69891	81159.0
2020-03-19	ALI	Futures	1965.47	1997.33	1962.74	1988.53	109.0
2020-03-19	B	Futures	23.13	25.03	21.23	24.22	335723.0
2020-03-19	B6	Futures	1.1792	1.2001	1.167	1.1736	169440.0
2020-03-19	BR	Futures	0.15652	0.16001	0.15652	0.16001	862.0
2020-03-19	BTC	Futures	7855.6	9359.6	7702.3	9111.4	8961.0
2020-03-19	BZ	Futures	21.89	24.32	20.68	23.57	41724.0
2020-03-19	C	Futures	1707.0	1711.0	1651.0	1673.0	13802.0
2020-03-19	CB	Futures	196.13	196.13	194.067	196.13	51.0
2020-03-19	CC	Futures	1468.0	1485.0	1443.0	1451.0	30445.0
2020-03-19	CNH	Futures	7.0264	7.0985	7.012	7.0928	1586.0
2020-03-19	CSC	Futures	2.994	3.024	2.991	3.0	209.0
2020-03-19	CT	Futures	54.2	54.83	51.64	52.89	27427.0
2020-03-19	DC	Futures	24.27	24.6	24.14	24.36	365.0
2020-03-19	DX	Futures	97.79	100.275	97.708	100.183	34697.0
2020-03-19	E1	Futures	1.1834	1.18795	1.15925	1.16062	55919.0
2020-03-19	E6	Futures	1.17923	1.18595	1.15075	1.15204	277211.0
2020-03-19	E7	Futures	1.1726	1.1798	1.1447	1.146	20228.0
2020-03-19	EBM	Futures	208.29	212.77	208.01	211.93	33002.0
2020-03-19	ED	Futures	96.1889	96.2179	95.9762	96.0536	779453.0
2020-03-19	ER	Futures	98.382	98.401	98.279	98.318	302366.0
2020-03-19	EW	Futures	1336.1	1412.2	1263.6	1383.9	18640.0
2020-03-19	FBON	Futures	138.22	139.25	137.28	137.96	491.0
2020-03-19	FBTP	Futures	125.09	127.77	121.52	122.7	130320.0
2020-03-19	FBTS	Futures	106.537	107.229	105.969	106.508	88111.0
2020-03-19	FCE	Futures	3686.5	3783.9	3550.5	3717.0	59165.0
2020-03-19	FDAX	Futures	9096.3	9307.3	8400.9	9105.8	55941.0
2020-03-19	FDIV	Futures	96.5	97.98	94.08	97.98	4591.0
2020-03-19	FDXM	Futures	9095.6	9350.7	8462.2	9149.3	7976.0
2020-03-19	FESX	Futures	2164.2	2236.7	1981.6	2185.3	1773039.0
2020-03-19	FEU3	Futures	99.045	99.055	99.045	99.055	100.0
2020-03-19	FGBL	Futures	165.26	166.39	162.84	163.24	813387.0
2020-03-19	FGBM	Futures	133.8	134.2	132.7	132.78	468048.0
2020-03-19	FGBS	Futures	113.041	113.122	112.684	112.729	461971.0
2020-03-19	FGBX	Futures	223.32	227.94	216.15	216.75	49878.0
2020-03-19	FMWO	Futures	5792.8	6003.3	5675.1	5858.6	9738.0
2020-03-19	FOAT	Futures	151.12	151.87	148.36	148.73	196285.0
2020-03-19	FTDX	Futures	2244.5	2329.9	2204.0	2288.4	149.0
2020-03-19	FTI	Futures	376.93	402.76	371.91	394.6	11988.0
2020-03-19	FTUK	Futures	4762.4	4931.2	4536.1	4834.5	116757.0
2020-03-19	FVSA	Futures	602.68	646.34	460.9	556.32	27497.0
2020-03-19	FXXP	Futures	253.4	266.0	248.8	261.5	94408.0
2020-03-19	G	Futures	120.3	122.25	117.24	119.72	312065.0

> showing 50 of 119 rows — these rows as CSV

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