PREVIEW / futures_daily / 2017-06-05

all futures daily files

  file:    by_date/futures_daily/2017/2017-06-05.parquet
  size:    9 KB
  rows:    105

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-05	ES	Futures	2644.79	2648.86	2642.34	2643.97	891938.0
2017-06-05	NQ	Futures	6923.34	6938.65	6916.86	6926.29	177414.0
2017-06-05	YM	Futures	22353.7	22390.7	22331.6	22344.2	72057.0
2017-06-05	CL	Futures	49.42	50.15	48.54	49.1	710199.0
2017-06-05	GC	Futures	1637.3	1641.7	1634.3	1637.5	139801.0
2017-06-05	ZN	Futures	124.734711	124.811527	124.534988	124.611804	26275.0
2017-06-05	A6	Futures	0.76285	0.76972	0.76172	0.76859	80614.0
2017-06-05	AD	Futures	0.75631	0.75794	0.75549	0.75707	41968.0
2017-06-05	ALI	Futures	2501.76	2501.76	2501.76	2501.76	0.0
2017-06-05	B	Futures	35.48	36.1	34.89	35.19	348409.0
2017-06-05	B6	Futures	1.35	1.3572	1.3483	1.3536	76722.0
2017-06-05	BR	Futures	0.22312	0.22312	0.22126	0.22126	18.0
2017-06-05	BZ	Futures	35.39	35.94	34.75	35.04	38387.0
2017-06-05	C	Futures	1573.0	1577.0	1519.0	1559.0	16031.0
2017-06-05	CB	Futures	311.861	313.594	310.797	311.861	16.0
2017-06-05	CC	Futures	1530.0	1534.0	1476.0	1522.0	19478.0
2017-06-05	CNH	Futures	7.0721	7.0784	7.0721	7.0724	30.0
2017-06-05	CSC	Futures	3.581	3.59	3.577	3.59	46.0
2017-06-05	CT	Futures	85.0	85.31	84.48	84.51	15179.0
2017-06-05	DC	Futures	30.05	30.31	30.05	30.21	187.0
2017-06-05	DX	Futures	90.064	90.306	90.036	90.142	14973.0
2017-06-05	E1	Futures	1.28395	1.28444	1.2795	1.2816	16906.0
2017-06-05	E6	Futures	1.30005	1.30057	1.29487	1.29752	111446.0
2017-06-05	E7	Futures	1.2928	1.2936	1.2883	1.291	2078.0
2017-06-05	EBM	Futures	185.39	185.39	183.72	184.0	5117.0
2017-06-05	ED	Futures	95.5784	95.5857	95.576	95.5833	161957.0
2017-06-05	ER	Futures	98.337	98.337	98.332	98.337	30971.0
2017-06-05	EW	Futures	1858.5	1862.2	1850.4	1852.0	12229.0
2017-06-05	FBON	Futures	123.28	123.39	123.22	123.26	1557.0
2017-06-05	FBTP	Futures	106.34	106.56	106.01	106.27	153016.0
2017-06-05	FBTS	Futures	102.462	102.471	102.416	102.435	115043.0
2017-06-05	FCE	Futures	4788.3	4791.0	4751.9	4759.6	49482.0
2017-06-05	FESX	Futures	2927.9	2930.4	2908.3	2914.0	329088.0
2017-06-05	FGBL	Futures	149.52	149.57	149.27	149.43	724264.0
2017-06-05	FGBM	Futures	129.82	129.82	129.7	129.76	533390.0
2017-06-05	FGBS	Futures	112.357	112.357	112.317	112.337	524428.0
2017-06-05	FGBX	Futures	168.65	168.77	167.82	168.22	86021.0
2017-06-05	FMWO	Futures	6504.9	6508.5	6497.6	6500.0	1386.0
2017-06-05	FOAT	Futures	135.93	135.99	135.66	135.82	147111.0
2017-06-05	FTI	Futures	483.13	483.41	480.15	480.84	14387.0
2017-06-05	FTUK	Futures	6461.0	6463.6	6425.1	6429.8	72440.0
2017-06-05	FVSA	Futures	480.81	485.89	477.42	479.12	7881.0
2017-06-05	FXXP	Futures	331.1	331.4	329.6	329.8	10648.0
2017-06-05	G	Futures	116.06	116.11	115.74	115.95	116567.0
2017-06-05	GF	Futures	349.583	352.821	346.839	350.955	4855.0
2017-06-05	GSCI	Futures	457.09	458.57	457.09	458.26	951.0
2017-06-05	HE	Futures	86.913	87.55	85.321	85.374	16022.0
2017-06-05	HG	Futures	3.1567	3.1573	3.1144	3.1352	58097.0
2017-06-05	HH	Futures	19.52	19.591	18.947	19.198	5245.0
2017-06-05	HO	Futures	0.9894	1.0009	0.9692	0.9743	17814.0

> showing 50 of 105 rows — these rows as CSV

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