PREVIEW / futures_daily / 2017-08-18

all futures daily files

  file:    by_date/futures_daily/2017/2017-08-18.parquet
  size:    9 KB
  rows:    108

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-08-18	ES	Futures	2637.45	2651.3	2629.57	2637.45	2203303.0
2017-08-18	NQ	Futures	6809.03	6859.28	6785.81	6819.61	443313.0
2017-08-18	YM	Futures	22956.2	23016.4	22856.8	22917.0	181899.0
2017-08-18	CL	Futures	48.32	50.19	48.17	49.94	733134.0
2017-08-18	GC	Futures	1646.2	1662.9	1640.3	1643.4	396538.0
2017-08-18	ZN	Futures	124.888742	125.13498	124.657894	124.842573	1344325.0
2017-08-18	A6	Futures	0.80989	0.81584	0.80804	0.81461	87386.0
2017-08-18	AD	Futures	0.80243	0.81026	0.80167	0.80894	71640.0
2017-08-18	ALI	Futures	2688.84	2688.84	2688.84	2688.84	0.0
2017-08-18	B	Futures	35.6	37.05	35.52	36.88	317440.0
2017-08-18	B6	Futures	1.3463	1.3514	1.3423	1.3469	100812.0
2017-08-18	BR	Futures	0.23273	0.23551	0.23206	0.23548	1260.0
2017-08-18	BZ	Futures	35.27	36.72	35.22	36.56	41235.0
2017-08-18	C	Futures	1488.0	1508.0	1476.0	1492.0	3052.0
2017-08-18	CB	Futures	323.6	326.337	322.596	323.143	29.0
2017-08-18	CC	Futures	1397.0	1423.0	1381.0	1394.0	20081.0
2017-08-18	CNH	Futures	6.9149	6.9149	6.9054	6.9072	6.0
2017-08-18	CSC	Futures	3.569	3.594	3.561	3.592	159.0
2017-08-18	DC	Futures	29.7	30.03	29.58	29.93	587.0
2017-08-18	DX	Futures	87.447	87.48	87.069	87.176	23748.0
2017-08-18	E1	Futures	1.27812	1.28353	1.27235	1.27542	32397.0
2017-08-18	E6	Futures	1.34549	1.3511	1.34343	1.34927	163095.0
2017-08-18	E7	Futures	1.3384	1.3439	1.3365	1.3422	2865.0
2017-08-18	EBM	Futures	173.98	174.26	172.31	173.42	5484.0
2017-08-18	ED	Futures	95.5935	95.6007	95.5935	95.5959	109393.0
2017-08-18	ER	Futures	98.342	98.342	98.337	98.337	21035.0
2017-08-18	EW	Futures	1796.6	1805.4	1790.2	1796.3	12203.0
2017-08-18	FBON	Futures	125.08	126.97	125.03	125.18	107.0
2017-08-18	FBTP	Futures	109.29	109.53	109.13	109.32	47054.0
2017-08-18	FBTS	Futures	103.054	103.1	103.054	103.1	27206.0
2017-08-18	FCE	Futures	4578.9	4587.4	4539.1	4574.0	98773.0
2017-08-18	FDAX	Futures	12777.1	12841.9	12713.9	12812.9	98557.0
2017-08-18	FDXM	Futures	12700.6	12760.2	12634.6	12734.0	36414.0
2017-08-18	FESX	Futures	2807.9	2818.5	2790.0	2813.6	1159013.0
2017-08-18	FGBL	Futures	149.15	149.42	148.98	149.31	500911.0
2017-08-18	FGBM	Futures	129.46	129.59	129.4	129.52	269895.0
2017-08-18	FGBS	Futures	112.357	112.382	112.337	112.367	214459.0
2017-08-18	FGBX	Futures	168.59	169.31	168.36	169.11	33518.0
2017-08-18	FMWO	Futures	6442.4	6457.9	6431.7	6454.3	3036.0
2017-08-18	FOAT	Futures	136.19	136.41	136.07	136.29	71661.0
2017-08-18	FTDX	Futures	2262.6	2265.1	2239.6	2257.6	213.0
2017-08-18	FTI	Futures	482.04	482.51	478.76	480.84	36714.0
2017-08-18	FTUK	Futures	6334.7	6354.1	6302.7	6325.6	111127.0
2017-08-18	FVSA	Futures	535.3	560.5	533.73	543.18	39198.0
2017-08-18	FXXP	Futures	319.2	319.3	317.3	318.6	36265.0
2017-08-18	G	Futures	116.09	116.17	115.78	116.04	130911.0
2017-08-18	GF	Futures	308.426	310.838	304.809	307.001	7047.0
2017-08-18	GSCI	Futures	447.51	456.36	447.51	456.06	291.0
2017-08-18	HE	Futures	93.078	93.498	91.574	92.553	19372.0
2017-08-18	HG	Futures	3.5422	3.6012	3.5391	3.5756	97776.0

> showing 50 of 108 rows — these rows as CSV

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