PREVIEW / futures_daily / 2018-01-17

all futures daily files

  file:    by_date/futures_daily/2018/2018-01-17.parquet
  size:    9 KB
  rows:    110

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-17	ES	Futures	3024.51	3053.59	3020.44	3047.34	1541873.0
2018-01-17	NQ	Futures	7920.39	8004.13	7899.31	7991.84	357653.0
2018-01-17	YM	Futures	27238.4	27546.3	27182.5	27523.1	188028.0
2018-01-17	CL	Futures	63.8	64.12	63.23	63.9	369424.0
2018-01-17	GC	Futures	1697.6	1704.5	1681.8	1697.8	365867.0
2018-01-17	ZN	Futures	121.419845	121.496976	120.98791	121.095894	1448410.0
2018-01-17	A6	Futures	0.81839	0.82517	0.81664	0.82363	139602.0
2018-01-17	AD	Futures	0.81701	0.82193	0.81006	0.81894	138880.0
2018-01-17	B	Futures	49.66	49.83	49.08	49.68	280419.0
2018-01-17	B6	Futures	1.4371	1.4532	1.4337	1.4464	160512.0
2018-01-17	BR	Futures	0.23408	0.23495	0.23355	0.23495	979.0
2018-01-17	BTC	Futures	14331.1	15112.4	11814.5	14017.4	2657.0
2018-01-17	BZ	Futures	49.01	49.15	48.41	49.0	20500.0
2018-01-17	C	Futures	1271.0	1301.0	1260.0	1296.0	15754.0
2018-01-17	CB	Futures	270.56	272.259	270.56	271.024	36.0
2018-01-17	CC	Futures	1439.0	1491.0	1436.0	1481.0	32631.0
2018-01-17	CNH	Futures	6.5728	6.5874	6.5636	6.5757	12.0
2018-01-17	CSC	Futures	3.169	3.208	3.169	3.208	156.0
2018-01-17	CT	Futures	94.96	96.03	94.56	95.94	13635.0
2018-01-17	DC	Futures	24.92	25.54	24.78	25.44	520.0
2018-01-17	DX	Futures	84.51	85.172	84.482	84.813	33599.0
2018-01-17	E1	Futures	1.27049	1.27352	1.26235	1.2683	35131.0
2018-01-17	E6	Futures	1.39458	1.40218	1.38563	1.39254	324261.0
2018-01-17	E7	Futures	1.3876	1.3948	1.3786	1.3856	8962.0
2018-01-17	EBM	Futures	166.69	168.3	166.15	168.3	34544.0
2018-01-17	ED	Futures	95.3116	95.3165	95.3019	95.3116	335633.0
2018-01-17	ER	Futures	98.332	98.337	98.332	98.337	34765.0
2018-01-17	EW	Futures	2073.7	2092.0	2073.0	2087.5	15891.0
2018-01-17	FBON	Futures	126.19	126.34	125.99	126.26	189.0
2018-01-17	FBTP	Futures	111.65	111.67	111.11	111.29	118805.0
2018-01-17	FBTS	Futures	103.595	103.613	103.531	103.576	43042.0
2018-01-17	FCE	Futures	4891.5	4920.5	4887.5	4896.4	138523.0
2018-01-17	FDAX	Futures	13669.2	13748.1	13619.4	13652.6	88004.0
2018-01-17	FDXM	Futures	13691.9	13771.9	13643.1	13675.8	28031.0
2018-01-17	FESX	Futures	2936.0	2957.3	2934.4	2940.1	1025988.0
2018-01-17	FGBL	Futures	149.01	149.19	148.89	149.05	514464.0
2018-01-17	FGBM	Futures	128.98	129.03	128.92	128.99	447354.0
2018-01-17	FGBS	Futures	112.281	112.291	112.271	112.281	244054.0
2018-01-17	FGBX	Futures	167.9	168.56	167.69	168.11	47607.0
2018-01-17	FMWO	Futures	7225.8	7278.3	7217.6	7239.8	3158.0
2018-01-17	FOAT	Futures	137.69	137.79	137.57	137.65	81924.0
2018-01-17	FTDX	Futures	2637.6	2655.1	2628.1	2637.1	473.0
2018-01-17	FTI	Futures	517.36	524.65	517.36	521.77	26277.0
2018-01-17	FTUK	Futures	6703.9	6720.1	6686.4	6692.6	103614.0
2018-01-17	FVSA	Futures	241.74	252.93	240.02	250.35	26347.0
2018-01-17	FXXP	Futures	337.3	339.8	337.1	337.8	27710.0
2018-01-17	G	Futures	114.37	114.49	114.24	114.35	143661.0
2018-01-17	GF	Futures	315.341	323.686	314.023	320.556	9165.0
2018-01-17	GSCI	Futures	521.62	522.95	521.44	522.89	27.0
2018-01-17	HE	Futures	98.246	98.312	96.745	97.012	15177.0

> showing 50 of 110 rows — these rows as CSV

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