PREVIEW / futures_daily / 2018-11-06

all futures daily files

  file:    by_date/futures_daily/2018/2018-11-06.parquet
  size:    10 KB
  rows:    115

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-06	ES	Futures	2970.48	2994.34	2960.44	2992.17	1269341.0
2018-11-06	NQ	Futures	8069.41	8171.04	8022.37	8149.85	514296.0
2018-11-06	YM	Futures	26791.5	27021.1	26710.4	27001.1	152627.0
2018-11-06	CL	Futures	65.34	65.99	63.89	64.83	761240.0
2018-11-06	GC	Futures	1563.2	1568.8	1552.5	1554.2	199669.0
2018-11-06	ZN	Futures	117.658626	117.767569	117.425176	117.534119	1215002.0
2018-11-06	A6	Futures	0.74239	0.74599	0.74167	0.7427	69297.0
2018-11-06	AD	Futures	0.77193	0.77203	0.76981	0.77006	43537.0
2018-11-06	B	Futures	53.84	54.16	52.61	53.31	290879.0
2018-11-06	B6	Futures	1.3453	1.3505	1.3415	1.3488	110183.0
2018-11-06	BFX	Futures	4062.3	4070.4	4033.7	4070.4	2.0
2018-11-06	BR	Futures	0.20403	0.2049	0.20178	0.20281	1760.0
2018-11-06	BTC	Futures	9257.1	9372.9	9242.6	9286.1	3048.0
2018-11-06	BZ	Futures	53.38	53.79	52.25	52.95	32871.0
2018-11-06	C	Futures	1571.0	1577.0	1557.0	1571.0	8135.0
2018-11-06	CB	Futures	270.366	270.366	267.662	267.662	29.0
2018-11-06	CC	Futures	1612.0	1649.0	1609.0	1645.0	43349.0
2018-11-06	CNH	Futures	6.9555	6.9653	6.9534	6.9615	268.0
2018-11-06	CSC	Futures	3.032	3.032	2.982	2.982	34.0
2018-11-06	CT	Futures	88.62	88.87	86.24	86.91	31382.0
2018-11-06	DC	Futures	25.04	25.06	24.68	24.74	498.0
2018-11-06	DX	Futures	91.308	91.441	91.151	91.309	14077.0
2018-11-06	E1	Futures	1.18395	1.18679	1.18288	1.18561	15939.0
2018-11-06	E6	Futures	1.27227	1.27578	1.27055	1.27289	159045.0
2018-11-06	E7	Futures	1.2662	1.2694	1.2643	1.2667	2659.0
2018-11-06	EBM	Futures	208.46	209.5	208.2	209.24	12988.0
2018-11-06	ED	Futures	94.9646	94.9841	94.9646	94.9694	191320.0
2018-11-06	ER	Futures	98.391	98.391	98.381	98.386	34542.0
2018-11-06	EW	Futures	1968.2	1984.4	1962.0	1980.2	15035.0
2018-11-06	FBON	Futures	127.49	127.52	127.35	127.38	373.0
2018-11-06	FBTP	Futures	105.33	105.69	104.8	104.91	76041.0
2018-11-06	FBTS	Futures	102.818	102.939	102.668	102.696	65899.0
2018-11-06	FCE	Futures	4577.0	4587.3	4534.9	4543.4	64327.0
2018-11-06	FDAX	Futures	12112.6	12135.7	12014.8	12077.9	85477.0
2018-11-06	FDXM	Futures	11904.9	11924.5	11807.8	11868.7	37855.0
2018-11-06	FESX	Futures	2701.6	2707.5	2678.9	2690.7	809160.0
2018-11-06	FGBL	Futures	152.85	153.16	152.75	152.84	525127.0
2018-11-06	FGBM	Futures	131.01	131.13	130.96	130.98	302247.0
2018-11-06	FGBS	Futures	112.688	112.708	112.668	112.678	254653.0
2018-11-06	FGBX	Futures	176.95	177.67	176.71	176.89	33187.0
2018-11-06	FMWO	Futures	6807.2	6825.7	6784.0	6808.3	5765.0
2018-11-06	FOAT	Futures	140.04	140.28	140.01	140.05	99595.0
2018-11-06	FTDX	Futures	2590.7	2616.2	2586.2	2603.4	238.0
2018-11-06	FTI	Futures	487.53	488.32	484.08	486.17	21124.0
2018-11-06	FTUK	Futures	6337.2	6344.8	6257.2	6272.4	109297.0
2018-11-06	FVSA	Futures	349.14	359.6	341.53	349.14	33746.0
2018-11-06	FXXP	Futures	315.1	315.4	312.3	313.5	33673.0
2018-11-06	G	Futures	114.4	114.58	114.15	114.24	235602.0
2018-11-06	GF	Futures	311.477	312.724	311.217	311.84	1121.0
2018-11-06	GSCI	Futures	507.95	510.4	507.95	510.4	228.0

> showing 50 of 115 rows — these rows as CSV

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