PREVIEW / futures_1hour / 2017-05-04

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-05-04.parquet
  size:    55 KB
  rows:    1,691

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-04 00:00:00	ES	Futures	2607.42	2607.7	2606.88	2607.42	1699.0
2017-05-04 01:00:00	ES	Futures	2607.42	2607.7	2606.33	2606.6	1668.0
2017-05-04 02:00:00	ES	Futures	2606.6	2607.7	2606.33	2607.15	6561.0
2017-05-04 03:00:00	ES	Futures	2607.15	2608.52	2605.51	2606.33	17598.0
2017-05-04 04:00:00	ES	Futures	2606.06	2608.79	2606.06	2608.52	8850.0
2017-05-04 05:00:00	ES	Futures	2608.79	2611.52	2608.79	2610.97	12003.0
2017-05-04 06:00:00	ES	Futures	2610.97	2611.52	2610.43	2610.97	9815.0
2017-05-04 07:00:00	ES	Futures	2610.97	2612.07	2610.7	2611.25	11594.0
2017-05-04 08:00:00	ES	Futures	2611.25	2611.25	2607.15	2608.52	35610.0
2017-05-04 09:00:00	ES	Futures	2608.24	2609.06	2601.69	2603.05	173494.0
2017-05-04 10:00:00	ES	Futures	2603.33	2607.7	2602.51	2604.96	176957.0
2017-05-04 11:00:00	ES	Futures	2604.69	2607.7	2603.33	2603.87	119521.0
2017-05-04 12:00:00	ES	Futures	2603.87	2604.69	2595.95	2603.87	197268.0
2017-05-04 13:00:00	ES	Futures	2603.87	2605.78	2601.69	2604.15	89915.0
2017-05-04 14:00:00	ES	Futures	2604.42	2607.15	2600.59	2603.87	134299.0
2017-05-04 15:00:00	ES	Futures	2603.87	2607.42	2602.78	2606.88	130550.0
2017-05-04 16:00:00	ES	Futures	2606.6	2607.7	2604.42	2607.42	62623.0
2017-05-04 18:00:00	ES	Futures	2606.88	2607.15	2605.78	2606.06	2876.0
2017-05-04 19:00:00	ES	Futures	2606.06	2607.42	2606.06	2606.33	1533.0
2017-05-04 20:00:00	ES	Futures	2606.6	2606.6	2604.96	2605.51	2995.0
2017-05-04 21:00:00	ES	Futures	2605.24	2607.15	2605.24	2605.78	3438.0
2017-05-04 22:00:00	ES	Futures	2605.78	2606.6	2605.51	2605.78	1710.0
2017-05-04 23:00:00	ES	Futures	2605.78	2605.78	2599.5	2600.05	11709.0
2017-05-04 00:00:00	NQ	Futures	6703.68	6703.98	6702.19	6703.98	308.0
2017-05-04 01:00:00	NQ	Futures	6703.98	6704.58	6701.6	6702.49	347.0
2017-05-04 02:00:00	NQ	Futures	6702.49	6704.87	6701.6	6703.98	1130.0
2017-05-04 03:00:00	NQ	Futures	6703.98	6706.37	6699.51	6701.89	2335.0
2017-05-04 04:00:00	NQ	Futures	6701.89	6708.75	6701.89	6707.56	1672.0
2017-05-04 05:00:00	NQ	Futures	6707.26	6714.71	6707.26	6714.12	2178.0
2017-05-04 06:00:00	NQ	Futures	6714.12	6716.2	6712.33	6714.71	1588.0
2017-05-04 07:00:00	NQ	Futures	6715.01	6718.89	6714.71	6717.99	2557.0
2017-05-04 08:00:00	NQ	Futures	6717.99	6718.89	6705.77	6706.66	7560.0
2017-05-04 09:00:00	NQ	Futures	6706.37	6709.94	6682.81	6687.58	37847.0
2017-05-04 10:00:00	NQ	Futures	6687.58	6708.15	6686.99	6699.51	36126.0
2017-05-04 11:00:00	NQ	Futures	6699.81	6715.31	6698.02	6703.38	27605.0
2017-05-04 12:00:00	NQ	Futures	6703.68	6707.26	6685.5	6705.77	34356.0
2017-05-04 13:00:00	NQ	Futures	6705.77	6710.24	6699.81	6704.58	15210.0
2017-05-04 14:00:00	NQ	Futures	6704.28	6710.54	6695.04	6703.38	20789.0
2017-05-04 15:00:00	NQ	Futures	6703.09	6709.65	6700.1	6706.37	18256.0
2017-05-04 16:00:00	NQ	Futures	6706.37	6712.33	6703.09	6711.73	4530.0
2017-05-04 18:00:00	NQ	Futures	6710.54	6711.14	6704.28	6705.47	983.0
2017-05-04 19:00:00	NQ	Futures	6705.47	6709.05	6705.47	6706.96	422.0
2017-05-04 20:00:00	NQ	Futures	6706.96	6707.26	6704.58	6705.17	482.0
2017-05-04 21:00:00	NQ	Futures	6705.17	6709.65	6705.17	6706.07	802.0
2017-05-04 22:00:00	NQ	Futures	6706.07	6707.56	6704.28	6704.87	437.0
2017-05-04 23:00:00	NQ	Futures	6705.17	6706.96	6693.84	6695.33	2748.0
2017-05-04 00:00:00	YM	Futures	22727.0	22729.1	22720.5	22725.9	418.0
2017-05-04 01:00:00	YM	Futures	22728.1	22729.1	22715.0	22717.2	594.0
2017-05-04 02:00:00	YM	Futures	22717.2	22723.7	22710.7	22719.4	1432.0
2017-05-04 03:00:00	YM	Futures	22719.4	22732.4	22705.2	22716.1	2259.0

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

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