PREVIEW / futures_daily / 2019-09-09

all futures daily files

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

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-09	ES	Futures	3215.86	3228.0	3204.26	3213.7	1199935.0
2019-09-09	NQ	Futures	9045.96	9080.5	8978.61	9015.74	372953.0
2019-09-09	YM	Futures	28148.0	28259.3	28110.2	28182.7	136590.0
2019-09-09	CL	Futures	58.34	59.73	58.11	59.41	646993.0
2019-09-09	GC	Futures	1870.6	1879.7	1857.1	1864.0	317523.0
2019-09-09	ZN	Futures	130.130999	130.177452	129.465169	129.681951	1331549.0
2019-09-09	A6	Futures	0.7046	0.70748	0.70357	0.70635	75569.0
2019-09-09	AD	Futures	0.76529	0.76726	0.76504	0.76584	68617.0
2019-09-09	ALI	Futures	2186.02	2193.3	2186.02	2190.57	98.0
2019-09-09	B	Futures	47.58	48.66	47.55	48.34	249708.0
2019-09-09	B6	Futures	1.2539	1.2648	1.2491	1.2605	171913.0
2019-09-09	BR	Futures	0.19776	0.19776	0.19635	0.19635	5.0
2019-09-09	BTC	Futures	14987.4	15173.1	14451.6	14816.0	3966.0
2019-09-09	BZ	Futures	46.83	47.93	46.83	47.63	31505.0
2019-09-09	C	Futures	1561.0	1566.0	1539.0	1557.0	2098.0
2019-09-09	CB	Futures	261.859	262.154	261.741	261.741	19.0
2019-09-09	CC	Futures	1492.0	1521.0	1482.0	1512.0	21300.0
2019-09-09	CNH	Futures	7.1042	7.134	7.1042	7.1201	630.0
2019-09-09	CSC	Futures	3.017	3.032	3.013	3.03	51.0
2019-09-09	CT	Futures	58.02	58.46	57.98	58.38	19.0
2019-09-09	DC	Futures	25.35	25.5	25.35	25.47	100.0
2019-09-09	DX	Futures	94.731	94.813	94.456	94.594	30446.0
2019-09-09	E1	Futures	1.17513	1.17513	1.16933	1.17003	25375.0
2019-09-09	E6	Futures	1.20351	1.20798	1.20225	1.20629	183127.0
2019-09-09	E7	Futures	1.1974	1.2016	1.196	1.2	2450.0
2019-09-09	EBM	Futures	182.5	184.15	181.68	184.15	20703.0
2019-09-09	ED	Futures	95.3355	95.3355	95.3136	95.3184	192992.0
2019-09-09	ER	Futures	98.538	98.543	98.533	98.543	76694.0
2019-09-09	EW	Futures	2006.4	2024.8	2006.4	2024.1	12826.0
2019-09-09	FBON	Futures	145.97	145.97	145.13	145.13	219.0
2019-09-09	FBTP	Futures	131.87	131.97	131.03	131.07	56658.0
2019-09-09	FBTS	Futures	108.664	108.664	108.529	108.558	46874.0
2019-09-09	FCE	Futures	5076.2	5084.8	5047.7	5063.5	57632.0
2019-09-09	FDAX	Futures	12830.1	12895.4	12829.1	12867.5	67680.0
2019-09-09	FDIV	Futures	145.91	146.18	145.81	146.18	135.0
2019-09-09	FDXM	Futures	12666.3	12735.0	12666.3	12709.0	24720.0
2019-09-09	FESX	Futures	3046.6	3058.8	3040.5	3050.1	648893.0
2019-09-09	FEU3	Futures	99.159	99.169	99.159	99.169	1.0
2019-09-09	FGBL	Futures	169.25	169.34	168.27	168.32	645246.0
2019-09-09	FGBM	Futures	135.88	135.91	135.6	135.63	355949.0
2019-09-09	FGBS	Futures	113.247	113.252	113.182	113.197	295984.0
2019-09-09	FGBX	Futures	226.22	226.22	221.51	222.0	55022.0
2019-09-09	FMWO	Futures	7351.0	7359.1	7325.6	7344.1	1314.0
2019-09-09	FOAT	Futures	156.0	156.02	154.87	154.91	122257.0
2019-09-09	FTDX	Futures	2841.9	2844.4	2825.1	2825.6	76.0
2019-09-09	FTI	Futures	539.63	540.67	535.75	537.69	19935.0
2019-09-09	FTUK	Futures	6741.4	6767.2	6655.1	6677.7	87220.0
2019-09-09	FVSA	Futures	189.38	193.77	186.87	188.75	17962.0
2019-09-09	FXXP	Futures	347.3	347.9	345.3	346.2	34009.0
2019-09-09	G	Futures	122.7	122.72	121.76	121.8	237977.0

> showing 50 of 121 rows — these rows as CSV

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