PREVIEW / futures_daily / 2019-07-25

all futures daily files

  file:    by_date/futures_daily/2019/2019-07-25.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-07-25	ES	Futures	3256.59	3267.11	3235.01	3244.18	1333721.0
2019-07-25	NQ	Futures	9215.78	9250.32	9115.33	9189.59	433945.0
2019-07-25	YM	Futures	28613.2	28717.2	28392.7	28451.5	196815.0
2019-07-25	CL	Futures	57.04	58.15	56.95	57.16	559282.0
2019-07-25	GC	Futures	1775.8	1784.9	1756.3	1760.8	489392.0
2019-07-25	ZN	Futures	126.942657	127.253715	126.491623	126.693811	1985659.0
2019-07-25	A6	Futures	0.7188	0.71962	0.7153	0.71571	80308.0
2019-07-25	AD	Futures	0.76816	0.76927	0.7663	0.7665	61694.0
2019-07-25	ALI	Futures	2274.27	2274.27	2274.27	2274.27	0.0
2019-07-25	B	Futures	47.52	48.29	47.37	47.65	169836.0
2019-07-25	B6	Futures	1.2773	1.2808	1.2724	1.274	97583.0
2019-07-25	BR	Futures	0.21154	0.21218	0.20954	0.2107	1201.0
2019-07-25	BTC	Futures	13665.0	14243.3	13623.7	13692.6	2071.0
2019-07-25	BZ	Futures	46.88	47.68	46.79	47.05	27929.0
2019-07-25	C	Futures	1737.0	1742.0	1718.0	1735.0	5884.0
2019-07-25	CB	Futures	281.826	282.38	281.768	282.088	124.0
2019-07-25	CC	Futures	1641.0	1645.0	1614.0	1621.0	19919.0
2019-07-25	CNH	Futures	6.879	6.8806	6.8721	6.8774	320.0
2019-07-25	CSC	Futures	3.139	3.14	3.122	3.13	83.0
2019-07-25	CT	Futures	63.18	63.5	62.81	63.01	18.0
2019-07-25	DC	Futures	26.55	26.55	26.3	26.36	232.0
2019-07-25	DX	Futures	93.792	94.018	93.604	93.924	24766.0
2019-07-25	E1	Futures	1.18313	1.18336	1.17466	1.17501	29849.0
2019-07-25	E6	Futures	1.22036	1.22538	1.21584	1.22064	306855.0
2019-07-25	E7	Futures	1.214	1.2189	1.2095	1.2143	6717.0
2019-07-25	EBM	Futures	201.52	202.67	200.94	202.38	16222.0
2019-07-25	ED	Futures	95.2892	95.3038	95.2551	95.2697	356463.0
2019-07-25	ER	Futures	98.543	98.553	98.519	98.529	264899.0
2019-07-25	EW	Futures	2087.2	2091.6	2061.2	2064.7	14233.0
2019-07-25	FBON	Futures	144.1	145.02	142.87	143.65	1041.0
2019-07-25	FBTP	Futures	126.03	127.19	125.05	125.74	154774.0
2019-07-25	FBTS	Futures	107.839	108.136	107.619	107.791	83799.0
2019-07-25	FCE	Futures	5139.3	5167.6	5052.8	5079.7	121846.0
2019-07-25	FDAX	Futures	13225.0	13265.5	12937.0	13027.0	156519.0
2019-07-25	FDIV	Futures	149.15	149.71	147.25	147.58	115.0
2019-07-25	FDXM	Futures	13063.6	13099.0	12777.6	12866.5	72901.0
2019-07-25	FESX	Futures	3092.0	3116.4	3041.3	3064.1	1389904.0
2019-07-25	FEU3	Futures	99.174	99.253	99.159	99.159	65.0
2019-07-25	FGBL	Futures	165.7	166.32	164.96	165.46	987392.0
2019-07-25	FGBM	Futures	134.86	135.11	134.6	134.75	605959.0
2019-07-25	FGBS	Futures	113.147	113.187	113.071	113.106	397466.0
2019-07-25	FGBX	Futures	211.75	213.81	209.22	210.91	76605.0
2019-07-25	FMWO	Futures	7471.0	7487.1	7415.6	7438.7	1011.0
2019-07-25	FOAT	Futures	152.81	153.55	152.06	152.61	181065.0
2019-07-25	FTDX	Futures	2896.7	2904.6	2863.6	2870.5	57.0
2019-07-25	FTI	Futures	552.58	553.29	542.51	546.11	41436.0
2019-07-25	FTUK	Futures	6880.8	6904.8	6828.6	6865.1	121139.0
2019-07-25	FVSA	Futures	167.56	178.69	165.09	171.27	54938.0
2019-07-25	FXXP	Futures	351.3	353.0	346.1	348.2	97909.0
2019-07-25	G	Futures	121.69	121.92	120.99	121.25	223547.0

> showing 50 of 120 rows — these rows as CSV

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