PREVIEW / futures_daily / 2017-06-01

all futures daily files

  file:    by_date/futures_daily/2017/2017-06-01.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
2017-06-01	ES	Futures	2621.44	2639.63	2617.91	2638.54	1432385.0
2017-06-01	NQ	Futures	6836.77	6859.45	6808.21	6857.09	266069.0
2017-06-01	YM	Futures	22191.2	22306.3	22143.8	22297.8	120297.0
2017-06-01	CL	Futures	50.37	50.93	49.61	50.09	774478.0
2017-06-01	GC	Futures	1623.3	1624.8	1613.2	1621.4	181198.0
2017-06-01	ZN	Futures	124.350628	124.381355	124.120178	124.335265	97166.0
2017-06-01	A6	Futures	0.76264	0.7651	0.75658	0.75689	116622.0
2017-06-01	AD	Futures	0.7558	0.75738	0.75411	0.75483	65227.0
2017-06-01	ALI	Futures	2541.09	2541.09	2541.09	2541.09	0.0
2017-06-01	B	Futures	36.4	36.6	35.73	36.02	462917.0
2017-06-01	B6	Futures	1.3506	1.3546	1.3456	1.3505	99087.0
2017-06-01	BR	Futures	0.22493	0.22493	0.22404	0.22404	104.0
2017-06-01	BZ	Futures	36.06	36.45	35.6	35.86	43640.0
2017-06-01	C	Futures	1594.0	1602.0	1545.0	1589.0	13029.0
2017-06-01	CB	Futures	301.674	302.89	300.214	301.43	45.0
2017-06-01	CC	Futures	1553.0	1558.0	1507.0	1547.0	28282.0
2017-06-01	CNH	Futures	7.084	7.084	7.0443	7.061	109.0
2017-06-01	CSC	Futures	3.645	3.645	3.602	3.616	29.0
2017-06-01	CT	Futures	85.23	86.17	85.07	85.97	15165.0
2017-06-01	DC	Futures	30.68	30.73	29.89	30.33	407.0
2017-06-01	DX	Futures	90.329	90.623	90.232	90.503	16409.0
2017-06-01	E1	Futures	1.27814	1.27876	1.27233	1.27307	23352.0
2017-06-01	E6	Futures	1.29597	1.29764	1.29118	1.2928	140453.0
2017-06-01	E7	Futures	1.2894	1.291	1.2847	1.2863	2887.0
2017-06-01	EBM	Futures	185.67	185.95	184.56	184.83	7804.0
2017-06-01	ED	Futures	95.593	95.593	95.576	95.5784	233531.0
2017-06-01	ER	Futures	98.337	98.337	98.332	98.337	34811.0
2017-06-01	EW	Futures	1830.3	1858.3	1828.3	1857.0	20125.0
2017-06-01	FBON	Futures	123.59	123.63	123.09	123.52	1391.0
2017-06-01	FBTP	Futures	106.75	106.76	106.12	106.46	232835.0
2017-06-01	FBTS	Futures	102.498	102.507	102.417	102.471	42813.0
2017-06-01	FCE	Futures	4742.1	4783.8	4733.5	4761.8	71769.0
2017-06-01	FDAX	Futures	13346.8	13403.8	13319.3	13370.5	70920.0
2017-06-01	FDXM	Futures	13236.3	13286.6	13202.8	13253.1	19031.0
2017-06-01	FESX	Futures	2904.3	2918.9	2896.1	2907.5	748660.0
2017-06-01	FGBL	Futures	149.06	149.18	148.84	149.14	889487.0
2017-06-01	FGBM	Futures	129.73	129.75	129.61	129.69	643487.0
2017-06-01	FGBS	Futures	112.352	112.362	112.322	112.327	413154.0
2017-06-01	FGBX	Futures	167.51	167.97	167.05	167.85	73079.0
2017-06-01	FMWO	Futures	6445.8	6475.9	6442.2	6454.3	2208.0
2017-06-01	FOAT	Futures	135.59	135.75	135.4	135.69	240376.0
2017-06-01	FTDX	Futures	2236.2	2289.1	2236.2	2265.1	271.0
2017-06-01	FTI	Futures	481.16	484.6	479.65	482.95	27496.0
2017-06-01	FTUK	Futures	6439.7	6473.9	6433.2	6449.1	108205.0
2017-06-01	FVSA	Futures	511.28	512.98	492.66	492.66	10721.0
2017-06-01	FXXP	Futures	329.4	331.3	328.4	330.2	33840.0
2017-06-01	G	Futures	116.02	116.09	115.63	115.85	200452.0
2017-06-01	GF	Futures	336.028	344.809	335.754	344.809	6003.0
2017-06-01	GSCI	Futures	465.22	466.14	462.88	464.23	254.0
2017-06-01	HE	Futures	88.638	88.664	86.701	87.178	17548.0

> showing 50 of 108 rows — these rows as CSV

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