PREVIEW / futures_daily / 2017-07-24

all futures daily files

  file:    by_date/futures_daily/2017/2017-07-24.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-07-24	ES	Futures	2684.18	2685.0	2677.39	2682.82	857750.0
2017-07-24	NQ	Futures	6958.32	7000.05	6941.57	6975.66	195018.0
2017-07-24	YM	Futures	22743.7	22758.5	22668.6	22726.8	77342.0
2017-07-24	CL	Futures	46.93	47.86	46.7	47.67	707910.0
2017-07-24	GC	Futures	1602.7	1607.2	1598.3	1601.2	212881.0
2017-07-24	ZN	Futures	124.380877	124.473216	124.180808	124.257758	581057.0
2017-07-24	A6	Futures	0.81245	0.8179	0.81132	0.81358	78850.0
2017-07-24	AD	Futures	0.81174	0.81535	0.81092	0.81433	64736.0
2017-07-24	ALI	Futures	2531.19	2531.19	2531.19	2531.19	0.0
2017-07-24	B	Futures	33.91	34.48	33.71	34.36	287928.0
2017-07-24	B6	Futures	1.3608	1.3672	1.3596	1.3649	83353.0
2017-07-24	BR	Futures	0.23474	0.23477	0.23381	0.2344	177.0
2017-07-24	BZ	Futures	33.64	34.25	33.5	34.14	25408.0
2017-07-24	C	Futures	1564.0	1580.0	1555.0	1566.0	11050.0
2017-07-24	CB	Futures	321.136	321.136	319.92	319.92	42.0
2017-07-24	CC	Futures	1495.0	1509.0	1483.0	1494.0	21440.0
2017-07-24	CNH	Futures	7.0054	7.0054	6.9941	6.9941	1.0
2017-07-24	CSC	Futures	3.427	3.441	3.406	3.421	116.0
2017-07-24	CT	Futures	80.94	80.94	80.53	80.53	4.0
2017-07-24	DC	Futures	28.66	28.8	28.45	28.54	377.0
2017-07-24	DX	Futures	87.573	87.723	87.447	87.585	13390.0
2017-07-24	E1	Futures	1.30416	1.3049	1.30072	1.30256	26520.0
2017-07-24	E6	Futures	1.34062	1.34257	1.33592	1.33787	165384.0
2017-07-24	E7	Futures	1.3335	1.3353	1.3289	1.3308	2442.0
2017-07-24	EBM	Futures	188.73	188.73	187.62	188.17	13810.0
2017-07-24	ED	Futures	95.5789	95.5838	95.5741	95.5741	75201.0
2017-07-24	ER	Futures	98.337	98.342	98.337	98.342	25312.0
2017-07-24	EW	Futures	1884.1	1888.4	1876.9	1886.6	7022.0
2017-07-24	FBON	Futures	124.65	124.84	124.52	124.59	606.0
2017-07-24	FBTP	Futures	108.57	109.08	108.53	108.86	60020.0
2017-07-24	FBTS	Futures	102.872	102.927	102.872	102.918	23153.0
2017-07-24	FCE	Futures	4607.8	4619.5	4573.2	4603.7	77913.0
2017-07-24	FDAX	Futures	12877.1	12897.1	12775.0	12835.5	83551.0
2017-07-24	FDXM	Futures	12792.6	12815.7	12696.4	12756.5	24975.0
2017-07-24	FESX	Futures	2816.1	2823.4	2795.7	2808.7	824135.0
2017-07-24	FEU3	Futures	99.016	99.016	99.016	99.016	20.0
2017-07-24	FGBL	Futures	147.48	147.78	147.4	147.66	368746.0
2017-07-24	FGBM	Futures	128.78	128.9	128.74	128.86	222915.0
2017-07-24	FGBS	Futures	112.187	112.222	112.172	112.217	190952.0
2017-07-24	FGBX	Futures	164.5	165.17	164.06	164.91	25048.0
2017-07-24	FMWO	Futures	6522.2	6530.5	6513.8	6516.2	170.0
2017-07-24	FOAT	Futures	135.34	135.66	135.28	135.57	72292.0
2017-07-24	FTDX	Futures	2266.7	2266.7	2253.6	2257.1	152.0
2017-07-24	FTI	Futures	479.6	480.99	476.83	479.05	26436.0
2017-07-24	FTUK	Futures	6387.4	6387.4	6300.5	6304.0	144080.0
2017-07-24	FVSA	Futures	459.82	464.26	449.43	455.37	12899.0
2017-07-24	FXXP	Futures	323.0	323.3	320.9	321.3	43464.0
2017-07-24	G	Futures	114.86	115.01	114.74	114.88	100800.0
2017-07-24	GF	Futures	328.4	328.729	325.875	325.875	5085.0
2017-07-24	GSCI	Futures	449.37	451.38	449.37	450.89	91.0

> showing 50 of 110 rows — these rows as CSV

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