PREVIEW / futures_daily / 2018-02-01

all futures daily files

  file:    by_date/futures_daily/2018/2018-02-01.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-02-01	ES	Futures	3074.51	3083.75	3053.59	3067.72	1646906.0
2018-02-01	NQ	Futures	8166.64	8183.91	8063.28	8079.38	492861.0
2018-02-01	YM	Futures	27590.6	27715.1	27337.5	27601.2	290184.0
2018-02-01	CL	Futures	64.74	66.23	64.61	65.78	685750.0
2018-02-01	GC	Futures	1722.1	1729.9	1711.9	1721.7	310504.0
2018-02-01	ZN	Futures	120.124042	120.124042	119.537845	119.676681	2201452.0
2018-02-01	A6	Futures	0.82847	0.8297	0.82147	0.82641	157072.0
2018-02-01	AD	Futures	0.82518	0.82874	0.82376	0.82777	70472.0
2018-02-01	B	Futures	49.51	50.21	49.38	49.98	336923.0
2018-02-01	B6	Futures	1.4785	1.4875	1.4749	1.4859	140669.0
2018-02-01	BR	Futures	0.23848	0.23928	0.23685	0.23852	2252.0
2018-02-01	BTC	Futures	13038.4	13240.1	11034.5	11828.2	1485.0
2018-02-01	BZ	Futures	48.75	49.54	48.73	49.32	29317.0
2018-02-01	C	Futures	1272.0	1291.0	1269.0	1288.0	15006.0
2018-02-01	CB	Futures	268.584	268.584	265.649	266.113	43.0
2018-02-01	CC	Futures	1490.0	1520.0	1482.0	1505.0	30063.0
2018-02-01	CNH	Futures	6.4427	6.4447	6.4302	6.4302	48.0
2018-02-01	CSC	Futures	3.161	3.195	3.161	3.191	102.0
2018-02-01	CT	Futures	90.28	93.36	90.12	91.51	37574.0
2018-02-01	DC	Futures	25.09	25.42	25.09	25.39	396.0
2018-02-01	DX	Futures	83.519	83.74	83.002	83.115	23881.0
2018-02-01	E1	Futures	1.30727	1.31577	1.30375	1.31297	34808.0
2018-02-01	E6	Futures	1.41113	1.4236	1.4079	1.42134	297451.0
2018-02-01	E7	Futures	1.404	1.4164	1.4008	1.4142	6343.0
2018-02-01	EBM	Futures	169.92	170.19	168.3	168.57	20482.0
2018-02-01	ED	Futures	95.2922	95.297	95.2825	95.2873	284823.0
2018-02-01	ER	Futures	98.337	98.337	98.332	98.337	66005.0
2018-02-01	EW	Futures	2075.6	2082.3	2064.1	2076.5	20654.0
2018-02-01	FBON	Futures	126.76	127.08	126.63	126.94	605.0
2018-02-01	FBTP	Futures	110.98	111.92	110.82	111.72	173044.0
2018-02-01	FBTS	Futures	103.586	103.695	103.567	103.677	72593.0
2018-02-01	FCE	Futures	4907.1	4929.9	4841.6	4862.5	111345.0
2018-02-01	FDAX	Futures	13739.3	13792.2	13413.0	13455.5	137671.0
2018-02-01	FDXM	Futures	13760.5	13814.5	13436.3	13478.3	43646.0
2018-02-01	FESX	Futures	2953.2	2968.7	2910.7	2914.0	1354670.0
2018-02-01	FEU3	Futures	99.011	99.011	99.011	99.011	200.0
2018-02-01	FGBL	Futures	146.94	147.18	146.57	146.99	1078524.0
2018-02-01	FGBM	Futures	128.18	128.41	128.08	128.3	905596.0
2018-02-01	FGBS	Futures	112.206	112.256	112.186	112.246	607942.0
2018-02-01	FGBX	Futures	165.62	166.03	164.5	165.53	93905.0
2018-02-01	FMWO	Futures	7326.2	7336.7	7267.8	7291.1	1082.0
2018-02-01	FOAT	Futures	135.94	136.19	135.65	136.03	196118.0
2018-02-01	FTDX	Futures	2626.1	2665.0	2623.6	2627.1	656.0
2018-02-01	FTI	Futures	520.52	522.7	514.85	516.01	37135.0
2018-02-01	FTUK	Futures	6535.7	6558.9	6478.1	6489.4	142245.0
2018-02-01	FVSA	Futures	266.69	286.48	257.23	275.3	37117.0
2018-02-01	FXXP	Futures	337.5	338.7	333.6	333.9	36692.0
2018-02-01	G	Futures	112.31	112.39	112.05	112.33	259715.0
2018-02-01	GF	Futures	320.227	328.407	319.349	328.407	7172.0
2018-02-01	GSCI	Futures	529.64	531.49	528.37	531.49	199.0

> showing 50 of 112 rows — these rows as CSV

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