PREVIEW / futures_1hour / 2018-03-02

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-03-02.parquet
  size:    48 KB
  rows:    1,392

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-03-02 00:00:00	ES	Futures	2925.16	2927.34	2922.42	2924.88	5777.0
2018-03-02 01:00:00	ES	Futures	2924.88	2929.53	2924.06	2929.26	7515.0
2018-03-02 02:00:00	ES	Futures	2929.26	2932.54	2922.97	2924.34	14670.0
2018-03-02 03:00:00	ES	Futures	2924.34	2935.0	2922.42	2924.61	27023.0
2018-03-02 04:00:00	ES	Futures	2924.61	2926.25	2917.5	2919.14	22166.0
2018-03-02 05:00:00	ES	Futures	2918.87	2923.24	2911.76	2912.86	32153.0
2018-03-02 06:00:00	ES	Futures	2912.86	2915.86	2906.84	2914.5	41406.0
2018-03-02 07:00:00	ES	Futures	2914.5	2916.96	2903.02	2904.38	45713.0
2018-03-02 08:00:00	ES	Futures	2904.38	2914.22	2900.28	2910.4	76098.0
2018-03-02 09:00:00	ES	Futures	2910.67	2912.31	2894.0	2901.92	286927.0
2018-03-02 10:00:00	ES	Futures	2902.2	2915.86	2894.82	2906.3	299986.0
2018-03-02 11:00:00	ES	Futures	2906.3	2927.34	2900.56	2927.07	229079.0
2018-03-02 12:00:00	ES	Futures	2927.07	2936.09	2918.6	2933.08	203036.0
2018-03-02 13:00:00	ES	Futures	2933.08	2934.18	2912.31	2919.96	177724.0
2018-03-02 14:00:00	ES	Futures	2919.96	2933.36	2919.96	2925.43	155029.0
2018-03-02 15:00:00	ES	Futures	2925.43	2947.57	2918.6	2941.01	335871.0
2018-03-02 16:00:00	ES	Futures	2940.74	2944.56	2938.82	2941.56	77161.0
2018-03-02 00:00:00	NQ	Futures	8025.84	8035.33	8018.13	8022.58	2728.0
2018-03-02 01:00:00	NQ	Futures	8023.17	8032.96	8019.91	8030.88	2311.0
2018-03-02 02:00:00	NQ	Futures	8031.48	8039.48	8009.23	8013.98	4098.0
2018-03-02 03:00:00	NQ	Futures	8013.68	8040.97	8006.86	8007.45	6963.0
2018-03-02 04:00:00	NQ	Futures	8007.16	8013.09	7989.06	7992.03	7390.0
2018-03-02 05:00:00	NQ	Futures	7991.44	8000.04	7969.19	7973.05	8896.0
2018-03-02 06:00:00	NQ	Futures	7973.64	7974.23	7940.12	7957.03	14021.0
2018-03-02 07:00:00	NQ	Futures	7956.73	7971.86	7919.07	7924.41	16258.0
2018-03-02 08:00:00	NQ	Futures	7924.7	7946.65	7910.76	7936.57	27212.0
2018-03-02 09:00:00	NQ	Futures	7936.86	7953.77	7884.66	7931.23	81008.0
2018-03-02 10:00:00	NQ	Futures	7931.52	7981.94	7909.58	7951.4	95785.0
2018-03-02 11:00:00	NQ	Futures	7951.69	8020.5	7939.83	8019.61	78301.0
2018-03-02 12:00:00	NQ	Futures	8019.91	8046.6	8000.04	8038.89	62635.0
2018-03-02 13:00:00	NQ	Futures	8038.89	8042.15	7972.16	8000.93	62207.0
2018-03-02 14:00:00	NQ	Futures	8001.22	8052.83	8000.93	8024.65	49510.0
2018-03-02 15:00:00	NQ	Futures	8024.65	8094.95	8005.97	8081.3	76513.0
2018-03-02 16:00:00	NQ	Futures	8080.71	8082.49	8070.92	8077.45	11602.0
2018-03-02 00:00:00	YM	Futures	26663.3	26689.4	26647.0	26668.8	3940.0
2018-03-02 01:00:00	YM	Futures	26672.0	26725.3	26656.8	26714.4	2838.0
2018-03-02 02:00:00	YM	Futures	26716.6	26740.5	26655.7	26664.4	4048.0
2018-03-02 03:00:00	YM	Futures	26663.3	26764.4	26655.7	26668.8	6998.0
2018-03-02 04:00:00	YM	Futures	26668.8	26690.5	26629.7	26638.3	5999.0
2018-03-02 05:00:00	YM	Futures	26637.3	26666.6	26538.4	26557.9	11096.0
2018-03-02 06:00:00	YM	Futures	26557.9	26571.0	26489.4	26554.7	11101.0
2018-03-02 07:00:00	YM	Futures	26555.7	26584.0	26447.1	26456.8	10633.0
2018-03-02 08:00:00	YM	Futures	26461.2	26577.5	26417.7	26530.7	18481.0
2018-03-02 09:00:00	YM	Futures	26531.8	26550.3	26326.4	26389.5	44784.0
2018-03-02 10:00:00	YM	Futures	26390.5	26485.1	26327.5	26398.1	54391.0
2018-03-02 11:00:00	YM	Futures	26397.1	26553.6	26306.8	26552.5	46393.0
2018-03-02 12:00:00	YM	Futures	26551.4	26675.3	26489.4	26650.3	38896.0
2018-03-02 13:00:00	YM	Futures	26648.1	26655.7	26447.1	26535.1	32475.0
2018-03-02 14:00:00	YM	Futures	26536.2	26642.7	26511.2	26539.4	29557.0
2018-03-02 15:00:00	YM	Futures	26537.3	26716.6	26454.7	26653.6	43598.0

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

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