PREVIEW / futures_daily / 2017-06-09

all futures daily files

  file:    by_date/futures_daily/2017/2017-06-09.parquet
  size:    9 KB
  rows:    110

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
2017-06-09	ES	Futures	2636.1	2656.19	2622.52	2639.63	1588107.0
2017-06-09	NQ	Futures	6916.57	6947.49	6666.58	6761.1	425289.0
2017-06-09	YM	Futures	22305.2	22476.1	22292.5	22423.4	121235.0
2017-06-09	CL	Futures	47.35	47.83	46.89	47.47	735933.0
2017-06-09	GC	Futures	1638.5	1639.9	1617.0	1623.0	219214.0
2017-06-09	ZN	Futures	124.673284	124.781013	124.257758	124.519385	1089893.0
2017-06-09	A6	Futures	0.77362	0.77445	0.77188	0.7728	63285.0
2017-06-09	AD	Futures	0.75467	0.75998	0.75391	0.75717	89593.0
2017-06-09	ALI	Futures	2504.93	2504.93	2504.93	2504.93	0.0
2017-06-09	B	Futures	34.0	34.54	33.72	34.25	285815.0
2017-06-09	B6	Futures	1.3362	1.3453	1.3249	1.3347	311481.0
2017-06-09	BR	Futures	0.22312	0.22312	0.22208	0.22208	12.0
2017-06-09	BZ	Futures	33.94	34.38	33.6	34.11	29536.0
2017-06-09	C	Futures	1578.0	1629.0	1558.0	1624.0	17895.0
2017-06-09	CB	Futures	311.222	311.405	310.797	310.797	11.0
2017-06-09	CC	Futures	1519.0	1554.0	1495.0	1547.0	38922.0
2017-06-09	CNH	Futures	7.0717	7.0779	7.0703	7.0703	35.0
2017-06-09	CSC	Futures	3.592	3.598	3.592	3.596	21.0
2017-06-09	CT	Futures	84.7	84.71	83.67	83.83	20788.0
2017-06-09	DC	Futures	30.03	30.12	29.98	30.07	130.0
2017-06-09	DX	Futures	90.614	90.809	90.488	90.594	29762.0
2017-06-09	E1	Futures	1.27727	1.27777	1.27085	1.27579	24106.0
2017-06-09	E6	Futures	1.29101	1.29239	1.28669	1.29032	197853.0
2017-06-09	E7	Futures	1.2844	1.2858	1.2802	1.2837	4219.0
2017-06-09	EBM	Futures	188.73	189.84	187.34	188.73	12340.0
2017-06-09	ED	Futures	95.5833	95.5857	95.5663	95.5736	205528.0
2017-06-09	ER	Futures	98.337	98.342	98.332	98.337	44197.0
2017-06-09	EW	Futures	1857.1	1879.0	1851.8	1867.4	27155.0
2017-06-09	FBON	Futures	124.41	124.9	124.35	124.59	212.0
2017-06-09	FBTP	Futures	107.47	108.2	107.19	107.92	168756.0
2017-06-09	FBTS	Futures	102.608	102.754	102.562	102.699	62001.0
2017-06-09	FCE	Futures	4728.6	4778.0	4723.6	4754.2	150292.0
2017-06-09	FDAX	Futures	13431.8	13541.6	13405.9	13516.2	87823.0
2017-06-09	FDXM	Futures	13305.4	13404.8	13305.4	13388.1	200.0
2017-06-09	FESX	Futures	2898.5	2927.9	2896.1	2914.0	545228.0
2017-06-09	FEU3	Futures	99.011	99.011	99.011	99.011	18.0
2017-06-09	FGBL	Futures	150.02	150.06	149.66	149.77	498843.0
2017-06-09	FGBM	Futures	129.91	129.95	129.84	129.89	331040.0
2017-06-09	FGBS	Futures	112.407	112.417	112.392	112.397	163762.0
2017-06-09	FGBX	Futures	170.08	170.45	168.75	168.99	38445.0
2017-06-09	FMWO	Futures	6483.2	6504.9	6460.3	6502.4	5019.0
2017-06-09	FOAT	Futures	136.74	137.02	136.62	136.65	122685.0
2017-06-09	FTDX	Futures	2264.1	2265.6	2182.2	2262.1	158.0
2017-06-09	FTI	Futures	480.66	484.14	479.83	483.55	36241.0
2017-06-09	FTUK	Futures	6328.4	6457.2	6328.4	6438.4	234763.0
2017-06-09	FVSA	Futures	482.5	501.12	468.96	472.34	21460.0
2017-06-09	FXXP	Futures	327.9	329.6	327.1	329.1	72476.0
2017-06-09	G	Futures	116.09	116.55	115.78	116.36	194096.0
2017-06-09	GF	Futures	338.443	340.254	334.875	338.443	3815.0
2017-06-09	GSCI	Futures	452.42	454.39	452.42	453.4	2683.0

> showing 50 of 110 rows — these rows as CSV

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