PREVIEW / futures_daily / 2018-01-05

all futures daily files

  file:    by_date/futures_daily/2018/2018-01-05.parquet
  size:    9 KB
  rows:    112

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-05	ES	Futures	2961.74	2981.58	2960.39	2980.77	1136500.0
2018-01-05	NQ	Futures	7739.15	7812.94	7729.49	7809.13	214944.0
2018-01-05	YM	Futures	26435.8	26662.6	26427.4	26648.9	106856.0
2018-01-05	CL	Futures	61.89	62.03	61.08	61.43	563036.0
2018-01-05	GC	Futures	1679.0	1679.4	1666.6	1676.4	330225.0
2018-01-05	ZN	Futures	122.098599	122.29914	121.898058	121.944337	1433004.0
2018-01-05	A6	Futures	0.80882	0.80995	0.80584	0.80933	106228.0
2018-01-05	AD	Futures	0.81376	0.82244	0.81209	0.81899	103650.0
2018-01-05	B	Futures	48.67	48.77	48.16	48.42	183452.0
2018-01-05	B6	Futures	1.4126	1.416	1.4098	1.4142	76932.0
2018-01-05	BR	Futures	0.23381	0.23473	0.23249	0.23359	1751.0
2018-01-05	BTC	Futures	19319.5	21573.5	19044.1	21247.0	814.0
2018-01-05	BZ	Futures	48.07	48.09	47.51	47.76	18290.0
2018-01-05	C	Futures	1241.0	1252.0	1224.0	1248.0	10490.0
2018-01-05	CB	Futures	276.429	277.046	276.12	276.46	27.0
2018-01-05	CC	Futures	1408.0	1421.0	1392.0	1414.0	14402.0
2018-01-05	CNH	Futures	6.6324	6.6356	6.6302	6.6315	51.0
2018-01-05	CSC	Futures	3.167	3.174	3.161	3.161	92.0
2018-01-05	CT	Futures	92.44	93.5	90.88	91.11	24676.0
2018-01-05	DC	Futures	25.15	25.18	24.96	24.98	89.0
2018-01-05	DX	Futures	85.975	86.238	85.937	86.09	13752.0
2018-01-05	E1	Futures	1.25131	1.2524	1.24657	1.25046	20919.0
2018-01-05	E6	Futures	1.37418	1.37548	1.36839	1.37157	187567.0
2018-01-05	E7	Futures	1.3671	1.3685	1.3616	1.3647	3650.0
2018-01-05	EBM	Futures	172.89	173.7	172.62	173.7	9753.0
2018-01-05	ED	Futures	95.3553	95.3747	95.3505	95.3602	268648.0
2018-01-05	ER	Futures	98.337	98.337	98.332	98.332	68656.0
2018-01-05	EW	Futures	2048.4	2056.0	2045.9	2054.9	12774.0
2018-01-05	FBON	Futures	126.01	126.44	125.93	126.27	235.0
2018-01-05	FBTP	Futures	110.94	111.47	110.8	111.24	78375.0
2018-01-05	FBTS	Futures	103.522	103.604	103.512	103.567	28796.0
2018-01-05	FCE	Futures	4839.1	4898.6	4838.2	4892.4	66971.0
2018-01-05	FDAX	Futures	13662.0	13843.0	13658.9	13806.2	71373.0
2018-01-05	FDXM	Futures	13689.8	13866.5	13682.6	13829.6	23348.0
2018-01-05	FESX	Futures	2905.0	2942.6	2904.2	2936.0	1001116.0
2018-01-05	FEU3	Futures	99.011	99.011	99.006	99.011	36.0
2018-01-05	FGBL	Futures	149.86	150.02	149.68	149.76	467759.0
2018-01-05	FGBM	Futures	129.43	129.5	129.36	129.42	338772.0
2018-01-05	FGBS	Futures	112.367	112.372	112.347	112.357	267240.0
2018-01-05	FGBX	Futures	168.91	169.38	168.23	168.43	38193.0
2018-01-05	FMWO	Futures	7089.2	7106.7	7088.1	7104.4	2797.0
2018-01-05	FOAT	Futures	138.18	138.34	138.04	138.14	89941.0
2018-01-05	FTDX	Futures	2621.2	2635.1	2607.7	2632.6	113.0
2018-01-05	FTI	Futures	512.74	517.56	512.74	516.54	23037.0
2018-01-05	FTUK	Futures	6682.9	6701.3	6666.3	6686.4	76175.0
2018-01-05	FVSA	Futures	249.68	253.89	246.52	249.68	19150.0
2018-01-05	FXXP	Futures	334.1	337.8	334.1	337.2	38959.0
2018-01-05	G	Futures	115.09	115.19	114.85	114.96	152972.0
2018-01-05	GF	Futures	322.03	322.03	315.004	317.004	2412.0
2018-01-05	GSCI	Futures	517.02	518.3	515.45	516.55	1475.0

> showing 50 of 112 rows — these rows as CSV

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