PREVIEW / futures_daily / 2018-08-22

all futures daily files

  file:    by_date/futures_daily/2018/2018-08-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-08-22	ES	Futures	3098.64	3115.2	3091.31	3107.6	996434.0
2018-08-22	NQ	Futures	8597.65	8679.85	8571.71	8666.44	309493.0
2018-08-22	YM	Futures	27114.7	27223.2	27055.7	27097.8	120095.0
2018-08-22	CL	Futures	68.83	70.99	68.73	70.68	581899.0
2018-08-22	GC	Futures	1524.7	1531.5	1519.9	1525.1	234153.0
2018-08-22	ZN	Futures	119.914088	120.085016	119.851932	119.960705	1428199.0
2018-08-22	A6	Futures	0.75761	0.75853	0.75442	0.75555	113559.0
2018-08-22	AD	Futures	0.77715	0.78019	0.77685	0.77903	74683.0
2018-08-22	B	Futures	53.04	54.67	53.0	54.51	300689.0
2018-08-22	B6	Futures	1.3327	1.336	1.3289	1.3335	78872.0
2018-08-22	BR	Futures	0.18715	0.1886	0.18517	0.18727	7088.0
2018-08-22	BTC	Futures	9174.4	9787.0	8903.7	9124.6	5379.0
2018-08-22	BZ	Futures	52.96	54.59	52.91	54.44	19801.0
2018-08-22	C	Futures	1520.0	1549.0	1517.0	1549.0	2487.0
2018-08-22	CB	Futures	269.314	269.344	268.864	269.344	4.0
2018-08-22	CC	Futures	1582.0	1624.0	1575.0	1615.0	17242.0
2018-08-22	CNH	Futures	6.9089	6.9232	6.9056	6.9181	539.0
2018-08-22	CSC	Futures	3.246	3.246	3.218	3.236	75.0
2018-08-22	CT	Futures	93.96	93.96	92.59	92.59	4.0
2018-08-22	DC	Futures	26.18	26.28	26.1	26.23	171.0
2018-08-22	DX	Futures	90.065	90.24	89.814	90.023	17928.0
2018-08-22	E1	Futures	1.2158	1.22094	1.21532	1.21771	31331.0
2018-08-22	E6	Futures	1.29664	1.30229	1.2944	1.29837	248075.0
2018-08-22	E7	Futures	1.29	1.2972	1.2878	1.2918	3493.0
2018-08-22	EBM	Futures	212.37	214.73	209.76	214.47	12515.0
2018-08-22	ED	Futures	95.0862	95.0935	95.0862	95.0886	176045.0
2018-08-22	ER	Futures	98.362	98.367	98.362	98.367	60655.0
2018-08-22	EW	Futures	2149.4	2160.9	2143.7	2155.7	9254.0
2018-08-22	FBON	Futures	129.75	129.78	129.46	129.47	195.0
2018-08-22	FBTP	Futures	105.54	106.02	104.87	105.05	75990.0
2018-08-22	FBTS	Futures	102.058	102.318	101.891	101.993	34310.0
2018-08-22	FCE	Futures	4864.4	4893.7	4863.5	4883.3	46846.0
2018-08-22	FDAX	Futures	12906.2	13001.3	12885.8	12945.4	67666.0
2018-08-22	FDXM	Futures	12741.9	12832.7	12722.2	12780.0	32993.0
2018-08-22	FESX	Futures	2841.4	2863.9	2838.0	2857.2	611373.0
2018-08-22	FGBL	Futures	153.93	154.01	153.51	153.59	597125.0
2018-08-22	FGBM	Futures	131.42	131.48	131.22	131.26	372065.0
2018-08-22	FGBS	Futures	112.703	112.713	112.668	112.673	335275.0
2018-08-22	FGBX	Futures	179.46	179.76	178.6	178.78	30322.0
2018-08-22	FMWO	Futures	7167.3	7192.9	7161.4	7192.9	833.0
2018-08-22	FOAT	Futures	141.29	141.37	140.96	141.02	108683.0
2018-08-22	FTDX	Futures	2874.5	2889.7	2869.1	2879.9	135.0
2018-08-22	FTI	Futures	514.36	519.37	514.26	518.25	17034.0
2018-08-22	FTUK	Futures	6708.7	6771.5	6690.9	6746.1	70122.0
2018-08-22	FVSA	Futures	265.66	268.27	259.56	263.05	29276.0
2018-08-22	FXXP	Futures	330.7	332.8	330.7	332.1	34943.0
2018-08-22	G	Futures	115.85	115.95	115.66	115.7	191536.0
2018-08-22	GF	Futures	313.29	313.29	308.713	310.273	3917.0
2018-08-22	GSCI	Futures	517.39	519.53	516.09	519.08	26.0
2018-08-22	HE	Futures	74.612	74.883	72.31	72.581	22989.0

> showing 50 of 113 rows — these rows as CSV

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