PREVIEW / futures_1hour / 2017-09-07

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-09-07.parquet
  size:    54 KB
  rows:    1,619

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-09-07 00:00:00	ES	Futures	2692.66	2692.66	2691.84	2692.66	4338.0
2017-09-07 01:00:00	ES	Futures	2692.39	2692.66	2690.2	2690.48	7652.0
2017-09-07 02:00:00	ES	Futures	2690.48	2692.39	2690.48	2692.12	8892.0
2017-09-07 03:00:00	ES	Futures	2692.12	2692.39	2689.66	2690.75	23942.0
2017-09-07 04:00:00	ES	Futures	2691.02	2692.12	2690.48	2691.02	13985.0
2017-09-07 05:00:00	ES	Futures	2691.02	2694.3	2691.02	2693.48	16374.0
2017-09-07 06:00:00	ES	Futures	2693.21	2697.58	2693.21	2697.04	20974.0
2017-09-07 07:00:00	ES	Futures	2697.04	2697.58	2694.85	2696.49	17517.0
2017-09-07 08:00:00	ES	Futures	2696.22	2698.4	2694.58	2697.58	31254.0
2017-09-07 09:00:00	ES	Futures	2697.58	2699.22	2694.3	2694.85	122228.0
2017-09-07 10:00:00	ES	Futures	2694.85	2697.58	2689.66	2695.94	181087.0
2017-09-07 11:00:00	ES	Futures	2695.94	2697.58	2691.02	2692.66	134106.0
2017-09-07 12:00:00	ES	Futures	2692.66	2693.48	2689.11	2692.66	120881.0
2017-09-07 13:00:00	ES	Futures	2692.66	2694.3	2691.57	2693.48	61706.0
2017-09-07 14:00:00	ES	Futures	2693.48	2694.85	2692.39	2694.3	54196.0
2017-09-07 15:00:00	ES	Futures	2694.58	2695.4	2691.02	2694.58	141640.0
2017-09-07 16:00:00	ES	Futures	2694.85	2697.04	2694.58	2696.22	54667.0
2017-09-07 18:00:00	ES	Futures	2696.76	2697.86	2694.85	2697.58	5847.0
2017-09-07 19:00:00	ES	Futures	2697.58	2697.58	2693.21	2693.21	3676.0
2017-09-07 20:00:00	ES	Futures	2693.21	2694.03	2690.2	2691.84	7216.0
2017-09-07 21:00:00	ES	Futures	2692.12	2693.48	2691.84	2692.66	3277.0
2017-09-07 22:00:00	ES	Futures	2692.66	2692.94	2690.75	2691.3	3399.0
2017-09-07 23:00:00	ES	Futures	2691.3	2692.94	2691.02	2692.94	3259.0
2017-09-07 00:00:00	NQ	Futures	7086.18	7086.18	7082.61	7084.4	1387.0
2017-09-07 01:00:00	NQ	Futures	7084.1	7084.69	7077.25	7080.23	1278.0
2017-09-07 02:00:00	NQ	Futures	7080.52	7084.4	7078.74	7083.2	2000.0
2017-09-07 03:00:00	NQ	Futures	7083.2	7084.69	7077.55	7081.42	2942.0
2017-09-07 04:00:00	NQ	Futures	7082.01	7085.88	7079.33	7082.01	1471.0
2017-09-07 05:00:00	NQ	Futures	7082.01	7093.63	7082.01	7091.54	2093.0
2017-09-07 06:00:00	NQ	Futures	7091.54	7102.56	7091.24	7100.47	3294.0
2017-09-07 07:00:00	NQ	Futures	7100.47	7102.56	7094.22	7098.69	4172.0
2017-09-07 08:00:00	NQ	Futures	7098.69	7104.05	7092.43	7101.66	8170.0
2017-09-07 09:00:00	NQ	Futures	7101.37	7104.94	7085.29	7093.92	33718.0
2017-09-07 10:00:00	NQ	Futures	7094.22	7121.91	7079.33	7117.15	52340.0
2017-09-07 11:00:00	NQ	Futures	7117.15	7124.0	7105.54	7112.09	30447.0
2017-09-07 12:00:00	NQ	Futures	7112.68	7112.98	7085.59	7094.82	40640.0
2017-09-07 13:00:00	NQ	Futures	7094.22	7109.41	7093.03	7105.83	20378.0
2017-09-07 14:00:00	NQ	Futures	7105.83	7110.0	7100.18	7107.02	13009.0
2017-09-07 15:00:00	NQ	Futures	7106.73	7108.81	7097.79	7104.94	21618.0
2017-09-07 16:00:00	NQ	Futures	7104.64	7112.09	7104.05	7109.41	4572.0
2017-09-07 18:00:00	NQ	Futures	7109.41	7112.68	7105.24	7112.38	831.0
2017-09-07 19:00:00	NQ	Futures	7112.09	7112.09	7102.86	7102.86	840.0
2017-09-07 20:00:00	NQ	Futures	7103.15	7104.94	7093.33	7099.28	2127.0
2017-09-07 21:00:00	NQ	Futures	7099.58	7103.75	7098.99	7101.96	795.0
2017-09-07 22:00:00	NQ	Futures	7101.96	7103.15	7096.01	7096.9	855.0
2017-09-07 23:00:00	NQ	Futures	7097.2	7101.07	7096.31	7099.88	1354.0
2017-09-07 00:00:00	YM	Futures	23714.8	23721.3	23707.1	23713.7	1762.0
2017-09-07 01:00:00	YM	Futures	23712.6	23713.7	23698.4	23701.7	939.0
2017-09-07 02:00:00	YM	Futures	23702.8	23712.6	23698.4	23709.3	1260.0
2017-09-07 03:00:00	YM	Futures	23709.3	23710.4	23687.5	23695.2	2120.0

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

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