PREVIEW / futures_1hour / 2015-03-26

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-03-26.parquet
  size:    52 KB
  rows:    1,558

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-26 00:00:00	ES	Futures	2169.73	2170.78	2168.67	2169.46	2634.0
2015-03-26 01:00:00	ES	Futures	2169.73	2169.99	2168.67	2169.2	2553.0
2015-03-26 02:00:00	ES	Futures	2169.2	2169.73	2162.6	2162.6	10926.0
2015-03-26 03:00:00	ES	Futures	2162.86	2163.39	2158.11	2158.37	23981.0
2015-03-26 04:00:00	ES	Futures	2158.63	2160.48	2153.09	2153.62	45778.0
2015-03-26 05:00:00	ES	Futures	2153.62	2154.41	2148.07	2152.03	54977.0
2015-03-26 06:00:00	ES	Futures	2152.03	2156.26	2150.71	2154.94	22818.0
2015-03-26 07:00:00	ES	Futures	2154.67	2157.31	2152.56	2153.88	28628.0
2015-03-26 08:00:00	ES	Futures	2153.88	2161.01	2151.24	2158.63	55593.0
2015-03-26 09:00:00	ES	Futures	2158.9	2166.03	2155.47	2158.37	277929.0
2015-03-26 10:00:00	ES	Futures	2158.37	2164.45	2151.24	2163.39	331695.0
2015-03-26 11:00:00	ES	Futures	2163.12	2169.46	2157.31	2169.46	189819.0
2015-03-26 12:00:00	ES	Futures	2169.46	2169.99	2163.12	2168.67	135782.0
2015-03-26 13:00:00	ES	Futures	2168.67	2175.01	2162.33	2172.9	161404.0
2015-03-26 14:00:00	ES	Futures	2173.16	2173.69	2164.45	2164.71	136996.0
2015-03-26 15:00:00	ES	Futures	2164.45	2170.26	2162.33	2163.65	217229.0
2015-03-26 16:00:00	ES	Futures	2163.92	2165.77	2162.07	2165.5	103970.0
2015-03-26 17:00:00	ES	Futures	2165.5	2165.77	2165.5	2165.5	938.0
2015-03-26 18:00:00	ES	Futures	2165.77	2166.56	2164.97	2165.24	3792.0
2015-03-26 19:00:00	ES	Futures	2164.97	2165.77	2164.71	2165.5	2103.0
2015-03-26 20:00:00	ES	Futures	2165.77	2168.41	2165.5	2168.14	6317.0
2015-03-26 21:00:00	ES	Futures	2168.14	2173.16	2167.35	2171.84	12620.0
2015-03-26 22:00:00	ES	Futures	2171.58	2171.84	2169.46	2171.05	4524.0
2015-03-26 23:00:00	ES	Futures	2171.05	2173.95	2171.05	2172.9	3468.0
2015-03-26 00:00:00	NQ	Futures	5082.89	5084.65	5080.83	5083.18	479.0
2015-03-26 01:00:00	NQ	Futures	5082.89	5084.06	5081.12	5081.71	702.0
2015-03-26 02:00:00	NQ	Futures	5082.3	5082.89	5067.01	5067.01	2625.0
2015-03-26 03:00:00	NQ	Futures	5066.71	5067.6	5054.95	5055.25	3828.0
2015-03-26 04:00:00	NQ	Futures	5055.25	5058.48	5037.9	5039.95	9258.0
2015-03-26 05:00:00	NQ	Futures	5039.95	5040.54	5022.61	5026.43	9510.0
2015-03-26 06:00:00	NQ	Futures	5026.43	5033.78	5023.78	5031.72	4967.0
2015-03-26 07:00:00	NQ	Futures	5031.72	5036.72	5027.31	5032.02	5786.0
2015-03-26 08:00:00	NQ	Futures	5031.72	5047.01	5023.19	5043.78	11424.0
2015-03-26 09:00:00	NQ	Futures	5043.48	5072.89	5024.96	5040.84	77307.0
2015-03-26 10:00:00	NQ	Futures	5040.54	5064.36	5024.66	5063.77	67253.0
2015-03-26 11:00:00	NQ	Futures	5063.77	5078.77	5047.6	5078.77	35102.0
2015-03-26 12:00:00	NQ	Futures	5078.77	5082.01	5060.83	5077.6	24318.0
2015-03-26 13:00:00	NQ	Futures	5077.6	5094.36	5060.54	5088.18	27792.0
2015-03-26 14:00:00	NQ	Futures	5087.89	5089.95	5068.48	5069.07	24516.0
2015-03-26 15:00:00	NQ	Futures	5068.77	5082.3	5063.77	5066.71	35310.0
2015-03-26 16:00:00	NQ	Futures	5066.42	5073.48	5064.66	5073.48	9700.0
2015-03-26 17:00:00	NQ	Futures	5073.48	5074.36	5073.48	5074.07	69.0
2015-03-26 18:00:00	NQ	Futures	5073.18	5077.01	5073.18	5074.65	623.0
2015-03-26 19:00:00	NQ	Futures	5074.65	5075.24	5073.77	5074.95	315.0
2015-03-26 20:00:00	NQ	Futures	5074.95	5080.83	5074.95	5080.24	1115.0
2015-03-26 21:00:00	NQ	Futures	5079.95	5088.77	5078.48	5086.42	2077.0
2015-03-26 22:00:00	NQ	Futures	5086.42	5088.48	5082.3	5086.71	814.0
2015-03-26 23:00:00	NQ	Futures	5086.42	5091.12	5085.53	5089.06	889.0
2015-03-26 00:00:00	YM	Futures	18510.0	18515.3	18498.5	18507.9	523.0
2015-03-26 01:00:00	YM	Futures	18509.0	18512.1	18503.7	18509.0	596.0

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

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