PREVIEW / futures_daily / 2018-01-18

all futures daily files

  file:    by_date/futures_daily/2018/2018-01-18.parquet
  size:    9 KB
  rows:    111

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
2018-01-18	ES	Futures	3046.79	3051.96	3036.47	3039.18	1345331.0
2018-01-18	NQ	Futures	7985.1	8008.53	7959.34	7979.25	314511.0
2018-01-18	YM	Futures	27508.4	27576.9	27327.0	27357.6	190652.0
2018-01-18	CL	Futures	63.98	64.26	63.42	63.87	511528.0
2018-01-18	GC	Futures	1682.9	1690.3	1678.9	1682.6	312113.0
2018-01-18	ZN	Futures	120.98791	121.034189	120.78737	120.895353	1950365.0
2018-01-18	A6	Futures	0.81828	0.82343	0.81674	0.8226	119439.0
2018-01-18	AD	Futures	0.816	0.81838	0.81346	0.81737	74253.0
2018-01-18	B	Futures	49.79	49.86	49.26	49.63	270231.0
2018-01-18	B6	Futures	1.4392	1.4498	1.4385	1.4478	114605.0
2018-01-18	BFX	Futures	4931.0	4943.5	4931.0	4932.1	74.0
2018-01-18	BR	Futures	0.23495	0.23579	0.23476	0.23545	217.0
2018-01-18	BTC	Futures	14247.9	15464.6	13633.2	15131.6	1708.0
2018-01-18	BZ	Futures	49.04	49.2	48.59	48.95	20117.0
2018-01-18	C	Futures	1303.0	1305.0	1280.0	1283.0	11654.0
2018-01-18	CB	Futures	270.56	270.56	268.954	270.282	70.0
2018-01-18	CC	Futures	1489.0	1500.0	1471.0	1480.0	27063.0
2018-01-18	CSC	Futures	3.195	3.195	3.137	3.144	174.0
2018-01-18	CT	Futures	95.78	98.04	95.56	96.51	26971.0
2018-01-18	DC	Futures	25.31	25.41	24.85	25.02	396.0
2018-01-18	DX	Futures	85.13	85.238	84.712	84.798	28152.0
2018-01-18	E1	Futures	1.26187	1.27304	1.26029	1.27182	30237.0
2018-01-18	E6	Futures	1.38449	1.39538	1.3841	1.39283	233389.0
2018-01-18	E7	Futures	1.3773	1.3883	1.3771	1.3858	6534.0
2018-01-18	EBM	Futures	168.3	168.57	167.77	168.04	19607.0
2018-01-18	ED	Futures	95.3116	95.3213	95.3067	95.3213	488313.0
2018-01-18	ER	Futures	98.332	98.337	98.332	98.332	24621.0
2018-01-18	EW	Futures	2086.3	2089.4	2074.4	2079.1	14193.0
2018-01-18	FBON	Futures	126.12	126.52	126.11	126.39	326.0
2018-01-18	FBTP	Futures	111.2	111.59	110.94	111.39	98252.0
2018-01-18	FBTS	Futures	103.549	103.613	103.531	103.576	43174.0
2018-01-18	FCE	Futures	4915.6	4918.3	4879.0	4897.3	95738.0
2018-01-18	FDAX	Futures	13725.8	13800.0	13686.4	13755.9	82810.0
2018-01-18	FDXM	Futures	13752.2	13828.0	13710.6	13779.2	31428.0
2018-01-18	FESX	Futures	2951.5	2956.4	2936.8	2945.0	996061.0
2018-01-18	FGBL	Futures	148.86	148.93	148.56	148.82	613599.0
2018-01-18	FGBM	Futures	128.92	129.0	128.82	128.95	489681.0
2018-01-18	FGBS	Futures	112.276	112.306	112.256	112.296	355152.0
2018-01-18	FGBX	Futures	167.67	167.67	166.66	167.12	40183.0
2018-01-18	FMWO	Futures	7252.6	7265.5	7246.8	7250.3	634.0
2018-01-18	FOAT	Futures	137.5	137.61	137.18	137.49	114055.0
2018-01-18	FTDX	Futures	2653.6	2671.5	2650.6	2666.5	139.0
2018-01-18	FTI	Futures	523.95	525.49	522.51	524.7	25926.0
2018-01-18	FTUK	Futures	6707.0	6714.8	6664.6	6672.0	108585.0
2018-01-18	FVSA	Futures	247.77	259.81	246.91	258.95	20040.0
2018-01-18	FXXP	Futures	339.1	339.5	337.6	338.3	41387.0
2018-01-18	G	Futures	114.13	114.18	113.92	114.01	170539.0
2018-01-18	GF	Futures	321.654	323.905	320.611	323.191	5440.0
2018-01-18	GSCI	Futures	522.54	523.12	521.73	523.12	28.0
2018-01-18	HE	Futures	97.012	97.878	96.659	97.461	17145.0

> showing 50 of 111 rows — these rows as CSV

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