PREVIEW / futures_daily / 2018-01-04

all futures daily files

  file:    by_date/futures_daily/2018/2018-01-04.parquet
  size:    10 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-04	ES	Futures	2945.71	2966.09	2943.81	2960.39	1166017.0
2018-01-04	NQ	Futures	7710.75	7750.28	7706.36	7733.88	254577.0
2018-01-04	YM	Futures	26242.8	26451.6	26236.5	26421.1	115656.0
2018-01-04	CL	Futures	61.95	62.2	61.58	62.0	654363.0
2018-01-04	GC	Futures	1667.8	1682.7	1657.1	1675.5	369850.0
2018-01-04	ZN	Futures	122.191156	122.206583	121.851779	122.098599	1133647.0
2018-01-04	A6	Futures	0.80522	0.80913	0.80378	0.80892	97657.0
2018-01-04	AD	Futures	0.81051	0.81412	0.80945	0.8133	65005.0
2018-01-04	B	Futures	48.61	48.88	48.42	48.74	246148.0
2018-01-04	B6	Futures	1.4088	1.4135	1.4078	1.413	67604.0
2018-01-04	BFX	Futures	4799.9	4829.1	4799.9	4829.1	1.0
2018-01-04	BR	Futures	0.23397	0.23397	0.23347	0.23378	1703.0
2018-01-04	BTC	Futures	19114.6	19812.6	18192.5	19082.6	760.0
2018-01-04	BZ	Futures	48.03	48.21	47.7	48.08	22840.0
2018-01-04	C	Futures	1247.0	1253.0	1209.0	1250.0	13989.0
2018-01-04	CB	Futures	275.502	276.521	274.298	275.626	47.0
2018-01-04	CC	Futures	1404.0	1425.0	1370.0	1421.0	30322.0
2018-01-04	CNH	Futures	6.6539	6.6539	6.6415	6.6415	28.0
2018-01-04	CSC	Futures	3.191	3.195	3.167	3.195	92.0
2018-01-04	CT	Futures	91.23	92.72	91.17	92.56	15374.0
2018-01-04	DC	Futures	25.11	25.33	25.04	25.28	307.0
2018-01-04	DX	Futures	86.364	86.397	85.947	86.004	15731.0
2018-01-04	E1	Futures	1.24839	1.25289	1.2473	1.25155	17166.0
2018-01-04	E6	Futures	1.36766	1.37633	1.36664	1.37423	222465.0
2018-01-04	E7	Futures	1.3606	1.3694	1.3598	1.3673	3830.0
2018-01-04	EBM	Futures	172.35	173.43	172.35	173.16	18280.0
2018-01-04	ED	Futures	95.3796	95.3844	95.3456	95.3602	436804.0
2018-01-04	ER	Futures	98.332	98.337	98.332	98.332	60121.0
2018-01-04	EW	Futures	2041.0	2054.4	2040.3	2046.6	12177.0
2018-01-04	FBON	Futures	125.44	126.08	125.37	126.06	322.0
2018-01-04	FBTP	Futures	110.58	111.15	110.4	111.0	87485.0
2018-01-04	FBTS	Futures	103.485	103.549	103.457	103.54	54258.0
2018-01-04	FCE	Futures	4785.0	4857.5	4783.2	4841.4	89219.0
2018-01-04	FDAX	Futures	13507.9	13697.8	13503.2	13650.6	88384.0
2018-01-04	FDXM	Futures	13536.0	13720.0	13525.6	13673.7	24485.0
2018-01-04	FESX	Futures	2865.8	2916.4	2864.9	2905.0	1119985.0
2018-01-04	FGBL	Futures	149.62	149.91	149.45	149.76	642023.0
2018-01-04	FGBM	Futures	129.38	129.46	129.31	129.38	446829.0
2018-01-04	FGBS	Futures	112.367	112.372	112.342	112.352	213541.0
2018-01-04	FGBX	Futures	167.86	168.95	167.57	168.83	49508.0
2018-01-04	FMWO	Futures	7046.0	7090.4	7046.0	7076.4	2353.0
2018-01-04	FOAT	Futures	137.89	138.21	137.84	138.15	156424.0
2018-01-04	FTDX	Futures	2609.7	2617.7	2593.2	2612.7	408.0
2018-01-04	FTI	Futures	509.36	513.62	509.32	512.74	23519.0
2018-01-04	FTUK	Futures	6672.9	6679.5	6651.9	6672.9	86349.0
2018-01-04	FVSA	Futures	267.59	267.59	250.73	253.89	34848.0
2018-01-04	FXXP	Futures	332.3	334.8	332.3	334.3	57761.0
2018-01-04	G	Futures	114.95	115.11	114.82	114.96	165369.0
2018-01-04	GF	Futures	323.057	326.3	321.328	322.193	2256.0
2018-01-04	GSCI	Futures	520.92	520.92	520.16	520.86	461.0

> showing 50 of 111 rows — these rows as CSV

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