PREVIEW / futures_daily / 2019-09-26

all futures daily files

  file:    by_date/futures_daily/2019/2019-09-26.parquet
  size:    10 KB
  rows:    120

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
2019-09-26	ES	Futures	3232.28	3242.29	3209.0	3226.59	1351351.0
2019-09-26	NQ	Futures	9014.81	9038.15	8913.69	8974.19	489320.0
2019-09-26	YM	Futures	28304.5	28388.4	28115.5	28231.0	184044.0
2019-09-26	CL	Futures	58.2	58.36	56.89	57.91	599653.0
2019-09-26	GC	Futures	1863.8	1874.4	1859.1	1869.1	378285.0
2019-09-26	ZN	Futures	128.752886	129.217418	128.737402	129.109028	1540564.0
2019-09-26	A6	Futures	0.69455	0.69753	0.69383	0.69476	82655.0
2019-09-26	AD	Futures	0.76025	0.76232	0.7596	0.7605	58538.0
2019-09-26	ALI	Futures	2124.21	2124.21	2111.83	2113.34	52.0
2019-09-26	B	Futures	48.77	49.05	47.93	48.91	300139.0
2019-09-26	B6	Futures	1.2604	1.2627	1.2548	1.2572	104378.0
2019-09-26	BR	Futures	0.19501	0.19501	0.19344	0.19344	20.0
2019-09-26	BTC	Futures	12426.6	12484.2	11168.1	11765.0	3517.0
2019-09-26	BZ	Futures	48.08	48.36	47.25	48.23	27982.0
2019-09-26	C	Futures	1691.0	1715.0	1689.0	1712.0	10651.0
2019-09-26	CB	Futures	255.069	256.633	254.773	254.773	6.0
2019-09-26	CC	Futures	1623.0	1649.0	1611.0	1644.0	23694.0
2019-09-26	CNH	Futures	7.1241	7.132	7.1152	7.1202	853.0
2019-09-26	CSC	Futures	3.117	3.117	3.098	3.098	62.0
2019-09-26	CT	Futures	58.84	59.32	58.33	58.68	11883.0
2019-09-26	DC	Futures	26.28	26.28	26.03	26.06	175.0
2019-09-26	DX	Futures	95.295	95.604	95.155	95.459	13498.0
2019-09-26	E1	Futures	1.16784	1.16899	1.16381	1.166	23954.0
2019-09-26	E6	Futures	1.19323	1.19567	1.18922	1.19139	190182.0
2019-09-26	E7	Futures	1.1869	1.1894	1.1832	1.1852	4448.0
2019-09-26	EBM	Futures	187.43	189.62	187.43	189.34	27907.0
2019-09-26	ED	Futures	95.2403	95.2694	95.2306	95.2549	241986.0
2019-09-26	ER	Futures	98.45	98.46	98.45	98.455	40951.0
2019-09-26	EW	Futures	2047.6	2053.8	2028.2	2035.6	9549.0
2019-09-26	FBON	Futures	146.33	146.33	145.97	146.01	136.0
2019-09-26	FBTP	Futures	132.35	132.62	132.31	132.56	57478.0
2019-09-26	FBTS	Futures	108.452	108.616	108.452	108.539	34762.0
2019-09-26	FCE	Futures	5048.1	5099.8	5034.6	5080.7	83570.0
2019-09-26	FDAX	Futures	12918.3	13009.5	12878.7	12947.3	100892.0
2019-09-26	FDIV	Futures	147.9	147.9	147.48	147.48	20.0
2019-09-26	FDXM	Futures	12744.4	12839.2	12712.1	12778.2	32104.0
2019-09-26	FESX	Futures	3067.6	3097.4	3058.9	3084.3	902553.0
2019-09-26	FGBL	Futures	168.19	168.53	168.12	168.4	524253.0
2019-09-26	FGBM	Futures	135.03	135.15	135.02	135.1	325620.0
2019-09-26	FGBS	Futures	112.966	113.006	112.956	112.991	277517.0
2019-09-26	FGBX	Futures	226.39	228.36	226.22	227.73	42031.0
2019-09-26	FMWO	Futures	7289.2	7305.1	7255.0	7259.6	5025.0
2019-09-26	FOAT	Futures	154.97	155.37	154.88	155.22	103047.0
2019-09-26	FTDX	Futures	2777.7	2780.2	2771.8	2772.8	23.0
2019-09-26	FTI	Futures	543.95	550.07	542.39	547.78	29008.0
2019-09-26	FTUK	Futures	6739.8	6813.9	6707.8	6783.8	127937.0
2019-09-26	FVSA	Futures	191.43	192.55	185.81	190.3	24511.0
2019-09-26	FXXP	Futures	349.2	352.6	348.2	351.3	37820.0
2019-09-26	G	Futures	122.59	122.77	122.38	122.66	173591.0
2019-09-26	GF	Futures	298.285	300.169	298.128	299.541	4438.0

> showing 50 of 120 rows — these rows as CSV

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