PREVIEW / futures_daily / 2018-03-09

all futures daily files

  file:    by_date/futures_daily/2018/2018-03-09.parquet
  size:    9 KB
  rows:    109

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-03-09	ES	Futures	2974.24	3029.13	2967.18	3025.87	1541679.0
2018-03-09	NQ	Futures	8165.46	8319.77	8154.92	8313.33	225672.0
2018-03-09	YM	Futures	26237.6	26730.1	26197.5	26718.5	153047.0
2018-03-09	CL	Futures	60.7	62.62	60.57	62.48	659722.0
2018-03-09	GC	Futures	1689.5	1693.6	1677.4	1691.2	345316.0
2018-03-09	ZN	Futures	119.307522	119.354048	118.935316	119.136928	1348496.0
2018-03-09	A6	Futures	0.801	0.808	0.79987	0.80728	113812.0
2018-03-09	AD	Futures	0.78772	0.79269	0.78655	0.79122	91198.0
2018-03-09	B	Futures	46.14	47.37	45.97	47.27	286492.0
2018-03-09	B6	Futures	1.4368	1.4449	1.4343	1.4407	123820.0
2018-03-09	BTC	Futures	12970.2	13102.0	11638.5	12505.5	2742.0
2018-03-09	BZ	Futures	45.52	46.78	45.41	46.69	33619.0
2018-03-09	C	Futures	1657.0	1673.0	1620.0	1620.0	4004.0
2018-03-09	CB	Futures	281.679	281.957	281.679	281.679	19.0
2018-03-09	CC	Futures	1841.0	1863.0	1793.0	1809.0	29087.0
2018-03-09	CNH	Futures	6.4752	6.4752	6.4506	6.4506	57.0
2018-03-09	CSC	Futures	3.327	3.327	3.302	3.314	12.0
2018-03-09	CT	Futures	97.64	98.34	96.82	97.15	15189.0
2018-03-09	DC	Futures	26.33	26.33	26.19	26.3	40.0
2018-03-09	DX	Futures	84.683	84.862	84.486	84.58	25546.0
2018-03-09	E1	Futures	1.27692	1.28008	1.27389	1.27728	24409.0
2018-03-09	E6	Futures	1.3964	1.39895	1.39198	1.39674	240854.0
2018-03-09	E7	Futures	1.3897	1.3918	1.385	1.3898	2908.0
2018-03-09	EBM	Futures	176.13	176.4	175.32	175.32	10575.0
2018-03-09	ED	Futures	95.0445	95.0518	95.03	95.0324	269079.0
2018-03-09	ER	Futures	98.337	98.342	98.337	98.337	21610.0
2018-03-09	EW	Futures	2034.7	2068.3	2030.5	2067.8	34735.0
2018-03-09	FBON	Futures	127.84	127.86	127.56	127.58	42.0
2018-03-09	FBTP	Futures	113.39	113.45	113.13	113.28	77573.0
2018-03-09	FBTS	Futures	103.871	103.89	103.853	103.871	31577.0
2018-03-09	FCE	Futures	4641.7	4674.8	4628.4	4658.0	70995.0
2018-03-09	FDAX	Futures	12825.2	12874.5	12741.2	12789.5	90024.0
2018-03-09	FDXM	Futures	12844.9	12895.9	12762.8	12811.2	30768.0
2018-03-09	FESX	Futures	2789.8	2806.1	2779.2	2790.6	1380794.0
2018-03-09	FEU3	Futures	99.011	99.016	99.011	99.016	507.0
2018-03-09	FGBL	Futures	147.88	147.98	147.63	147.72	528974.0
2018-03-09	FGBM	Futures	128.87	128.91	128.77	128.8	358094.0
2018-03-09	FGBS	Futures	112.422	112.437	112.407	112.417	180638.0
2018-03-09	FGBX	Futures	166.79	166.99	166.0	166.15	34438.0
2018-03-09	FMWO	Futures	7006.4	7093.9	7005.2	7076.4	4412.0
2018-03-09	FOAT	Futures	137.22	137.28	136.93	136.97	78121.0
2018-03-09	FTDX	Futures	2655.1	2690.0	2653.1	2679.5	180.0
2018-03-09	FTI	Futures	491.57	494.1	490.47	493.13	23189.0
2018-03-09	FTUK	Futures	6294.2	6323.9	6277.6	6305.5	253398.0
2018-03-09	FVSA	Futures	413.66	413.66	374.26	382.88	32088.0
2018-03-09	FXXP	Futures	320.6	323.3	320.5	322.3	85696.0
2018-03-09	G	Futures	112.87	113.02	112.74	112.84	135075.0
2018-03-09	GF	Futures	313.255	314.188	309.686	312.98	1734.0
2018-03-09	GSCI	Futures	500.47	505.24	500.29	505.24	2720.0
2018-03-09	HE	Futures	86.996	87.702	86.033	87.124	28945.0

> showing 50 of 109 rows — these rows as CSV

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