PREVIEW / futures_daily / 2017-01-24

all futures daily files

  file:    by_date/futures_daily/2017/2017-01-24.parquet
  size:    9 KB
  rows:    109

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
2017-01-24	ES	Futures	2450.88	2472.29	2449.52	2465.78	1273116.0
2017-01-24	NQ	Futures	5968.18	6015.62	5963.76	6006.48	141578.0
2017-01-24	YM	Futures	20776.3	20941.7	20768.9	20901.6	121989.0
2017-01-24	CL	Futures	56.57	57.32	56.36	56.91	520285.0
2017-01-24	GC	Futures	1564.2	1566.9	1549.0	1554.9	216007.0
2017-01-24	ZN	Futures	122.118722	122.195132	121.476876	121.492158	1168462.0
2017-01-24	A6	Futures	0.7772	0.77843	0.77259	0.77535	80965.0
2017-01-24	AD	Futures	0.77255	0.7797	0.76841	0.77704	82086.0
2017-01-24	ALI	Futures	2512.05	2545.74	2512.05	2539.97	29.0
2017-01-24	B	Futures	41.21	41.49	40.93	41.19	233418.0
2017-01-24	B6	Futures	1.3164	1.3171	1.3039	1.3128	111884.0
2017-01-24	BR	Futures	0.22258	0.22301	0.22194	0.22251	357.0
2017-01-24	BZ	Futures	40.95	41.26	40.73	40.98	19474.0
2017-01-24	C	Futures	1812.0	1834.0	1805.0	1822.0	6743.0
2017-01-24	CB	Futures	274.325	274.325	272.555	274.325	21.0
2017-01-24	CC	Futures	1649.0	1680.0	1634.0	1676.0	18059.0
2017-01-24	CNH	Futures	7.2419	7.2725	7.2403	7.2574	56.0
2017-01-24	CSC	Futures	3.967	3.997	3.935	3.96	169.0
2017-01-24	CT	Futures	85.74	86.16	83.32	84.51	30020.0
2017-01-24	DC	Futures	33.0	33.07	32.63	32.8	542.0
2017-01-24	DX	Futures	93.09	93.477	93.002	93.424	29391.0
2017-01-24	E1	Futures	1.24706	1.24781	1.24012	1.24037	14169.0
2017-01-24	E6	Futures	1.24633	1.24708	1.24067	1.2409	148585.0
2017-01-24	E7	Futures	1.2401	1.2405	1.2343	1.2345	2625.0
2017-01-24	EBM	Futures	193.99	194.27	193.42	193.7	17031.0
2017-01-24	ED	Futures	95.5617	95.5665	95.5472	95.5472	238702.0
2017-01-24	ER	Futures	98.308	98.313	98.303	98.308	43493.0
2017-01-24	EW	Futures	1779.6	1810.0	1777.7	1805.0	21211.0
2017-01-24	FBON	Futures	122.36	122.36	121.63	121.94	1467.0
2017-01-24	FBTP	Futures	105.8	105.94	105.33	105.55	92385.0
2017-01-24	FBTS	Futures	101.837	101.855	101.819	101.837	19168.0
2017-01-24	FCE	Futures	4258.0	4275.7	4240.9	4252.3	70814.0
2017-01-24	FDAX	Futures	12217.2	12292.7	12180.8	12231.5	61726.0
2017-01-24	FDXM	Futures	12166.4	12241.1	12130.7	12182.2	16538.0
2017-01-24	FESX	Futures	2620.7	2633.5	2608.7	2618.3	635428.0
2017-01-24	FEU3	Futures	98.976	98.976	98.976	98.976	3.0
2017-01-24	FGBL	Futures	147.13	147.21	146.53	146.78	723034.0
2017-01-24	FGBM	Futures	128.83	128.84	128.63	128.69	408825.0
2017-01-24	FGBS	Futures	112.057	112.067	112.032	112.042	194220.0
2017-01-24	FGBX	Futures	165.84	166.25	164.69	165.42	46048.0
2017-01-24	FMWO	Futures	5952.8	5978.1	5951.5	5969.6	742.0
2017-01-24	FOAT	Futures	132.25	132.36	131.81	132.05	123650.0
2017-01-24	FTDX	Futures	1800.4	1802.4	1792.1	1798.4	56.0
2017-01-24	FTI	Futures	440.05	441.51	438.32	439.23	23145.0
2017-01-24	FTUK	Futures	6026.6	6039.3	6003.7	6010.9	85545.0
2017-01-24	FVSA	Futures	859.74	873.95	836.05	843.16	13808.0
2017-01-24	FXXP	Futures	298.7	300.1	298.2	298.8	20407.0
2017-01-24	G	Futures	111.11	111.34	110.93	111.08	195831.0
2017-01-24	GF	Futures	297.734	299.386	294.485	296.765	4503.0
2017-01-24	GSCI	Futures	530.13	530.13	527.63	527.63	23.0

> showing 50 of 109 rows — these rows as CSV

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