PREVIEW / futures_daily / 2016-03-23

all futures daily files

  file:    by_date/futures_daily/2016/2016-03-23.parquet
  size:    9 KB
  rows:    109

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
2016-03-23	ES	Futures	2193.61	2196.02	2174.55	2178.3	1557185.0
2016-03-23	NQ	Futures	5210.86	5218.5	5150.35	5164.74	212040.0
2016-03-23	YM	Futures	18191.5	18215.4	18078.2	18118.7	144382.0
2016-03-23	CL	Futures	50.0	50.18	48.15	48.3	492003.0
2016-03-23	GC	Futures	1604.2	1605.9	1561.7	1572.7	266165.0
2016-03-23	ZN	Futures	124.302934	124.906419	124.212411	124.876245	886490.0
2016-03-23	A6	Futures	0.76788	0.77142	0.75826	0.75927	91569.0
2016-03-23	AD	Futures	0.78402	0.78433	0.77349	0.77411	67848.0
2016-03-23	ALI	Futures	2065.93	2065.93	2055.27	2062.38	37.0
2016-03-23	B	Futures	34.61	34.83	33.66	33.7	240906.0
2016-03-23	B6	Futures	1.497	1.4988	1.4831	1.4866	81461.0
2016-03-23	BFX	Futures	4036.6	4036.6	4012.0	4014.4	2.0
2016-03-23	BR	Futures	0.17761	0.17761	0.17439	0.17439	134.0
2016-03-23	BZ	Futures	34.27	34.47	33.31	33.36	30553.0
2016-03-23	C	Futures	2363.0	2369.0	2300.0	2332.0	17111.0
2016-03-23	CB	Futures	246.33	246.33	243.281	243.373	40.0
2016-03-23	CC	Futures	2225.0	2225.0	2150.0	2170.0	22816.0
2016-03-23	CNH	Futures	7.095	7.108	7.095	7.1014	55.0
2016-03-23	CSC	Futures	3.589	3.589	3.58	3.584	30.0
2016-03-23	CT	Futures	67.04	67.28	66.56	67.06	9732.0
2016-03-23	DC	Futures	28.4	28.4	28.22	28.28	37.0
2016-03-23	DX	Futures	89.167	89.726	89.157	89.562	14472.0
2016-03-23	E1	Futures	1.29642	1.29642	1.2909	1.2924	12593.0
2016-03-23	E6	Futures	1.31109	1.31202	1.30444	1.30712	133451.0
2016-03-23	E7	Futures	1.304	1.3048	1.2975	1.3	2003.0
2016-03-23	EBM	Futures	200.1	200.74	198.17	199.45	21494.0
2016-03-23	ED	Futures	95.6389	95.663	95.634	95.6581	262897.0
2016-03-23	ER	Futures	98.259	98.259	98.254	98.259	24115.0
2016-03-23	EW	Futures	1507.2	1507.8	1486.7	1488.7	16472.0
2016-03-23	FBON	Futures	118.38	118.41	118.02	118.26	67.0
2016-03-23	FBTP	Futures	107.56	107.72	107.03	107.36	81791.0
2016-03-23	FBTS	Futures	101.042	101.042	100.988	101.015	20844.0
2016-03-23	FCE	Futures	3686.7	3722.6	3660.9	3685.1	75512.0
2016-03-23	FDAX	Futures	10759.2	10906.4	10742.6	10815.6	99401.0
2016-03-23	FDXM	Futures	10363.4	10502.0	10344.7	10414.0	19421.0
2016-03-23	FESX	Futures	2316.6	2340.0	2298.6	2314.2	1090028.0
2016-03-23	FGBL	Futures	145.16	145.73	145.09	145.55	499144.0
2016-03-23	FGBM	Futures	127.21	127.33	127.17	127.29	341928.0
2016-03-23	FGBS	Futures	111.618	111.628	111.608	111.618	124967.0
2016-03-23	FGBX	Futures	170.86	172.15	170.4	171.54	26827.0
2016-03-23	FMWO	Futures	5560.6	5564.4	5515.9	5530.8	1369.0
2016-03-23	FOAT	Futures	132.88	133.25	132.77	133.14	55141.0
2016-03-23	FTDX	Futures	1532.3	1546.1	1532.3	1541.4	40.0
2016-03-23	FTI	Futures	391.89	395.09	390.83	393.0	28397.0
2016-03-23	FTUK	Futures	5048.6	5079.5	5031.7	5065.1	88326.0
2016-03-23	FVSA	Futures	2655.78	2755.17	2600.57	2683.39	11768.0
2016-03-23	FXXP	Futures	268.0	270.0	266.4	268.0	12353.0
2016-03-23	G	Futures	107.92	108.35	107.77	108.31	150190.0
2016-03-23	GF	Futures	307.931	310.679	303.563	305.379	4540.0
2016-03-23	GSCI	Futures	500.37	501.12	494.06	494.96	94.0

> showing 50 of 109 rows — these rows as CSV

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