PREVIEW / futures_daily / 2018-12-27

all futures daily files

  file:    by_date/futures_daily/2018/2018-12-27.parquet
  size:    10 KB
  rows:    116

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-27	ES	Futures	2674.46	2705.32	2595.16	2701.26	2283892.0
2018-12-27	NQ	Futures	7274.17	7332.05	7008.17	7321.05	740129.0
2018-12-27	YM	Futures	24127.9	24470.7	23460.2	24421.1	359456.0
2018-12-27	CL	Futures	48.86	48.98	46.54	46.79	665590.0
2018-12-27	GC	Futures	1600.3	1614.8	1599.1	1614.2	213501.0
2018-12-27	ZN	Futures	120.475561	121.098013	120.46	121.035768	1465439.0
2018-12-27	A6	Futures	0.72869	0.72992	0.72374	0.72395	86136.0
2018-12-27	AD	Futures	0.74745	0.7477	0.74259	0.7436	73612.0
2018-12-27	B	Futures	39.7	39.7	37.91	38.07	224693.0
2018-12-27	B6	Futures	1.3035	1.3068	1.3005	1.3036	71803.0
2018-12-27	BR	Futures	0.20192	0.20408	0.20192	0.20408	53.0
2018-12-27	BTC	Futures	5548.1	5584.6	5153.4	5182.6	1186.0
2018-12-27	BZ	Futures	39.54	39.54	37.59	37.75	26850.0
2018-12-27	C	Futures	1530.0	1542.0	1511.0	1535.0	14924.0
2018-12-27	CB	Futures	271.468	272.744	271.468	272.319	22.0
2018-12-27	CC	Futures	1643.0	1654.0	1617.0	1635.0	23293.0
2018-12-27	CNH	Futures	6.9093	6.9185	6.889	6.8915	866.0
2018-12-27	CSC	Futures	2.793	2.801	2.79	2.801	59.0
2018-12-27	CT	Futures	80.39	80.81	78.29	78.5	16933.0
2018-12-27	DC	Futures	23.81	23.92	23.78	23.92	100.0
2018-12-27	DX	Futures	91.994	92.027	91.493	91.556	20520.0
2018-12-27	E1	Futures	1.191	1.20394	1.1903	1.20147	32605.0
2018-12-27	E6	Futures	1.2637	1.27425	1.26337	1.27359	178453.0
2018-12-27	E7	Futures	1.2575	1.268	1.2572	1.2674	3659.0
2018-12-27	EBM	Futures	210.51	210.77	208.71	208.97	6828.0
2018-12-27	ED	Futures	94.9646	95.0037	94.9646	94.9988	192085.0
2018-12-27	ER	Futures	98.401	98.401	98.396	98.401	42624.0
2018-12-27	EW	Futures	1745.9	1758.9	1694.7	1753.5	28592.0
2018-12-27	FBON	Futures	129.97	130.14	129.88	130.1	237.0
2018-12-27	FBTP	Futures	110.74	111.8	110.4	111.77	35880.0
2018-12-27	FBTS	Futures	104.585	104.717	104.443	104.708	29085.0
2018-12-27	FCE	Futures	4165.8	4176.5	4041.9	4081.0	115706.0
2018-12-27	FDAX	Futures	11166.4	11245.2	10790.7	10893.7	123093.0
2018-12-27	FDIV	Futures	128.27	128.27	127.46	127.46	1.0
2018-12-27	FDXM	Futures	11124.5	11212.6	10766.0	10867.1	71205.0
2018-12-27	FESX	Futures	2547.5	2558.6	2474.0	2497.9	1177785.0
2018-12-27	FGBL	Futures	155.15	155.73	155.12	155.67	335388.0
2018-12-27	FGBM	Futures	131.77	131.97	131.71	131.94	214058.0
2018-12-27	FGBS	Futures	112.673	112.759	112.673	112.744	213949.0
2018-12-27	FGBX	Futures	183.11	184.33	183.05	184.06	19073.0
2018-12-27	FMWO	Futures	6219.6	6262.7	6107.7	6166.0	4400.0
2018-12-27	FOAT	Futures	141.29	141.49	141.28	141.46	46571.0
2018-12-27	FTDX	Futures	2432.5	2441.0	2358.0	2376.4	628.0
2018-12-27	FTI	Futures	453.86	455.69	441.56	445.24	41180.0
2018-12-27	FTUK	Futures	6041.7	6095.9	5897.8	5947.4	137684.0
2018-12-27	FVSA	Futures	449.91	511.87	449.91	498.66	31113.0
2018-12-27	FXXP	Futures	293.5	295.0	285.6	287.7	47078.0
2018-12-27	G	Futures	116.67	117.11	116.45	116.52	106516.0
2018-12-27	GF	Futures	319.015	322.029	318.531	320.738	3134.0
2018-12-27	GSCI	Futures	429.27	430.64	427.45	427.45	97.0

> showing 50 of 116 rows — these rows as CSV

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