PREVIEW / futures_daily / 2018-09-26

all futures daily files

  file:    by_date/futures_daily/2018/2018-09-26.parquet
  size:    10 KB
  rows:    116

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-26	ES	Futures	3169.48	3184.13	3153.22	3157.55	1308995.0
2018-09-26	NQ	Futures	8825.27	8906.58	8801.46	8816.27	405833.0
2018-09-26	YM	Futures	27930.9	28039.4	27767.7	27820.4	152942.0
2018-09-26	CL	Futures	75.46	75.77	74.82	74.92	464463.0
2018-09-26	GC	Futures	1527.9	1529.6	1514.1	1519.8	343475.0
2018-09-26	ZN	Futures	117.969892	118.390101	117.969892	118.265595	1538450.0
2018-09-26	A6	Futures	0.7464	0.75309	0.74537	0.74897	116045.0
2018-09-26	AD	Futures	0.78199	0.78235	0.77754	0.77891	71108.0
2018-09-26	B	Futures	59.47	59.93	59.16	59.36	283100.0
2018-09-26	B6	Futures	1.3607	1.3644	1.3561	1.3608	92239.0
2018-09-26	BFX	Futures	4346.1	4347.3	4346.1	4347.3	1.0
2018-09-26	BR	Futures	0.18578	0.18822	0.18552	0.18822	1889.0
2018-09-26	BTC	Futures	9199.3	9415.8	9184.9	9343.6	640.0
2018-09-26	BZ	Futures	59.07	59.47	58.72	58.92	28224.0
2018-09-26	C	Futures	1448.0	1450.0	1423.0	1425.0	7898.0
2018-09-26	CB	Futures	275.262	275.713	275.262	275.713	2.0
2018-09-26	CC	Futures	1532.0	1545.0	1499.0	1502.0	20504.0
2018-09-26	CNH	Futures	6.9299	6.9454	6.9287	6.9384	232.0
2018-09-26	CSC	Futures	3.25	3.272	3.25	3.258	26.0
2018-09-26	CT	Futures	88.67	89.35	88.02	88.17	11997.0
2018-09-26	DC	Futures	27.04	27.15	26.98	27.06	46.0
2018-09-26	DX	Futures	89.07	89.298	88.842	89.083	21089.0
2018-09-26	E1	Futures	1.23716	1.2406	1.23064	1.23716	31047.0
2018-09-26	E6	Futures	1.31675	1.32031	1.31208	1.31608	264250.0
2018-09-26	E7	Futures	1.3104	1.3137	1.3056	1.3096	5001.0
2018-09-26	EBM	Futures	209.76	210.79	208.46	209.24	16180.0
2018-09-26	ED	Futures	95.0476	95.0622	95.0427	95.0525	310997.0
2018-09-26	ER	Futures	98.377	98.377	98.372	98.377	35462.0
2018-09-26	EW	Futures	2142.9	2147.7	2118.5	2120.8	16736.0
2018-09-26	FBON	Futures	127.76	127.97	127.7	127.91	213.0
2018-09-26	FBTP	Futures	108.83	109.71	108.64	109.35	85057.0
2018-09-26	FBTS	Futures	103.117	103.445	103.061	103.333	64026.0
2018-09-26	FCE	Futures	4939.2	4973.9	4929.3	4966.3	55398.0
2018-09-26	FDAX	Futures	13035.8	13045.8	12949.1	13014.3	65572.0
2018-09-26	FDXM	Futures	12811.1	12819.4	12725.3	12788.9	25257.0
2018-09-26	FESX	Futures	2866.3	2876.3	2857.9	2873.8	683130.0
2018-09-26	FEU3	Futures	99.001	99.001	99.001	99.001	198.0
2018-09-26	FGBL	Futures	151.13	151.68	151.1	151.25	518127.0
2018-09-26	FGBM	Futures	130.06	130.29	130.03	130.1	414861.0
2018-09-26	FGBS	Futures	112.452	112.492	112.442	112.452	291666.0
2018-09-26	FGBX	Futures	173.25	174.69	173.25	173.72	38838.0
2018-09-26	FMWO	Futures	7320.5	7329.7	7292.7	7328.6	734.0
2018-09-26	FOAT	Futures	139.19	139.41	139.17	139.28	106690.0
2018-09-26	FTDX	Futures	2804.3	2808.7	2783.2	2797.4	316.0
2018-09-26	FTI	Futures	513.15	513.29	510.41	512.46	15539.0
2018-09-26	FTUK	Futures	6648.2	6689.8	6648.2	6680.8	82977.0
2018-09-26	FVSA	Futures	249.31	252.76	245.86	246.72	24018.0
2018-09-26	FXXP	Futures	331.8	332.5	330.8	332.3	29850.0
2018-09-26	G	Futures	113.3	113.68	113.27	113.59	227988.0
2018-09-26	GF	Futures	325.771	329.464	324.731	329.308	3223.0

> showing 50 of 116 rows — these rows as CSV

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