PREVIEW / futures_1hour / 2017-04-27

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-04-27.parquet
  size:    52 KB
  rows:    1,641

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-27 00:00:00	ES	Futures	2604.69	2605.24	2604.42	2604.42	1752.0
2017-04-27 01:00:00	ES	Futures	2604.69	2604.69	2603.05	2604.15	4594.0
2017-04-27 02:00:00	ES	Futures	2604.15	2605.51	2604.15	2604.42	6191.0
2017-04-27 03:00:00	ES	Futures	2604.42	2604.96	2602.78	2602.78	16936.0
2017-04-27 04:00:00	ES	Futures	2602.78	2604.15	2601.69	2602.23	10637.0
2017-04-27 05:00:00	ES	Futures	2602.23	2604.15	2601.96	2603.05	5960.0
2017-04-27 06:00:00	ES	Futures	2603.05	2604.69	2602.23	2603.87	7264.0
2017-04-27 07:00:00	ES	Futures	2603.87	2607.42	2603.87	2605.78	15270.0
2017-04-27 08:00:00	ES	Futures	2605.78	2607.42	2603.87	2605.51	26208.0
2017-04-27 09:00:00	ES	Futures	2605.51	2607.97	2603.33	2605.78	113657.0
2017-04-27 10:00:00	ES	Futures	2605.78	2608.52	2599.5	2601.69	212309.0
2017-04-27 11:00:00	ES	Futures	2601.69	2603.6	2598.96	2600.32	156531.0
2017-04-27 12:00:00	ES	Futures	2600.59	2609.61	2600.32	2609.61	127274.0
2017-04-27 13:00:00	ES	Futures	2609.61	2609.88	2606.06	2606.88	79927.0
2017-04-27 14:00:00	ES	Futures	2606.6	2608.24	2605.24	2607.15	59421.0
2017-04-27 15:00:00	ES	Futures	2607.15	2607.15	2603.6	2606.06	151035.0
2017-04-27 16:00:00	ES	Futures	2606.06	2609.06	2605.24	2608.24	76515.0
2017-04-27 18:00:00	ES	Futures	2607.15	2607.42	2605.24	2606.33	4101.0
2017-04-27 19:00:00	ES	Futures	2606.6	2606.88	2605.51	2606.06	2109.0
2017-04-27 20:00:00	ES	Futures	2606.06	2607.42	2605.51	2606.88	4653.0
2017-04-27 21:00:00	ES	Futures	2607.15	2607.7	2606.06	2606.88	4618.0
2017-04-27 22:00:00	ES	Futures	2606.88	2607.42	2605.78	2606.06	2812.0
2017-04-27 23:00:00	ES	Futures	2606.33	2606.33	2605.51	2605.78	2495.0
2017-04-27 00:00:00	NQ	Futures	6607.08	6608.87	6606.79	6607.68	477.0
2017-04-27 01:00:00	NQ	Futures	6607.68	6608.87	6605.3	6607.98	815.0
2017-04-27 02:00:00	NQ	Futures	6607.98	6611.86	6607.68	6609.17	1094.0
2017-04-27 03:00:00	NQ	Futures	6608.87	6611.56	6604.1	6604.1	2600.0
2017-04-27 04:00:00	NQ	Futures	6604.1	6607.68	6601.42	6603.51	1952.0
2017-04-27 05:00:00	NQ	Futures	6603.21	6608.28	6602.91	6605.3	1083.0
2017-04-27 06:00:00	NQ	Futures	6605.3	6609.77	6603.81	6608.58	1248.0
2017-04-27 07:00:00	NQ	Futures	6608.58	6618.12	6607.98	6615.43	3712.0
2017-04-27 08:00:00	NQ	Futures	6615.43	6617.82	6610.96	6614.54	5950.0
2017-04-27 09:00:00	NQ	Futures	6614.24	6629.74	6614.24	6627.66	26132.0
2017-04-27 10:00:00	NQ	Futures	6627.66	6637.5	6623.48	6627.66	36555.0
2017-04-27 11:00:00	NQ	Futures	6627.66	6634.51	6624.97	6630.64	19552.0
2017-04-27 12:00:00	NQ	Futures	6630.94	6640.48	6627.06	6640.18	14762.0
2017-04-27 13:00:00	NQ	Futures	6639.88	6640.77	6634.51	6635.71	11147.0
2017-04-27 14:00:00	NQ	Futures	6635.41	6638.69	6630.94	6637.5	10077.0
2017-04-27 15:00:00	NQ	Futures	6637.5	6644.35	6629.74	6643.46	24818.0
2017-04-27 16:00:00	NQ	Futures	6643.76	6677.15	6636.6	6662.24	27164.0
2017-04-27 18:00:00	NQ	Futures	6659.86	6664.33	6657.77	6663.43	1830.0
2017-04-27 19:00:00	NQ	Futures	6663.14	6664.33	6661.94	6664.03	621.0
2017-04-27 20:00:00	NQ	Futures	6664.33	6670.29	6663.43	6668.5	1532.0
2017-04-27 21:00:00	NQ	Futures	6668.5	6670.59	6666.41	6667.61	1391.0
2017-04-27 22:00:00	NQ	Futures	6667.91	6669.4	6666.41	6667.91	954.0
2017-04-27 23:00:00	NQ	Futures	6668.2	6668.5	6666.12	6667.31	677.0
2017-04-27 00:00:00	YM	Futures	22737.8	22744.4	22737.8	22742.2	519.0
2017-04-27 01:00:00	YM	Futures	22743.3	22748.7	22734.6	22744.4	1206.0
2017-04-27 02:00:00	YM	Futures	22744.4	22755.2	22742.2	22749.8	1237.0
2017-04-27 03:00:00	YM	Futures	22748.7	22754.1	22729.1	22731.3	2442.0

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

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