PREVIEW / futures_1hour / 2016-03-09

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-03-09.parquet
  size:    52 KB
  rows:    1,599

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2016-03-09 00:00:00	ES	Futures	2131.13	2134.62	2131.13	2133.55	7372.0
2016-03-09 01:00:00	ES	Futures	2133.82	2134.09	2132.21	2132.74	3052.0
2016-03-09 02:00:00	ES	Futures	2133.01	2135.7	2130.06	2131.4	12605.0
2016-03-09 03:00:00	ES	Futures	2131.4	2138.12	2129.79	2132.47	35253.0
2016-03-09 04:00:00	ES	Futures	2132.21	2138.39	2132.21	2135.7	16816.0
2016-03-09 05:00:00	ES	Futures	2135.43	2137.58	2132.21	2137.31	16266.0
2016-03-09 06:00:00	ES	Futures	2137.31	2140.54	2136.24	2139.19	20329.0
2016-03-09 07:00:00	ES	Futures	2138.92	2143.22	2138.66	2138.66	23815.0
2016-03-09 08:00:00	ES	Futures	2138.92	2140.54	2136.24	2137.85	26023.0
2016-03-09 09:00:00	ES	Futures	2137.85	2138.66	2130.86	2134.62	200943.0
2016-03-09 10:00:00	ES	Futures	2134.62	2140.0	2126.03	2129.52	383154.0
2016-03-09 11:00:00	ES	Futures	2129.25	2140.8	2128.98	2140.27	211436.0
2016-03-09 12:00:00	ES	Futures	2140.0	2140.27	2131.94	2132.47	112400.0
2016-03-09 13:00:00	ES	Futures	2132.47	2137.58	2130.59	2136.77	92480.0
2016-03-09 14:00:00	ES	Futures	2136.77	2138.12	2133.55	2135.43	82009.0
2016-03-09 15:00:00	ES	Futures	2135.43	2137.31	2130.59	2136.77	154203.0
2016-03-09 16:00:00	ES	Futures	2136.77	2139.73	2135.97	2138.12	60546.0
2016-03-09 18:00:00	ES	Futures	2138.92	2139.73	2137.04	2137.58	5031.0
2016-03-09 19:00:00	ES	Futures	2137.58	2138.92	2135.97	2136.77	5495.0
2016-03-09 20:00:00	ES	Futures	2136.77	2144.57	2136.24	2141.61	8225.0
2016-03-09 21:00:00	ES	Futures	2141.88	2142.69	2140.54	2141.61	3567.0
2016-03-09 22:00:00	ES	Futures	2141.61	2142.95	2141.07	2141.61	2903.0
2016-03-09 23:00:00	ES	Futures	2141.61	2141.88	2138.12	2139.46	3353.0
2016-03-09 00:00:00	NQ	Futures	5076.04	5087.03	5075.74	5083.76	1062.0
2016-03-09 01:00:00	NQ	Futures	5084.36	5085.84	5080.2	5084.06	683.0
2016-03-09 02:00:00	NQ	Futures	5084.06	5091.78	5075.74	5078.71	1547.0
2016-03-09 03:00:00	NQ	Futures	5078.42	5097.72	5073.07	5078.42	6143.0
2016-03-09 04:00:00	NQ	Futures	5078.12	5095.94	5077.82	5088.22	2730.0
2016-03-09 05:00:00	NQ	Futures	5088.22	5095.04	5076.64	5093.56	3019.0
2016-03-09 06:00:00	NQ	Futures	5093.56	5104.25	5091.48	5096.23	2914.0
2016-03-09 07:00:00	NQ	Futures	5096.23	5106.03	5094.45	5094.75	2791.0
2016-03-09 08:00:00	NQ	Futures	5095.04	5099.8	5086.73	5092.08	4310.0
2016-03-09 09:00:00	NQ	Futures	5092.37	5093.56	5055.85	5066.84	35797.0
2016-03-09 10:00:00	NQ	Futures	5066.24	5097.72	5059.71	5064.76	57811.0
2016-03-09 11:00:00	NQ	Futures	5064.76	5095.34	5063.87	5092.67	29362.0
2016-03-09 12:00:00	NQ	Futures	5092.67	5093.56	5074.56	5077.23	15592.0
2016-03-09 13:00:00	NQ	Futures	5077.23	5097.42	5073.96	5094.45	14258.0
2016-03-09 14:00:00	NQ	Futures	5094.45	5098.91	5085.25	5093.86	14116.0
2016-03-09 15:00:00	NQ	Futures	5093.86	5098.61	5080.5	5097.72	25300.0
2016-03-09 16:00:00	NQ	Futures	5097.72	5105.73	5096.53	5100.98	7018.0
2016-03-09 18:00:00	NQ	Futures	5101.58	5104.55	5096.53	5097.42	609.0
2016-03-09 19:00:00	NQ	Futures	5097.42	5100.69	5094.75	5096.23	847.0
2016-03-09 20:00:00	NQ	Futures	5096.23	5117.61	5095.34	5109.3	1528.0
2016-03-09 21:00:00	NQ	Futures	5109.3	5112.86	5106.63	5109.3	683.0
2016-03-09 22:00:00	NQ	Futures	5109.59	5111.38	5106.03	5106.92	729.0
2016-03-09 23:00:00	NQ	Futures	5106.92	5107.81	5097.42	5101.87	684.0
2016-03-09 00:00:00	YM	Futures	18085.5	18117.4	18085.5	18108.9	1363.0
2016-03-09 01:00:00	YM	Futures	18108.9	18111.0	18096.1	18100.4	496.0
2016-03-09 02:00:00	YM	Futures	18102.5	18122.7	18085.5	18094.0	1528.0
2016-03-09 03:00:00	YM	Futures	18091.9	18152.5	18079.1	18106.8	6148.0

> showing 50 of 1,599 rows — these rows as CSV

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