PREVIEW / futures_daily / 2018-01-10

all futures daily files

  file:    by_date/futures_daily/2018/2018-01-10.parquet
  size:    9 KB
  rows:    111

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-10	ES	Futures	2988.65	2991.09	2974.24	2989.46	1289898.0
2018-01-10	NQ	Futures	7823.19	7831.39	7762.87	7820.26	320261.0
2018-01-10	YM	Futures	26738.5	26770.1	26599.3	26735.3	143641.0
2018-01-10	CL	Futures	63.39	63.65	63.07	63.55	697844.0
2018-01-10	GC	Futures	1665.0	1684.4	1659.4	1672.6	391661.0
2018-01-10	ZN	Futures	121.419845	121.527828	121.142173	121.435271	2134251.0
2018-01-10	A6	Futures	0.8045	0.80902	0.80296	0.80594	131728.0
2018-01-10	AD	Futures	0.81539	0.81757	0.80742	0.80792	114043.0
2018-01-10	B	Futures	49.49	49.67	49.23	49.55	290542.0
2018-01-10	B6	Futures	1.4116	1.4136	1.4052	1.4081	110012.0
2018-01-10	BR	Futures	0.23214	0.23359	0.23214	0.23359	6799.0
2018-01-10	BTC	Futures	18448.6	18852.0	17264.0	18506.2	887.0
2018-01-10	BZ	Futures	48.86	48.99	48.56	48.88	21538.0
2018-01-10	C	Futures	1262.0	1285.0	1262.0	1284.0	9299.0
2018-01-10	CB	Futures	272.475	272.63	271.178	272.105	64.0
2018-01-10	CC	Futures	1422.0	1459.0	1418.0	1448.0	21757.0
2018-01-10	CNH	Futures	6.6916	6.6916	6.6699	6.676	6.0
2018-01-10	CSC	Futures	3.105	3.127	3.099	3.107	106.0
2018-01-10	CT	Futures	91.51	93.36	91.49	93.03	16686.0
2018-01-10	DC	Futures	24.43	24.59	24.31	24.39	126.0
2018-01-10	DX	Futures	86.609	86.665	86.069	86.463	24556.0
2018-01-10	E1	Futures	1.24062	1.25046	1.23868	1.24694	31100.0
2018-01-10	E6	Futures	1.3587	1.36788	1.35711	1.36108	292236.0
2018-01-10	E7	Futures	1.3515	1.361	1.3503	1.3542	5742.0
2018-01-10	EBM	Futures	173.97	174.51	173.43	173.7	13974.0
2018-01-10	ED	Futures	95.3553	95.3602	95.3407	95.3553	338772.0
2018-01-10	ER	Futures	98.337	98.337	98.332	98.332	29212.0
2018-01-10	EW	Futures	2060.0	2061.3	2046.9	2052.2	12896.0
2018-01-10	FBON	Futures	126.29	126.39	125.76	125.8	299.0
2018-01-10	FBTP	Futures	110.8	111.02	110.57	110.71	166994.0
2018-01-10	FBTS	Futures	103.567	103.613	103.567	103.595	51870.0
2018-01-10	FCE	Futures	4941.1	4945.1	4906.2	4923.2	75872.0
2018-01-10	FDAX	Futures	13868.9	13877.8	13714.4	13765.2	86878.0
2018-01-10	FDXM	Futures	13894.6	13900.8	13736.6	13788.6	31146.0
2018-01-10	FESX	Futures	2948.3	2952.4	2929.5	2936.8	1116372.0
2018-01-10	FEU3	Futures	99.011	99.011	99.011	99.011	3.0
2018-01-10	FGBL	Futures	149.21	149.56	149.13	149.28	870619.0
2018-01-10	FGBM	Futures	129.31	129.43	129.29	129.33	535663.0
2018-01-10	FGBS	Futures	112.357	112.382	112.357	112.367	339142.0
2018-01-10	FGBX	Futures	166.56	167.82	166.17	166.69	57946.0
2018-01-10	FMWO	Futures	7127.7	7130.1	7114.9	7124.2	2553.0
2018-01-10	FOAT	Futures	137.76	138.05	137.64	137.83	119581.0
2018-01-10	FTDX	Futures	2669.5	2669.5	2625.1	2636.1	311.0
2018-01-10	FTI	Futures	521.12	521.49	518.05	519.17	178.0
2018-01-10	FTUK	Futures	6704.4	6725.8	6689.9	6710.0	91733.0
2018-01-10	FVSA	Futures	254.95	258.11	248.63	253.89	27897.0
2018-01-10	FXXP	Futures	339.3	339.6	337.6	338.0	36327.0
2018-01-10	G	Futures	114.42	114.63	114.31	114.47	196329.0
2018-01-10	GF	Futures	314.517	317.153	311.169	312.321	6040.0
2018-01-10	GSCI	Futures	521.73	522.02	519.13	519.48	3817.0

> showing 50 of 111 rows — these rows as CSV

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