PREVIEW / futures_daily / 2019-08-16

all futures daily files

  file:    by_date/futures_daily/2019/2019-08-16.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-08-16	ES	Futures	3076.39	3123.6	3074.77	3120.09	1631175.0
2019-08-16	NQ	Futures	8645.59	8787.49	8637.81	8763.6	449473.0
2019-08-16	YM	Futures	26864.9	27226.1	26855.5	27203.0	196934.0
2019-08-16	CL	Futures	56.09	57.12	55.69	56.29	395156.0
2019-08-16	GC	Futures	1892.1	1897.9	1867.5	1879.4	322455.0
2019-08-16	ZN	Futures	130.30208	130.488715	129.804388	130.317633	1549517.0
2019-08-16	A6	Futures	0.6975	0.69977	0.6973	0.69853	49128.0
2019-08-16	AD	Futures	0.75733	0.7604	0.75687	0.76	59516.0
2019-08-16	ALI	Futures	2199.68	2201.5	2199.68	2201.5	30.0
2019-08-16	B	Futures	44.06	44.89	43.97	44.24	209433.0
2019-08-16	B6	Futures	1.2345	1.2444	1.2345	1.2421	86631.0
2019-08-16	BR	Futures	0.19976	0.20087	0.19896	0.19964	6416.0
2019-08-16	BTC	Futures	14319.0	14580.6	13444.7	14477.3	5247.0
2019-08-16	BZ	Futures	43.5	44.31	43.41	43.67	25244.0
2019-08-16	C	Futures	1553.0	1556.0	1530.0	1533.0	5899.0
2019-08-16	CB	Futures	276.224	276.224	275.991	276.02	31.0
2019-08-16	CC	Futures	1441.0	1443.0	1424.0	1435.0	24920.0
2019-08-16	CNH	Futures	7.058	7.0658	7.0512	7.0512	660.0
2019-08-16	CSC	Futures	3.1	3.112	3.099	3.112	89.0
2019-08-16	CT	Futures	59.25	59.33	59.2	59.33	3.0
2019-08-16	DC	Futures	26.08	26.23	26.05	26.2	233.0
2019-08-16	DX	Futures	94.36	94.553	94.322	94.362	10735.0
2019-08-16	E1	Futures	1.19067	1.19102	1.18533	1.18881	19196.0
2019-08-16	E6	Futures	1.2142	1.21491	1.20984	1.21333	145844.0
2019-08-16	E7	Futures	1.208	1.2089	1.2036	1.207	3434.0
2019-08-16	EBM	Futures	193.46	194.03	193.17	193.46	11475.0
2019-08-16	ED	Futures	95.4548	95.4596	95.4207	95.445	309404.0
2019-08-16	ER	Futures	98.563	98.563	98.548	98.548	60837.0
2019-08-16	EW	Futures	1930.7	1970.7	1929.6	1968.6	11209.0
2019-08-16	FBON	Futures	147.18	147.5	146.28	146.74	1033.0
2019-08-16	FBTP	Futures	128.01	128.01	126.77	127.02	85610.0
2019-08-16	FBTS	Futures	107.695	107.705	107.389	107.475	58340.0
2019-08-16	FCE	Futures	4772.2	4805.7	4752.7	4800.3	99105.0
2019-08-16	FDAX	Futures	12032.5	12188.8	12020.9	12159.4	110443.0
2019-08-16	FDIV	Futures	138.76	139.22	138.76	139.22	118.0
2019-08-16	FDXM	Futures	11903.0	12037.1	11874.9	12009.6	50298.0
2019-08-16	FESX	Futures	2868.5	2909.5	2865.0	2903.4	1274335.0
2019-08-16	FGBL	Futures	170.57	170.76	169.39	169.82	739569.0
2019-08-16	FGBM	Futures	136.17	136.18	135.91	136.02	466604.0
2019-08-16	FGBS	Futures	113.378	113.408	113.363	113.393	267092.0
2019-08-16	FGBX	Futures	234.59	235.41	229.07	230.39	88686.0
2019-08-16	FMWO	Futures	7055.6	7111.0	7041.8	7098.3	1322.0
2019-08-16	FOAT	Futures	156.74	156.83	155.8	156.16	133980.0
2019-08-16	FTDX	Futures	2620.8	2667.2	2620.3	2664.7	244.0
2019-08-16	FTI	Futures	509.05	513.5	506.54	512.22	37815.0
2019-08-16	FTUK	Futures	6525.3	6573.8	6520.3	6561.3	103543.0
2019-08-16	FVSA	Futures	238.92	238.92	225.75	232.02	26128.0
2019-08-16	FXXP	Futures	328.6	331.6	327.6	330.8	70005.0
2019-08-16	G	Futures	124.22	124.35	123.45	123.72	237021.0
2019-08-16	GF	Futures	272.068	274.815	268.609	269.372	2550.0

> showing 50 of 120 rows — these rows as CSV

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