PREVIEW / futures_daily / 2018-02-26

all futures daily files

  file:    by_date/futures_daily/2018/2018-02-26.parquet
  size:    9 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-02-26	ES	Futures	2990.55	3028.04	2980.77	3026.41	1256268.0
2018-02-26	NQ	Futures	8102.51	8207.04	8069.43	8198.26	297831.0
2018-02-26	YM	Futures	26711.1	27181.4	26681.6	27164.6	192591.0
2018-02-26	CL	Futures	64.05	64.69	63.51	64.36	469853.0
2018-02-26	GC	Futures	1699.4	1715.3	1696.3	1702.4	247243.0
2018-02-26	ZN	Futures	119.198468	119.47614	119.121337	119.291025	2811227.0
2018-02-26	A6	Futures	0.80676	0.8119	0.80501	0.80738	85882.0
2018-02-26	AD	Futures	0.80315	0.80503	0.79884	0.80092	58413.0
2018-02-26	B	Futures	48.37	48.84	47.99	48.56	269161.0
2018-02-26	B6	Futures	1.4542	1.4646	1.4496	1.4534	102490.0
2018-02-26	BR	Futures	0.23302	0.23302	0.23302	0.23302	802.0
2018-02-26	BTC	Futures	13428.0	14412.9	12859.2	14218.7	745.0
2018-02-26	BZ	Futures	47.79	48.23	47.4	47.97	23886.0
2018-02-26	C	Futures	1404.0	1423.0	1386.0	1419.0	7239.0
2018-02-26	CB	Futures	286.621	291.347	286.621	291.316	49.0
2018-02-26	CC	Futures	1616.0	1629.0	1585.0	1625.0	22935.0
2018-02-26	CNH	Futures	6.4493	6.4493	6.4293	6.4293	89.0
2018-02-26	CSC	Futures	3.306	3.314	3.277	3.304	18.0
2018-02-26	CT	Futures	93.5	94.85	93.11	94.43	21352.0
2018-02-26	DC	Futures	26.19	26.24	26.05	26.22	43.0
2018-02-26	DX	Futures	84.406	84.519	83.979	84.322	20834.0
2018-02-26	E1	Futures	1.29756	1.30375	1.29477	1.29622	17970.0
2018-02-26	E6	Futures	1.39504	1.40252	1.39379	1.39753	177858.0
2018-02-26	E7	Futures	1.3881	1.3955	1.3867	1.3906	2994.0
2018-02-26	EBM	Futures	176.13	177.48	176.13	176.94	13417.0
2018-02-26	ED	Futures	95.0907	95.0955	95.064	95.0664	398042.0
2018-02-26	ER	Futures	98.332	98.332	98.328	98.328	39461.0
2018-02-26	EW	Futures	2020.2	2034.5	2010.8	2030.4	9761.0
2018-02-26	FBON	Futures	126.0	126.38	126.0	126.34	239.0
2018-02-26	FBTP	Futures	111.01	111.53	110.95	111.4	81836.0
2018-02-26	FBTS	Futures	103.549	103.604	103.549	103.595	41029.0
2018-02-26	FCE	Futures	4717.2	4741.9	4705.7	4719.0	47027.0
2018-02-26	FDAX	Futures	13039.0	13070.1	12944.0	13008.4	75762.0
2018-02-26	FDXM	Futures	13061.1	13093.3	12966.5	13030.4	23966.0
2018-02-26	FESX	Futures	2825.7	2842.9	2818.4	2831.5	692313.0
2018-02-26	FEU3	Futures	99.001	99.006	99.001	99.006	50.0
2018-02-26	FGBL	Futures	147.96	147.98	147.59	147.88	679178.0
2018-02-26	FGBM	Futures	128.83	128.87	128.71	128.8	411230.0
2018-02-26	FGBS	Futures	112.372	112.372	112.331	112.352	309479.0
2018-02-26	FGBX	Futures	166.66	166.91	166.03	166.73	50148.0
2018-02-26	FMWO	Futures	7110.2	7145.3	7084.6	7112.6	2466.0
2018-02-26	FOAT	Futures	136.76	136.79	136.51	136.68	98369.0
2018-02-26	FTDX	Futures	2610.7	2627.1	2597.2	2608.7	126.0
2018-02-26	FTI	Futures	492.49	496.85	492.31	494.14	15409.0
2018-02-26	FTUK	Futures	6334.8	6385.5	6327.4	6362.8	73824.0
2018-02-26	FVSA	Futures	412.43	419.81	392.73	397.65	20736.0
2018-02-26	FXXP	Futures	325.9	327.4	325.3	326.5	22629.0
2018-02-26	G	Futures	112.46	112.75	112.35	112.73	280784.0
2018-02-26	GF	Futures	319.458	321.929	317.866	319.623	3823.0
2018-02-26	GSCI	Futures	515.54	516.45	512.98	515.82	15.0

> showing 50 of 111 rows — these rows as CSV

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