PREVIEW / futures_daily / 2019-07-05

all futures daily files

  file:    by_date/futures_daily/2019/2019-07-05.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-07-05	ES	Futures	3237.98	3243.64	3206.15	3226.92	1339312.0
2019-07-05	NQ	Futures	9081.36	9106.69	8977.17	9039.63	375287.0
2019-07-05	YM	Futures	28322.3	28360.1	28065.1	28229.9	199744.0
2019-07-05	CL	Futures	58.7	59.15	57.58	58.83	698015.0
2019-07-05	GC	Futures	1769.4	1775.8	1728.3	1742.6	577376.0
2019-07-05	ZN	Futures	127.65809	127.813619	126.678258	126.880446	1994242.0
2019-07-05	A6	Futures	0.72538	0.72672	0.71746	0.71972	128581.0
2019-07-05	AD	Futures	0.77305	0.77421	0.76836	0.77139	91808.0
2019-07-05	ALI	Futures	2207.08	2207.08	2205.25	2207.08	2.0
2019-07-05	B	Futures	47.56	48.5	47.29	48.29	203540.0
2019-07-05	B6	Futures	1.2879	1.2894	1.2783	1.2826	117483.0
2019-07-05	BR	Futures	0.20839	0.20942	0.20799	0.20835	11.0
2019-07-05	BTC	Futures	16077.7	17120.6	15272.8	15797.7	8761.0
2019-07-05	BZ	Futures	47.42	47.89	46.7	47.68	34614.0
2019-07-05	C	Futures	1747.0	1748.0	1719.0	1733.0	4437.0
2019-07-05	CB	Futures	284.86	284.948	284.306	284.306	31.0
2019-07-05	CC	Futures	1644.0	1661.0	1623.0	1641.0	19561.0
2019-07-05	CNH	Futures	6.8842	6.9032	6.8727	6.8969	1077.0
2019-07-05	CSC	Futures	3.139	3.157	3.139	3.151	49.0
2019-07-05	CT	Futures	65.73	65.93	65.25	65.41	29.0
2019-07-05	DC	Futures	26.2	26.48	26.2	26.46	251.0
2019-07-05	DX	Futures	92.733	93.431	92.733	93.286	24517.0
2019-07-05	E1	Futures	1.18325	1.18557	1.17513	1.17652	27866.0
2019-07-05	E6	Futures	1.23749	1.23907	1.22953	1.23111	224589.0
2019-07-05	E7	Futures	1.2307	1.2325	1.2231	1.2247	5921.0
2019-07-05	EBM	Futures	206.7	206.7	204.11	205.26	11040.0
2019-07-05	ED	Futures	95.4012	95.4012	95.2941	95.3136	567393.0
2019-07-05	ER	Futures	98.529	98.533	98.509	98.514	145998.0
2019-07-05	EW	Futures	2067.6	2074.7	2044.0	2068.1	12264.0
2019-07-05	FBON	Futures	144.43	144.55	143.36	143.6	740.0
2019-07-05	FBTP	Futures	124.58	124.92	123.2	123.72	111476.0
2019-07-05	FBTS	Futures	107.389	107.437	107.149	107.245	61220.0
2019-07-05	FCE	Futures	5130.0	5136.8	5091.1	5109.8	57607.0
2019-07-05	FDAX	Futures	13281.8	13300.8	13170.8	13217.6	93509.0
2019-07-05	FDIV	Futures	149.29	149.29	149.15	149.15	20.0
2019-07-05	FDXM	Futures	13125.0	13136.4	13009.6	13054.8	33327.0
2019-07-05	FESX	Futures	3084.1	3088.5	3060.6	3071.0	770324.0
2019-07-05	FEU3	Futures	99.149	99.149	99.144	99.144	38.0
2019-07-05	FGBL	Futures	165.39	165.41	164.49	164.67	709544.0
2019-07-05	FGBM	Futures	134.7	134.7	134.41	134.51	485835.0
2019-07-05	FGBS	Futures	113.121	113.121	113.071	113.081	276293.0
2019-07-05	FGBX	Futures	212.21	212.25	208.99	209.77	60631.0
2019-07-05	FMWO	Futures	7479.1	7479.1	7383.3	7404.1	1710.0
2019-07-05	FOAT	Futures	152.94	152.97	151.95	152.25	170307.0
2019-07-05	FTDX	Futures	2910.0	2910.0	2877.9	2881.4	91.0
2019-07-05	FTI	Futures	539.89	540.22	534.76	536.86	20994.0
2019-07-05	FTUK	Futures	6969.9	6969.9	6905.3	6915.9	74914.0
2019-07-05	FVSA	Futures	179.28	186.89	177.9	184.13	24587.0
2019-07-05	FXXP	Futures	350.7	350.8	347.3	348.2	41398.0
2019-07-05	G	Futures	121.53	121.64	120.76	120.81	191675.0

> showing 50 of 121 rows — these rows as CSV

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