PREVIEW / futures_daily / 2018-09-24

all futures daily files

  file:    by_date/futures_daily/2018/2018-09-24.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-09-24	ES	Futures	3177.08	3177.89	3164.33	3172.74	1162107.0
2018-09-24	NQ	Futures	8757.61	8820.63	8680.95	8811.33	390762.0
2018-09-24	YM	Futures	28125.7	28157.3	27986.7	28021.5	148656.0
2018-09-24	CL	Futures	74.47	76.15	74.47	75.45	576894.0
2018-09-24	GC	Futures	1526.0	1532.1	1519.1	1526.5	214291.0
2018-09-24	ZN	Futures	118.234468	118.250032	118.001019	118.156652	1188674.0
2018-09-24	A6	Futures	0.74794	0.74949	0.7464	0.74702	65803.0
2018-09-24	AD	Futures	0.78386	0.78452	0.78169	0.78265	49362.0
2018-09-24	B	Futures	57.56	59.39	57.56	59.18	243314.0
2018-09-24	B6	Futures	1.3507	1.3593	1.3485	1.3542	89659.0
2018-09-24	BR	Futures	0.18788	0.18788	0.18502	0.18502	58.0
2018-09-24	BTC	Futures	9639.4	9682.7	9487.9	9538.4	609.0
2018-09-24	BZ	Futures	57.41	59.13	57.41	58.93	21939.0
2018-09-24	C	Futures	1445.0	1486.0	1437.0	1479.0	11515.0
2018-09-24	CB	Futures	269.945	271.237	269.945	271.237	4.0
2018-09-24	CC	Futures	1508.0	1577.0	1506.0	1561.0	26404.0
2018-09-24	CNH	Futures	6.9251	6.9404	6.9251	6.9295	630.0
2018-09-24	CSC	Futures	3.266	3.274	3.258	3.26	20.0
2018-09-24	CT	Futures	88.96	89.01	87.91	88.2	11144.0
2018-09-24	DC	Futures	27.03	27.16	26.98	27.15	154.0
2018-09-24	DX	Futures	89.104	89.251	88.743	89.085	16814.0
2018-09-24	E1	Futures	1.24629	1.24665	1.2374	1.23965	22010.0
2018-09-24	E6	Futures	1.31441	1.32231	1.31213	1.31597	225120.0
2018-09-24	E7	Futures	1.3082	1.3158	1.3057	1.3095	4415.0
2018-09-24	EBM	Futures	209.76	211.57	209.5	211.05	22150.0
2018-09-24	ED	Futures	95.0573	95.072	95.0525	95.0671	461506.0
2018-09-24	ER	Futures	98.372	98.377	98.372	98.372	37185.0
2018-09-24	EW	Futures	2148.3	2151.6	2132.0	2143.2	13625.0
2018-09-24	FBON	Futures	128.13	128.18	127.67	127.75	511.0
2018-09-24	FBTP	Futures	109.25	109.33	108.22	108.4	68849.0
2018-09-24	FBTS	Futures	103.211	103.295	102.949	103.005	45330.0
2018-09-24	FCE	Futures	4930.7	4937.9	4914.4	4926.6	53860.0
2018-09-24	FDAX	Futures	12996.9	13034.3	12960.1	12977.0	66415.0
2018-09-24	FDIV	Futures	147.78	147.83	147.78	147.83	3.0
2018-09-24	FDXM	Futures	12773.9	12809.0	12736.7	12752.2	26510.0
2018-09-24	FESX	Futures	2858.7	2862.1	2846.1	2849.5	632778.0
2018-09-24	FGBL	Futures	152.2	152.3	151.41	151.52	745994.0
2018-09-24	FGBM	Futures	130.58	130.62	130.18	130.23	492711.0
2018-09-24	FGBS	Futures	112.537	112.542	112.462	112.482	470867.0
2018-09-24	FGBX	Futures	175.09	175.31	173.58	174.18	50281.0
2018-09-24	FMWO	Futures	7306.6	7315.8	7292.7	7303.1	983.0
2018-09-24	FOAT	Futures	140.08	140.1	139.36	139.44	130942.0
2018-09-24	FTDX	Futures	2759.1	2762.1	2751.7	2755.2	200.0
2018-09-24	FTI	Futures	508.79	510.6	507.82	508.7	16436.0
2018-09-24	FTUK	Futures	6632.1	6657.6	6623.6	6635.7	77362.0
2018-09-24	FVSA	Futures	253.62	258.8	252.76	255.35	24616.0
2018-09-24	FXXP	Futures	330.9	331.3	329.2	329.6	31062.0
2018-09-24	G	Futures	114.03	114.05	113.4	113.5	253887.0
2018-09-24	GF	Futures	327.123	328.06	324.367	325.147	4286.0
2018-09-24	GSCI	Futures	536.67	538.97	536.67	538.07	7.0

> showing 50 of 115 rows — these rows as CSV

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