PREVIEW / futures_1hour / 2016-08-09

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-08-09.parquet
  size:    53 KB
  rows:    1,601

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-09 00:00:00	ES	Futures	2360.68	2361.22	2360.41	2360.68	1846.0
2016-08-09 01:00:00	ES	Futures	2360.68	2360.95	2359.86	2360.14	2449.0
2016-08-09 02:00:00	ES	Futures	2360.14	2360.68	2358.78	2359.59	4384.0
2016-08-09 03:00:00	ES	Futures	2359.59	2361.49	2358.78	2360.68	19526.0
2016-08-09 04:00:00	ES	Futures	2360.95	2361.49	2359.32	2360.14	9645.0
2016-08-09 05:00:00	ES	Futures	2359.86	2360.95	2359.86	2360.14	6746.0
2016-08-09 06:00:00	ES	Futures	2360.41	2362.3	2360.14	2361.76	10239.0
2016-08-09 07:00:00	ES	Futures	2361.76	2362.85	2361.22	2362.3	16183.0
2016-08-09 08:00:00	ES	Futures	2362.58	2363.66	2360.68	2361.49	22257.0
2016-08-09 09:00:00	ES	Futures	2361.76	2365.02	2360.41	2364.47	158957.0
2016-08-09 10:00:00	ES	Futures	2364.75	2367.46	2362.03	2366.1	216904.0
2016-08-09 11:00:00	ES	Futures	2366.37	2368.54	2366.1	2366.64	134280.0
2016-08-09 12:00:00	ES	Futures	2366.64	2367.73	2362.03	2362.85	109499.0
2016-08-09 13:00:00	ES	Futures	2362.85	2363.93	2360.41	2361.49	80716.0
2016-08-09 14:00:00	ES	Futures	2361.49	2362.03	2357.97	2360.41	144006.0
2016-08-09 15:00:00	ES	Futures	2360.41	2362.3	2359.05	2362.03	177872.0
2016-08-09 16:00:00	ES	Futures	2362.03	2362.85	2361.49	2362.85	56844.0
2016-08-09 18:00:00	ES	Futures	2362.58	2362.58	2360.14	2360.41	5827.0
2016-08-09 19:00:00	ES	Futures	2360.41	2361.22	2359.86	2360.14	2719.0
2016-08-09 20:00:00	ES	Futures	2360.14	2360.41	2359.32	2359.59	5791.0
2016-08-09 21:00:00	ES	Futures	2359.32	2360.14	2358.78	2359.59	4125.0
2016-08-09 22:00:00	ES	Futures	2359.59	2360.41	2359.32	2360.14	2916.0
2016-08-09 23:00:00	ES	Futures	2360.14	2360.68	2359.59	2360.41	2701.0
2016-08-09 00:00:00	NQ	Futures	5700.83	5702.02	5700.53	5700.83	296.0
2016-08-09 01:00:00	NQ	Futures	5700.83	5701.43	5699.64	5701.43	285.0
2016-08-09 02:00:00	NQ	Futures	5700.83	5701.13	5696.96	5698.45	804.0
2016-08-09 03:00:00	NQ	Futures	5698.45	5705.3	5696.96	5702.92	1805.0
2016-08-09 04:00:00	NQ	Futures	5703.22	5704.71	5698.45	5700.53	1195.0
2016-08-09 05:00:00	NQ	Futures	5700.24	5702.62	5699.94	5700.83	461.0
2016-08-09 06:00:00	NQ	Futures	5700.83	5705.9	5699.94	5704.41	732.0
2016-08-09 07:00:00	NQ	Futures	5704.41	5707.39	5703.81	5706.5	1087.0
2016-08-09 08:00:00	NQ	Futures	5706.79	5708.88	5702.92	5704.71	2110.0
2016-08-09 09:00:00	NQ	Futures	5705.0	5720.8	5701.13	5716.63	23978.0
2016-08-09 10:00:00	NQ	Futures	5716.63	5729.45	5711.26	5724.68	26566.0
2016-08-09 11:00:00	NQ	Futures	5724.97	5731.83	5724.08	5726.76	14172.0
2016-08-09 12:00:00	NQ	Futures	5726.76	5731.23	5713.35	5716.03	14711.0
2016-08-09 13:00:00	NQ	Futures	5716.03	5720.5	5710.67	5714.84	9926.0
2016-08-09 14:00:00	NQ	Futures	5715.14	5718.42	5705.6	5713.05	14095.0
2016-08-09 15:00:00	NQ	Futures	5712.75	5714.54	5708.58	5713.65	16038.0
2016-08-09 16:00:00	NQ	Futures	5713.65	5715.14	5710.97	5714.24	3919.0
2016-08-09 18:00:00	NQ	Futures	5714.84	5714.84	5701.13	5708.88	1197.0
2016-08-09 19:00:00	NQ	Futures	5709.18	5710.07	5705.9	5706.5	522.0
2016-08-09 20:00:00	NQ	Futures	5706.5	5708.28	5705.3	5705.3	579.0
2016-08-09 21:00:00	NQ	Futures	5705.3	5707.69	5702.92	5706.79	457.0
2016-08-09 22:00:00	NQ	Futures	5706.2	5709.18	5705.6	5709.18	433.0
2016-08-09 23:00:00	NQ	Futures	5708.58	5709.48	5707.39	5708.88	198.0
2016-08-09 00:00:00	YM	Futures	19871.0	19875.4	19871.0	19873.2	174.0
2016-08-09 01:00:00	YM	Futures	19874.3	19876.4	19868.9	19874.3	366.0
2016-08-09 02:00:00	YM	Futures	19873.2	19873.2	19863.5	19866.7	645.0
2016-08-09 03:00:00	YM	Futures	19866.7	19886.1	19862.4	19877.5	2178.0

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

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