PREVIEW / futures_daily / 2014-11-20

all futures daily files

  file:    by_date/futures_daily/2014/2014-11-20.parquet
  size:    9 KB
  rows:    105

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
2014-11-20	ES	Futures	2138.27	2144.27	2125.99	2143.49	1130058.0
2014-11-20	NQ	Futures	4895.22	4923.62	4869.73	4919.85	214465.0
2014-11-20	YM	Futures	17908.4	17958.1	17813.0	17951.0	102216.0
2014-11-20	CL	Futures	143.31	147.22	143.04	146.22	236720.0
2014-11-20	GC	Futures	1551.8	1569.5	1542.8	1562.0	187475.0
2014-11-20	ZN	Futures	118.407594	118.8469	118.407594	118.612603	1606209.0
2014-11-20	A6	Futures	0.83458	0.83837	0.83108	0.83788	106328.0
2014-11-20	AD	Futures	0.89498	0.89904	0.89295	0.89823	51869.0
2014-11-20	ALI	Futures	3068.92	3068.92	3068.92	3068.92	0.0
2014-11-20	B	Futures	80.81	82.66	80.19	82.02	206376.0
2014-11-20	B6	Futures	1.648	1.6541	1.6428	1.6499	94568.0
2014-11-20	BFX	Futures	3861.6	3861.6	3847.5	3858.7	136.0
2014-11-20	BR	Futures	0.21085	0.21177	0.21085	0.21107	185.0
2014-11-20	BZ	Futures	81.68	83.47	81.03	82.85	16540.0
2014-11-20	C	Futures	2016.0	2023.0	2013.0	2018.0	2565.0
2014-11-20	CB	Futures	137.005	138.739	137.005	138.219	19.0
2014-11-20	CC	Futures	2092.0	2100.0	2080.0	2088.0	6452.0
2014-11-20	CSC	Futures	4.77	4.791	4.683	4.778	47.0
2014-11-20	CT	Futures	74.63	76.0	73.29	74.18	3819.0
2014-11-20	DC	Futures	38.7	39.03	38.03	38.91	768.0
2014-11-20	DX	Futures	83.327	83.545	83.099	83.22	38420.0
2014-11-20	E1	Futures	1.33543	1.33875	1.33134	1.33555	46445.0
2014-11-20	E6	Futures	1.47727	1.48045	1.47209	1.47751	265602.0
2014-11-20	E7	Futures	1.4679	1.4711	1.4628	1.4682	4432.0
2014-11-20	ED	Futures	95.4398	95.4422	95.4374	95.4398	75662.0
2014-11-20	ER	Futures	97.989	97.999	97.989	97.994	38892.0
2014-11-20	EW	Futures	1490.8	1498.5	1480.6	1497.2	10440.0
2014-11-20	FBTP	Futures	95.7	96.25	95.64	95.97	56069.0
2014-11-20	FBTS	Futures	98.508	98.606	98.499	98.552	10469.0
2014-11-20	FCE	Futures	3447.0	3452.7	3396.8	3425.1	60344.0
2014-11-20	FDAX	Futures	10369.5	10396.4	10272.6	10392.0	104232.0
2014-11-20	FESX	Futures	2256.4	2260.0	2223.1	2244.1	952722.0
2014-11-20	FEU3	Futures	98.621	98.621	98.621	98.621	2.0
2014-11-20	FGBL	Futures	133.16	133.7	133.1	133.59	756936.0
2014-11-20	FGBM	Futures	122.94	123.13	122.89	123.1	508092.0
2014-11-20	FGBS	Futures	110.823	110.848	110.808	110.838	329498.0
2014-11-20	FGBX	Futures	145.42	146.82	145.42	146.56	25920.0
2014-11-20	FMWO	Futures	5717.5	5741.3	5717.5	5741.3	249.0
2014-11-20	FOAT	Futures	122.67	123.2	122.65	123.11	78503.0
2014-11-20	FTDX	Futures	1250.9	1251.8	1229.6	1247.1	137.0
2014-11-20	FTI	Futures	362.72	363.85	360.29	362.46	21206.0
2014-11-20	FTUK	Futures	5171.5	5179.2	5135.9	5163.4	79362.0
2014-11-20	FVSA	Futures	1577.96	1613.13	1569.17	1569.17	5316.0
2014-11-20	FXXP	Futures	256.9	257.3	255.0	256.6	6452.0
2014-11-20	G	Futures	99.72	100.23	99.7	99.98	172426.0
2014-11-20	GF	Futures	381.146	381.146	376.734	377.977	3206.0
2014-11-20	GSCI	Futures	876.82	882.14	876.82	881.21	129.0
2014-11-20	HE	Futures	122.853	122.853	120.606	121.948	15662.0
2014-11-20	HG	Futures	3.8312	3.8445	3.8001	3.8255	19009.0
2014-11-20	HH	Futures	52.465	53.502	50.951	53.502	12922.0

> showing 50 of 105 rows — these rows as CSV

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