PREVIEW / futures_daily / 2018-08-06

all futures daily files

  file:    by_date/futures_daily/2018/2018-08-06.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-08-06	ES	Futures	3086.15	3099.18	3079.09	3095.38	797324.0
2018-08-06	NQ	Futures	8632.63	8685.68	8613.1	8678.97	250166.0
2018-08-06	YM	Futures	26789.1	26877.6	26706.9	26835.4	96912.0
2018-08-06	CL	Futures	71.03	72.34	70.87	71.4	495605.0
2018-08-06	GC	Futures	1548.8	1553.9	1539.2	1543.3	199536.0
2018-08-06	ZN	Futures	118.950673	119.183757	118.872978	119.074985	905781.0
2018-08-06	A6	Futures	0.76121	0.76182	0.75853	0.76018	64071.0
2018-08-06	AD	Futures	0.78024	0.78039	0.77715	0.77938	40986.0
2018-08-06	B	Futures	53.37	54.29	53.27	53.76	200582.0
2018-08-06	B6	Futures	1.3439	1.344	1.335	1.3375	75626.0
2018-08-06	BR	Futures	0.20616	0.20647	0.20342	0.20388	3101.0
2018-08-06	BTC	Futures	10086.2	10171.6	9787.0	9858.2	5117.0
2018-08-06	BZ	Futures	53.35	54.2	53.24	53.69	20253.0
2018-08-06	C	Futures	1457.0	1510.0	1443.0	1509.0	10666.0
2018-08-06	CB	Futures	278.249	280.378	278.249	279.539	11.0
2018-08-06	CC	Futures	1467.0	1518.0	1467.0	1515.0	29209.0
2018-08-06	CNH	Futures	6.9227	6.9528	6.9025	6.9419	1196.0
2018-08-06	CSC	Futures	3.23	3.23	3.198	3.208	26.0
2018-08-06	CT	Futures	98.59	99.51	98.32	99.51	33.0
2018-08-06	DC	Futures	26.08	26.08	25.8	25.8	282.0
2018-08-06	DX	Futures	90.017	90.306	90.003	90.152	15081.0
2018-08-06	E1	Futures	1.206	1.20624	1.20086	1.20349	21289.0
2018-08-06	E6	Futures	1.29781	1.29792	1.29334	1.2963	205320.0
2018-08-06	E7	Futures	1.2908	1.2914	1.2867	1.2897	2096.0
2018-08-06	EBM	Futures	221.79	225.19	219.96	224.67	10193.0
2018-08-06	ED	Futures	95.0253	95.0302	95.0205	95.0253	149068.0
2018-08-06	ER	Futures	98.362	98.367	98.357	98.362	90630.0
2018-08-06	EW	Futures	2122.0	2131.6	2116.2	2129.3	8599.0
2018-08-06	FBON	Futures	128.9	129.1	128.86	129.07	73.0
2018-08-06	FBTP	Futures	105.91	106.48	105.88	106.16	71015.0
2018-08-06	FBTS	Futures	102.077	102.327	102.077	102.243	33537.0
2018-08-06	FCE	Futures	4928.5	4934.8	4892.1	4911.9	47288.0
2018-08-06	FDAX	Futures	13214.1	13288.3	13095.9	13147.7	88375.0
2018-08-06	FDIV	Futures	150.48	151.46	150.48	150.48	152.0
2018-08-06	FDXM	Futures	13044.2	13117.5	12928.6	12979.7	39847.0
2018-08-06	FESX	Futures	2913.2	2923.2	2896.5	2904.0	639550.0
2018-08-06	FGBL	Futures	152.66	153.01	152.49	152.98	352122.0
2018-08-06	FGBM	Futures	130.84	130.97	130.79	130.95	185119.0
2018-08-06	FGBS	Futures	112.613	112.628	112.608	112.623	133876.0
2018-08-06	FGBX	Futures	176.79	177.64	176.37	177.52	23191.0
2018-08-06	FMWO	Futures	7178.9	7178.9	7154.5	7177.8	1367.0
2018-08-06	FOAT	Futures	140.38	140.63	140.22	140.6	63232.0
2018-08-06	FTDX	Futures	2868.1	2896.6	2866.2	2875.5	317.0
2018-08-06	FTI	Futures	527.35	528.92	526.01	527.9	21898.0
2018-08-06	FTUK	Futures	6777.8	6802.7	6749.7	6771.5	60815.0
2018-08-06	FVSA	Futures	267.51	270.38	261.78	264.65	15573.0
2018-08-06	FXXP	Futures	336.5	336.7	334.4	335.1	36776.0
2018-08-06	G	Futures	115.0	115.46	115.0	115.39	140440.0
2018-08-06	GF	Futures	316.64	316.95	314.413	314.568	2309.0
2018-08-06	GSCI	Futures	523.25	523.25	523.25	523.25	816.0

> showing 50 of 113 rows — these rows as CSV

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