PREVIEW / futures_daily / 2017-03-01

all futures daily files

  file:    by_date/futures_daily/2017/2017-03-01.parquet
  size:    9 KB
  rows:    110

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
2017-03-01	ES	Futures	2563.35	2602.92	2562.0	2594.79	2171551.0
2017-03-01	NQ	Futures	6287.29	6364.48	6284.34	6347.98	241769.0
2017-03-01	YM	Futures	21946.5	22289.9	21919.1	22215.1	204334.0
2017-03-01	CL	Futures	57.25	57.77	56.91	57.12	491289.0
2017-03-01	GC	Futures	1594.9	1598.6	1580.5	1596.9	318035.0
2017-03-01	ZN	Futures	122.057594	122.057594	121.446312	121.553287	141988.0
2017-03-01	A6	Futures	0.78344	0.78836	0.7817	0.7857	102930.0
2017-03-01	AD	Futures	0.76724	0.76897	0.76468	0.76494	84262.0
2017-03-01	ALI	Futures	2628.1	2628.1	2628.1	2628.1	0.0
2017-03-01	B	Futures	41.22	41.66	41.07	41.16	261742.0
2017-03-01	B6	Futures	1.2986	1.3015	1.2883	1.2885	138277.0
2017-03-01	BFX	Futures	4426.9	4431.7	4426.9	4431.7	12.0
2017-03-01	BR	Futures	0.22738	0.22908	0.22738	0.22908	55.0
2017-03-01	BZ	Futures	41.07	41.47	40.87	40.97	25932.0
2017-03-01	C	Futures	1587.0	1603.0	1578.0	1581.0	7737.0
2017-03-01	CB	Futures	280.122	286.225	277.834	281.953	72.0
2017-03-01	CC	Futures	1454.0	1468.0	1441.0	1448.0	21694.0
2017-03-01	CNH	Futures	7.2472	7.2621	7.2472	7.254	42.0
2017-03-01	CSC	Futures	3.741	3.741	3.681	3.706	120.0
2017-03-01	CT	Futures	85.35	86.92	84.9	86.79	22174.0
2017-03-01	DC	Futures	30.69	30.71	30.01	30.16	171.0
2017-03-01	DX	Futures	94.482	94.952	94.245	94.766	54886.0
2017-03-01	E1	Futures	1.23268	1.23355	1.22413	1.22897	27503.0
2017-03-01	E6	Futures	1.22166	1.22374	1.21491	1.21837	243721.0
2017-03-01	E7	Futures	1.2154	1.2175	1.2087	1.2121	4928.0
2017-03-01	EBM	Futures	197.12	199.11	197.12	198.55	9425.0
2017-03-01	ED	Futures	95.4868	95.4965	95.4723	95.4916	574502.0
2017-03-01	ER	Futures	98.303	98.308	98.303	98.303	57130.0
2017-03-01	EW	Futures	1840.9	1874.6	1840.8	1870.8	21503.0
2017-03-01	FBON	Futures	121.19	121.52	121.0	121.04	1490.0
2017-03-01	FBTP	Futures	105.06	105.14	104.68	104.77	168143.0
2017-03-01	FBTS	Futures	101.674	101.71	101.62	101.701	58336.0
2017-03-01	FCE	Futures	4288.8	4376.8	4287.1	4364.9	128877.0
2017-03-01	FDAX	Futures	12524.4	12772.5	12516.5	12732.9	95034.0
2017-03-01	FDXM	Futures	12471.3	12721.5	12467.1	12681.6	30616.0
2017-03-01	FESX	Futures	2663.1	2719.1	2661.5	2709.5	1300394.0
2017-03-01	FEU3	Futures	98.976	98.976	98.976	98.976	1.0
2017-03-01	FGBL	Futures	149.51	149.62	148.58	148.74	1406475.0
2017-03-01	FGBM	Futures	130.13	130.19	129.69	129.73	1137567.0
2017-03-01	FGBS	Futures	112.492	112.492	112.362	112.372	683211.0
2017-03-01	FGBX	Futures	170.88	171.1	168.35	168.69	97351.0
2017-03-01	FMWO	Futures	6159.0	6218.1	6159.0	6216.9	1128.0
2017-03-01	FOAT	Futures	132.12	132.31	131.72	131.85	303206.0
2017-03-01	FTDX	Futures	1872.0	1892.1	1871.0	1889.6	119.0
2017-03-01	FTI	Futures	451.7	460.25	451.48	458.84	39085.0
2017-03-01	FTUK	Futures	6159.3	6260.2	6156.4	6243.3	143081.0
2017-03-01	FVSA	Futures	705.19	705.19	677.99	692.64	16222.0
2017-03-01	FXXP	Futures	307.5	311.9	307.3	311.0	33715.0
2017-03-01	G	Futures	114.46	114.57	114.15	114.22	240511.0
2017-03-01	GF	Futures	285.138	287.019	282.516	283.827	2450.0

> showing 50 of 110 rows — these rows as CSV

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