PREVIEW / futures_daily / 2018-02-09

all futures daily files

  file:    by_date/futures_daily/2018/2018-02-09.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-02-09	ES	Futures	2819.09	2866.91	2750.08	2846.54	3909443.0
2018-02-09	NQ	Futures	7411.22	7560.55	7219.15	7516.34	787495.0
2018-02-09	YM	Futures	25277.9	25679.7	24598.7	25486.7	522982.0
2018-02-09	CL	Futures	60.42	60.76	58.06	59.19	933307.0
2018-02-09	GC	Futures	1687.4	1692.5	1677.4	1680.6	317671.0
2018-02-09	ZN	Futures	119.491566	120.031484	119.260173	119.630402	2874444.0
2018-02-09	A6	Futures	0.79925	0.80532	0.79792	0.8011	172606.0
2018-02-09	AD	Futures	0.80635	0.80863	0.80011	0.80523	131444.0
2018-02-09	B	Futures	46.24	46.38	44.33	45.06	399495.0
2018-02-09	B6	Futures	1.4501	1.4567	1.4332	1.4379	203365.0
2018-02-09	BR	Futures	0.22987	0.23173	0.22824	0.22869	5781.0
2018-02-09	BTC	Futures	10624.6	11411.8	10039.0	11203.6	764.0
2018-02-09	BZ	Futures	45.59	45.77	43.74	44.47	34853.0
2018-02-09	C	Futures	1335.0	1347.0	1325.0	1343.0	12365.0
2018-02-09	CB	Futures	259.627	259.627	258.855	258.855	7.0
2018-02-09	CC	Futures	1511.0	1520.0	1487.0	1511.0	35290.0
2018-02-09	CNH	Futures	6.496	6.4988	6.4404	6.4622	179.0
2018-02-09	CSC	Futures	3.186	3.21	3.178	3.203	93.0
2018-02-09	CT	Futures	89.93	90.25	88.46	89.56	27401.0
2018-02-09	DC	Futures	25.04	25.28	25.04	25.22	208.0
2018-02-09	DX	Futures	84.669	84.942	84.524	84.833	34964.0
2018-02-09	E1	Futures	1.30096	1.30193	1.29367	1.29659	29321.0
2018-02-09	E6	Futures	1.39181	1.39617	1.38687	1.38982	276282.0
2018-02-09	E7	Futures	1.3847	1.3891	1.38	1.3829	3695.0
2018-02-09	EBM	Futures	171.54	172.08	171.0	171.54	16573.0
2018-02-09	ED	Futures	95.2339	95.2388	95.1854	95.2145	555003.0
2018-02-09	ER	Futures	98.332	98.337	98.332	98.332	27739.0
2018-02-09	EW	Futures	1909.1	1941.2	1874.5	1928.5	48232.0
2018-02-09	FBON	Futures	126.62	126.7	126.31	126.33	428.0
2018-02-09	FBTP	Futures	111.4	111.44	110.71	110.8	122085.0
2018-02-09	FBTS	Futures	103.695	103.741	103.65	103.686	67295.0
2018-02-09	FCE	Futures	4548.2	4595.9	4433.7	4527.3	167307.0
2018-02-09	FDAX	Futures	12612.0	12751.1	12345.9	12500.0	155946.0
2018-02-09	FDXM	Futures	12631.9	12773.2	12362.7	12521.2	82099.0
2018-02-09	FESX	Futures	2727.7	2757.9	2659.9	2701.6	2584403.0
2018-02-09	FEU3	Futures	99.011	99.011	99.006	99.006	7.0
2018-02-09	FGBL	Futures	146.48	147.03	146.15	146.47	920977.0
2018-02-09	FGBM	Futures	128.24	128.49	128.15	128.27	598575.0
2018-02-09	FGBS	Futures	112.241	112.321	112.236	112.271	342776.0
2018-02-09	FGBX	Futures	164.18	165.33	163.43	164.03	68588.0
2018-02-09	FMWO	Futures	6786.9	6786.9	6582.7	6688.9	8456.0
2018-02-09	FOAT	Futures	135.82	136.08	135.62	135.82	119456.0
2018-02-09	FTDX	Futures	2445.1	2463.6	2394.2	2428.7	348.0
2018-02-09	FTI	Futures	482.83	486.69	471.31	480.09	66232.0
2018-02-09	FTUK	Futures	6150.5	6211.2	6045.2	6129.5	218411.0
2018-02-09	FVSA	Futures	483.49	559.2	446.5	499.84	50697.0
2018-02-09	FXXP	Futures	315.5	317.6	308.5	312.3	98936.0
2018-02-09	G	Futures	111.48	112.17	111.38	111.7	248854.0
2018-02-09	GF	Futures	323.356	324.619	316.658	321.05	10107.0
2018-02-09	GSCI	Futures	499.56	499.56	490.95	491.88	2497.0

> showing 50 of 111 rows — these rows as CSV

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