PREVIEW / futures_daily / 2018-09-07

all futures daily files

  file:    by_date/futures_daily/2018/2018-09-07.parquet
  size:    10 KB
  rows:    116

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-09-07	ES	Futures	3125.52	3133.39	3111.67	3122.26	1692240.0
2018-09-07	NQ	Futures	8691.51	8738.14	8619.51	8672.56	606515.0
2018-09-07	YM	Futures	27399.2	27436.0	27220.0	27352.8	206054.0
2018-09-07	CL	Futures	70.7	70.91	69.64	70.57	530895.0
2018-09-07	GC	Futures	1528.0	1532.3	1519.3	1521.4	287651.0
2018-09-07	ZN	Futures	119.665465	119.681004	119.090523	119.13714	44350.0
2018-09-07	A6	Futures	0.74043	0.74063	0.73004	0.73128	154188.0
2018-09-07	AD	Futures	0.77067	0.7727	0.76799	0.7691	94733.0
2018-09-07	B	Futures	55.9	56.2	55.31	56.0	208999.0
2018-09-07	B6	Futures	1.3344	1.3445	1.3321	1.3338	150787.0
2018-09-07	BFX	Futures	4231.9	4244.1	4231.9	4244.1	5.0
2018-09-07	BR	Futures	0.18479	0.18479	0.18361	0.18361	4.0
2018-09-07	BTC	Futures	9167.5	9303.3	8981.5	9138.9	2475.0
2018-09-07	BZ	Futures	55.58	55.94	55.08	55.76	17798.0
2018-09-07	C	Futures	1529.0	1554.0	1520.0	1525.0	1317.0
2018-09-07	CB	Futures	262.886	268.263	262.886	267.241	12.0
2018-09-07	CC	Futures	1593.0	1627.0	1569.0	1578.0	22390.0
2018-09-07	CNH	Futures	6.9117	6.9619	6.904	6.9438	1159.0
2018-09-07	CSC	Futures	3.291	3.329	3.283	3.317	64.0
2018-09-07	CT	Futures	92.15	92.15	92.15	92.15	1.0
2018-09-07	DC	Futures	27.01	27.38	26.98	27.31	112.0
2018-09-07	DX	Futures	89.975	90.372	89.814	90.286	26235.0
2018-09-07	E1	Futures	1.2385	1.2403	1.23277	1.23408	40320.0
2018-09-07	E6	Futures	1.30083	1.30357	1.2925	1.29412	291942.0
2018-09-07	E7	Futures	1.2941	1.2969	1.2859	1.2876	4521.0
2018-09-07	EBM	Futures	205.34	206.9	203.78	205.6	26915.0
2018-09-07	ED	Futures	95.0886	95.0911	95.0789	95.0813	282798.0
2018-09-07	ER	Futures	98.372	98.372	98.367	98.372	21226.0
2018-09-07	EW	Futures	2150.4	2158.1	2139.7	2147.3	16420.0
2018-09-07	FBON	Futures	128.59	128.71	128.35	128.44	327.0
2018-09-07	FBTP	Futures	107.1	107.68	106.82	107.04	86139.0
2018-09-07	FBTS	Futures	102.649	102.995	102.621	102.715	65604.0
2018-09-07	FCE	Futures	4726.9	4745.9	4708.0	4732.8	75228.0
2018-09-07	FDAX	Futures	12481.3	12530.9	12420.7	12489.1	93932.0
2018-09-07	FDXM	Futures	12327.0	12370.3	12264.0	12329.6	37712.0
2018-09-07	FESX	Futures	2752.8	2761.2	2733.6	2747.8	1173954.0
2018-09-07	FGBL	Futures	153.53	153.53	152.96	153.08	569842.0
2018-09-07	FGBM	Futures	131.1	131.1	130.9	130.97	330096.0
2018-09-07	FGBS	Futures	112.623	112.623	112.573	112.593	310626.0
2018-09-07	FGBX	Futures	178.26	178.28	176.73	176.95	37693.0
2018-09-07	FMWO	Futures	7141.6	7145.1	7098.6	7134.7	2712.0
2018-09-07	FOAT	Futures	141.05	141.05	140.62	140.72	121917.0
2018-09-07	FTDX	Futures	2833.8	2859.3	2827.9	2858.3	786.0
2018-09-07	FTI	Futures	501.04	501.27	495.2	499.51	30650.0
2018-09-07	FTUK	Futures	6523.4	6537.2	6439.7	6484.6	142344.0
2018-09-07	FVSA	Futures	285.69	294.4	282.21	285.69	31824.0
2018-09-07	FXXP	Futures	323.0	323.7	321.7	323.1	56568.0
2018-09-07	G	Futures	115.06	115.13	114.73	114.83	251432.0
2018-09-07	GF	Futures	315.422	318.282	314.642	318.23	1447.0
2018-09-07	GSCI	Futures	515.59	519.81	515.59	519.25	490.0

> showing 50 of 116 rows — these rows as CSV

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