PREVIEW / futures_daily / 2020-05-18

all futures daily files

  file:    by_date/futures_daily/2020/2020-05-18.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-05-18	ES	Futures	3164.27	3280.45	3153.48	3261.92	1775433.0
2020-05-18	NQ	Futures	10472.73	10732.4	10444.35	10691.12	398562.0
2020-05-18	YM	Futures	25182.5	26292.2	25116.3	26150.3	209126.0
2020-05-18	CL	Futures	21.61	24.0	21.42	22.94	561527.0
2020-05-18	GC	Futures	2131.4	2153.6	2097.2	2103.3	271472.0
2020-05-18	ZN	Futures	137.670324	137.701195	136.883107	136.913978	1274344.0
2020-05-18	A6	Futures	0.65895	0.67066	0.65884	0.66932	88484.0
2020-05-18	AD	Futures	0.71811	0.72703	0.71806	0.72571	48224.0
2020-05-18	ALI	Futures	1763.67	1796.64	1763.67	1796.64	94.0
2020-05-18	B	Futures	21.65	23.59	21.59	22.99	232249.0
2020-05-18	B6	Futures	1.2267	1.2413	1.2261	1.2377	94734.0
2020-05-18	BR	Futures	0.13993	0.1437	0.13993	0.14313	6451.0
2020-05-18	BTC	Futures	13623.2	13957.0	13233.7	13553.6	7691.0
2020-05-18	BZ	Futures	20.91	22.84	20.91	22.25	28869.0
2020-05-18	C	Futures	1875.0	1884.0	1864.0	1869.0	2955.0
2020-05-18	CB	Futures	182.913	182.913	181.798	182.356	81.0
2020-05-18	CC	Futures	1564.0	1579.0	1553.0	1571.0	8502.0
2020-05-18	CNH	Futures	7.0674	7.0834	7.0578	7.0578	335.0
2020-05-18	CSC	Futures	3.258	3.273	3.172	3.227	147.0
2020-05-18	CT	Futures	56.93	57.47	55.95	56.34	11952.0
2020-05-18	DC	Futures	26.64	26.88	25.96	26.5	656.0
2020-05-18	DX	Futures	97.118	97.196	96.306	96.389	17630.0
2020-05-18	E1	Futures	1.17326	1.17782	1.16768	1.17155	31405.0
2020-05-18	E6	Futures	1.1629	1.17504	1.16129	1.17365	182678.0
2020-05-18	E7	Futures	1.1572	1.1689	1.1552	1.1675	6045.0
2020-05-18	EBM	Futures	223.05	223.94	220.65	220.95	15863.0
2020-05-18	ED	Futures	96.3775	96.392	96.3581	96.3629	272932.0
2020-05-18	ER	Futures	98.264	98.279	98.259	98.274	56465.0
2020-05-18	ESG	Futures	265.08	268.14	265.08	266.76	5071.0
2020-05-18	EW	Futures	1667.0	1781.4	1665.4	1772.6	14262.0
2020-05-18	FBON	Futures	140.37	140.74	140.04	140.54	448.0
2020-05-18	FBTP	Futures	123.24	125.17	122.88	124.06	106778.0
2020-05-18	FBTS	Futures	106.874	107.355	106.729	107.085	70774.0
2020-05-18	FCE	Futures	4198.0	4384.9	4197.5	4358.2	48521.0
2020-05-18	FDAX	Futures	11162.9	11787.4	11162.9	11710.2	94875.0
2020-05-18	FDIV	Futures	120.06	124.52	120.06	124.52	300.0
2020-05-18	FDXM	Futures	11207.2	11842.7	11207.2	11766.2	71646.0
2020-05-18	FESX	Futures	2550.6	2681.0	2549.7	2665.4	1264069.0
2020-05-18	FGBL	Futures	168.89	169.22	167.78	168.32	678104.0
2020-05-18	FGBM	Futures	135.08	135.25	134.67	134.86	470835.0
2020-05-18	FGBS	Futures	112.905	112.966	112.815	112.87	362414.0
2020-05-18	FGBX	Futures	229.01	229.66	224.89	226.86	48229.0
2020-05-18	FMWO	Futures	7026.8	7244.5	7026.8	7213.9	3769.0
2020-05-18	FOAT	Futures	152.96	153.22	152.39	152.63	145420.0
2020-05-18	FTDX	Futures	2995.1	3064.9	2995.1	3063.4	109.0
2020-05-18	FTI	Futures	471.89	487.07	471.57	483.79	28020.0
2020-05-18	FTUK	Futures	5511.6	5730.0	5511.6	5702.1	100394.0
2020-05-18	FVSA	Futures	286.37	286.37	261.49	263.3	17004.0
2020-05-18	FXXP	Futures	306.3	316.3	306.3	315.6	76514.0
2020-05-18	G	Futures	126.14	126.53	125.83	125.93	144010.0

> showing 50 of 119 rows — these rows as CSV

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