PREVIEW / futures_daily / 2019-06-17

all futures daily files

  file:    by_date/futures_daily/2019/2019-06-17.parquet
  size:    10 KB
  rows:    117

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-06-17	ES	Futures	3123.87	3134.39	3120.63	3125.22	1649621.0
2019-06-17	NQ	Futures	8644.15	8724.16	8642.99	8705.45	291514.0
2019-06-17	YM	Futures	27436.1	27529.6	27367.9	27445.6	125744.0
2019-06-17	CL	Futures	53.92	54.22	53.01	53.37	235025.0
2019-06-17	GC	Futures	1674.6	1676.6	1663.6	1671.4	238707.0
2019-06-17	ZN	Futures	126.802681	126.818234	126.507176	126.74047	994596.0
2019-06-17	A6	Futures	0.70892	0.71005	0.70645	0.70666	69797.0
2019-06-17	AD	Futures	0.75289	0.7539	0.75239	0.75274	50571.0
2019-06-17	ALI	Futures	2718.01	2718.01	2718.01	2718.01	0.0
2019-06-17	B	Futures	46.2	46.43	45.21	45.36	236161.0
2019-06-17	B6	Futures	1.2908	1.292	1.2844	1.2852	62637.0
2019-06-17	BR	Futures	0.20427	0.20427	0.20295	0.20359	2.0
2019-06-17	BTC	Futures	13929.7	14590.5	13914.4	14413.8	6926.0
2019-06-17	BZ	Futures	45.54	45.82	44.62	44.78	46699.0
2019-06-17	C	Futures	1780.0	1794.0	1758.0	1773.0	4009.0
2019-06-17	CB	Futures	285.619	285.619	285.473	285.619	12.0
2019-06-17	CC	Futures	1664.0	1665.0	1631.0	1651.0	16856.0
2019-06-17	CNH	Futures	6.9457	6.9497	6.9421	6.9421	538.0
2019-06-17	CSC	Futures	3.052	3.052	3.035	3.045	52.0
2019-06-17	CT	Futures	69.12	69.61	68.37	68.7	12302.0
2019-06-17	DC	Futures	25.63	25.63	25.44	25.6	128.0
2019-06-17	DX	Futures	93.445	93.484	93.219	93.442	11289.0
2019-06-17	E1	Futures	1.1713	1.17339	1.16933	1.17072	20176.0
2019-06-17	E6	Futures	1.23214	1.23591	1.23105	1.23258	131890.0
2019-06-17	E7	Futures	1.2255	1.2296	1.2247	1.2261	3096.0
2019-06-17	EBM	Futures	209.87	211.59	209.0	210.44	17514.0
2019-06-17	ED	Futures	95.3525	95.3574	95.3184	95.3282	294690.0
2019-06-17	ER	Futures	98.445	98.45	98.44	98.445	77133.0
2019-06-17	EW	Futures	2002.2	2009.4	1997.2	2000.2	44036.0
2019-06-17	FBON	Futures	141.55	141.66	141.23	141.29	279.0
2019-06-17	FBTP	Futures	118.37	118.85	118.27	118.7	78043.0
2019-06-17	FBTS	Futures	106.325	106.478	106.325	106.392	53726.0
2019-06-17	FCE	Futures	4899.2	4931.7	4893.3	4914.3	130251.0
2019-06-17	FDAX	Futures	12735.3	12753.8	12681.1	12726.4	28625.0
2019-06-17	FDIV	Futures	144.79	144.79	144.37	144.65	144.0
2019-06-17	FDXM	Futures	12584.2	12592.5	12532.2	12569.6	2166.0
2019-06-17	FESX	Futures	2945.3	2953.2	2935.7	2947.9	1546996.0
2019-06-17	FGBL	Futures	163.27	163.31	163.0	163.13	479352.0
2019-06-17	FGBM	Futures	134.08	134.12	134.02	134.09	312288.0
2019-06-17	FGBS	Futures	112.975	112.98	112.95	112.965	166728.0
2019-06-17	FGBX	Futures	206.44	206.77	205.34	205.71	38543.0
2019-06-17	FMWO	Futures	7167.5	7181.4	7160.6	7175.6	13582.0
2019-06-17	FOAT	Futures	150.1	150.18	149.82	149.94	103076.0
2019-06-17	FTDX	Futures	2748.6	2757.0	2748.6	2755.5	1036.0
2019-06-17	FTI	Futures	521.12	521.82	518.01	519.03	17544.0
2019-06-17	FTUK	Futures	6736.8	6740.5	6697.1	6733.1	392614.0
2019-06-17	FVSA	Futures	209.74	211.12	205.58	205.58	39841.0
2019-06-17	FXXP	Futures	337.2	338.3	336.7	337.7	182658.0
2019-06-17	G	Futures	119.75	119.84	119.58	119.7	148706.0
2019-06-17	GF	Futures	263.844	269.29	263.207	268.701	6817.0

> showing 50 of 117 rows — these rows as CSV

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