PREVIEW / futures_1hour / 2016-02-26

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-02-26.parquet
  size:    46 KB
  rows:    1,317

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-02-26 00:00:00	ES	Futures	2097.54	2098.35	2095.12	2095.66	5536.0
2016-02-26 01:00:00	ES	Futures	2095.66	2098.62	2095.39	2098.08	3729.0
2016-02-26 02:00:00	ES	Futures	2098.08	2104.53	2096.47	2103.45	26499.0
2016-02-26 03:00:00	ES	Futures	2103.45	2109.63	2101.84	2106.95	56111.0
2016-02-26 04:00:00	ES	Futures	2106.95	2114.2	2106.14	2113.93	47570.0
2016-02-26 05:00:00	ES	Futures	2113.93	2116.08	2112.05	2113.4	36020.0
2016-02-26 06:00:00	ES	Futures	2113.4	2113.67	2105.87	2107.22	37283.0
2016-02-26 07:00:00	ES	Futures	2107.48	2108.56	2103.45	2105.07	40206.0
2016-02-26 08:00:00	ES	Futures	2105.07	2113.13	2104.53	2107.22	85912.0
2016-02-26 09:00:00	ES	Futures	2107.22	2109.37	2101.3	2101.84	255973.0
2016-02-26 10:00:00	ES	Futures	2102.11	2105.07	2095.12	2104.8	292191.0
2016-02-26 11:00:00	ES	Futures	2104.8	2105.6	2095.39	2098.62	242827.0
2016-02-26 12:00:00	ES	Futures	2098.35	2103.45	2093.51	2101.57	161590.0
2016-02-26 13:00:00	ES	Futures	2101.57	2102.92	2092.17	2094.86	120760.0
2016-02-26 14:00:00	ES	Futures	2094.86	2097.01	2088.41	2089.48	142606.0
2016-02-26 15:00:00	ES	Futures	2089.48	2095.39	2088.94	2090.82	191162.0
2016-02-26 16:00:00	ES	Futures	2091.09	2091.36	2086.53	2086.53	77635.0
2016-02-26 00:00:00	NQ	Futures	5047.54	5049.61	5040.71	5042.19	1034.0
2016-02-26 01:00:00	NQ	Futures	5042.49	5050.8	5041.3	5050.8	1004.0
2016-02-26 02:00:00	NQ	Futures	5050.51	5070.99	5046.35	5067.73	3475.0
2016-02-26 03:00:00	NQ	Futures	5067.73	5085.25	5063.27	5079.9	6389.0
2016-02-26 04:00:00	NQ	Futures	5080.2	5093.86	5077.82	5093.26	5680.0
2016-02-26 05:00:00	NQ	Futures	5093.26	5099.2	5086.14	5088.51	3688.0
2016-02-26 06:00:00	NQ	Futures	5088.81	5089.11	5069.51	5074.56	4690.0
2016-02-26 07:00:00	NQ	Futures	5074.85	5077.82	5063.57	5069.51	4013.0
2016-02-26 08:00:00	NQ	Futures	5069.21	5087.92	5067.73	5073.37	10409.0
2016-02-26 09:00:00	NQ	Futures	5073.07	5079.31	5056.74	5058.52	41883.0
2016-02-26 10:00:00	NQ	Futures	5058.82	5059.41	5035.66	5055.26	40371.0
2016-02-26 11:00:00	NQ	Futures	5054.96	5058.52	5030.02	5035.36	28577.0
2016-02-26 12:00:00	NQ	Futures	5035.66	5042.19	5018.14	5037.44	24686.0
2016-02-26 13:00:00	NQ	Futures	5037.14	5044.57	5023.19	5030.31	17592.0
2016-02-26 14:00:00	NQ	Futures	5030.31	5039.82	5018.44	5024.08	25455.0
2016-02-26 15:00:00	NQ	Futures	5024.38	5040.71	5022.3	5029.42	37923.0
2016-02-26 16:00:00	NQ	Futures	5029.42	5032.1	5019.92	5019.92	6843.0
2016-02-26 00:00:00	YM	Futures	17752.3	17760.8	17735.3	17739.5	893.0
2016-02-26 01:00:00	YM	Futures	17739.5	17758.7	17737.4	17755.5	615.0
2016-02-26 02:00:00	YM	Futures	17757.6	17813.0	17744.9	17805.5	2915.0
2016-02-26 03:00:00	YM	Futures	17807.7	17852.4	17792.8	17835.3	6160.0
2016-02-26 04:00:00	YM	Futures	17835.3	17887.5	17827.9	17886.4	4712.0
2016-02-26 05:00:00	YM	Futures	17887.5	17904.5	17874.7	17885.4	2868.0
2016-02-26 06:00:00	YM	Futures	17886.4	17886.4	17825.8	17834.3	5208.0
2016-02-26 07:00:00	YM	Futures	17835.3	17843.8	17806.6	17824.7	3584.0
2016-02-26 08:00:00	YM	Futures	17823.6	17890.7	17819.4	17851.3	10415.0
2016-02-26 09:00:00	YM	Futures	17850.2	17870.5	17786.4	17788.5	22919.0
2016-02-26 10:00:00	YM	Futures	17789.6	17808.7	17735.3	17806.6	25415.0
2016-02-26 11:00:00	YM	Futures	17806.6	17810.9	17726.8	17748.0	19165.0
2016-02-26 12:00:00	YM	Futures	17748.0	17793.8	17708.7	17778.9	12488.0
2016-02-26 13:00:00	YM	Futures	17778.9	17791.7	17705.5	17722.5	8929.0
2016-02-26 14:00:00	YM	Futures	17722.5	17737.4	17670.3	17672.5	10731.0
2016-02-26 15:00:00	YM	Futures	17672.5	17718.2	17668.2	17686.3	11544.0

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

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