PREVIEW / futures_daily / 2018-01-25

all futures daily files

  file:    by_date/futures_daily/2018/2018-01-25.parquet
  size:    10 KB
  rows:    112

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-01-25	ES	Futures	3086.74	3101.68	3076.68	3088.09	1439217.0
2018-01-25	NQ	Futures	8120.37	8183.32	8083.48	8118.03	415464.0
2018-01-25	YM	Futures	27699.2	27880.6	27641.2	27816.3	222390.0
2018-01-25	CL	Futures	65.86	66.64	65.06	65.49	771758.0
2018-01-25	GC	Futures	1720.4	1731.0	1700.1	1727.9	537659.0
2018-01-25	ZN	Futures	120.694812	120.910779	120.41714	120.879927	1766131.0
2018-01-25	A6	Futures	0.82908	0.83505	0.82394	0.82507	184014.0
2018-01-25	AD	Futures	0.823	0.82706	0.8198	0.82158	116032.0
2018-01-25	B	Futures	50.61	50.79	49.91	50.21	277003.0
2018-01-25	B6	Futures	1.4832	1.4946	1.4672	1.4712	271901.0
2018-01-25	BFX	Futures	4944.1	4944.1	4935.1	4935.1	1.0
2018-01-25	BR	Futures	0.24194	0.24292	0.23989	0.24171	1377.0
2018-01-25	BTC	Futures	14899.1	15172.4	14092.4	14573.8	380.0
2018-01-25	BZ	Futures	49.67	50.12	49.29	49.55	15624.0
2018-01-25	C	Futures	1239.0	1250.0	1233.0	1240.0	11546.0
2018-01-25	CB	Futures	269.016	269.016	267.904	267.966	47.0
2018-01-25	CC	Futures	1457.0	1485.0	1450.0	1462.0	18916.0
2018-01-25	CNH	Futures	6.501	6.501	6.4507	6.4753	129.0
2018-01-25	CSC	Futures	3.125	3.137	3.11	3.12	60.0
2018-01-25	CT	Futures	96.1	96.77	95.5	95.63	18011.0
2018-01-25	DC	Futures	24.98	24.98	24.74	24.85	115.0
2018-01-25	DX	Futures	83.669	83.97	82.88	83.793	77360.0
2018-01-25	E1	Futures	1.28845	1.31152	1.28675	1.29258	74453.0
2018-01-25	E6	Futures	1.41023	1.42576	1.40598	1.40892	557530.0
2018-01-25	E7	Futures	1.4036	1.4185	1.399	1.4018	16777.0
2018-01-25	EBM	Futures	168.57	169.11	167.77	168.84	15436.0
2018-01-25	ED	Futures	95.3213	95.3262	95.3116	95.3165	172080.0
2018-01-25	ER	Futures	98.337	98.337	98.332	98.337	40619.0
2018-01-25	EW	Futures	2107.6	2119.2	2098.4	2107.5	13921.0
2018-01-25	FBON	Futures	127.7	127.76	126.61	126.93	1394.0
2018-01-25	FBTP	Futures	112.19	112.53	111.33	111.6	150743.0
2018-01-25	FBTS	Futures	103.677	103.723	103.613	103.659	50894.0
2018-01-25	FCE	Futures	4896.0	4925.8	4861.2	4884.8	102189.0
2018-01-25	FDAX	Futures	13896.4	13946.8	13709.2	13772.5	110382.0
2018-01-25	FDXM	Futures	13927.8	13968.3	13734.5	13795.8	40959.0
2018-01-25	FESX	Futures	2967.9	2983.4	2944.2	2954.8	1099193.0
2018-01-25	FEU3	Futures	99.011	99.011	99.011	99.011	5.0
2018-01-25	FGBL	Futures	148.81	148.98	147.97	148.33	1010494.0
2018-01-25	FGBM	Futures	128.96	129.02	128.53	128.68	960609.0
2018-01-25	FGBS	Futures	112.321	112.331	112.261	112.286	538265.0
2018-01-25	FGBX	Futures	167.12	168.39	166.25	167.16	81259.0
2018-01-25	FMWO	Futures	7360.0	7400.9	7344.8	7370.5	810.0
2018-01-25	FOAT	Futures	137.5	137.72	136.72	137.08	146849.0
2018-01-25	FTDX	Futures	2636.6	2659.1	2621.2	2622.7	732.0
2018-01-25	FTI	Futures	523.63	527.48	521.86	523.54	32678.0
2018-01-25	FTUK	Futures	6635.3	6646.3	6599.1	6601.3	104166.0
2018-01-25	FVSA	Futures	251.21	254.65	243.47	251.21	14289.0
2018-01-25	FXXP	Futures	340.6	341.5	337.7	338.1	38204.0
2018-01-25	G	Futures	113.39	113.54	113.07	113.3	215864.0
2018-01-25	GF	Futures	322.039	323.466	312.761	316.055	6824.0

> showing 50 of 112 rows — these rows as CSV

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