PREVIEW / futures_daily / 2018-09-05

all futures daily files

  file:    by_date/futures_daily/2018/2018-09-05.parquet
  size:    10 KB
  rows:    115

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-09-05	ES	Futures	3148.33	3150.23	3125.25	3136.92	1604742.0
2018-09-05	NQ	Futures	8910.11	8911.28	8748.05	8781.28	522313.0
2018-09-05	YM	Futures	27396.0	27423.4	27228.5	27367.6	173923.0
2018-09-05	CL	Futures	72.32	72.49	71.41	71.58	542104.0
2018-09-05	GC	Futures	1517.4	1526.2	1516.3	1522.5	209563.0
2018-09-05	ZN	Futures	119.447919	119.556692	119.323608	119.43238	62969.0
2018-09-05	A6	Futures	0.73837	0.74259	0.73487	0.73899	121228.0
2018-09-05	AD	Futures	0.76854	0.76991	0.76708	0.76809	77341.0
2018-09-05	B	Futures	56.72	56.92	56.06	56.32	277124.0
2018-09-05	B6	Futures	1.3266	1.3401	1.3197	1.3312	190915.0
2018-09-05	BR	Futures	0.18178	0.183	0.18178	0.183	12.0
2018-09-05	BTC	Futures	10519.0	10576.2	9782.4	9868.3	4585.0
2018-09-05	BZ	Futures	56.53	56.65	55.83	56.08	27811.0
2018-09-05	C	Futures	1539.0	1561.0	1529.0	1540.0	3965.0
2018-09-05	CB	Futures	263.186	263.306	260.963	260.963	47.0
2018-09-05	CC	Futures	1613.0	1657.0	1601.0	1614.0	20276.0
2018-09-05	CNH	Futures	6.9172	6.9379	6.9172	6.9174	130.0
2018-09-05	CSC	Futures	3.355	3.359	3.347	3.347	29.0
2018-09-05	CT	Futures	91.68	91.68	91.68	91.68	26.0
2018-09-05	DC	Futures	27.48	27.61	27.48	27.55	192.0
2018-09-05	DX	Futures	90.306	90.562	89.97	90.092	24328.0
2018-09-05	E1	Futures	1.22811	1.23217	1.22631	1.23026	34057.0
2018-09-05	E6	Futures	1.29641	1.30296	1.29194	1.30106	300428.0
2018-09-05	E7	Futures	1.2899	1.2963	1.2855	1.2945	4630.0
2018-09-05	EBM	Futures	209.24	210.53	207.42	207.68	18304.0
2018-09-05	ED	Futures	95.0838	95.0959	95.0838	95.0911	217917.0
2018-09-05	ER	Futures	98.367	98.372	98.367	98.372	20288.0
2018-09-05	EW	Futures	2162.9	2163.1	2142.5	2159.4	13660.0
2018-09-05	FBON	Futures	129.03	129.03	128.45	128.52	2484.0
2018-09-05	FBTP	Futures	105.56	107.28	105.56	106.54	211700.0
2018-09-05	FBTS	Futures	101.965	102.537	101.937	102.434	116351.0
2018-09-05	FCE	Futures	4813.4	4813.9	4736.8	4739.5	99185.0
2018-09-05	FDAX	Futures	12730.1	12732.2	12576.9	12586.3	116827.0
2018-09-05	FDIV	Futures	145.05	145.05	144.28	144.28	8.0
2018-09-05	FDXM	Futures	12571.6	12574.7	12415.7	12425.6	48810.0
2018-09-05	FESX	Futures	2802.9	2803.8	2765.4	2768.7	1302524.0
2018-09-05	FGBL	Futures	153.47	153.62	152.88	153.05	1209772.0
2018-09-05	FGBM	Futures	131.14	131.18	130.87	130.92	962548.0
2018-09-05	FGBS	Futures	112.643	112.663	112.578	112.593	733644.0
2018-09-05	FGBX	Futures	177.84	178.3	176.58	177.05	107690.0
2018-09-05	FMWO	Futures	7163.8	7187.1	7147.5	7147.5	1535.0
2018-09-05	FOAT	Futures	141.04	141.09	140.55	140.66	253520.0
2018-09-05	FTDX	Futures	2926.0	2936.8	2859.8	2863.2	385.0
2018-09-05	FTI	Futures	512.82	512.82	506.89	507.3	32648.0
2018-09-05	FTUK	Futures	6637.4	6640.1	6549.2	6576.4	129673.0
2018-09-05	FVSA	Futures	278.72	290.05	277.85	287.43	45647.0
2018-09-05	FXXP	Futures	327.5	327.7	324.5	324.7	67294.0
2018-09-05	G	Futures	115.13	115.27	114.57	114.71	286199.0
2018-09-05	GF	Futures	315.942	317.242	314.642	315.63	1378.0
2018-09-05	GSCI	Futures	524.37	524.37	522.52	522.52	14.0

> showing 50 of 115 rows — these rows as CSV

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