PREVIEW / futures_daily / 2018-10-22

all futures daily files

  file:    by_date/futures_daily/2018/2018-10-22.parquet
  size:    10 KB
  rows:    113

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-22	ES	Futures	2991.08	3017.11	2982.13	2989.46	1665740.0
2018-10-22	NQ	Futures	8230.28	8375.18	8196.89	8311.01	650331.0
2018-10-22	YM	Futures	26714.7	26922.1	26557.8	26635.7	229965.0
2018-10-22	CL	Futures	72.53	72.78	71.34	72.28	513770.0
2018-10-22	GC	Futures	1559.6	1562.2	1549.8	1552.1	187230.0
2018-10-22	ZN	Futures	117.502993	117.658626	117.409613	117.534119	1410808.0
2018-10-22	A6	Futures	0.73302	0.73354	0.7285	0.72922	81872.0
2018-10-22	AD	Futures	0.77213	0.77385	0.77112	0.77249	54926.0
2018-10-22	B	Futures	58.86	59.08	58.04	58.66	269911.0
2018-10-22	B6	Futures	1.3468	1.3496	1.3358	1.3374	97807.0
2018-10-22	BR	Futures	0.20517	0.20662	0.20517	0.20635	53.0
2018-10-22	BTC	Futures	9257.0	9300.3	9177.7	9228.2	1752.0
2018-10-22	BZ	Futures	58.4	58.63	57.59	58.22	37080.0
2018-10-22	C	Futures	1488.0	1522.0	1484.0	1520.0	7706.0
2018-10-22	CB	Futures	270.666	270.756	269.044	270.366	53.0
2018-10-22	CC	Futures	1518.0	1555.0	1496.0	1550.0	19054.0
2018-10-22	CNH	Futures	6.988	6.999	6.9803	6.9943	571.0
2018-10-22	CSC	Futures	3.09	3.09	3.07	3.076	80.0
2018-10-22	CT	Futures	87.38	89.95	87.28	89.82	23655.0
2018-10-22	DC	Futures	25.93	25.93	25.73	25.73	185.0
2018-10-22	DX	Futures	90.614	91.046	90.443	90.96	16460.0
2018-10-22	E1	Futures	1.19568	1.19829	1.19343	1.1958	18166.0
2018-10-22	E6	Futures	1.286	1.28979	1.27922	1.2805	165811.0
2018-10-22	E7	Futures	1.2796	1.2835	1.273	1.2742	3170.0
2018-10-22	EBM	Futures	208.98	209.76	208.2	208.2	14054.0
2018-10-22	ED	Futures	94.9597	94.989	94.9597	94.9841	369117.0
2018-10-22	ER	Futures	98.377	98.381	98.377	98.377	45147.0
2018-10-22	EW	Futures	1967.4	1979.2	1957.4	1960.5	17173.0
2018-10-22	FBON	Futures	126.47	126.59	125.82	125.9	1538.0
2018-10-22	FBTP	Futures	104.6	105.67	103.71	104.02	164429.0
2018-10-22	FBTS	Futures	102.04	102.443	101.656	101.872	95424.0
2018-10-22	FCE	Futures	4571.2	4596.7	4517.0	4521.9	81751.0
2018-10-22	FDAX	Futures	12171.5	12270.8	12074.7	12111.0	112385.0
2018-10-22	FDXM	Futures	11963.8	12058.8	11866.7	11901.3	48923.0
2018-10-22	FESX	Futures	2699.9	2715.9	2666.3	2673.1	1018159.0
2018-10-22	FGBL	Futures	152.23	152.66	152.01	152.49	655438.0
2018-10-22	FGBM	Futures	130.71	130.83	130.59	130.76	402724.0
2018-10-22	FGBS	Futures	112.648	112.663	112.608	112.643	357173.0
2018-10-22	FGBX	Futures	176.02	177.13	175.6	176.81	42247.0
2018-10-22	FMWO	Futures	6896.4	6896.4	6819.9	6846.6	1204.0
2018-10-22	FOAT	Futures	139.71	139.76	139.44	139.68	128575.0
2018-10-22	FTDX	Futures	2622.1	2622.1	2579.4	2591.6	114.0
2018-10-22	FTI	Futures	489.16	491.07	481.98	482.61	29212.0
2018-10-22	FTUK	Futures	6248.3	6334.5	6237.1	6274.6	94323.0
2018-10-22	FVSA	Futures	347.24	350.09	333.92	345.33	34065.0
2018-10-22	FXXP	Futures	312.7	314.4	310.2	310.9	61125.0
2018-10-22	G	Futures	113.61	114.43	113.6	114.31	238922.0
2018-10-22	GF	Futures	322.913	326.551	322.809	326.291	3496.0
2018-10-22	GSCI	Futures	541.88	544.05	541.31	542.96	91.0
2018-10-22	HE	Futures	70.062	72.378	68.821	71.371	20483.0

> showing 50 of 113 rows — these rows as CSV

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