PREVIEW / futures_1hour / 2015-03-16

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-03-16.parquet
  size:    49 KB
  rows:    1,510

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-03-16 00:00:00	ES	Futures	2159.96	2160.22	2158.9	2158.9	1386.0
2015-03-16 01:00:00	ES	Futures	2159.16	2160.48	2158.9	2160.22	1476.0
2015-03-16 02:00:00	ES	Futures	2160.22	2162.6	2159.96	2161.54	2777.0
2015-03-16 03:00:00	ES	Futures	2161.8	2162.6	2160.48	2161.01	5602.0
2015-03-16 04:00:00	ES	Futures	2160.75	2167.88	2160.22	2167.88	16930.0
2015-03-16 05:00:00	ES	Futures	2167.88	2168.41	2164.97	2167.35	15235.0
2015-03-16 06:00:00	ES	Futures	2167.35	2169.2	2165.77	2166.82	8262.0
2015-03-16 07:00:00	ES	Futures	2166.56	2167.35	2164.45	2166.03	8886.0
2015-03-16 08:00:00	ES	Futures	2166.03	2170.78	2165.77	2169.99	28849.0
2015-03-16 09:00:00	ES	Futures	2169.99	2181.08	2169.46	2179.76	213109.0
2015-03-16 10:00:00	ES	Futures	2180.03	2183.2	2178.97	2181.35	170812.0
2015-03-16 11:00:00	ES	Futures	2181.61	2186.1	2180.82	2184.52	123184.0
2015-03-16 12:00:00	ES	Futures	2184.52	2185.05	2181.08	2183.2	71959.0
2015-03-16 13:00:00	ES	Futures	2183.2	2185.57	2180.03	2184.25	63823.0
2015-03-16 14:00:00	ES	Futures	2184.52	2189.27	2182.93	2188.74	85677.0
2015-03-16 15:00:00	ES	Futures	2188.74	2191.12	2187.16	2190.59	154891.0
2015-03-16 16:00:00	ES	Futures	2190.59	2190.86	2184.25	2184.78	86199.0
2015-03-16 17:00:00	ES	Futures	2184.78	2185.05	2183.46	2183.73	2292.0
2015-03-16 18:00:00	ES	Futures	2183.2	2183.46	2181.35	2182.67	4504.0
2015-03-16 19:00:00	ES	Futures	2182.67	2183.99	2182.14	2183.73	2069.0
2015-03-16 20:00:00	ES	Futures	2183.99	2184.25	2181.88	2182.41	4499.0
2015-03-16 21:00:00	ES	Futures	2182.14	2183.46	2181.08	2181.61	4436.0
2015-03-16 22:00:00	ES	Futures	2181.88	2183.46	2181.35	2182.67	1309.0
2015-03-16 23:00:00	ES	Futures	2182.93	2184.52	2182.67	2183.46	2500.0
2015-03-16 00:00:00	NQ	Futures	5066.13	5066.42	5063.48	5063.48	368.0
2015-03-16 01:00:00	NQ	Futures	5063.48	5067.3	5063.48	5066.13	299.0
2015-03-16 02:00:00	NQ	Futures	5065.83	5071.42	5065.24	5069.07	606.0
2015-03-16 03:00:00	NQ	Futures	5069.66	5071.13	5067.3	5068.48	1091.0
2015-03-16 04:00:00	NQ	Futures	5069.07	5080.83	5064.36	5080.54	3499.0
2015-03-16 05:00:00	NQ	Futures	5080.54	5083.18	5076.42	5080.83	3171.0
2015-03-16 06:00:00	NQ	Futures	5080.83	5084.65	5077.6	5078.77	1552.0
2015-03-16 07:00:00	NQ	Futures	5078.77	5080.54	5076.42	5078.77	1881.0
2015-03-16 08:00:00	NQ	Futures	5078.77	5087.59	5078.18	5086.12	4401.0
2015-03-16 09:00:00	NQ	Futures	5086.12	5107.88	5080.54	5104.65	36577.0
2015-03-16 10:00:00	NQ	Futures	5104.65	5117.59	5103.77	5115.82	28129.0
2015-03-16 11:00:00	NQ	Futures	5115.82	5123.76	5114.35	5119.35	21124.0
2015-03-16 12:00:00	NQ	Futures	5119.06	5121.12	5109.06	5114.35	10744.0
2015-03-16 13:00:00	NQ	Futures	5114.65	5121.12	5107.3	5119.94	9860.0
2015-03-16 14:00:00	NQ	Futures	5120.23	5129.94	5117.29	5127.0	13487.0
2015-03-16 15:00:00	NQ	Futures	5127.59	5135.23	5125.82	5134.64	24955.0
2015-03-16 16:00:00	NQ	Futures	5134.94	5134.94	5118.18	5119.65	10889.0
2015-03-16 17:00:00	NQ	Futures	5119.35	5120.23	5117.0	5117.29	147.0
2015-03-16 18:00:00	NQ	Futures	5114.35	5117.29	5111.12	5115.82	799.0
2015-03-16 19:00:00	NQ	Futures	5116.12	5119.35	5115.53	5119.35	292.0
2015-03-16 20:00:00	NQ	Futures	5119.35	5119.94	5114.94	5116.41	495.0
2015-03-16 21:00:00	NQ	Futures	5116.41	5118.76	5113.76	5115.53	929.0
2015-03-16 22:00:00	NQ	Futures	5115.82	5119.06	5114.94	5118.18	315.0
2015-03-16 23:00:00	NQ	Futures	5118.47	5122.0	5117.59	5119.94	507.0
2015-03-16 00:00:00	YM	Futures	18528.9	18528.9	18521.5	18521.5	306.0
2015-03-16 01:00:00	YM	Futures	18523.6	18535.2	18521.5	18533.1	370.0

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

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