PREVIEW / futures_1hour / 2017-04-26

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-04-26.parquet
  size:    54 KB
  rows:    1,675

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
2017-04-26 00:00:00	ES	Futures	2606.06	2606.6	2604.96	2606.6	4630.0
2017-04-26 01:00:00	ES	Futures	2606.6	2607.15	2606.33	2606.6	2718.0
2017-04-26 02:00:00	ES	Futures	2606.6	2606.88	2604.96	2605.78	6042.0
2017-04-26 03:00:00	ES	Futures	2605.78	2606.33	2603.33	2603.87	16105.0
2017-04-26 04:00:00	ES	Futures	2603.6	2605.24	2603.6	2604.96	8069.0
2017-04-26 05:00:00	ES	Futures	2604.96	2607.42	2604.42	2607.15	11189.0
2017-04-26 06:00:00	ES	Futures	2607.15	2607.7	2604.15	2604.42	14028.0
2017-04-26 07:00:00	ES	Futures	2604.42	2605.24	2602.78	2603.87	19800.0
2017-04-26 08:00:00	ES	Futures	2603.87	2607.42	2603.6	2606.6	37255.0
2017-04-26 09:00:00	ES	Futures	2606.6	2608.79	2604.96	2608.24	129250.0
2017-04-26 10:00:00	ES	Futures	2607.97	2611.52	2606.88	2610.97	136297.0
2017-04-26 11:00:00	ES	Futures	2610.97	2616.44	2607.15	2609.33	255196.0
2017-04-26 12:00:00	ES	Futures	2609.33	2614.52	2608.24	2614.25	120530.0
2017-04-26 13:00:00	ES	Futures	2614.25	2616.16	2608.52	2610.15	175506.0
2017-04-26 14:00:00	ES	Futures	2610.15	2613.16	2607.97	2610.97	146352.0
2017-04-26 15:00:00	ES	Futures	2610.97	2613.43	2603.05	2604.15	287130.0
2017-04-26 16:00:00	ES	Futures	2604.15	2604.96	2601.96	2602.23	82240.0
2017-04-26 17:00:00	ES	Futures	2601.96	2601.96	2601.96	2601.96	1.0
2017-04-26 18:00:00	ES	Futures	2601.96	2603.87	2601.69	2603.87	6408.0
2017-04-26 19:00:00	ES	Futures	2603.87	2605.78	2603.33	2604.15	4792.0
2017-04-26 20:00:00	ES	Futures	2604.15	2605.78	2603.87	2604.96	4265.0
2017-04-26 21:00:00	ES	Futures	2604.96	2605.78	2604.42	2604.42	3469.0
2017-04-26 22:00:00	ES	Futures	2604.42	2605.51	2603.87	2605.24	4346.0
2017-04-26 23:00:00	ES	Futures	2605.24	2605.51	2604.15	2604.42	2936.0
2017-04-26 00:00:00	NQ	Futures	6620.2	6621.1	6617.82	6620.5	745.0
2017-04-26 01:00:00	NQ	Futures	6620.8	6624.08	6620.8	6622.89	839.0
2017-04-26 02:00:00	NQ	Futures	6622.89	6623.18	6618.41	6620.5	1343.0
2017-04-26 03:00:00	NQ	Futures	6620.2	6623.78	6617.52	6618.12	2315.0
2017-04-26 04:00:00	NQ	Futures	6618.12	6620.8	6617.52	6619.31	1449.0
2017-04-26 05:00:00	NQ	Futures	6619.31	6624.38	6619.01	6623.18	1715.0
2017-04-26 06:00:00	NQ	Futures	6623.18	6624.38	6617.22	6618.12	2151.0
2017-04-26 07:00:00	NQ	Futures	6618.12	6620.5	6614.84	6617.22	2405.0
2017-04-26 08:00:00	NQ	Futures	6617.22	6621.99	6616.63	6621.1	4804.0
2017-04-26 09:00:00	NQ	Futures	6621.4	6633.62	6611.86	6616.33	32705.0
2017-04-26 10:00:00	NQ	Futures	6616.33	6619.9	6609.77	6616.92	27402.0
2017-04-26 11:00:00	NQ	Futures	6616.92	6625.87	6604.4	6609.17	35996.0
2017-04-26 12:00:00	NQ	Futures	6608.87	6620.5	6606.19	6618.41	19635.0
2017-04-26 13:00:00	NQ	Futures	6618.41	6624.97	6607.98	6611.26	24040.0
2017-04-26 14:00:00	NQ	Futures	6611.26	6620.5	6606.79	6613.94	24109.0
2017-04-26 15:00:00	NQ	Futures	6613.94	6622.29	6601.72	6605.59	28000.0
2017-04-26 16:00:00	NQ	Futures	6605.59	6606.79	6600.82	6600.82	5836.0
2017-04-26 18:00:00	NQ	Futures	6601.12	6605.3	6599.93	6605.0	976.0
2017-04-26 19:00:00	NQ	Futures	6605.0	6609.47	6604.7	6605.0	593.0
2017-04-26 20:00:00	NQ	Futures	6604.7	6608.58	6604.7	6607.08	953.0
2017-04-26 21:00:00	NQ	Futures	6607.38	6610.07	6604.4	6605.3	950.0
2017-04-26 22:00:00	NQ	Futures	6605.3	6608.87	6603.21	6608.58	949.0
2017-04-26 23:00:00	NQ	Futures	6608.58	6609.17	6605.89	6607.08	757.0
2017-04-26 00:00:00	YM	Futures	22772.6	22774.8	22763.9	22772.6	693.0
2017-04-26 01:00:00	YM	Futures	22773.7	22780.2	22771.5	22773.7	662.0
2017-04-26 02:00:00	YM	Futures	22774.8	22778.1	22767.2	22773.7	1398.0

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

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