PREVIEW / futures_daily / 2018-01-22

all futures daily files

  file:    by_date/futures_daily/2018/2018-01-22.parquet
  size:    9 KB
  rows:    108

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-22	ES	Futures	3047.61	3084.83	3045.43	3081.57	1179414.0
2018-01-22	NQ	Futures	8000.03	8129.45	7992.42	8117.45	262762.0
2018-01-22	YM	Futures	27399.7	27657.1	27360.7	27625.4	140635.0
2018-01-22	CL	Futures	63.48	64.11	63.03	63.55	625662.0
2018-01-22	GC	Futures	1691.2	1693.5	1683.6	1688.6	337481.0
2018-01-22	ZN	Futures	120.725665	120.802796	120.494271	120.54055	1455296.0
2018-01-22	A6	Futures	0.82271	0.82559	0.82055	0.82394	82879.0
2018-01-22	AD	Futures	0.81391	0.81701	0.8129	0.81579	36601.0
2018-01-22	B	Futures	49.26	49.77	48.97	49.43	250603.0
2018-01-22	B6	Futures	1.4484	1.4578	1.4439	1.4568	117345.0
2018-01-22	BR	Futures	0.23685	0.23685	0.23579	0.23598	1125.0
2018-01-22	BTC	Futures	14472.0	15150.8	12749.5	13261.7	1137.0
2018-01-22	BZ	Futures	48.58	49.1	48.3	48.76	23250.0
2018-01-22	C	Futures	1263.0	1271.0	1250.0	1253.0	9458.0
2018-01-22	CB	Futures	268.892	269.356	268.707	268.738	33.0
2018-01-22	CC	Futures	1447.0	1474.0	1433.0	1446.0	19359.0
2018-01-22	CSC	Futures	3.176	3.18	3.144	3.169	50.0
2018-01-22	CT	Futures	97.35	98.05	96.94	97.42	17156.0
2018-01-22	DC	Futures	25.17	25.22	24.96	25.18	288.0
2018-01-22	DX	Futures	84.773	84.989	84.651	84.698	16701.0
2018-01-22	E1	Futures	1.26733	1.27049	1.2643	1.26648	22652.0
2018-01-22	E6	Futures	1.39419	1.39543	1.38931	1.39436	173513.0
2018-01-22	E7	Futures	1.3865	1.3883	1.3823	1.3874	4494.0
2018-01-22	EBM	Futures	168.04	168.3	167.5	168.04	10226.0
2018-01-22	ED	Futures	95.3165	95.331	95.3116	95.3213	440428.0
2018-01-22	ER	Futures	98.332	98.337	98.332	98.332	29331.0
2018-01-22	EW	Futures	2094.7	2114.0	2091.0	2111.3	12397.0
2018-01-22	FBON	Futures	127.28	127.55	126.87	127.26	593.0
2018-01-22	FBTP	Futures	111.61	112.18	111.61	112.04	86144.0
2018-01-22	FBTS	Futures	103.604	103.668	103.595	103.65	38003.0
2018-01-22	FCE	Futures	4931.6	4954.8	4912.0	4939.7	53330.0
2018-01-22	FDAX	Futures	13956.6	14021.5	13906.3	13950.4	65647.0
2018-01-22	FDXM	Futures	13981.9	14043.2	13930.9	13974.1	19744.0
2018-01-22	FESX	Futures	2977.7	2998.1	2969.5	2985.0	734868.0
2018-01-22	FGBL	Futures	148.8	149.05	148.64	148.97	432972.0
2018-01-22	FGBM	Futures	129.06	129.12	128.97	129.1	355891.0
2018-01-22	FGBS	Futures	112.331	112.342	112.321	112.342	185331.0
2018-01-22	FGBX	Futures	166.5	167.49	166.32	167.26	34741.0
2018-01-22	FMWO	Futures	7280.6	7326.2	7277.1	7304.0	1194.0
2018-01-22	FOAT	Futures	137.43	137.67	137.27	137.59	64804.0
2018-01-22	FTDX	Futures	2701.9	2712.4	2695.0	2700.4	120.0
2018-01-22	FTI	Futures	528.27	530.6	526.93	528.69	16585.0
2018-01-22	FTUK	Futures	6700.0	6713.5	6681.6	6686.0	85421.0
2018-01-22	FVSA	Futures	254.65	258.95	245.19	247.77	16651.0
2018-01-22	FXXP	Futures	340.9	342.4	340.1	341.4	31751.0
2018-01-22	G	Futures	114.0	114.05	113.7	113.84	154453.0
2018-01-22	GF	Futures	321.599	321.984	319.458	320.227	4267.0
2018-01-22	GSCI	Futures	521.16	523.23	520.4	522.6	105.0
2018-01-22	HE	Futures	96.98	97.172	96.434	96.466	10583.0
2018-01-22	HG	Futures	3.8144	3.8527	3.806	3.8288	85886.0

> showing 50 of 108 rows — these rows as CSV

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