PREVIEW / futures_daily / 2018-05-24

all futures daily files

  file:    by_date/futures_daily/2018/2018-05-24.parquet
  size:    10 KB
  rows:    112

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-24	ES	Futures	2968.52	2972.32	2942.42	2966.07	1277264.0
2018-05-24	NQ	Futures	8142.41	8163.77	8058.73	8143.0	379490.0
2018-05-24	YM	Futures	26176.0	26196.0	25896.8	26127.5	204225.0
2018-05-24	CL	Futures	72.3	72.47	70.98	71.17	640725.0
2018-05-24	GC	Futures	1651.1	1667.9	1649.7	1665.3	432419.0
2018-05-24	ZN	Futures	118.516584	118.811248	118.392516	118.609636	3791797.0
2018-05-24	A6	Futures	0.77818	0.77982	0.77561	0.77931	102328.0
2018-05-24	AD	Futures	0.78829	0.789	0.78343	0.78546	78785.0
2018-05-24	B	Futures	58.37	58.47	57.58	57.74	228579.0
2018-05-24	B6	Futures	1.3841	1.3913	1.3838	1.3875	145550.0
2018-05-24	BR	Futures	0.20967	0.2105	0.20833	0.20871	5075.0
2018-05-24	BTC	Futures	10658.5	10985.4	10338.7	10800.6	713.0
2018-05-24	BZ	Futures	57.82	57.91	56.99	57.15	25431.0
2018-05-24	C	Futures	1711.0	1715.0	1692.0	1697.0	6625.0
2018-05-24	CB	Futures	297.439	303.586	297.439	302.206	5.0
2018-05-24	CC	Futures	1915.0	1926.0	1893.0	1898.0	15836.0
2018-05-24	CNH	Futures	6.4732	6.4839	6.4695	6.4695	167.0
2018-05-24	CSC	Futures	3.488	3.505	3.488	3.492	20.0
2018-05-24	CT	Futures	99.1	99.86	98.49	99.42	20915.0
2018-05-24	DC	Futures	28.27	28.3	28.12	28.21	163.0
2018-05-24	DX	Futures	88.513	88.57	88.225	88.372	22333.0
2018-05-24	E1	Futures	1.21273	1.22044	1.21261	1.21682	26120.0
2018-05-24	E6	Futures	1.32019	1.32571	1.31906	1.32317	308535.0
2018-05-24	E7	Futures	1.313	1.3186	1.312	1.3162	6735.0
2018-05-24	EBM	Futures	188.57	191.19	188.31	188.83	32625.0
2018-05-24	ED	Futures	95.0011	95.0205	94.9986	95.0108	372930.0
2018-05-24	ER	Futures	98.332	98.337	98.328	98.332	47187.0
2018-05-24	EW	Futures	2066.3	2069.9	2049.8	2067.2	11987.0
2018-05-24	FBON	Futures	127.9	128.5	127.83	128.35	1213.0
2018-05-24	FBTP	Futures	110.28	110.77	109.66	109.98	167829.0
2018-05-24	FBTS	Futures	103.409	103.501	103.316	103.381	117423.0
2018-05-24	FCE	Futures	4962.8	4985.3	4915.7	4939.9	84738.0
2018-05-24	FDAX	Futures	13473.3	13515.9	13297.2	13346.6	117034.0
2018-05-24	FDXM	Futures	13354.9	13395.1	13178.8	13227.7	39742.0
2018-05-24	FESX	Futures	2932.2	2948.9	2902.2	2916.4	1130653.0
2018-05-24	FEU3	Futures	99.021	99.021	99.016	99.016	99.0
2018-05-24	FGBL	Futures	150.28	150.84	149.92	150.77	1057541.0
2018-05-24	FGBM	Futures	130.12	130.3	129.93	130.26	603210.0
2018-05-24	FGBS	Futures	112.633	112.653	112.588	112.648	478114.0
2018-05-24	FGBX	Futures	170.26	171.92	169.46	171.73	82157.0
2018-05-24	FMWO	Futures	7058.9	7062.4	7004.0	7021.5	343.0
2018-05-24	FOAT	Futures	138.53	139.17	138.43	139.1	194483.0
2018-05-24	FTDX	Futures	2765.6	2785.9	2758.7	2770.5	311.0
2018-05-24	FTI	Futures	521.71	523.56	516.67	517.78	30204.0
2018-05-24	FTUK	Futures	6877.2	6888.7	6798.6	6822.5	132832.0
2018-05-24	FVSA	Futures	316.83	329.72	307.16	321.12	30426.0
2018-05-24	FXXP	Futures	338.5	339.7	335.6	336.9	53429.0
2018-05-24	G	Futures	113.79	114.24	113.55	114.17	824280.0
2018-05-24	GF	Futures	297.011	299.963	295.82	296.856	6878.0
2018-05-24	GSCI	Futures	553.07	554.19	551.33	551.61	62.0

> showing 50 of 112 rows — these rows as CSV

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