PREVIEW / futures_daily / 2018-08-01

all futures daily files

  file:    by_date/futures_daily/2018/2018-08-01.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-01	ES	Futures	3067.41	3069.04	3047.05	3052.75	1098291.0
2018-08-01	NQ	Futures	8502.92	8515.46	8442.3	8484.27	370601.0
2018-08-01	YM	Futures	26839.7	26839.7	26602.6	26646.8	142699.0
2018-08-01	CL	Futures	70.8	70.89	69.64	70.0	576561.0
2018-08-01	GC	Futures	1562.3	1563.6	1551.8	1555.9	218458.0
2018-08-01	ZN	Futures	118.748667	118.904056	118.422349	118.515582	1500142.0
2018-08-01	A6	Futures	0.76408	0.76429	0.76018	0.76131	83639.0
2018-08-01	AD	Futures	0.77903	0.7812	0.77776	0.78014	70729.0
2018-08-01	B	Futures	53.99	54.03	52.58	52.77	284022.0
2018-08-01	B6	Futures	1.356	1.3587	1.3536	1.357	85278.0
2018-08-01	BR	Futures	0.20205	0.20342	0.20136	0.20228	3967.0
2018-08-01	BTC	Futures	10962.3	11054.9	10599.0	10748.6	9125.0
2018-08-01	BZ	Futures	54.02	54.04	52.51	52.7	23660.0
2018-08-01	C	Futures	1518.0	1522.0	1456.0	1458.0	16406.0
2018-08-01	CB	Futures	275.221	276.96	275.221	276.96	15.0
2018-08-01	CC	Futures	1545.0	1553.0	1479.0	1484.0	36110.0
2018-08-01	CNH	Futures	6.9025	6.9187	6.8791	6.9105	776.0
2018-08-01	CSC	Futures	3.212	3.23	3.192	3.224	65.0
2018-08-01	CT	Futures	100.52	101.62	99.93	99.93	13.0
2018-08-01	DC	Futures	25.91	26.08	25.65	26.08	373.0
2018-08-01	DX	Futures	89.364	89.515	89.302	89.433	10724.0
2018-08-01	E1	Futures	1.21138	1.2115	1.20755	1.2097	20083.0
2018-08-01	E6	Futures	1.31162	1.31285	1.3081	1.30877	193668.0
2018-08-01	E7	Futures	1.3049	1.3062	1.3015	1.3022	2109.0
2018-08-01	EBM	Futures	212.11	217.08	212.11	216.82	14611.0
2018-08-01	ED	Futures	95.001	95.0059	94.9961	95.0059	232063.0
2018-08-01	ER	Futures	98.362	98.367	98.362	98.367	38730.0
2018-08-01	EW	Futures	2106.8	2106.8	2083.4	2097.0	13510.0
2018-08-01	FBON	Futures	128.91	128.91	128.5	128.5	89.0
2018-08-01	FBTP	Futures	107.93	107.93	107.16	107.3	50358.0
2018-08-01	FBTS	Futures	102.781	102.781	102.614	102.679	35323.0
2018-08-01	FCE	Futures	4940.6	4961.2	4917.7	4931.2	61981.0
2018-08-01	FDAX	Futures	13399.1	13413.7	13264.2	13314.4	85912.0
2018-08-01	FDXM	Futures	13226.9	13242.4	13089.6	13144.3	36634.0
2018-08-01	FESX	Futures	2939.9	2946.6	2919.0	2926.5	839836.0
2018-08-01	FEU3	Futures	99.011	99.016	99.011	99.016	109.0
2018-08-01	FGBL	Futures	152.1	152.13	151.57	151.62	691141.0
2018-08-01	FGBM	Futures	130.63	130.63	130.42	130.46	428903.0
2018-08-01	FGBS	Futures	112.583	112.583	112.532	112.542	368604.0
2018-08-01	FGBX	Futures	175.53	175.53	173.93	174.11	41139.0
2018-08-01	FMWO	Futures	7181.2	7181.2	7148.6	7163.8	1484.0
2018-08-01	FOAT	Futures	140.22	140.22	139.62	139.68	155709.0
2018-08-01	FTDX	Futures	2842.1	2862.2	2836.3	2839.2	417.0
2018-08-01	FTI	Futures	527.12	529.06	525.5	526.7	24177.0
2018-08-01	FTUK	Futures	6849.5	6858.0	6745.2	6761.3	125869.0
2018-08-01	FVSA	Futures	261.78	269.42	259.87	266.56	15094.0
2018-08-01	FXXP	Futures	337.8	338.6	335.3	336.0	49561.0
2018-08-01	G	Futures	114.99	114.99	114.54	114.58	222826.0
2018-08-01	GF	Futures	310.011	315.5	308.612	314.516	3060.0
2018-08-01	GSCI	Futures	517.5	517.73	515.75	515.98	50.0

> showing 50 of 115 rows — these rows as CSV

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