PREVIEW / futures_daily / 2018-11-28

all futures daily files

  file:    by_date/futures_daily/2018/2018-11-28.parquet
  size:    10 KB
  rows:    113

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
2018-11-28	ES	Futures	2913.27	2976.98	2907.57	2973.19	1866115.0
2018-11-28	NQ	Futures	7808.07	8041.82	7792.97	8035.73	639404.0
2018-11-28	YM	Futures	26086.0	26715.7	26038.6	26688.3	248227.0
2018-11-28	CL	Futures	55.11	55.61	52.96	53.21	831688.0
2018-11-28	GC	Futures	1538.3	1554.6	1533.2	1549.6	209030.0
2018-11-28	ZN	Futures	118.763621	118.934817	118.607988	118.919254	3081143.0
2018-11-28	A6	Futures	0.74352	0.75422	0.74321	0.75288	114259.0
2018-11-28	AD	Futures	0.76066	0.76389	0.75712	0.76212	102689.0
2018-11-28	B	Futures	44.67	45.1	43.22	43.39	336180.0
2018-11-28	B6	Futures	1.3115	1.3224	1.3106	1.3212	96949.0
2018-11-28	BR	Futures	0.20611	0.20611	0.20611	0.20611	359.0
2018-11-28	BTC	Futures	5760.1	6629.8	5752.5	6538.3	1334.0
2018-11-28	BZ	Futures	44.24	44.51	42.68	42.83	30988.0
2018-11-28	C	Futures	1448.0	1452.0	1428.0	1441.0	4524.0
2018-11-28	CB	Futures	264.24	266.427	264.24	265.698	34.0
2018-11-28	CC	Futures	1472.0	1485.0	1451.0	1461.0	16161.0
2018-11-28	CNH	Futures	6.9919	6.9977	6.9716	6.9748	248.0
2018-11-28	CSC	Futures	2.905	2.907	2.888	2.892	22.0
2018-11-28	CT	Futures	84.84	86.11	84.64	85.93	11127.0
2018-11-28	DC	Futures	23.89	24.2	23.89	23.97	108.0
2018-11-28	DX	Futures	92.443	92.58	91.749	91.845	29530.0
2018-11-28	E1	Futures	1.18869	1.19604	1.18632	1.19544	23611.0
2018-11-28	E6	Futures	1.25771	1.2681	1.25448	1.2666	242326.0
2018-11-28	E7	Futures	1.2512	1.2618	1.2485	1.2604	5063.0
2018-11-28	EBM	Futures	206.9	207.68	206.38	207.68	13601.0
2018-11-28	ED	Futures	94.945	94.9572	94.9426	94.9548	329702.0
2018-11-28	ER	Futures	98.386	98.391	98.386	98.386	28411.0
2018-11-28	EW	Futures	1942.4	1966.4	1916.2	1965.3	22255.0
2018-11-28	FBON	Futures	127.9	128.1	127.78	128.03	435.0
2018-11-28	FBTP	Futures	106.43	106.85	106.16	106.69	138250.0
2018-11-28	FBTS	Futures	103.632	103.632	103.361	103.426	78249.0
2018-11-28	FCE	Futures	4471.4	4499.1	4442.7	4448.5	72231.0
2018-11-28	FDAX	Futures	11969.6	12005.9	11854.4	11878.6	100743.0
2018-11-28	FDXM	Futures	11759.2	11799.5	11648.6	11672.9	49805.0
2018-11-28	FESX	Futures	2669.7	2686.5	2652.9	2656.3	911094.0
2018-11-28	FGBL	Futures	154.08	154.25	153.92	153.98	881241.0
2018-11-28	FGBM	Futures	131.44	131.51	131.39	131.41	428423.0
2018-11-28	FGBS	Futures	112.698	112.724	112.698	112.703	298752.0
2018-11-28	FGBX	Futures	178.8	179.35	178.4	178.64	47567.0
2018-11-28	FMWO	Futures	6671.6	6796.7	6663.5	6676.2	1272.0
2018-11-28	FOAT	Futures	141.04	141.16	140.94	140.98	148864.0
2018-11-28	FTDX	Futures	2525.8	2537.6	2514.0	2520.4	305.0
2018-11-28	FTI	Futures	484.41	487.24	480.88	482.06	23565.0
2018-11-28	FTUK	Futures	6291.6	6325.1	6245.6	6263.5	92518.0
2018-11-28	FVSA	Futures	334.65	340.7	326.59	335.66	21136.0
2018-11-28	FXXP	Futures	311.3	312.6	309.1	309.4	43532.0
2018-11-28	G	Futures	116.0	116.19	115.89	115.99	331674.0
2018-11-28	GF	Futures	319.285	320.092	317.562	317.939	3625.0
2018-11-28	GSCI	Futures	459.29	459.52	455.96	457.03	67.0
2018-11-28	HE	Futures	78.016	79.249	76.784	77.566	12618.0

> showing 50 of 113 rows — these rows as CSV

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