PREVIEW / futures_daily / 2018-01-16

all futures daily files

  file:    by_date/futures_daily/2018/2018-01-16.parquet
  size:    10 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-16	ES	Futures	3032.12	3052.5	3009.84	3024.24	1981469.0
2018-01-16	NQ	Futures	7942.35	8017.6	7881.16	7919.81	516270.0
2018-01-16	YM	Futures	27222.6	27484.1	27084.4	27228.9	309926.0
2018-01-16	CL	Futures	64.31	64.81	63.32	63.65	458597.0
2018-01-16	GC	Futures	1695.4	1705.2	1688.8	1695.2	499759.0
2018-01-16	ZN	Futures	121.35814	121.589533	121.281009	121.419845	1402869.0
2018-01-16	A6	Futures	0.81406	0.82055	0.81314	0.81859	174459.0
2018-01-16	AD	Futures	0.8162	0.8195	0.81462	0.81752	100773.0
2018-01-16	B	Futures	50.16	50.21	49.28	49.51	322952.0
2018-01-16	B6	Futures	1.4329	1.4403	1.4307	1.4375	187127.0
2018-01-16	BR	Futures	0.23723	0.23723	0.23366	0.23408	489.0
2018-01-16	BTC	Futures	17417.6	18288.5	14292.7	14292.7	2552.0
2018-01-16	BZ	Futures	49.38	49.7	48.62	48.84	33284.0
2018-01-16	C	Futures	1284.0	1288.0	1255.0	1272.0	11622.0
2018-01-16	CB	Futures	270.591	270.591	270.56	270.591	12.0
2018-01-16	CC	Futures	1453.0	1456.0	1418.0	1441.0	25335.0
2018-01-16	CNH	Futures	6.5774	6.5935	6.5759	6.5862	73.0
2018-01-16	CSC	Futures	3.107	3.159	3.105	3.152	84.0
2018-01-16	CT	Futures	95.56	95.83	94.16	95.11	19313.0
2018-01-16	DC	Futures	24.39	24.92	24.3	24.85	282.0
2018-01-16	DX	Futures	84.759	85.064	84.618	84.656	27966.0
2018-01-16	E1	Futures	1.26065	1.27255	1.25895	1.27097	54644.0
2018-01-16	E6	Futures	1.38869	1.39923	1.38682	1.39628	546081.0
2018-01-16	E7	Futures	1.3826	1.392	1.3798	1.3893	12890.0
2018-01-16	EBM	Futures	168.04	168.04	166.69	166.69	24710.0
2018-01-16	ED	Futures	95.3359	95.3359	95.3067	95.3116	496691.0
2018-01-16	ER	Futures	98.332	98.337	98.332	98.332	30631.0
2018-01-16	EW	Futures	2088.1	2098.1	2067.3	2070.8	22369.0
2018-01-16	FBON	Futures	125.96	126.46	125.96	126.19	187.0
2018-01-16	FBTP	Futures	111.21	112.01	111.21	111.59	112543.0
2018-01-16	FBTS	Futures	103.54	103.65	103.54	103.595	46754.0
2018-01-16	FCE	Futures	4915.6	4933.9	4877.7	4913.8	188467.0
2018-01-16	FDAX	Futures	13711.3	13846.1	13616.8	13718.0	104375.0
2018-01-16	FDXM	Futures	13733.5	13868.6	13642.0	13741.3	37894.0
2018-01-16	FESX	Futures	2945.0	2964.6	2927.0	2946.6	1013513.0
2018-01-16	FEU3	Futures	99.011	99.011	99.006	99.006	58.0
2018-01-16	FGBL	Futures	148.71	149.19	148.67	149.0	632976.0
2018-01-16	FGBM	Futures	128.89	129.04	128.88	128.96	505385.0
2018-01-16	FGBS	Futures	112.276	112.296	112.261	112.271	302985.0
2018-01-16	FGBX	Futures	166.62	168.31	166.54	167.73	58418.0
2018-01-16	FMWO	Futures	7259.6	7269.0	7198.9	7246.8	4063.0
2018-01-16	FOAT	Futures	137.37	137.91	137.36	137.67	105611.0
2018-01-16	FTDX	Futures	2648.1	2661.6	2619.7	2636.6	197.0
2018-01-16	FTI	Futures	520.14	521.26	516.29	519.82	33701.0
2018-01-16	FTUK	Futures	6734.1	6757.6	6689.1	6718.8	117711.0
2018-01-16	FVSA	Futures	242.6	248.63	235.72	240.02	45414.0
2018-01-16	FXXP	Futures	338.4	339.6	336.0	338.0	27989.0
2018-01-16	G	Futures	114.23	114.54	114.18	114.29	154251.0
2018-01-16	GF	Futures	313.474	316.549	312.047	316.055	5052.0
2018-01-16	GSCI	Futures	523.52	524.45	520.58	521.79	499.0

> showing 50 of 112 rows — these rows as CSV

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