PREVIEW / futures_daily / 2018-03-07

all futures daily files

  file:    by_date/futures_daily/2018/2018-03-07.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
2018-03-07	ES	Futures	2934.57	2967.45	2914.19	2959.84	1870360.0
2018-03-07	NQ	Futures	8031.95	8124.47	7961.97	8109.83	498163.0
2018-03-07	YM	Futures	26005.6	26201.7	25743.0	26149.0	314554.0
2018-03-07	CL	Futures	62.74	63.02	61.01	61.58	879119.0
2018-03-07	GC	Futures	1711.0	1714.2	1689.9	1695.8	305077.0
2018-03-07	ZN	Futures	119.183042	119.522419	119.075058	119.105911	43812.0
2018-03-07	A6	Futures	0.80357	0.80542	0.79936	0.80398	110036.0
2018-03-07	AD	Futures	0.78615	0.78777	0.78107	0.78559	108245.0
2018-03-07	B	Futures	47.08	47.49	46.07	46.44	332906.0
2018-03-07	B6	Futures	1.4458	1.4477	1.4405	1.4459	119223.0
2018-03-07	BTC	Futures	14891.5	15092.6	13018.8	13580.6	1888.0
2018-03-07	BZ	Futures	46.64	46.89	45.51	45.87	36313.0
2018-03-07	C	Futures	1602.0	1611.0	1593.0	1600.0	2781.0
2018-03-07	CB	Futures	286.621	286.621	284.274	285.077	35.0
2018-03-07	CC	Futures	1791.0	1811.0	1779.0	1792.0	29020.0
2018-03-07	CNH	Futures	6.4529	6.453	6.4449	6.4468	60.0
2018-03-07	CSC	Futures	3.331	3.331	3.304	3.31	11.0
2018-03-07	CT	Futures	94.83	96.29	94.0	95.24	22478.0
2018-03-07	DC	Futures	26.33	26.33	26.15	26.19	49.0
2018-03-07	DX	Futures	84.04	84.28	83.89	84.15	23588.0
2018-03-07	E1	Futures	1.2961	1.29841	1.28663	1.2876	28661.0
2018-03-07	E6	Futures	1.40909	1.41272	1.40496	1.40728	205870.0
2018-03-07	E7	Futures	1.402	1.4055	1.398	1.4003	2752.0
2018-03-07	EBM	Futures	176.93	176.93	175.59	176.13	18690.0
2018-03-07	ED	Futures	95.0688	95.0737	95.0518	95.0591	262056.0
2018-03-07	ER	Futures	98.337	98.342	98.337	98.337	13399.0
2018-03-07	EW	Futures	2015.9	2040.9	2002.8	2036.6	22607.0
2018-03-07	FBON	Futures	128.41	128.41	127.12	127.3	868.0
2018-03-07	FBTP	Futures	112.46	112.91	112.38	112.76	160177.0
2018-03-07	FBTS	Futures	103.788	103.871	103.788	103.834	67180.0
2018-03-07	FCE	Futures	4541.4	4597.5	4529.9	4581.6	83955.0
2018-03-07	FDAX	Futures	12448.6	12734.5	12413.9	12698.2	109241.0
2018-03-07	FDXM	Futures	12482.2	12756.6	12436.5	12719.7	42987.0
2018-03-07	FESX	Futures	2717.9	2766.1	2712.2	2758.7	1413587.0
2018-03-07	FGBL	Futures	147.51	147.73	147.36	147.56	936851.0
2018-03-07	FGBM	Futures	128.8	128.85	128.7	128.76	642076.0
2018-03-07	FGBS	Futures	112.402	112.422	112.377	112.387	444253.0
2018-03-07	FGBX	Futures	165.46	166.39	165.05	165.92	85485.0
2018-03-07	FMWO	Futures	6899.0	6979.5	6899.0	6965.5	1610.0
2018-03-07	FOAT	Futures	136.66	137.01	136.64	136.88	151322.0
2018-03-07	FTDX	Futures	2543.4	2658.1	2535.9	2582.3	195.0
2018-03-07	FTI	Futures	481.88	488.4	480.69	487.17	25614.0
2018-03-07	FTUK	Futures	6209.9	6264.5	6178.0	6242.6	104079.0
2018-03-07	FVSA	Futures	453.05	469.06	413.66	438.28	24000.0
2018-03-07	FXXP	Futures	314.0	318.1	313.7	317.3	61620.0
2018-03-07	G	Futures	112.62	113.0	112.59	112.86	194376.0
2018-03-07	GF	Futures	316.878	318.305	315.451	315.725	1777.0
2018-03-07	GSCI	Futures	506.49	508.54	501.43	502.11	2562.0
2018-03-07	HE	Futures	87.413	87.734	85.294	87.06	34019.0
2018-03-07	HG	Futures	3.7536	3.7577	3.709	3.731	92633.0

> showing 50 of 110 rows — these rows as CSV

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