PREVIEW / futures_daily / 2018-10-19

all futures daily files

  file:    by_date/futures_daily/2018/2018-10-19.parquet
  size:    10 KB
  rows:    114

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-10-19	ES	Futures	3009.25	3037.17	2995.69	3001.39	2023613.0
2018-10-19	NQ	Futures	8309.56	8414.38	8238.41	8254.38	661050.0
2018-10-19	YM	Futures	26729.4	26953.7	26682.0	26776.8	267838.0
2018-10-19	CL	Futures	71.66	72.85	71.51	72.2	547544.0
2018-10-19	GC	Futures	1557.2	1564.1	1554.1	1557.3	191796.0
2018-10-19	ZN	Futures	117.611936	117.720879	117.425176	117.487429	1956703.0
2018-10-19	A6	Futures	0.73097	0.73611	0.72973	0.73282	97939.0
2018-10-19	AD	Futures	0.7738	0.77694	0.77077	0.77168	87955.0
2018-10-19	B	Futures	58.37	59.43	58.21	58.62	291069.0
2018-10-19	B6	Futures	1.3427	1.3512	1.3415	1.3472	101479.0
2018-10-19	BR	Futures	0.20487	0.20544	0.20422	0.2049	51.0
2018-10-19	BTC	Futures	9199.3	9242.6	9148.8	9206.5	1108.0
2018-10-19	BZ	Futures	57.86	58.99	57.77	58.18	34401.0
2018-10-19	C	Futures	1465.0	1489.0	1455.0	1487.0	6609.0
2018-10-19	CB	Futures	270.366	270.366	270.366	270.366	33.0
2018-10-19	CC	Futures	1502.0	1525.0	1476.0	1510.0	18249.0
2018-10-19	CNH	Futures	6.9913	7.0013	6.9755	6.9878	650.0
2018-10-19	CSC	Futures	3.076	3.086	3.064	3.076	29.0
2018-10-19	CT	Futures	87.72	87.72	87.01	87.46	11714.0
2018-10-19	DC	Futures	25.89	25.91	25.74	25.88	283.0
2018-10-19	DX	Futures	90.909	91.037	90.51	90.669	26371.0
2018-10-19	E1	Futures	1.19639	1.19734	1.19378	1.19461	21009.0
2018-10-19	E6	Futures	1.27922	1.28817	1.27678	1.28539	245234.0
2018-10-19	E7	Futures	1.273	1.2818	1.2705	1.2791	4983.0
2018-10-19	EBM	Futures	209.24	210.27	208.98	209.24	13788.0
2018-10-19	ED	Futures	94.9646	94.989	94.9499	94.9597	671980.0
2018-10-19	ER	Futures	98.367	98.381	98.367	98.377	150527.0
2018-10-19	EW	Futures	1987.4	1997.0	1965.4	1971.4	21083.0
2018-10-19	FBON	Futures	125.55	125.59	124.72	125.53	2984.0
2018-10-19	FBTP	Futures	102.1	104.3	101.39	103.47	177877.0
2018-10-19	FBTS	Futures	100.757	101.806	100.448	101.422	141940.0
2018-10-19	FCE	Futures	4581.5	4597.6	4525.1	4550.1	109338.0
2018-10-19	FDAX	Futures	12186.2	12211.4	12080.5	12138.9	138453.0
2018-10-19	FDXM	Futures	11972.1	12000.0	11871.8	11928.7	65218.0
2018-10-19	FESX	Futures	2692.4	2702.5	2666.3	2689.9	1472968.0
2018-10-19	FGBL	Futures	152.91	153.2	152.23	152.55	1044791.0
2018-10-19	FGBM	Futures	131.03	131.12	130.65	130.84	647280.0
2018-10-19	FGBS	Futures	112.729	112.729	112.618	112.673	518556.0
2018-10-19	FGBX	Futures	176.93	177.86	176.1	176.85	63065.0
2018-10-19	FMWO	Futures	6883.6	6918.4	6854.7	6894.1	2066.0
2018-10-19	FOAT	Futures	139.84	139.9	139.44	139.54	231199.0
2018-10-19	FTDX	Futures	2607.4	2629.9	2586.7	2601.5	487.0
2018-10-19	FTI	Futures	486.73	490.75	485.24	488.26	39778.0
2018-10-19	FTUK	Futures	6241.1	6295.6	6240.7	6278.2	108976.0
2018-10-19	FVSA	Futures	340.58	356.75	337.72	344.38	37971.0
2018-10-19	FXXP	Futures	312.8	313.3	310.0	312.1	78191.0
2018-10-19	G	Futures	114.05	114.26	113.61	113.91	271831.0
2018-10-19	GF	Futures	320.833	322.029	319.638	320.417	3765.0
2018-10-19	GSCI	Futures	543.54	543.59	542.45	542.45	78.0
2018-10-19	HE	Futures	71.002	72.411	69.123	69.257	22938.0

> showing 50 of 114 rows — these rows as CSV

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