PREVIEW / futures_daily / 2017-09-20

all futures daily files

  file:    by_date/futures_daily/2017/2017-09-20.parquet
  size:    9 KB
  rows:    109

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-09-20	ES	Futures	2723.31	2727.12	2712.71	2724.95	1232948.0
2017-09-20	NQ	Futures	7044.15	7048.26	6966.03	7022.42	347504.0
2017-09-20	YM	Futures	23595.1	23642.7	23521.2	23628.9	118814.0
2017-09-20	CL	Futures	50.94	51.79	50.8	51.36	754413.0
2017-09-20	GC	Futures	1672.8	1679.3	1653.5	1675.0	351415.0
2017-09-20	ZN	Futures	124.179181	124.39485	123.763248	123.855677	1546871.0
2017-09-20	A6	Futures	0.82292	0.83301	0.82087	0.82364	136089.0
2017-09-20	AD	Futures	0.82841	0.83452	0.82154	0.82398	97445.0
2017-09-20	B	Futures	38.81	39.61	38.75	39.47	295650.0
2017-09-20	B6	Futures	1.4125	1.4279	1.4062	1.4095	176871.0
2017-09-20	BR	Futures	0.2386	0.2386	0.2386	0.2386	3.0
2017-09-20	BZ	Futures	38.52	39.27	38.43	39.14	27031.0
2017-09-20	C	Futures	1434.0	1451.0	1430.0	1448.0	6567.0
2017-09-20	CB	Futures	316.823	316.823	314.965	314.965	9.0
2017-09-20	CC	Futures	1460.0	1491.0	1458.0	1483.0	18482.0
2017-09-20	CNH	Futures	6.7826	6.8018	6.7725	6.8018	10.0
2017-09-20	CSC	Futures	3.385	3.414	3.385	3.41	33.0
2017-09-20	CT	Futures	82.3	82.99	81.28	81.74	38.0
2017-09-20	DC	Futures	27.55	27.78	27.52	27.78	75.0
2017-09-20	DX	Futures	85.679	86.498	85.301	86.311	37394.0
2017-09-20	E1	Futures	1.27773	1.28238	1.26538	1.26746	38214.0
2017-09-20	E6	Futures	1.37546	1.3798	1.35983	1.36314	265602.0
2017-09-20	E7	Futures	1.368	1.3723	1.3528	1.3561	5143.0
2017-09-20	EBM	Futures	175.05	176.13	174.78	175.86	14486.0
2017-09-20	ED	Futures	95.5279	95.5473	95.4988	95.5085	491682.0
2017-09-20	ER	Futures	98.337	98.342	98.337	98.337	26434.0
2017-09-20	EW	Futures	1871.8	1879.4	1871.2	1878.0	12623.0
2017-09-20	FBON	Futures	125.27	125.45	125.07	125.16	206.0
2017-09-20	FBTP	Futures	109.19	109.46	108.99	109.03	71529.0
2017-09-20	FBTS	Futures	103.246	103.274	103.228	103.228	22844.0
2017-09-20	FCE	Futures	4679.7	4716.4	4674.3	4686.4	52403.0
2017-09-20	FDAX	Futures	13188.8	13273.4	13142.0	13196.7	61431.0
2017-09-20	FDXM	Futures	13072.8	13163.5	13031.1	13085.3	18038.0
2017-09-20	FESX	Futures	2866.7	2883.8	2861.0	2863.4	595242.0
2017-09-20	FEU3	Futures	99.006	99.006	99.006	99.006	16.0
2017-09-20	FGBL	Futures	148.93	149.24	148.64	149.16	529434.0
2017-09-20	FGBM	Futures	129.52	129.6	129.35	129.57	317275.0
2017-09-20	FGBS	Futures	112.402	112.412	112.347	112.397	140949.0
2017-09-20	FGBX	Futures	166.46	167.42	166.09	167.11	45705.0
2017-09-20	FMWO	Futures	6637.6	6644.7	6601.0	6637.6	272.0
2017-09-20	FOAT	Futures	136.22	136.55	136.21	136.36	79692.0
2017-09-20	FTDX	Futures	2387.7	2396.6	2382.7	2383.7	83.0
2017-09-20	FTI	Futures	486.59	488.94	485.95	486.69	17097.0
2017-09-20	FTUK	Futures	6277.6	6295.4	6253.4	6268.1	92859.0
2017-09-20	FVSA	Futures	420.0	424.26	410.07	418.58	20274.0
2017-09-20	FXXP	Futures	323.3	324.9	322.8	323.0	16968.0
2017-09-20	G	Futures	113.5	113.83	113.33	113.6	182794.0
2017-09-20	GF	Futures	333.597	343.309	333.269	343.254	8420.0
2017-09-20	GSCI	Futures	474.72	476.63	474.6	476.51	4.0
2017-09-20	HE	Futures	87.117	88.741	86.711	88.483	24546.0

> showing 50 of 109 rows — these rows as CSV

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