PREVIEW / futures_1hour / 2018-01-02

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-01-02.parquet
  size:    53 KB
  rows:    1,605

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
2018-01-02 00:00:00	ES	Futures	2929.53	2930.9	2928.98	2930.08	3125.0
2018-01-02 01:00:00	ES	Futures	2930.08	2930.62	2929.8	2930.08	1332.0
2018-01-02 02:00:00	ES	Futures	2930.08	2930.9	2930.08	2930.62	4382.0
2018-01-02 03:00:00	ES	Futures	2930.62	2930.62	2927.07	2928.16	19005.0
2018-01-02 04:00:00	ES	Futures	2928.16	2928.44	2924.88	2925.98	14127.0
2018-01-02 05:00:00	ES	Futures	2925.7	2929.26	2925.7	2928.98	12507.0
2018-01-02 06:00:00	ES	Futures	2928.71	2932.26	2928.71	2931.99	13484.0
2018-01-02 07:00:00	ES	Futures	2931.99	2935.27	2931.72	2934.72	21273.0
2018-01-02 08:00:00	ES	Futures	2934.72	2936.64	2933.63	2935.0	23780.0
2018-01-02 09:00:00	ES	Futures	2935.27	2939.1	2931.99	2938.28	185839.0
2018-01-02 10:00:00	ES	Futures	2938.28	2943.47	2938.0	2941.83	159833.0
2018-01-02 11:00:00	ES	Futures	2941.56	2943.2	2938.55	2940.19	73991.0
2018-01-02 12:00:00	ES	Futures	2940.19	2941.83	2939.37	2940.19	47442.0
2018-01-02 13:00:00	ES	Futures	2940.19	2942.38	2939.92	2941.83	44270.0
2018-01-02 14:00:00	ES	Futures	2941.56	2942.65	2940.74	2942.1	42187.0
2018-01-02 15:00:00	ES	Futures	2942.38	2947.57	2941.56	2947.3	173457.0
2018-01-02 16:00:00	ES	Futures	2947.3	2947.57	2943.2	2945.38	87718.0
2018-01-02 18:00:00	ES	Futures	2945.11	2945.66	2943.47	2945.11	7462.0
2018-01-02 19:00:00	ES	Futures	2945.11	2947.3	2944.84	2946.2	5519.0
2018-01-02 20:00:00	ES	Futures	2945.93	2946.75	2945.66	2946.75	4528.0
2018-01-02 21:00:00	ES	Futures	2947.02	2948.39	2946.75	2947.57	3925.0
2018-01-02 22:00:00	ES	Futures	2947.3	2948.39	2947.02	2947.57	2598.0
2018-01-02 23:00:00	ES	Futures	2947.57	2948.12	2947.02	2947.57	1837.0
2018-01-02 00:00:00	NQ	Futures	7613.87	7620.4	7613.87	7618.62	829.0
2018-01-02 01:00:00	NQ	Futures	7619.21	7619.51	7615.95	7618.02	455.0
2018-01-02 02:00:00	NQ	Futures	7618.02	7618.32	7608.83	7610.02	1267.0
2018-01-02 03:00:00	NQ	Futures	7610.02	7610.02	7594.0	7601.71	2936.0
2018-01-02 04:00:00	NQ	Futures	7602.01	7602.01	7590.14	7590.74	2475.0
2018-01-02 05:00:00	NQ	Futures	7591.03	7604.38	7590.74	7602.01	2078.0
2018-01-02 06:00:00	NQ	Futures	7602.01	7612.68	7602.01	7610.61	2026.0
2018-01-02 07:00:00	NQ	Futures	7610.91	7636.12	7610.91	7632.85	5595.0
2018-01-02 08:00:00	NQ	Futures	7632.85	7637.6	7629.0	7629.89	6307.0
2018-01-02 09:00:00	NQ	Futures	7630.18	7690.39	7623.96	7688.61	64191.0
2018-01-02 10:00:00	NQ	Futures	7688.61	7712.64	7687.72	7712.04	47030.0
2018-01-02 11:00:00	NQ	Futures	7712.04	7721.83	7708.48	7712.64	25918.0
2018-01-02 12:00:00	NQ	Futures	7712.34	7716.49	7708.48	7711.45	15989.0
2018-01-02 13:00:00	NQ	Futures	7711.45	7721.53	7710.26	7720.94	13001.0
2018-01-02 14:00:00	NQ	Futures	7720.94	7731.32	7720.35	7728.06	17836.0
2018-01-02 15:00:00	NQ	Futures	7727.76	7739.03	7725.98	7736.07	27708.0
2018-01-02 16:00:00	NQ	Futures	7735.77	7736.36	7727.17	7729.54	10689.0
2018-01-02 18:00:00	NQ	Futures	7727.17	7731.62	7724.8	7731.32	1546.0
2018-01-02 19:00:00	NQ	Futures	7731.03	7737.85	7730.73	7734.29	1325.0
2018-01-02 20:00:00	NQ	Futures	7734.29	7735.77	7730.73	7735.47	973.0
2018-01-02 21:00:00	NQ	Futures	7735.47	7741.11	7734.88	7736.96	1150.0
2018-01-02 22:00:00	NQ	Futures	7736.96	7739.33	7736.07	7737.55	562.0
2018-01-02 23:00:00	NQ	Futures	7737.55	7737.85	7736.07	7736.36	216.0
2018-01-02 00:00:00	YM	Futures	26920.9	26929.6	26917.7	26925.3	535.0
2018-01-02 01:00:00	YM	Futures	26925.3	26926.4	26920.9	26924.2	285.0
2018-01-02 02:00:00	YM	Futures	26925.3	26940.5	26924.2	26935.1	1444.0
2018-01-02 03:00:00	YM	Futures	26934.0	26934.0	26906.8	26927.5	2005.0

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

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