PREVIEW / futures_1hour / 2016-11-10

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-11-10.parquet
  size:    58 KB
  rows:    1,676

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-11-10 00:00:00	ES	Futures	2349.67	2362.46	2349.4	2358.11	20501.0
2016-11-10 01:00:00	ES	Futures	2358.11	2359.74	2355.66	2355.93	8126.0
2016-11-10 02:00:00	ES	Futures	2355.93	2364.09	2355.93	2361.92	18647.0
2016-11-10 03:00:00	ES	Futures	2361.65	2373.07	2358.65	2368.99	82058.0
2016-11-10 04:00:00	ES	Futures	2369.26	2369.54	2362.46	2366.54	42129.0
2016-11-10 05:00:00	ES	Futures	2366.54	2371.44	2366.54	2368.18	28745.0
2016-11-10 06:00:00	ES	Futures	2368.45	2368.72	2364.09	2367.09	31630.0
2016-11-10 07:00:00	ES	Futures	2367.09	2367.36	2356.2	2363.01	68234.0
2016-11-10 08:00:00	ES	Futures	2363.01	2365.73	2358.65	2362.73	86305.0
2016-11-10 09:00:00	ES	Futures	2362.73	2370.9	2358.65	2361.65	363295.0
2016-11-10 10:00:00	ES	Futures	2361.92	2364.37	2337.43	2340.42	803047.0
2016-11-10 11:00:00	ES	Futures	2340.15	2355.66	2337.43	2346.68	496089.0
2016-11-10 12:00:00	ES	Futures	2346.68	2358.38	2346.14	2357.84	218620.0
2016-11-10 13:00:00	ES	Futures	2357.84	2367.63	2355.66	2363.82	238559.0
2016-11-10 14:00:00	ES	Futures	2363.82	2366.27	2357.84	2362.19	174359.0
2016-11-10 15:00:00	ES	Futures	2362.46	2364.09	2353.21	2355.39	268603.0
2016-11-10 16:00:00	ES	Futures	2355.12	2359.2	2353.48	2355.66	89626.0
2016-11-10 18:00:00	ES	Futures	2356.2	2357.56	2354.84	2357.02	7786.0
2016-11-10 19:00:00	ES	Futures	2356.75	2358.92	2354.3	2355.12	10402.0
2016-11-10 20:00:00	ES	Futures	2355.12	2356.2	2353.48	2353.76	13204.0
2016-11-10 21:00:00	ES	Futures	2353.76	2354.84	2351.58	2352.12	15038.0
2016-11-10 22:00:00	ES	Futures	2352.12	2354.3	2351.85	2352.94	8596.0
2016-11-10 23:00:00	ES	Futures	2353.21	2355.39	2352.67	2354.84	5892.0
2016-11-10 00:00:00	NQ	Futures	5768.01	5805.3	5767.11	5789.79	4877.0
2016-11-10 01:00:00	NQ	Futures	5789.79	5796.95	5785.01	5787.4	1522.0
2016-11-10 02:00:00	NQ	Futures	5787.7	5802.32	5785.61	5795.45	4518.0
2016-11-10 03:00:00	NQ	Futures	5795.45	5823.2	5790.08	5814.25	10070.0
2016-11-10 04:00:00	NQ	Futures	5813.95	5813.95	5794.86	5806.19	4918.0
2016-11-10 05:00:00	NQ	Futures	5805.9	5816.34	5805.0	5807.69	3061.0
2016-11-10 06:00:00	NQ	Futures	5807.98	5808.88	5796.05	5802.61	3217.0
2016-11-10 07:00:00	NQ	Futures	5802.32	5802.61	5777.55	5790.38	7616.0
2016-11-10 08:00:00	NQ	Futures	5790.38	5795.45	5778.15	5786.21	11880.0
2016-11-10 09:00:00	NQ	Futures	5785.91	5789.49	5746.53	5747.72	54893.0
2016-11-10 10:00:00	NQ	Futures	5747.72	5755.18	5583.93	5614.07	153378.0
2016-11-10 11:00:00	NQ	Futures	5613.77	5661.8	5606.91	5624.21	87943.0
2016-11-10 12:00:00	NQ	Futures	5624.21	5661.8	5617.05	5660.91	49347.0
2016-11-10 13:00:00	NQ	Futures	5660.91	5701.18	5653.75	5689.25	49104.0
2016-11-10 14:00:00	NQ	Futures	5689.25	5702.08	5671.05	5690.74	30607.0
2016-11-10 15:00:00	NQ	Futures	5690.74	5695.81	5650.46	5659.12	39137.0
2016-11-10 16:00:00	NQ	Futures	5659.41	5664.19	5652.25	5655.83	9269.0
2016-11-10 18:00:00	NQ	Futures	5658.52	5659.12	5651.36	5653.45	1444.0
2016-11-10 19:00:00	NQ	Futures	5653.45	5659.41	5645.69	5647.18	2444.0
2016-11-10 20:00:00	NQ	Futures	5647.78	5649.87	5625.4	5626.0	4522.0
2016-11-10 21:00:00	NQ	Futures	5625.7	5636.14	5621.82	5624.51	2746.0
2016-11-10 22:00:00	NQ	Futures	5624.51	5629.88	5615.56	5616.75	2528.0
2016-11-10 23:00:00	NQ	Futures	5617.05	5623.31	5616.15	5619.14	1221.0
2016-11-10 00:00:00	YM	Futures	20024.4	20123.8	20022.2	20090.3	6572.0
2016-11-10 01:00:00	YM	Futures	20090.3	20105.4	20065.4	20074.1	2553.0
2016-11-10 02:00:00	YM	Futures	20074.1	20143.3	20074.1	20126.0	4294.0
2016-11-10 03:00:00	YM	Futures	20124.9	20225.4	20103.3	20191.9	14356.0

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

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