PREVIEW / futures_daily / 2018-05-17

all futures daily files

  file:    by_date/futures_daily/2018/2018-05-17.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-05-17	ES	Futures	2959.82	2970.96	2948.13	2956.55	1071506.0
2018-05-17	NQ	Futures	8117.25	8148.56	8046.73	8082.72	325159.0
2018-05-17	YM	Futures	26062.2	26162.3	25946.3	26023.2	165080.0
2018-05-17	CL	Futures	72.09	72.84	71.68	72.04	460639.0
2018-05-17	GC	Futures	1647.2	1652.0	1639.3	1646.1	298816.0
2018-05-17	ZN	Futures	117.617087	117.710138	117.446492	117.632595	1649924.0
2018-05-17	A6	Futures	0.77283	0.77612	0.77098	0.77211	108841.0
2018-05-17	AD	Futures	0.79153	0.79411	0.7895	0.79087	68977.0
2018-05-17	B	Futures	58.08	58.99	57.98	58.11	330172.0
2018-05-17	B6	Futures	1.4009	1.4071	1.3972	1.4006	116842.0
2018-05-17	BFX	Futures	4478.7	4478.7	4477.5	4477.5	40.0
2018-05-17	BR	Futures	0.2094	0.21028	0.20502	0.2054	3499.0
2018-05-17	BTC	Futures	11641.5	11880.2	11395.7	11487.0	2872.0
2018-05-17	BZ	Futures	57.47	58.39	57.39	57.52	38385.0
2018-05-17	C	Futures	1724.0	1759.0	1685.0	1689.0	7336.0
2018-05-17	CB	Futures	300.211	300.211	298.975	298.975	16.0
2018-05-17	CC	Futures	1987.0	2017.0	1915.0	1924.0	22150.0
2018-05-17	CNH	Futures	6.4411	6.4555	6.4411	6.4543	57.0
2018-05-17	CSC	Futures	3.534	3.534	3.49	3.492	49.0
2018-05-17	CT	Futures	96.03	97.41	95.54	96.66	15148.0
2018-05-17	DC	Futures	28.61	28.61	28.19	28.23	441.0
2018-05-17	DX	Futures	87.895	88.164	87.716	88.065	21660.0
2018-05-17	E1	Futures	1.20659	1.20887	1.20309	1.20562	21075.0
2018-05-17	E6	Futures	1.33326	1.3363	1.32943	1.33185	283482.0
2018-05-17	E7	Futures	1.3262	1.3292	1.3223	1.3248	3975.0
2018-05-17	EBM	Futures	180.73	182.56	180.47	182.3	16386.0
2018-05-17	ED	Futures	94.9841	94.9913	94.9743	94.9865	264891.0
2018-05-17	ER	Futures	98.332	98.337	98.332	98.332	38615.0
2018-05-17	EW	Futures	2060.5	2071.5	2056.1	2063.8	11910.0
2018-05-17	FBON	Futures	128.09	128.44	127.84	127.99	1302.0
2018-05-17	FBTP	Futures	112.83	112.85	111.79	112.36	269784.0
2018-05-17	FBTS	Futures	103.742	103.927	103.677	103.816	138159.0
2018-05-17	FCE	Futures	4964.2	4998.8	4948.5	4995.6	77579.0
2018-05-17	FDAX	Futures	13517.0	13640.1	13484.2	13613.6	74179.0
2018-05-17	FDIV	Futures	157.35	158.21	157.35	158.21	2.0
2018-05-17	FDXM	Futures	13394.0	13519.7	13361.1	13492.4	29800.0
2018-05-17	FESX	Futures	2942.2	2965.5	2938.1	2958.9	1037007.0
2018-05-17	FEU3	Futures	99.026	99.026	99.021	99.021	50.0
2018-05-17	FGBL	Futures	148.7	149.05	148.43	148.56	905329.0
2018-05-17	FGBM	Futures	129.42	129.57	129.31	129.37	529559.0
2018-05-17	FGBS	Futures	112.507	112.532	112.482	112.497	461725.0
2018-05-17	FGBX	Futures	167.49	168.05	166.64	166.89	67442.0
2018-05-17	FMWO	Futures	7058.9	7085.7	7058.9	7084.6	359.0
2018-05-17	FOAT	Futures	137.78	138.02	137.46	137.68	190061.0
2018-05-17	FTDX	Futures	2750.7	2773.5	2750.7	2770.0	104.0
2018-05-17	FTI	Futures	521.25	524.53	520.6	524.3	17214.0
2018-05-17	FTUK	Futures	6833.1	6875.5	6800.8	6859.1	121251.0
2018-05-17	FVSA	Futures	302.87	307.16	298.57	299.64	21679.0
2018-05-17	FXXP	Futures	338.7	340.6	337.8	340.0	31727.0
2018-05-17	G	Futures	112.82	113.0	112.52	112.63	212734.0

> showing 50 of 115 rows — these rows as CSV

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