PREVIEW / futures_1hour / 2016-08-30

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-08-30.parquet
  size:    50 KB
  rows:    1,580

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-08-30 00:00:00	ES	Futures	2363.39	2363.93	2363.39	2363.39	1339.0
2016-08-30 01:00:00	ES	Futures	2363.39	2364.2	2363.39	2363.93	1601.0
2016-08-30 02:00:00	ES	Futures	2363.93	2364.2	2362.58	2362.85	9133.0
2016-08-30 03:00:00	ES	Futures	2362.85	2365.29	2362.3	2363.93	26664.0
2016-08-30 04:00:00	ES	Futures	2363.66	2365.02	2362.3	2364.47	13359.0
2016-08-30 05:00:00	ES	Futures	2364.47	2364.75	2362.3	2363.12	14395.0
2016-08-30 06:00:00	ES	Futures	2362.85	2363.93	2361.22	2363.12	21516.0
2016-08-30 07:00:00	ES	Futures	2363.12	2363.66	2362.3	2363.12	6994.0
2016-08-30 08:00:00	ES	Futures	2362.85	2364.2	2362.3	2363.12	18332.0
2016-08-30 09:00:00	ES	Futures	2363.12	2366.37	2361.76	2363.12	171017.0
2016-08-30 10:00:00	ES	Futures	2363.39	2364.75	2355.53	2357.97	299108.0
2016-08-30 11:00:00	ES	Futures	2357.97	2360.14	2356.34	2358.78	155160.0
2016-08-30 12:00:00	ES	Futures	2359.05	2360.68	2357.97	2358.24	80300.0
2016-08-30 13:00:00	ES	Futures	2357.97	2359.32	2355.8	2356.61	73752.0
2016-08-30 14:00:00	ES	Futures	2356.61	2356.88	2352.27	2355.53	164451.0
2016-08-30 15:00:00	ES	Futures	2355.8	2359.59	2354.17	2359.32	201820.0
2016-08-30 16:00:00	ES	Futures	2359.32	2360.95	2358.51	2360.14	77989.0
2016-08-30 18:00:00	ES	Futures	2360.14	2360.68	2359.05	2359.32	2871.0
2016-08-30 19:00:00	ES	Futures	2359.32	2359.86	2358.78	2358.78	1752.0
2016-08-30 20:00:00	ES	Futures	2359.05	2359.32	2357.69	2357.97	4354.0
2016-08-30 21:00:00	ES	Futures	2357.97	2359.05	2357.15	2358.78	4684.0
2016-08-30 22:00:00	ES	Futures	2358.78	2359.86	2358.24	2359.59	2235.0
2016-08-30 23:00:00	ES	Futures	2359.59	2359.59	2359.05	2359.32	1776.0
2016-08-30 00:00:00	NQ	Futures	5714.24	5714.24	5713.35	5713.65	408.0
2016-08-30 01:00:00	NQ	Futures	5713.65	5716.63	5713.65	5715.44	370.0
2016-08-30 02:00:00	NQ	Futures	5715.73	5716.63	5712.16	5713.95	948.0
2016-08-30 03:00:00	NQ	Futures	5713.65	5719.01	5711.26	5714.84	2972.0
2016-08-30 04:00:00	NQ	Futures	5715.14	5717.82	5710.97	5714.54	1697.0
2016-08-30 05:00:00	NQ	Futures	5714.84	5716.63	5705.9	5706.79	2911.0
2016-08-30 06:00:00	NQ	Futures	5706.5	5707.99	5699.34	5704.11	4080.0
2016-08-30 07:00:00	NQ	Futures	5704.11	5705.3	5701.73	5703.22	1253.0
2016-08-30 08:00:00	NQ	Futures	5703.22	5707.39	5700.24	5703.22	3292.0
2016-08-30 09:00:00	NQ	Futures	5703.22	5720.8	5702.32	5715.14	28282.0
2016-08-30 10:00:00	NQ	Futures	5715.14	5719.61	5682.35	5691.29	46889.0
2016-08-30 11:00:00	NQ	Futures	5691.0	5699.34	5685.63	5689.8	19640.0
2016-08-30 12:00:00	NQ	Futures	5689.8	5697.85	5689.21	5690.7	12234.0
2016-08-30 13:00:00	NQ	Futures	5690.7	5693.38	5682.95	5686.53	9917.0
2016-08-30 14:00:00	NQ	Futures	5686.53	5686.53	5674.6	5683.25	18125.0
2016-08-30 15:00:00	NQ	Futures	5682.95	5695.47	5680.27	5695.47	22043.0
2016-08-30 16:00:00	NQ	Futures	5695.17	5698.15	5691.29	5697.26	6871.0
2016-08-30 18:00:00	NQ	Futures	5696.66	5697.85	5692.78	5693.68	686.0
2016-08-30 19:00:00	NQ	Futures	5693.68	5693.98	5691.59	5691.59	222.0
2016-08-30 20:00:00	NQ	Futures	5691.59	5692.19	5688.02	5688.91	891.0
2016-08-30 21:00:00	NQ	Futures	5688.61	5691.0	5685.63	5689.8	799.0
2016-08-30 22:00:00	NQ	Futures	5690.1	5692.49	5689.51	5691.89	329.0
2016-08-30 23:00:00	NQ	Futures	5691.89	5692.49	5690.4	5692.19	418.0
2016-08-30 00:00:00	YM	Futures	19898.0	19901.2	19896.9	19898.0	200.0
2016-08-30 01:00:00	YM	Futures	19899.0	19904.4	19899.0	19903.3	491.0
2016-08-30 02:00:00	YM	Futures	19903.3	19904.4	19892.6	19896.9	1290.0
2016-08-30 03:00:00	YM	Futures	19896.9	19917.3	19890.4	19904.4	3184.0

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

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