PREVIEW / futures_daily / 2018-08-16

all futures daily files

  file:    by_date/futures_daily/2018/2018-08-16.parquet
  size:    10 KB
  rows:    115

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-08-16	ES	Futures	3065.24	3097.28	3060.08	3089.68	1271529.0
2018-08-16	NQ	Futures	8604.36	8667.9	8584.83	8614.85	348395.0
2018-08-16	YM	Futures	26562.5	26983.0	26497.2	26966.1	170510.0
2018-08-16	CL	Futures	67.03	67.65	66.55	67.58	233783.0
2018-08-16	GC	Futures	1499.4	1507.0	1479.2	1500.6	362108.0
2018-08-16	ZN	Futures	119.665465	119.743159	119.447919	119.603309	1253118.0
2018-08-16	A6	Futures	0.74444	0.74948	0.74197	0.7467	116756.0
2018-08-16	AD	Futures	0.77098	0.77275	0.7692	0.77011	65799.0
2018-08-16	B	Futures	51.5	52.14	51.32	52.07	227201.0
2018-08-16	B6	Futures	1.3111	1.3173	1.3103	1.3127	98992.0
2018-08-16	BR	Futures	0.19496	0.19656	0.19359	0.19473	2731.0
2018-08-16	BTC	Futures	9117.4	9224.3	8811.1	9124.6	4378.0
2018-08-16	BZ	Futures	51.52	52.06	51.25	52.0	18403.0
2018-08-16	C	Futures	1464.0	1484.0	1460.0	1467.0	2112.0
2018-08-16	CB	Futures	281.877	284.246	279.449	280.648	69.0
2018-08-16	CC	Futures	1499.0	1532.0	1499.0	1507.0	18506.0
2018-08-16	CNH	Futures	7.0178	7.0188	6.9384	6.9489	1095.0
2018-08-16	CSC	Futures	3.294	3.294	3.254	3.258	71.0
2018-08-16	CT	Futures	91.56	92.4	91.5	92.15	27.0
2018-08-16	DC	Futures	26.66	26.79	26.36	26.48	307.0
2018-08-16	DX	Futures	91.504	91.552	91.116	91.429	19619.0
2018-08-16	E1	Futures	1.20564	1.20803	1.20086	1.20218	28309.0
2018-08-16	E6	Futures	1.27136	1.27863	1.27041	1.27377	305497.0
2018-08-16	E7	Futures	1.2651	1.2721	1.264	1.2673	3932.0
2018-08-16	EBM	Futures	215.51	218.91	214.99	217.6	17950.0
2018-08-16	ED	Futures	95.0838	95.0862	95.0643	95.0667	273421.0
2018-08-16	ER	Futures	98.367	98.367	98.362	98.367	20445.0
2018-08-16	EW	Futures	2106.0	2130.8	2102.0	2119.9	8707.0
2018-08-16	FBON	Futures	128.97	129.05	128.72	128.83	378.0
2018-08-16	FBTP	Futures	104.13	104.51	103.49	104.28	72886.0
2018-08-16	FBTS	Futures	101.539	101.659	101.335	101.576	37943.0
2018-08-16	FCE	Futures	4800.8	4835.5	4779.7	4818.4	79129.0
2018-08-16	FDAX	Futures	12781.8	12823.1	12712.8	12798.5	68242.0
2018-08-16	FDXM	Futures	12614.9	12659.3	12550.9	12635.0	28560.0
2018-08-16	FESX	Futures	2813.8	2828.0	2801.3	2822.1	864345.0
2018-08-16	FEU3	Futures	99.011	99.016	99.011	99.016	80.0
2018-08-16	FGBL	Futures	153.98	154.22	153.93	154.05	403234.0
2018-08-16	FGBM	Futures	131.47	131.58	131.46	131.51	271653.0
2018-08-16	FGBS	Futures	112.734	112.749	112.718	112.729	175174.0
2018-08-16	FGBX	Futures	179.7	180.4	179.52	179.9	20341.0
2018-08-16	FMWO	Futures	7082.2	7119.5	7065.9	7111.4	3925.0
2018-08-16	FOAT	Futures	141.19	141.34	141.14	141.23	70162.0
2018-08-16	FTDX	Futures	2817.1	2833.8	2812.2	2829.9	209.0
2018-08-16	FTI	Futures	512.73	517.19	512.73	515.52	20339.0
2018-08-16	FTUK	Futures	6661.1	6741.2	6661.1	6731.9	90431.0
2018-08-16	FVSA	Futures	287.43	291.79	276.11	281.34	33103.0
2018-08-16	FXXP	Futures	328.7	330.4	328.1	329.9	43498.0
2018-08-16	G	Futures	115.97	116.2	115.92	116.07	144043.0
2018-08-16	GF	Futures	310.793	313.082	309.753	312.301	4031.0
2018-08-16	GSCI	Futures	503.98	506.23	503.98	505.33	8.0

> showing 50 of 115 rows — these rows as CSV

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