PREVIEW / futures_1hour / 2015-10-05

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-10-05.parquet
  size:    52 KB
  rows:    1,575

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
2015-10-05 00:00:00	ES	Futures	2081.75	2084.15	2080.14	2081.48	4932.0
2015-10-05 01:00:00	ES	Futures	2081.75	2082.01	2076.66	2079.87	5743.0
2015-10-05 02:00:00	ES	Futures	2079.87	2080.94	2078.54	2080.41	8994.0
2015-10-05 03:00:00	ES	Futures	2080.14	2086.56	2074.25	2083.62	33921.0
2015-10-05 04:00:00	ES	Futures	2083.89	2086.56	2079.34	2083.35	25195.0
2015-10-05 05:00:00	ES	Futures	2083.35	2090.58	2082.55	2089.77	21185.0
2015-10-05 06:00:00	ES	Futures	2089.51	2091.91	2088.7	2090.04	20359.0
2015-10-05 07:00:00	ES	Futures	2090.31	2095.93	2089.77	2095.39	39548.0
2015-10-05 08:00:00	ES	Futures	2095.39	2097.0	2090.84	2094.59	63809.0
2015-10-05 09:00:00	ES	Futures	2094.59	2104.49	2092.45	2103.42	253745.0
2015-10-05 10:00:00	ES	Futures	2103.42	2106.63	2098.34	2102.08	265305.0
2015-10-05 11:00:00	ES	Futures	2102.08	2105.83	2101.28	2105.29	167414.0
2015-10-05 12:00:00	ES	Futures	2105.03	2109.31	2104.49	2106.9	129387.0
2015-10-05 13:00:00	ES	Futures	2106.9	2113.05	2105.56	2111.98	126282.0
2015-10-05 14:00:00	ES	Futures	2111.98	2118.4	2110.91	2115.73	146505.0
2015-10-05 15:00:00	ES	Futures	2116.0	2119.21	2113.86	2116.8	218679.0
2015-10-05 16:00:00	ES	Futures	2116.53	2117.6	2112.52	2114.39	91977.0
2015-10-05 18:00:00	ES	Futures	2111.71	2112.25	2109.31	2110.91	5820.0
2015-10-05 19:00:00	ES	Futures	2110.91	2111.98	2109.57	2111.45	3311.0
2015-10-05 20:00:00	ES	Futures	2111.45	2114.12	2109.31	2109.84	8717.0
2015-10-05 21:00:00	ES	Futures	2109.84	2111.45	2106.63	2107.7	8190.0
2015-10-05 22:00:00	ES	Futures	2107.7	2109.31	2106.63	2107.43	5121.0
2015-10-05 23:00:00	ES	Futures	2107.7	2108.24	2105.56	2107.7	8032.0
2015-10-05 00:00:00	NQ	Futures	5062.88	5069.4	5058.73	5063.18	1359.0
2015-10-05 01:00:00	NQ	Futures	5063.47	5064.07	5051.32	5061.1	2089.0
2015-10-05 02:00:00	NQ	Futures	5060.51	5062.88	5055.17	5059.03	1489.0
2015-10-05 03:00:00	NQ	Futures	5058.43	5076.82	5045.09	5071.18	5604.0
2015-10-05 04:00:00	NQ	Futures	5071.78	5076.82	5061.1	5070.0	3744.0
2015-10-05 05:00:00	NQ	Futures	5070.89	5088.68	5068.22	5086.3	3392.0
2015-10-05 06:00:00	NQ	Futures	5086.3	5091.05	5083.04	5084.82	2731.0
2015-10-05 07:00:00	NQ	Futures	5084.82	5095.49	5083.93	5092.53	5764.0
2015-10-05 08:00:00	NQ	Futures	5092.23	5095.79	5075.33	5084.52	10362.0
2015-10-05 09:00:00	NQ	Futures	5084.52	5090.45	5074.74	5087.79	46126.0
2015-10-05 10:00:00	NQ	Futures	5088.08	5106.76	5077.41	5094.31	40789.0
2015-10-05 11:00:00	NQ	Futures	5094.31	5107.65	5086.01	5098.46	20896.0
2015-10-05 12:00:00	NQ	Futures	5098.16	5106.17	5093.12	5097.27	15874.0
2015-10-05 13:00:00	NQ	Futures	5097.87	5122.77	5094.31	5119.51	16399.0
2015-10-05 14:00:00	NQ	Futures	5119.51	5134.93	5115.66	5124.55	19539.0
2015-10-05 15:00:00	NQ	Futures	5124.85	5132.56	5117.44	5122.77	28051.0
2015-10-05 16:00:00	NQ	Futures	5122.48	5126.33	5110.32	5115.06	8777.0
2015-10-05 18:00:00	NQ	Futures	5108.84	5110.62	5099.65	5104.69	1030.0
2015-10-05 19:00:00	NQ	Futures	5104.69	5108.54	5102.02	5107.65	354.0
2015-10-05 20:00:00	NQ	Futures	5107.35	5113.58	5102.02	5103.8	1443.0
2015-10-05 21:00:00	NQ	Futures	5103.8	5108.24	5096.09	5097.57	1237.0
2015-10-05 22:00:00	NQ	Futures	5097.57	5103.5	5096.68	5098.16	951.0
2015-10-05 23:00:00	NQ	Futures	5098.76	5100.24	5093.12	5097.87	2317.0
2015-10-05 00:00:00	YM	Futures	17363.3	17384.5	17354.8	17366.5	1203.0
2015-10-05 01:00:00	YM	Futures	17368.6	17368.6	17319.9	17345.3	1497.0
2015-10-05 02:00:00	YM	Futures	17344.2	17358.0	17336.8	17355.9	1323.0
2015-10-05 03:00:00	YM	Futures	17354.8	17409.9	17309.3	17391.9	4222.0

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

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