PREVIEW / futures_1hour / 2017-09-04

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-09-04.parquet
  size:    37 KB
  rows:    1,159

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-04 00:00:00	ES	Futures	2695.4	2696.49	2695.4	2696.22	2506.0
2017-09-04 01:00:00	ES	Futures	2696.49	2696.76	2694.85	2695.12	3904.0
2017-09-04 02:00:00	ES	Futures	2694.85	2695.12	2692.12	2692.66	21168.0
2017-09-04 03:00:00	ES	Futures	2692.66	2694.3	2691.84	2693.21	21221.0
2017-09-04 04:00:00	ES	Futures	2692.94	2694.58	2692.12	2693.21	9166.0
2017-09-04 05:00:00	ES	Futures	2693.21	2696.22	2693.21	2695.12	8890.0
2017-09-04 06:00:00	ES	Futures	2695.4	2698.13	2695.12	2697.31	8742.0
2017-09-04 07:00:00	ES	Futures	2697.31	2697.58	2695.4	2697.58	6721.0
2017-09-04 08:00:00	ES	Futures	2697.58	2698.13	2695.67	2695.94	6080.0
2017-09-04 09:00:00	ES	Futures	2695.67	2697.31	2694.3	2695.94	16110.0
2017-09-04 10:00:00	ES	Futures	2696.22	2699.5	2695.94	2698.68	12191.0
2017-09-04 11:00:00	ES	Futures	2698.4	2698.68	2697.04	2698.13	11200.0
2017-09-04 12:00:00	ES	Futures	2698.13	2699.5	2697.86	2698.4	5598.0
2017-09-04 18:00:00	ES	Futures	2696.76	2698.4	2696.49	2698.13	3030.0
2017-09-04 19:00:00	ES	Futures	2698.4	2701.41	2698.13	2700.32	6496.0
2017-09-04 20:00:00	ES	Futures	2700.32	2700.32	2697.58	2697.86	8905.0
2017-09-04 21:00:00	ES	Futures	2698.13	2698.95	2697.58	2698.13	4673.0
2017-09-04 22:00:00	ES	Futures	2698.13	2698.4	2695.4	2696.76	8594.0
2017-09-04 23:00:00	ES	Futures	2696.49	2697.31	2695.67	2697.31	5789.0
2017-09-04 00:00:00	NQ	Futures	7099.28	7102.56	7096.9	7101.96	712.0
2017-09-04 01:00:00	NQ	Futures	7101.96	7103.15	7096.31	7098.09	781.0
2017-09-04 02:00:00	NQ	Futures	7098.09	7098.39	7089.46	7093.03	2667.0
2017-09-04 03:00:00	NQ	Futures	7093.03	7104.05	7091.24	7098.39	4391.0
2017-09-04 04:00:00	NQ	Futures	7098.69	7102.86	7095.41	7099.28	1187.0
2017-09-04 05:00:00	NQ	Futures	7099.28	7107.02	7099.28	7105.24	1063.0
2017-09-04 06:00:00	NQ	Futures	7104.64	7113.57	7104.64	7109.41	2340.0
2017-09-04 07:00:00	NQ	Futures	7109.11	7111.79	7105.24	7111.49	2302.0
2017-09-04 08:00:00	NQ	Futures	7111.19	7113.87	7104.05	7104.94	1580.0
2017-09-04 09:00:00	NQ	Futures	7105.24	7110.3	7101.66	7107.62	3517.0
2017-09-04 10:00:00	NQ	Futures	7107.32	7118.93	7106.43	7116.55	3311.0
2017-09-04 11:00:00	NQ	Futures	7116.55	7118.34	7112.38	7117.15	2649.0
2017-09-04 12:00:00	NQ	Futures	7117.15	7124.89	7117.15	7121.32	2449.0
2017-09-04 18:00:00	NQ	Futures	7117.74	7118.64	7111.49	7116.85	1293.0
2017-09-04 19:00:00	NQ	Futures	7116.85	7124.29	7116.85	7122.81	1113.0
2017-09-04 20:00:00	NQ	Futures	7122.81	7124.0	7113.28	7115.66	1894.0
2017-09-04 21:00:00	NQ	Futures	7115.06	7120.13	7113.87	7117.74	1690.0
2017-09-04 22:00:00	NQ	Futures	7117.45	7118.34	7108.22	7111.79	6878.0
2017-09-04 23:00:00	NQ	Futures	7112.09	7115.06	7108.51	7113.87	1995.0
2017-09-04 00:00:00	YM	Futures	23866.1	23873.7	23865.0	23871.5	395.0
2017-09-04 01:00:00	YM	Futures	23872.6	23875.9	23859.5	23859.5	1365.0
2017-09-04 02:00:00	YM	Futures	23860.6	23862.8	23834.5	23842.1	2232.0
2017-09-04 03:00:00	YM	Futures	23841.0	23866.1	23838.8	23848.6	3039.0
2017-09-04 04:00:00	YM	Futures	23848.6	23857.3	23841.0	23847.5	788.0
2017-09-04 05:00:00	YM	Futures	23848.6	23866.1	23848.6	23859.5	661.0
2017-09-04 06:00:00	YM	Futures	23859.5	23878.0	23858.4	23872.6	909.0
2017-09-04 07:00:00	YM	Futures	23871.5	23878.0	23861.7	23876.9	954.0
2017-09-04 08:00:00	YM	Futures	23876.9	23879.1	23857.3	23857.3	1028.0
2017-09-04 09:00:00	YM	Futures	23857.3	23870.4	23847.5	23861.7	2165.0
2017-09-04 10:00:00	YM	Futures	23861.7	23885.6	23861.7	23872.6	1454.0
2017-09-04 11:00:00	YM	Futures	23871.5	23871.5	23853.0	23863.9	1679.0

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

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