PREVIEW / futures_1hour / 2017-05-03

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-05-03.parquet
  size:    53 KB
  rows:    1,655

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-05-03 00:00:00	ES	Futures	2603.33	2603.6	2603.05	2603.33	989.0
2017-05-03 01:00:00	ES	Futures	2603.6	2604.15	2603.05	2603.6	1872.0
2017-05-03 02:00:00	ES	Futures	2603.33	2603.87	2603.05	2603.05	3837.0
2017-05-03 03:00:00	ES	Futures	2603.33	2603.6	2601.69	2602.78	12224.0
2017-05-03 04:00:00	ES	Futures	2603.05	2603.05	2601.69	2602.51	7573.0
2017-05-03 05:00:00	ES	Futures	2602.51	2603.33	2601.69	2602.51	5809.0
2017-05-03 06:00:00	ES	Futures	2602.51	2603.33	2601.41	2602.78	5304.0
2017-05-03 07:00:00	ES	Futures	2603.05	2604.15	2602.23	2603.33	7359.0
2017-05-03 08:00:00	ES	Futures	2603.33	2603.6	2601.96	2603.05	16304.0
2017-05-03 09:00:00	ES	Futures	2603.05	2604.15	2600.59	2602.78	110510.0
2017-05-03 10:00:00	ES	Futures	2603.05	2604.15	2595.4	2597.32	231462.0
2017-05-03 11:00:00	ES	Futures	2597.59	2603.05	2597.04	2602.23	131605.0
2017-05-03 12:00:00	ES	Futures	2602.23	2603.05	2600.32	2601.41	57622.0
2017-05-03 13:00:00	ES	Futures	2601.41	2602.51	2598.68	2601.14	63105.0
2017-05-03 14:00:00	ES	Futures	2601.14	2604.69	2599.23	2603.6	124099.0
2017-05-03 15:00:00	ES	Futures	2603.87	2606.88	2602.23	2604.15	209101.0
2017-05-03 16:00:00	ES	Futures	2604.42	2605.24	2602.23	2602.78	59648.0
2017-05-03 18:00:00	ES	Futures	2602.51	2603.33	2601.69	2602.78	3042.0
2017-05-03 19:00:00	ES	Futures	2602.78	2607.42	2602.51	2606.33	8181.0
2017-05-03 20:00:00	ES	Futures	2606.06	2607.15	2606.06	2606.88	4424.0
2017-05-03 21:00:00	ES	Futures	2606.88	2607.7	2606.6	2606.88	3942.0
2017-05-03 22:00:00	ES	Futures	2606.88	2607.42	2606.06	2606.88	2651.0
2017-05-03 23:00:00	ES	Futures	2606.88	2607.97	2606.88	2607.7	2527.0
2017-05-03 00:00:00	NQ	Futures	6703.38	6704.58	6703.38	6703.98	549.0
2017-05-03 01:00:00	NQ	Futures	6703.68	6707.86	6703.09	6706.37	1091.0
2017-05-03 02:00:00	NQ	Futures	6706.37	6708.15	6705.17	6705.47	863.0
2017-05-03 03:00:00	NQ	Futures	6705.47	6706.96	6702.49	6706.37	1902.0
2017-05-03 04:00:00	NQ	Futures	6706.96	6707.26	6703.09	6705.17	1597.0
2017-05-03 05:00:00	NQ	Futures	6705.17	6706.37	6703.98	6706.07	966.0
2017-05-03 06:00:00	NQ	Futures	6706.37	6707.56	6703.09	6706.66	1065.0
2017-05-03 07:00:00	NQ	Futures	6706.66	6712.03	6704.87	6710.24	2941.0
2017-05-03 08:00:00	NQ	Futures	6710.24	6714.71	6706.66	6714.71	5073.0
2017-05-03 09:00:00	NQ	Futures	6714.71	6715.31	6697.72	6701.89	27392.0
2017-05-03 10:00:00	NQ	Futures	6702.19	6703.98	6686.69	6689.07	42558.0
2017-05-03 11:00:00	NQ	Futures	6689.07	6701.3	6685.5	6697.72	25261.0
2017-05-03 12:00:00	NQ	Futures	6697.72	6703.98	6695.33	6701.0	12839.0
2017-05-03 13:00:00	NQ	Futures	6700.7	6703.38	6693.25	6696.53	10385.0
2017-05-03 14:00:00	NQ	Futures	6696.83	6706.07	6689.97	6698.61	22881.0
2017-05-03 15:00:00	NQ	Futures	6698.61	6711.43	6693.25	6703.68	30342.0
2017-05-03 16:00:00	NQ	Futures	6703.68	6706.96	6689.07	6690.56	9037.0
2017-05-03 18:00:00	NQ	Futures	6689.07	6693.84	6687.28	6693.84	1384.0
2017-05-03 19:00:00	NQ	Futures	6693.84	6705.47	6692.65	6702.19	1737.0
2017-05-03 20:00:00	NQ	Futures	6701.89	6704.87	6701.89	6703.09	936.0
2017-05-03 21:00:00	NQ	Futures	6703.09	6705.47	6700.1	6701.6	1180.0
2017-05-03 22:00:00	NQ	Futures	6701.3	6703.38	6700.1	6702.19	1285.0
2017-05-03 23:00:00	NQ	Futures	6702.19	6704.58	6701.0	6703.68	941.0
2017-05-03 00:00:00	YM	Futures	22657.4	22662.9	22657.4	22660.7	146.0
2017-05-03 01:00:00	YM	Futures	22660.7	22665.0	22659.6	22661.8	347.0
2017-05-03 02:00:00	YM	Futures	22660.7	22665.0	22656.3	22656.3	853.0
2017-05-03 03:00:00	YM	Futures	22656.3	22659.6	22641.1	22652.0	2315.0

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

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