PREVIEW / futures_daily / 2017-10-27

all futures daily files

  file:    by_date/futures_daily/2017/2017-10-27.parquet
  size:    10 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-10-27	ES	Futures	2786.13	2807.07	2781.78	2804.62	1561074.0
2017-10-27	NQ	Futures	7155.73	7312.84	7140.17	7300.5	435844.0
2017-10-27	YM	Futures	24663.8	24718.7	24601.5	24680.7	126170.0
2017-10-27	CL	Futures	53.24	54.66	52.69	54.35	730915.0
2017-10-27	GC	Futures	1613.4	1622.6	1608.1	1618.3	363096.0
2017-10-27	ZN	Futures	122.546258	122.993001	122.453828	122.838951	2067719.0
2017-10-27	A6	Futures	0.78774	0.78969	0.78413	0.78835	133993.0
2017-10-27	AD	Futures	0.79219	0.79473	0.78802	0.79214	94499.0
2017-10-27	ALI	Futures	2718.01	2718.01	2718.01	2718.01	0.0
2017-10-27	B	Futures	41.83	42.69	41.43	42.53	332438.0
2017-10-27	B6	Futures	1.3732	1.3733	1.3646	1.3701	118149.0
2017-10-27	BFX	Futures	4882.2	4882.2	4853.6	4862.0	7.0
2017-10-27	BR	Futures	0.22894	0.23223	0.22759	0.23102	20026.0
2017-10-27	BZ	Futures	41.53	42.31	41.07	42.15	26997.0
2017-10-27	C	Futures	1549.0	1552.0	1525.0	1539.0	8159.0
2017-10-27	CB	Futures	297.328	297.36	296.037	296.446	30.0
2017-10-27	CC	Futures	1578.0	1578.0	1553.0	1570.0	24024.0
2017-10-27	CNH	Futures	6.8503	6.8506	6.8419	6.8419	77.0
2017-10-27	CSC	Futures	3.449	3.449	3.437	3.445	12.0
2017-10-27	CT	Futures	80.45	80.45	79.64	80.11	12315.0
2017-10-27	DC	Futures	27.94	28.03	27.86	27.98	95.0
2017-10-27	DX	Futures	88.522	88.896	88.494	88.674	36495.0
2017-10-27	E1	Futures	1.22956	1.23017	1.22186	1.22821	36368.0
2017-10-27	E6	Futures	1.33319	1.33341	1.32406	1.32691	331026.0
2017-10-27	E7	Futures	1.3262	1.3263	1.3171	1.32	6030.0
2017-10-27	EBM	Futures	175.59	176.13	175.59	175.86	18929.0
2017-10-27	ED	Futures	95.4891	95.4939	95.4842	95.4891	223802.0
2017-10-27	ER	Futures	98.342	98.347	98.342	98.347	28167.0
2017-10-27	EW	Futures	1943.0	1955.0	1936.8	1953.2	12078.0
2017-10-27	FBON	Futures	125.64	125.9	124.93	125.16	1273.0
2017-10-27	FBTP	Futures	111.15	111.45	110.93	111.19	126929.0
2017-10-27	FBTS	Futures	103.558	103.594	103.558	103.567	55036.0
2017-10-27	FCE	Futures	4894.7	4938.6	4894.7	4921.1	87736.0
2017-10-27	FDAX	Futures	13836.7	13920.8	13836.7	13893.5	81870.0
2017-10-27	FDXM	Futures	13718.9	13803.3	13718.9	13776.2	29506.0
2017-10-27	FESX	Futures	2967.8	2989.9	2967.8	2976.0	1274948.0
2017-10-27	FEU3	Futures	99.011	99.016	99.011	99.016	110.0
2017-10-27	FGBL	Futures	149.57	150.23	149.45	150.14	896662.0
2017-10-27	FGBM	Futures	129.85	130.17	129.84	130.1	646933.0
2017-10-27	FGBS	Futures	112.532	112.592	112.517	112.572	386929.0
2017-10-27	FGBX	Futures	166.87	167.85	166.22	167.62	64661.0
2017-10-27	FMWO	Futures	6746.2	6761.6	6735.6	6760.4	1137.0
2017-10-27	FOAT	Futures	137.07	137.67	137.0	137.6	132895.0
2017-10-27	FTDX	Futures	2495.5	2524.4	2495.5	2521.9	430.0
2017-10-27	FTI	Futures	507.51	509.27	506.17	507.47	29936.0
2017-10-27	FTUK	Futures	6482.0	6501.1	6468.6	6490.7	76871.0
2017-10-27	FVSA	Futures	356.83	359.39	345.32	350.44	19804.0
2017-10-27	FXXP	Futures	333.0	333.9	332.6	333.8	35862.0
2017-10-27	G	Futures	113.2	113.7	113.07	113.58	182341.0
2017-10-27	GF	Futures	339.764	340.303	335.185	337.232	2550.0

> showing 50 of 110 rows — these rows as CSV

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