PREVIEW / futures_daily / 2018-12-06

all futures daily files

  file:    by_date/futures_daily/2018/2018-12-06.parquet
  size:    10 KB
  rows:    114

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-12-06	ES	Futures	2942.55	2943.36	2842.78	2918.42	3308356.0
2018-12-06	NQ	Futures	7938.45	7961.39	7701.21	7926.83	986103.0
2018-12-06	YM	Futures	26466.1	26474.6	25542.6	26228.2	487528.0
2018-12-06	CL	Futures	56.0	56.39	52.99	54.48	987266.0
2018-12-06	GC	Futures	1566.2	1574.9	1562.4	1566.9	248859.0
2018-12-06	ZN	Futures	119.635166	120.413332	119.60404	119.977559	98775.0
2018-12-06	A6	Futures	0.74825	0.74825	0.74002	0.74311	136185.0
2018-12-06	AD	Futures	0.75732	0.75732	0.75221	0.7551	115618.0
2018-12-06	B	Futures	45.05	45.5	42.85	44.1	399988.0
2018-12-06	B6	Futures	1.3099	1.3182	1.3066	1.3144	121645.0
2018-12-06	BR	Futures	0.20336	0.20396	0.20256	0.20396	2.0
2018-12-06	BTC	Futures	5599.9	6042.4	5126.9	5493.1	5768.0
2018-12-06	BZ	Futures	44.72	44.91	42.32	43.53	60772.0
2018-12-06	C	Futures	1416.0	1421.0	1387.0	1390.0	3357.0
2018-12-06	CB	Futures	267.885	267.885	266.7	267.672	12.0
2018-12-06	CC	Futures	1459.0	1476.0	1455.0	1466.0	12793.0
2018-12-06	CNH	Futures	6.8959	6.9431	6.8959	6.9225	1161.0
2018-12-06	CSC	Futures	2.849	2.849	2.829	2.831	154.0
2018-12-06	CT	Futures	88.01	88.01	85.62	86.14	22141.0
2018-12-06	DC	Futures	23.89	23.96	23.81	23.81	153.0
2018-12-06	DX	Futures	92.091	92.314	91.668	91.924	23219.0
2018-12-06	E1	Futures	1.18904	1.199	1.18726	1.19438	28906.0
2018-12-06	E6	Futures	1.26238	1.26972	1.25954	1.26538	252497.0
2018-12-06	E7	Futures	1.2563	1.2635	1.2534	1.2591	3522.0
2018-12-06	EBM	Futures	208.2	208.2	207.17	207.68	11986.0
2018-12-06	ED	Futures	94.9133	94.9499	94.906	94.9108	772821.0
2018-12-06	ER	Futures	98.386	98.391	98.386	98.386	55362.0
2018-12-06	EW	Futures	1928.4	1928.9	1861.9	1910.9	30810.0
2018-12-06	FBON	Futures	129.18	129.2	128.93	128.98	514.0
2018-12-06	FBTP	Futures	108.64	108.74	107.3	107.48	110617.0
2018-12-06	FBTS	Futures	104.083	104.149	103.544	103.619	112000.0
2018-12-06	FCE	Futures	4377.4	4387.2	4253.4	4271.7	157987.0
2018-12-06	FDAX	Futures	11607.9	11659.9	11309.2	11316.1	180587.0
2018-12-06	FDIV	Futures	132.8	132.8	131.72	131.72	1.0
2018-12-06	FDXM	Futures	11414.1	11458.5	11113.4	11120.1	94363.0
2018-12-06	FESX	Futures	2608.4	2621.0	2542.8	2544.5	2184273.0
2018-12-06	FGBL	Futures	155.11	155.56	154.92	155.5	881066.0
2018-12-06	FGBM	Futures	131.8	131.96	131.69	131.93	482739.0
2018-12-06	FGBS	Futures	112.739	112.759	112.708	112.749	365965.0
2018-12-06	FGBX	Futures	181.99	183.55	181.75	183.35	68645.0
2018-12-06	FMWO	Futures	6612.5	6642.6	6485.1	6488.5	6248.0
2018-12-06	FOAT	Futures	141.77	141.94	141.55	141.88	237423.0
2018-12-06	FTDX	Futures	2487.5	2498.8	2450.7	2454.1	455.0
2018-12-06	FTI	Futures	473.74	474.9	460.7	462.9	52232.0
2018-12-06	FTUK	Futures	6163.4	6163.4	5961.8	5967.6	224338.0
2018-12-06	FVSA	Futures	359.85	408.24	354.81	406.22	92713.0
2018-12-06	FXXP	Futures	303.3	304.4	296.0	296.2	77781.0
2018-12-06	G	Futures	116.78	117.37	116.64	117.31	293899.0
2018-12-06	GF	Futures	311.912	312.827	309.436	310.405	5470.0
2018-12-06	GSCI	Futures	458.73	461.72	453.99	461.32	78.0

> showing 50 of 114 rows — these rows as CSV

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