PREVIEW / futures_1hour / 2016-03-15

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-03-15.parquet
  size:    51 KB
  rows:    1,582

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-15 00:00:00	ES	Futures	2165.51	2165.78	2163.62	2164.97	5018.0
2016-03-15 01:00:00	ES	Futures	2165.24	2165.51	2163.62	2164.7	3608.0
2016-03-15 02:00:00	ES	Futures	2164.7	2165.51	2164.16	2164.7	2991.0
2016-03-15 03:00:00	ES	Futures	2164.7	2166.05	2159.84	2160.11	15145.0
2016-03-15 04:00:00	ES	Futures	2160.11	2162.54	2157.14	2157.68	33988.0
2016-03-15 05:00:00	ES	Futures	2157.68	2161.19	2157.14	2158.22	18274.0
2016-03-15 06:00:00	ES	Futures	2158.49	2160.11	2156.06	2158.76	17392.0
2016-03-15 07:00:00	ES	Futures	2158.76	2159.84	2157.14	2158.76	16108.0
2016-03-15 08:00:00	ES	Futures	2158.49	2159.84	2155.25	2157.68	40807.0
2016-03-15 09:00:00	ES	Futures	2157.95	2160.38	2154.98	2156.33	192243.0
2016-03-15 10:00:00	ES	Futures	2156.6	2162.81	2154.44	2158.76	214216.0
2016-03-15 11:00:00	ES	Futures	2158.76	2162.54	2157.41	2158.49	123407.0
2016-03-15 12:00:00	ES	Futures	2158.49	2160.92	2157.41	2158.76	90656.0
2016-03-15 13:00:00	ES	Futures	2158.76	2164.16	2158.22	2163.62	86618.0
2016-03-15 14:00:00	ES	Futures	2163.35	2165.78	2160.92	2162.0	96808.0
2016-03-15 15:00:00	ES	Futures	2162.0	2167.13	2161.46	2167.13	166229.0
2016-03-15 16:00:00	ES	Futures	2166.86	2167.94	2165.51	2167.13	57668.0
2016-03-15 18:00:00	ES	Futures	2167.13	2167.94	2166.59	2167.67	2739.0
2016-03-15 19:00:00	ES	Futures	2167.4	2169.83	2166.86	2169.56	4174.0
2016-03-15 20:00:00	ES	Futures	2169.56	2172.53	2169.02	2171.45	7140.0
2016-03-15 21:00:00	ES	Futures	2171.72	2171.72	2168.75	2169.56	5565.0
2016-03-15 22:00:00	ES	Futures	2169.83	2169.83	2166.59	2167.4	4248.0
2016-03-15 23:00:00	ES	Futures	2167.67	2168.21	2165.24	2166.32	4533.0
2016-03-15 00:00:00	NQ	Futures	5171.66	5172.55	5167.5	5170.47	415.0
2016-03-15 01:00:00	NQ	Futures	5170.47	5173.45	5167.2	5171.07	475.0
2016-03-15 02:00:00	NQ	Futures	5171.36	5174.04	5169.58	5171.07	429.0
2016-03-15 03:00:00	NQ	Futures	5171.07	5175.53	5161.25	5162.14	1617.0
2016-03-15 04:00:00	NQ	Futures	5162.14	5167.2	5153.21	5156.49	3758.0
2016-03-15 05:00:00	NQ	Futures	5156.49	5166.01	5155.0	5160.36	2591.0
2016-03-15 06:00:00	NQ	Futures	5161.25	5168.98	5156.49	5166.01	2978.0
2016-03-15 07:00:00	NQ	Futures	5166.01	5173.45	5164.22	5171.07	2596.0
2016-03-15 08:00:00	NQ	Futures	5171.36	5172.85	5160.06	5166.9	6496.0
2016-03-15 09:00:00	NQ	Futures	5167.2	5176.72	5156.19	5163.03	31696.0
2016-03-15 10:00:00	NQ	Futures	5163.33	5179.69	5152.62	5172.26	33393.0
2016-03-15 11:00:00	NQ	Futures	5172.26	5187.13	5169.58	5171.07	23427.0
2016-03-15 12:00:00	NQ	Futures	5171.07	5181.18	5168.98	5173.74	13728.0
2016-03-15 13:00:00	NQ	Futures	5173.45	5186.54	5171.07	5184.46	11440.0
2016-03-15 14:00:00	NQ	Futures	5184.46	5189.81	5177.61	5181.18	13169.0
2016-03-15 15:00:00	NQ	Futures	5181.48	5191.89	5178.5	5186.24	18943.0
2016-03-15 16:00:00	NQ	Futures	5186.24	5194.57	5181.18	5189.22	5566.0
2016-03-15 18:00:00	NQ	Futures	5188.03	5189.51	5183.26	5188.62	338.0
2016-03-15 19:00:00	NQ	Futures	5188.32	5193.68	5186.24	5193.08	463.0
2016-03-15 20:00:00	NQ	Futures	5192.79	5199.63	5191.3	5198.74	859.0
2016-03-15 21:00:00	NQ	Futures	5199.03	5199.33	5191.3	5193.98	775.0
2016-03-15 22:00:00	NQ	Futures	5192.79	5193.08	5185.65	5187.73	451.0
2016-03-15 23:00:00	NQ	Futures	5188.03	5189.51	5180.29	5183.26	662.0
2016-03-15 00:00:00	YM	Futures	18300.5	18300.5	18284.4	18293.0	600.0
2016-03-15 01:00:00	YM	Futures	18291.9	18300.5	18282.3	18291.9	338.0
2016-03-15 02:00:00	YM	Futures	18293.0	18300.5	18286.5	18286.5	541.0
2016-03-15 03:00:00	YM	Futures	18286.5	18300.5	18259.8	18263.0	1472.0

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

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