PREVIEW / futures_daily / 2018-04-26

all futures daily files

  file:    by_date/futures_daily/2018/2018-04-26.parquet
  size:    10 KB
  rows:    113

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-04-26	ES	Futures	2879.89	2911.7	2870.37	2908.43	1279539.0
2018-04-26	NQ	Futures	7705.26	7899.25	7677.17	7882.58	424984.0
2018-04-26	YM	Futures	25403.8	25664.0	25295.3	25614.5	204755.0
2018-04-26	CL	Futures	68.28	69.03	67.96	68.44	660549.0
2018-04-26	GC	Futures	1690.6	1695.4	1680.4	1682.5	295688.0
2018-04-26	ZN	Futures	118.159887	118.501076	118.12887	118.423533	1312131.0
2018-04-26	A6	Futures	0.77787	0.78034	0.77602	0.77663	115949.0
2018-04-26	AD	Futures	0.78869	0.78991	0.78601	0.78682	65809.0
2018-04-26	B	Futures	53.77	54.35	53.73	54.14	296999.0
2018-04-26	B6	Futures	1.446	1.4528	1.4421	1.4452	116106.0
2018-04-26	BR	Futures	0.21732	0.21854	0.21656	0.21797	24997.0
2018-04-26	BTC	Futures	12905.3	13010.7	12175.1	12491.1	526.0
2018-04-26	BZ	Futures	53.26	53.78	53.18	53.59	31949.0
2018-04-26	C	Futures	1699.0	1720.0	1643.0	1708.0	5772.0
2018-04-26	CB	Futures	301.446	302.99	301.446	301.446	24.0
2018-04-26	CC	Futures	2091.0	2146.0	2019.0	2043.0	40700.0
2018-04-26	CNH	Futures	6.4248	6.4359	6.4248	6.4275	42.0
2018-04-26	CSC	Futures	3.417	3.427	3.417	3.425	60.0
2018-04-26	CT	Futures	95.24	96.59	95.0	95.68	17521.0
2018-04-26	DC	Futures	27.57	27.71	27.57	27.64	136.0
2018-04-26	DX	Futures	85.83	86.24	85.585	86.169	38967.0
2018-04-26	E1	Futures	1.22971	1.23188	1.222	1.22248	31408.0
2018-04-26	E6	Futures	1.37505	1.38057	1.36767	1.36874	344686.0
2018-04-26	E7	Futures	1.3679	1.3731	1.3603	1.3614	5396.0
2018-04-26	EBM	Futures	177.2	178.54	176.93	178.28	25779.0
2018-04-26	ED	Futures	94.916	94.95	94.9111	94.9452	333801.0
2018-04-26	ER	Futures	98.342	98.342	98.337	98.337	39111.0
2018-04-26	EW	Futures	2004.4	2014.1	1995.3	2007.5	14944.0
2018-04-26	FBON	Futures	129.28	129.66	129.28	129.56	661.0
2018-04-26	FBTP	Futures	115.78	116.27	115.78	116.16	108546.0
2018-04-26	FBTS	Futures	104.241	104.306	104.241	104.287	48407.0
2018-04-26	FCE	Futures	4793.2	4840.0	4778.1	4820.9	64214.0
2018-04-26	FDAX	Futures	12942.4	13078.5	12873.8	13000.5	116461.0
2018-04-26	FDIV	Futures	150.25	151.24	150.25	151.24	50.0
2018-04-26	FDXM	Futures	12820.4	12962.5	12759.7	12884.8	37870.0
2018-04-26	FESX	Futures	2853.1	2878.9	2841.4	2867.2	863951.0
2018-04-26	FEU3	Futures	99.03	99.03	99.026	99.026	99.0
2018-04-26	FGBL	Futures	148.49	149.12	148.44	148.98	752359.0
2018-04-26	FGBM	Futures	129.18	129.45	129.15	129.38	480503.0
2018-04-26	FGBS	Futures	112.457	112.492	112.447	112.477	338066.0
2018-04-26	FGBX	Futures	167.45	169.0	167.43	168.73	51841.0
2018-04-26	FMWO	Futures	6901.2	6965.5	6901.2	6936.3	371.0
2018-04-26	FOAT	Futures	137.8	138.35	137.75	138.24	141700.0
2018-04-26	FTDX	Futures	2542.0	2594.4	2538.5	2582.0	115.0
2018-04-26	FTI	Futures	506.42	510.67	503.28	508.41	26903.0
2018-04-26	FTUK	Futures	6487.1	6540.1	6458.4	6514.1	112171.0
2018-04-26	FVSA	Futures	354.75	360.49	336.38	338.68	21684.0
2018-04-26	FXXP	Futures	324.8	329.0	324.1	327.9	30625.0
2018-04-26	G	Futures	112.7	113.07	112.68	112.96	192586.0
2018-04-26	GF	Futures	304.992	305.638	301.495	301.926	2419.0

> showing 50 of 113 rows — these rows as CSV

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