PREVIEW / futures_daily / 2018-11-01

all futures daily files

  file:    by_date/futures_daily/2018/2018-11-01.parquet
  size:    10 KB
  rows:    117

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-01	ES	Futures	2934.69	2972.92	2934.15	2969.39	1820142.0
2018-11-01	NQ	Futures	8084.22	8223.31	8057.21	8220.99	589071.0
2018-11-01	YM	Futures	26375.6	26707.3	26374.5	26668.3	214660.0
2018-11-01	CL	Futures	67.61	68.15	65.77	66.37	790286.0
2018-11-01	GC	Futures	1541.9	1570.7	1541.3	1569.8	313451.0
2018-11-01	ZN	Futures	118.047709	118.187778	117.876512	118.109962	1654904.0
2018-11-01	A6	Futures	0.72829	0.74249	0.72819	0.74187	163352.0
2018-11-01	AD	Futures	0.769	0.77436	0.76844	0.77325	81979.0
2018-11-01	B	Futures	55.2	55.43	53.63	53.87	360162.0
2018-11-01	B6	Futures	1.3162	1.3434	1.3153	1.3412	219406.0
2018-11-01	BFX	Futures	4066.3	4076.2	4066.3	4076.2	2.0
2018-11-01	BR	Futures	0.20487	0.2065	0.20437	0.20593	3032.0
2018-11-01	BTC	Futures	9112.4	9170.3	9105.1	9141.3	1174.0
2018-11-01	BZ	Futures	54.9	55.04	53.26	53.51	33938.0
2018-11-01	C	Futures	1558.0	1568.0	1534.0	1552.0	13662.0
2018-11-01	CB	Futures	270.185	271.567	270.185	271.327	21.0
2018-11-01	CC	Futures	1561.0	1601.0	1554.0	1581.0	29440.0
2018-11-01	CNH	Futures	7.031	7.031	6.9569	6.9618	1360.0
2018-11-01	CSC	Futures	3.072	3.084	3.048	3.074	128.0
2018-11-01	CT	Futures	86.51	89.35	85.9	88.71	35132.0
2018-11-01	DC	Futures	25.34	25.46	25.18	25.41	353.0
2018-11-01	DX	Futures	92.039	92.063	91.198	91.275	29791.0
2018-11-01	E1	Futures	1.18015	1.18964	1.17968	1.18738	31154.0
2018-11-01	E6	Futures	1.26249	1.2745	1.2621	1.27272	248490.0
2018-11-01	E7	Futures	1.2563	1.2682	1.2558	1.2665	4167.0
2018-11-01	EBM	Futures	206.38	209.24	206.38	208.72	27441.0
2018-11-01	ED	Futures	94.9792	94.989	94.9646	94.9694	305534.0
2018-11-01	ER	Futures	98.381	98.386	98.381	98.386	32347.0
2018-11-01	EW	Futures	1920.9	1959.6	1919.5	1957.6	25845.0
2018-11-01	FBON	Futures	127.68	127.79	127.45	127.52	350.0
2018-11-01	FBTP	Futures	104.65	105.41	104.43	105.12	54233.0
2018-11-01	FBTS	Futures	102.424	102.686	102.265	102.537	59338.0
2018-11-01	FCE	Futures	4545.7	4581.9	4527.7	4550.6	93710.0
2018-11-01	FDAX	Futures	12005.3	12162.0	11986.4	12019.0	122478.0
2018-11-01	FDXM	Futures	11801.6	11951.4	11778.8	11810.9	55894.0
2018-11-01	FESX	Futures	2673.9	2705.0	2668.9	2678.9	1218789.0
2018-11-01	FEU3	Futures	99.011	99.011	99.011	99.011	40.0
2018-11-01	FGBL	Futures	153.34	153.38	152.88	153.1	650185.0
2018-11-01	FGBM	Futures	131.14	131.16	130.96	131.07	383524.0
2018-11-01	FGBS	Futures	112.713	112.718	112.678	112.703	302546.0
2018-11-01	FGBX	Futures	178.42	178.46	177.45	177.65	47811.0
2018-11-01	FMWO	Futures	6712.2	6795.6	6712.2	6768.9	5331.0
2018-11-01	FOAT	Futures	140.5	140.54	140.26	140.43	120075.0
2018-11-01	FTDX	Futures	2588.2	2623.1	2587.7	2613.2	497.0
2018-11-01	FTI	Futures	480.58	486.87	480.58	484.7	29294.0
2018-11-01	FTUK	Futures	6335.4	6380.5	6301.0	6319.3	152394.0
2018-11-01	FVSA	Futures	371.97	372.92	354.85	360.55	42785.0
2018-11-01	FXXP	Futures	311.5	315.3	311.1	313.2	87504.0
2018-11-01	G	Futures	114.87	115.03	114.6	114.95	260177.0
2018-11-01	GF	Futures	319.482	320.21	317.766	318.754	2038.0

> showing 50 of 117 rows — these rows as CSV

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