PREVIEW / futures_daily / 2018-02-02

all futures daily files

  file:    by_date/futures_daily/2018/2018-02-02.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-02-02	ES	Futures	3072.06	3076.95	2994.62	2996.25	2532442.0
2018-02-02	NQ	Futures	8144.38	8155.51	7908.1	7912.2	642482.0
2018-02-02	YM	Futures	27601.2	27646.5	26797.6	26816.5	353706.0
2018-02-02	CL	Futures	65.97	66.28	64.45	65.43	857572.0
2018-02-02	GC	Futures	1727.2	1728.6	1699.0	1708.2	431414.0
2018-02-02	ZN	Futures	119.553271	119.661255	119.121337	119.198468	2651934.0
2018-02-02	A6	Futures	0.82661	0.82733	0.81417	0.81622	194380.0
2018-02-02	AD	Futures	0.82798	0.82879	0.81666	0.82001	122981.0
2018-02-02	B	Futures	50.23	50.25	48.77	49.21	307134.0
2018-02-02	B6	Futures	1.4862	1.4873	1.4689	1.4719	132157.0
2018-02-02	BFX	Futures	4816.6	4827.3	4816.6	4827.3	5.0
2018-02-02	BR	Futures	0.23852	0.23852	0.23431	0.23533	5691.0
2018-02-02	BTC	Futures	11568.0	11808.7	10084.6	11171.1	2535.0
2018-02-02	BZ	Futures	49.39	49.58	48.13	48.57	27547.0
2018-02-02	C	Futures	1293.0	1333.0	1288.0	1331.0	18864.0
2018-02-02	CB	Futures	265.619	265.711	265.001	265.495	52.0
2018-02-02	CC	Futures	1505.0	1531.0	1495.0	1530.0	23451.0
2018-02-02	CNH	Futures	6.4301	6.4536	6.4235	6.4526	37.0
2018-02-02	CSC	Futures	3.191	3.208	3.184	3.184	99.0
2018-02-02	CT	Futures	91.63	92.06	90.2	90.28	30885.0
2018-02-02	DC	Futures	25.39	25.46	25.0	25.18	251.0
2018-02-02	DX	Futures	83.101	83.838	83.054	83.614	32678.0
2018-02-02	E1	Futures	1.31528	1.31552	1.30436	1.30763	34964.0
2018-02-02	E6	Futures	1.42162	1.42292	1.41045	1.41544	320107.0
2018-02-02	E7	Futures	1.4145	1.4157	1.4034	1.4084	6412.0
2018-02-02	EBM	Futures	168.57	169.92	168.3	169.65	15158.0
2018-02-02	ED	Futures	95.2873	95.2922	95.2728	95.2728	438871.0
2018-02-02	ER	Futures	98.332	98.337	98.332	98.337	46561.0
2018-02-02	EW	Futures	2080.3	2081.5	2027.5	2033.7	25487.0
2018-02-02	FBON	Futures	126.8	126.84	126.35	126.49	668.0
2018-02-02	FBTP	Futures	111.32	111.57	110.71	110.95	132288.0
2018-02-02	FBTS	Futures	103.622	103.659	103.586	103.604	66040.0
2018-02-02	FCE	Futures	4865.2	4871.0	4744.8	4782.3	115151.0
2018-02-02	FDAX	Futures	13465.9	13470.0	13162.9	13255.8	120851.0
2018-02-02	FDIV	Futures	147.77	147.77	147.23	147.23	120.0
2018-02-02	FDXM	Futures	13489.3	13494.5	13184.8	13278.3	46986.0
2018-02-02	FESX	Futures	2920.5	2922.1	2851.1	2876.4	1496397.0
2018-02-02	FEU3	Futures	99.006	99.011	99.006	99.011	107.0
2018-02-02	FGBL	Futures	146.59	146.77	146.16	146.31	1036097.0
2018-02-02	FGBM	Futures	128.15	128.26	128.05	128.12	666730.0
2018-02-02	FGBS	Futures	112.211	112.261	112.206	112.226	461169.0
2018-02-02	FGBX	Futures	164.5	164.96	163.37	163.87	83931.0
2018-02-02	FMWO	Futures	7288.8	7288.8	7158.1	7211.8	2419.0
2018-02-02	FOAT	Futures	135.73	135.91	135.39	135.55	132030.0
2018-02-02	FTDX	Futures	2633.1	2633.1	2569.8	2593.7	286.0
2018-02-02	FTI	Futures	515.4	515.96	505.09	509.69	34645.0
2018-02-02	FTUK	Futures	6485.9	6500.4	6408.2	6451.9	109111.0
2018-02-02	FVSA	Futures	270.99	306.27	267.55	293.36	38419.0
2018-02-02	FXXP	Futures	334.6	334.6	327.2	329.7	48288.0
2018-02-02	G	Futures	112.09	112.11	111.52	111.9	249351.0

> showing 50 of 113 rows — these rows as CSV

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