PREVIEW / futures_daily / 2019-08-06

all futures daily files

  file:    by_date/futures_daily/2019/2019-08-06.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-06	ES	Futures	3038.89	3111.73	2995.19	3103.37	2601037.0
2019-08-06	NQ	Futures	8461.09	8691.35	8317.75	8652.78	845239.0
2019-08-06	YM	Futures	26731.6	27298.6	26284.2	27220.9	356709.0
2019-08-06	CL	Futures	56.07	56.55	54.38	54.72	682794.0
2019-08-06	GC	Futures	1827.0	1834.0	1811.1	1830.8	381923.0
2019-08-06	ZN	Futures	129.555542	129.726624	128.871215	129.16672	2306499.0
2019-08-06	A6	Futures	0.69586	0.70059	0.69534	0.69606	114503.0
2019-08-06	AD	Futures	0.76332	0.76494	0.75889	0.75954	81496.0
2019-08-06	ALI	Futures	2176.24	2176.55	2164.02	2164.02	141.0
2019-08-06	B	Futures	44.93	45.69	44.17	44.46	328149.0
2019-08-06	B6	Futures	1.2415	1.2486	1.241	1.2426	115851.0
2019-08-06	BR	Futures	0.20079	0.20235	0.1998	0.20115	14631.0
2019-08-06	BTC	Futures	16418.7	17217.2	16108.9	16287.9	3814.0
2019-08-06	BZ	Futures	44.68	45.08	43.61	43.89	34335.0
2019-08-06	C	Futures	1688.0	1689.0	1656.0	1658.0	11168.0
2019-08-06	CB	Futures	275.991	276.574	275.407	275.407	39.0
2019-08-06	CC	Futures	1535.0	1539.0	1507.0	1511.0	33871.0
2019-08-06	CNH	Futures	7.1446	7.1519	7.0507	7.0614	1954.0
2019-08-06	CSC	Futures	3.12	3.124	3.114	3.124	63.0
2019-08-06	CT	Futures	57.23	57.54	57.2	57.54	10.0
2019-08-06	DC	Futures	26.2	26.29	26.05	26.27	288.0
2019-08-06	DX	Futures	93.469	93.936	93.373	93.794	20260.0
2019-08-06	E1	Futures	1.19728	1.19948	1.18823	1.19136	39065.0
2019-08-06	E6	Futures	1.22702	1.23105	1.22205	1.22571	230617.0
2019-08-06	E7	Futures	1.2207	1.2246	1.2157	1.2193	5234.0
2019-08-06	EBM	Futures	198.93	199.22	196.34	196.62	14494.0
2019-08-06	ED	Futures	95.4499	95.484	95.4012	95.4109	446078.0
2019-08-06	ER	Futures	98.558	98.558	98.543	98.548	56527.0
2019-08-06	EW	Futures	1935.8	1980.6	1910.0	1978.6	16727.0
2019-08-06	FBON	Futures	145.12	145.4	145.11	145.23	119.0
2019-08-06	FBTP	Futures	125.66	126.1	125.53	125.92	70574.0
2019-08-06	FBTS	Futures	107.561	107.705	107.552	107.657	38357.0
2019-08-06	FCE	Futures	4774.9	4824.6	4762.7	4766.7	125384.0
2019-08-06	FDAX	Futures	12088.3	12363.1	12040.9	12191.5	144853.0
2019-08-06	FDIV	Futures	139.46	139.46	138.25	138.25	90.0
2019-08-06	FDXM	Futures	11960.2	12210.8	11881.1	12041.3	71291.0
2019-08-06	FESX	Futures	2845.8	2910.4	2834.4	2873.7	1541063.0
2019-08-06	FEU3	Futures	99.169	99.174	99.169	99.174	198.0
2019-08-06	FGBL	Futures	167.93	168.06	167.47	167.9	538517.0
2019-08-06	FGBM	Futures	135.39	135.4	135.19	135.35	345156.0
2019-08-06	FGBS	Futures	113.212	113.227	113.187	113.217	207440.0
2019-08-06	FGBX	Futures	222.41	223.34	221.03	222.45	65377.0
2019-08-06	FMWO	Futures	7000.2	7104.1	7000.2	7046.4	8622.0
2019-08-06	FOAT	Futures	154.27	154.61	154.14	154.51	103766.0
2019-08-06	FTDX	Futures	2739.2	2768.8	2732.8	2732.8	129.0
2019-08-06	FTI	Futures	511.52	513.8	507.53	507.99	38760.0
2019-08-06	FTUK	Futures	6469.5	6620.9	6462.1	6559.0	173500.0
2019-08-06	FVSA	Futures	234.95	238.66	220.73	237.43	71256.0
2019-08-06	FXXP	Futures	329.5	332.3	327.7	328.4	108124.0
2019-08-06	G	Futures	123.3	123.41	123.0	123.21	206121.0

> showing 50 of 120 rows — these rows as CSV

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