PREVIEW / futures_daily / 2018-04-06

all futures daily files

  file:    by_date/futures_daily/2018/2018-04-06.parquet
  size:    10 KB
  rows:    111

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-04-06	ES	Futures	2895.93	2897.01	2810.56	2833.67	2615117.0
2018-04-06	NQ	Futures	7734.22	7738.03	7500.72	7554.85	631810.0
2018-04-06	YM	Futures	25790.4	25814.6	24965.6	25203.7	426617.0
2018-04-06	CL	Futures	63.97	64.06	62.07	62.32	753262.0
2018-04-06	GC	Futures	1697.6	1709.6	1688.5	1705.8	373574.0
2018-04-06	ZN	Futures	119.66422	120.160494	119.648711	120.113968	1660843.0
2018-04-06	A6	Futures	0.79031	0.79175	0.78743	0.78866	97393.0
2018-04-06	AD	Futures	0.79451	0.79593	0.79173	0.79274	73075.0
2018-04-06	B	Futures	49.49	49.88	48.6	48.78	296092.0
2018-04-06	B6	Futures	1.4541	1.465	1.4524	1.4629	108201.0
2018-04-06	BR	Futures	0.2257	0.2257	0.22456	0.22456	47.0
2018-04-06	BTC	Futures	9600.3	9784.9	9209.7	9415.6	2415.0
2018-04-06	BZ	Futures	49.21	49.23	47.97	48.15	30749.0
2018-04-06	C	Futures	1608.0	1617.0	1569.0	1573.0	9242.0
2018-04-06	CB	Futures	288.165	289.308	288.165	289.308	33.0
2018-04-06	CC	Futures	1853.0	1860.0	1818.0	1821.0	37557.0
2018-04-06	CNH	Futures	6.4085	6.4274	6.4085	6.4158	35.0
2018-04-06	CSC	Futures	3.365	3.375	3.365	3.371	14.0
2018-04-06	CT	Futures	94.26	95.93	94.03	94.88	26500.0
2018-04-06	DC	Futures	26.76	26.99	26.76	26.94	102.0
2018-04-06	DX	Futures	84.948	85.16	84.641	84.676	22625.0
2018-04-06	E1	Futures	1.25729	1.26464	1.25524	1.26355	24414.0
2018-04-06	E6	Futures	1.38598	1.39172	1.38299	1.3911	216056.0
2018-04-06	E7	Futures	1.3786	1.3843	1.3758	1.3837	3205.0
2018-04-06	EBM	Futures	178.54	179.89	178.28	179.35	20686.0
2018-04-06	ED	Futures	94.9889	94.9986	94.9695	94.9889	408960.0
2018-04-06	ER	Futures	98.337	98.342	98.337	98.337	27710.0
2018-04-06	EW	Futures	2004.3	2004.3	1948.1	1963.6	23981.0
2018-04-06	FBON	Futures	130.16	130.19	129.66	130.06	410.0
2018-04-06	FBTP	Futures	115.56	115.7	115.33	115.64	76513.0
2018-04-06	FBTS	Futures	104.278	104.278	104.204	104.232	50626.0
2018-04-06	FCE	Futures	4612.1	4650.5	4587.4	4628.9	77873.0
2018-04-06	FDAX	Futures	12673.2	12778.7	12628.0	12706.5	105878.0
2018-04-06	FDXM	Futures	12566.1	12664.9	12515.6	12593.3	41023.0
2018-04-06	FESX	Futures	2764.0	2784.8	2745.6	2767.3	1072905.0
2018-04-06	FEU3	Futures	99.026	99.026	99.026	99.026	36.0
2018-04-06	FGBL	Futures	149.85	150.16	149.77	150.1	532132.0
2018-04-06	FGBM	Futures	129.68	129.79	129.66	129.77	306172.0
2018-04-06	FGBS	Futures	112.527	112.547	112.522	112.542	180265.0
2018-04-06	FGBX	Futures	170.49	171.22	170.31	171.09	33995.0
2018-04-06	FMWO	Futures	6867.4	6896.6	6769.3	6847.5	543.0
2018-04-06	FOAT	Futures	138.98	139.19	138.88	139.18	101052.0
2018-04-06	FTDX	Futures	2461.8	2479.6	2432.1	2463.3	361.0
2018-04-06	FTI	Futures	491.44	495.71	488.73	493.96	27075.0
2018-04-06	FTUK	Futures	6265.8	6310.0	6221.6	6271.5	108685.0
2018-04-06	FVSA	Futures	423.31	434.01	403.09	419.74	25169.0
2018-04-06	FXXP	Futures	317.5	319.9	316.0	318.0	64050.0
2018-04-06	G	Futures	113.87	114.0	113.72	113.96	173763.0
2018-04-06	GF	Futures	298.17	298.714	293.051	294.739	2562.0
2018-04-06	GSCI	Futures	509.53	509.53	506.5	506.79	1918.0

> showing 50 of 111 rows — these rows as CSV

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