PREVIEW / futures_daily / 2018-04-10

all futures daily files

  file:    by_date/futures_daily/2018/2018-04-10.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-04-10	ES	Futures	2846.72	2899.46	2840.74	2887.23	1998582.0
2018-04-10	NQ	Futures	7596.7	7785.43	7574.75	7753.24	542219.0
2018-04-10	YM	Futures	25285.8	25789.4	25225.8	25651.4	358832.0
2018-04-10	CL	Futures	63.57	66.14	63.47	65.79	840280.0
2018-04-10	GC	Futures	1710.5	1718.7	1703.3	1718.3	285177.0
2018-04-10	ZN	Futures	120.020917	120.09846	119.788288	119.865831	1160672.0
2018-04-10	A6	Futures	0.79195	0.79884	0.79124	0.79874	107765.0
2018-04-10	AD	Futures	0.79765	0.80473	0.79714	0.80443	87114.0
2018-04-10	B	Futures	49.76	51.86	49.76	51.64	452335.0
2018-04-10	B6	Futures	1.4676	1.4734	1.4664	1.473	83354.0
2018-04-10	BR	Futures	0.22247	0.22277	0.22128	0.22277	423.0
2018-04-10	BTC	Futures	9522.2	9770.7	9429.9	9713.9	1882.0
2018-04-10	BZ	Futures	49.19	51.17	49.13	50.97	45123.0
2018-04-10	C	Futures	1608.0	1613.0	1581.0	1597.0	4508.0
2018-04-10	CB	Futures	295.238	296.813	292.613	292.829	33.0
2018-04-10	CC	Futures	1867.0	1869.0	1825.0	1845.0	31529.0
2018-04-10	CNH	Futures	6.3876	6.3928	6.377	6.377	48.0
2018-04-10	CSC	Futures	3.417	3.425	3.396	3.406	21.0
2018-04-10	CT	Futures	95.27	96.08	94.61	96.01	30865.0
2018-04-10	DC	Futures	27.17	27.46	27.17	27.26	209.0
2018-04-10	DX	Futures	84.453	84.566	84.156	84.203	21988.0
2018-04-10	E1	Futures	1.26681	1.2703	1.26404	1.26584	22297.0
2018-04-10	E6	Futures	1.3951	1.40124	1.39274	1.39927	228800.0
2018-04-10	E7	Futures	1.388	1.3938	1.3853	1.3918	3108.0
2018-04-10	EBM	Futures	179.89	180.69	179.35	179.89	21791.0
2018-04-10	ED	Futures	95.0035	95.0132	94.9889	94.9889	228399.0
2018-04-10	ER	Futures	98.337	98.342	98.332	98.337	123032.0
2018-04-10	EW	Futures	1969.3	2005.1	1964.5	1997.6	18420.0
2018-04-10	FBON	Futures	130.12	130.12	129.62	129.65	626.0
2018-04-10	FBTP	Futures	115.79	115.9	115.44	115.52	86085.0
2018-04-10	FBTS	Futures	104.25	104.25	104.158	104.176	49307.0
2018-04-10	FCE	Futures	4672.6	4677.9	4648.3	4672.6	63871.0
2018-04-10	FDAX	Futures	12879.5	12920.0	12820.3	12890.9	99475.0
2018-04-10	FDIV	Futures	149.53	149.71	149.53	149.71	5.0
2018-04-10	FDXM	Futures	12755.5	12806.0	12706.1	12776.1	37521.0
2018-04-10	FESX	Futures	2799.8	2803.9	2786.4	2798.9	906856.0
2018-04-10	FGBL	Futures	149.95	150.18	149.63	149.67	877264.0
2018-04-10	FGBM	Futures	129.66	129.76	129.46	129.52	626417.0
2018-04-10	FGBS	Futures	112.517	112.532	112.462	112.467	409004.0
2018-04-10	FGBX	Futures	170.76	171.28	170.53	170.66	55662.0
2018-04-10	FMWO	Futures	6917.6	6945.6	6890.7	6929.3	1972.0
2018-04-10	FOAT	Futures	139.16	139.33	138.73	138.75	165718.0
2018-04-10	FTDX	Futures	2522.7	2540.0	2514.3	2539.0	103.0
2018-04-10	FTI	Futures	494.6	496.59	493.82	496.59	24.0
2018-04-10	FTUK	Futures	6277.3	6361.2	6269.3	6352.4	101594.0
2018-04-10	FVSA	Futures	411.42	414.98	390.01	391.2	17883.0
2018-04-10	FXXP	Futures	321.2	322.0	320.1	321.9	68989.0
2018-04-10	G	Futures	113.83	113.97	113.65	113.78	257059.0
2018-04-10	GF	Futures	292.834	296.223	289.068	291.112	7366.0
2018-04-10	GSCI	Futures	515.65	520.89	514.35	520.1	3380.0

> showing 50 of 112 rows — these rows as CSV

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