PREVIEW / futures_daily / 2017-08-08

all futures daily files

  file:    by_date/futures_daily/2017/2017-08-08.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-08-08	ES	Futures	2692.6	2704.56	2681.73	2687.44	1367671.0
2017-08-08	NQ	Futures	6976.84	7021.21	6944.51	6956.85	305079.0
2017-08-08	YM	Futures	23326.1	23395.9	23265.9	23288.1	108182.0
2017-08-08	CL	Futures	50.72	51.22	50.26	50.58	924240.0
2017-08-08	GC	Futures	1606.9	1617.2	1599.5	1606.5	247543.0
2017-08-08	ZN	Futures	124.273148	124.334707	124.01152	124.119249	913666.0
2017-08-08	A6	Futures	0.81256	0.81543	0.80989	0.81245	82257.0
2017-08-08	AD	Futures	0.80253	0.80446	0.80096	0.80345	59912.0
2017-08-08	ALI	Futures	2662.78	2662.78	2662.78	2662.78	0.0
2017-08-08	B	Futures	36.54	36.88	36.25	36.47	235160.0
2017-08-08	B6	Futures	1.3643	1.366	1.3553	1.3591	88184.0
2017-08-08	BFX	Futures	4778.5	4785.1	4778.5	4785.1	1.0
2017-08-08	BR	Futures	0.23674	0.23685	0.23566	0.23678	924.0
2017-08-08	BZ	Futures	36.23	36.57	35.94	36.16	24795.0
2017-08-08	C	Futures	1587.0	1620.0	1586.0	1588.0	10221.0
2017-08-08	CB	Futures	325.303	326.002	322.657	324.786	34.0
2017-08-08	CC	Futures	1511.0	1542.0	1501.0	1506.0	27401.0
2017-08-08	CNH	Futures	6.9426	6.9481	6.9393	6.9425	56.0
2017-08-08	CSC	Futures	3.468	3.472	3.443	3.458	85.0
2017-08-08	CT	Futures	83.31	83.96	82.42	83.93	75.0
2017-08-08	DC	Futures	28.94	28.94	28.66	28.73	451.0
2017-08-08	DX	Futures	87.106	87.559	86.952	87.321	20298.0
2017-08-08	E1	Futures	1.26511	1.26805	1.25983	1.26265	21535.0
2017-08-08	E6	Futures	1.35442	1.35752	1.34503	1.34938	187291.0
2017-08-08	E7	Futures	1.3473	1.3503	1.3379	1.3423	3613.0
2017-08-08	EBM	Futures	181.22	181.49	179.82	180.1	6791.0
2017-08-08	ED	Futures	95.5983	95.5983	95.5886	95.5935	114900.0
2017-08-08	ER	Futures	98.342	98.342	98.337	98.337	17439.0
2017-08-08	EW	Futures	1860.0	1871.9	1852.2	1855.6	18394.0
2017-08-08	FBON	Futures	124.86	125.05	124.86	124.91	157.0
2017-08-08	FBTP	Futures	109.45	109.71	109.35	109.38	43016.0
2017-08-08	FBTS	Futures	102.991	103.009	102.982	102.991	18503.0
2017-08-08	FCE	Futures	4662.1	4698.5	4655.4	4687.3	54998.0
2017-08-08	FDAX	Futures	12877.7	12977.7	12818.2	12936.6	69202.0
2017-08-08	FDXM	Futures	12797.9	12898.3	12740.3	12857.0	22364.0
2017-08-08	FESX	Futures	2853.6	2875.7	2848.7	2866.7	648340.0
2017-08-08	FEU3	Futures	99.016	99.016	99.011	99.011	10.0
2017-08-08	FGBL	Futures	148.37	148.46	148.1	148.19	338952.0
2017-08-08	FGBM	Futures	129.18	129.21	129.08	129.11	206506.0
2017-08-08	FGBS	Futures	112.282	112.292	112.257	112.267	119462.0
2017-08-08	FGBX	Futures	167.01	167.11	166.2	166.4	27448.0
2017-08-08	FMWO	Futures	6584.1	6587.7	6566.2	6584.1	357.0
2017-08-08	FOAT	Futures	135.82	135.91	135.6	135.66	80866.0
2017-08-08	FTDX	Futures	2280.7	2289.2	2274.7	2282.2	118.0
2017-08-08	FTI	Futures	489.87	491.71	488.8	491.02	19940.0
2017-08-08	FTUK	Futures	6464.7	6478.6	6437.9	6469.9	69572.0
2017-08-08	FVSA	Futures	418.28	424.22	400.48	403.45	29761.0
2017-08-08	FXXP	Futures	323.9	325.6	323.5	325.0	17277.0
2017-08-08	G	Futures	115.37	115.39	115.14	115.21	110046.0
2017-08-08	GF	Futures	321.046	323.076	318.412	320.552	2514.0

> showing 50 of 110 rows — these rows as CSV

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