PREVIEW / futures_daily / 2018-02-22

all futures daily files

  file:    by_date/futures_daily/2018/2018-02-22.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
2018-02-22	ES	Futures	2932.94	2968.27	2915.01	2947.07	1623017.0
2018-02-22	NQ	Futures	7913.07	8000.91	7840.75	7950.85	439678.0
2018-02-22	YM	Futures	26136.3	26509.7	25918.0	26378.9	276484.0
2018-02-22	CL	Futures	61.77	63.54	61.18	63.21	592603.0
2018-02-22	GC	Futures	1694.0	1704.5	1689.8	1702.3	206244.0
2018-02-22	ZN	Futures	118.612271	118.951648	118.565993	118.889943	2364742.0
2018-02-22	A6	Futures	0.80224	0.80841	0.80131	0.80686	96905.0
2018-02-22	AD	Futures	0.79995	0.80153	0.79589	0.79868	91030.0
2018-02-22	B	Futures	46.58	47.76	46.37	47.64	253001.0
2018-02-22	B6	Futures	1.4481	1.4562	1.4423	1.4529	115141.0
2018-02-22	BTC	Futures	13669.5	14183.4	12635.0	13122.9	1168.0
2018-02-22	BZ	Futures	46.04	47.13	45.78	47.01	29052.0
2018-02-22	C	Futures	1378.0	1397.0	1378.0	1381.0	10226.0
2018-02-22	CB	Futures	284.15	284.891	282.05	282.42	50.0
2018-02-22	CC	Futures	1583.0	1597.0	1571.0	1575.0	19108.0
2018-02-22	CNH	Futures	6.4685	6.4857	6.4652	6.4665	33.0
2018-02-22	CSC	Futures	3.312	3.319	3.298	3.304	66.0
2018-02-22	CT	Futures	92.16	92.3	91.07	91.35	16489.0
2018-02-22	DC	Futures	26.35	26.44	26.22	26.22	69.0
2018-02-22	DX	Futures	84.571	84.679	84.106	84.196	24080.0
2018-02-22	E1	Futures	1.29452	1.30387	1.29234	1.30314	19247.0
2018-02-22	E6	Futures	1.39385	1.40235	1.39181	1.39997	222821.0
2018-02-22	E7	Futures	1.3868	1.3953	1.3849	1.3929	3750.0
2018-02-22	EBM	Futures	173.7	174.78	173.7	174.51	22188.0
2018-02-22	ED	Futures	95.0834	95.1101	95.0737	95.1052	487255.0
2018-02-22	ER	Futures	98.332	98.337	98.328	98.332	87784.0
2018-02-22	EW	Futures	1995.9	2015.6	1982.3	1994.2	10989.0
2018-02-22	FBON	Futures	125.89	126.09	125.8	125.9	234.0
2018-02-22	FBTP	Futures	110.89	111.09	110.59	110.81	93570.0
2018-02-22	FBTS	Futures	103.613	103.622	103.576	103.586	39283.0
2018-02-22	FCE	Futures	4651.0	4699.5	4636.4	4688.1	68899.0
2018-02-22	FDAX	Futures	12823.2	12962.7	12734.0	12958.0	96275.0
2018-02-22	FDXM	Futures	12844.9	12984.2	12755.6	12980.0	39391.0
2018-02-22	FESX	Futures	2775.1	2809.4	2768.6	2808.6	1011934.0
2018-02-22	FGBL	Futures	146.66	147.22	146.6	147.14	630429.0
2018-02-22	FGBM	Futures	128.4	128.61	128.39	128.58	463283.0
2018-02-22	FGBS	Futures	112.306	112.331	112.296	112.331	214520.0
2018-02-22	FGBX	Futures	163.5	164.61	163.29	164.38	38719.0
2018-02-22	FMWO	Futures	6937.5	7035.5	6934.0	7033.2	1918.0
2018-02-22	FOAT	Futures	135.68	136.13	135.59	136.06	88624.0
2018-02-22	FTDX	Futures	2569.3	2578.3	2551.3	2573.8	225.0
2018-02-22	FTI	Futures	486.38	489.92	484.96	488.96	23141.0
2018-02-22	FTUK	Futures	6288.9	6332.2	6263.2	6329.6	114878.0
2018-02-22	FVSA	Futures	465.36	469.06	439.51	441.97	22979.0
2018-02-22	FXXP	Futures	321.3	324.4	320.7	324.3	31960.0
2018-02-22	G	Futures	112.15	112.43	111.96	112.34	426118.0
2018-02-22	GF	Futures	321.435	322.478	320.062	320.611	5144.0
2018-02-22	GSCI	Futures	506.32	510.13	505.13	510.13	18.0
2018-02-22	HE	Futures	89.66	91.875	89.211	91.522	21244.0
2018-02-22	HG	Futures	3.8339	3.8827	3.7774	3.8803	48789.0

> showing 50 of 110 rows — these rows as CSV

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