PREVIEW / futures_1hour / 2015-09-14

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-09-14.parquet
  size:    48 KB
  rows:    1,515

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-09-14 00:00:00	ES	Futures	2091.65	2092.45	2088.17	2091.38	4782.0
2015-09-14 01:00:00	ES	Futures	2091.38	2096.46	2088.7	2088.97	7169.0
2015-09-14 02:00:00	ES	Futures	2088.97	2090.58	2083.35	2084.96	12490.0
2015-09-14 03:00:00	ES	Futures	2085.22	2097.53	2084.96	2092.98	25604.0
2015-09-14 04:00:00	ES	Futures	2092.72	2093.52	2085.76	2090.31	11059.0
2015-09-14 05:00:00	ES	Futures	2090.04	2094.05	2089.77	2092.18	8331.0
2015-09-14 06:00:00	ES	Futures	2092.18	2096.46	2091.65	2094.32	13261.0
2015-09-14 07:00:00	ES	Futures	2094.32	2094.32	2085.49	2086.03	13619.0
2015-09-14 08:00:00	ES	Futures	2086.03	2089.77	2083.35	2087.63	27567.0
2015-09-14 09:00:00	ES	Futures	2087.37	2090.04	2073.99	2077.2	169636.0
2015-09-14 10:00:00	ES	Futures	2077.47	2084.69	2076.39	2081.21	129142.0
2015-09-14 11:00:00	ES	Futures	2081.21	2083.35	2073.45	2076.93	101958.0
2015-09-14 12:00:00	ES	Futures	2077.2	2078.27	2072.65	2075.32	81779.0
2015-09-14 13:00:00	ES	Futures	2075.06	2081.48	2073.18	2080.94	78461.0
2015-09-14 14:00:00	ES	Futures	2081.21	2081.21	2075.32	2077.47	68129.0
2015-09-14 15:00:00	ES	Futures	2077.73	2080.14	2074.25	2079.07	119596.0
2015-09-14 16:00:00	ES	Futures	2079.34	2082.28	2078.8	2079.61	45373.0
2015-09-14 17:00:00	ES	Futures	2079.61	2080.94	2079.61	2080.68	865.0
2015-09-14 18:00:00	ES	Futures	2080.14	2082.82	2079.07	2081.21	2120.0
2015-09-14 19:00:00	ES	Futures	2081.21	2082.82	2080.14	2082.55	1205.0
2015-09-14 20:00:00	ES	Futures	2082.55	2086.56	2079.34	2085.76	7614.0
2015-09-14 21:00:00	ES	Futures	2085.76	2086.56	2081.48	2084.42	6481.0
2015-09-14 22:00:00	ES	Futures	2084.69	2086.56	2083.35	2083.62	3879.0
2015-09-14 23:00:00	ES	Futures	2083.35	2084.42	2081.21	2084.15	4490.0
2015-09-14 00:00:00	NQ	Futures	5124.85	5129.29	5117.14	5126.63	1003.0
2015-09-14 01:00:00	NQ	Futures	5126.63	5138.19	5119.21	5119.21	1251.0
2015-09-14 02:00:00	NQ	Futures	5118.92	5123.96	5105.87	5111.51	1483.0
2015-09-14 03:00:00	NQ	Futures	5112.69	5145.31	5111.8	5133.74	4312.0
2015-09-14 04:00:00	NQ	Futures	5134.04	5136.11	5116.84	5125.74	2691.0
2015-09-14 05:00:00	NQ	Futures	5126.03	5136.41	5124.25	5129.0	1607.0
2015-09-14 06:00:00	NQ	Futures	5129.0	5139.38	5128.7	5136.41	2847.0
2015-09-14 07:00:00	NQ	Futures	5136.41	5137.6	5118.92	5120.4	1957.0
2015-09-14 08:00:00	NQ	Futures	5120.7	5133.15	5112.99	5127.81	5198.0
2015-09-14 09:00:00	NQ	Futures	5127.81	5135.22	5088.68	5094.31	29722.0
2015-09-14 10:00:00	NQ	Futures	5094.9	5107.35	5090.45	5097.27	23836.0
2015-09-14 11:00:00	NQ	Futures	5096.98	5104.69	5078.89	5088.68	18712.0
2015-09-14 12:00:00	NQ	Futures	5088.38	5094.01	5077.71	5085.12	12273.0
2015-09-14 13:00:00	NQ	Futures	5084.82	5104.39	5080.67	5104.09	11575.0
2015-09-14 14:00:00	NQ	Futures	5103.8	5103.8	5089.86	5096.09	9342.0
2015-09-14 15:00:00	NQ	Futures	5096.38	5102.02	5085.12	5095.79	17436.0
2015-09-14 16:00:00	NQ	Futures	5096.09	5102.91	5094.61	5097.27	3980.0
2015-09-14 17:00:00	NQ	Futures	5096.68	5098.76	5096.38	5098.46	128.0
2015-09-14 18:00:00	NQ	Futures	5096.98	5104.69	5090.16	5100.54	614.0
2015-09-14 19:00:00	NQ	Futures	5101.13	5105.58	5098.46	5105.58	293.0
2015-09-14 20:00:00	NQ	Futures	5105.58	5115.06	5096.38	5112.99	1233.0
2015-09-14 21:00:00	NQ	Futures	5112.39	5114.17	5101.13	5109.43	894.0
2015-09-14 22:00:00	NQ	Futures	5111.21	5116.25	5107.35	5107.35	700.0
2015-09-14 23:00:00	NQ	Futures	5106.76	5109.73	5099.65	5107.65	727.0
2015-09-14 00:00:00	YM	Futures	17318.8	17328.3	17293.4	17318.8	988.0
2015-09-14 01:00:00	YM	Futures	17318.8	17355.9	17298.7	17298.7	2118.0

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

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