PREVIEW / futures_1hour / 2018-04-19

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-04-19.parquet
  size:    54 KB
  rows:    1,679

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-04-19 00:00:00	ES	Futures	2961.05	2961.33	2960.23	2960.51	1361.0
2018-04-19 01:00:00	ES	Futures	2960.23	2961.05	2958.05	2959.14	2727.0
2018-04-19 02:00:00	ES	Futures	2959.14	2959.96	2952.05	2955.87	9894.0
2018-04-19 03:00:00	ES	Futures	2956.14	2959.14	2955.05	2955.32	11456.0
2018-04-19 04:00:00	ES	Futures	2955.32	2956.96	2951.5	2952.32	11754.0
2018-04-19 05:00:00	ES	Futures	2952.05	2955.87	2951.77	2955.05	7937.0
2018-04-19 06:00:00	ES	Futures	2955.32	2955.59	2951.77	2953.14	11304.0
2018-04-19 07:00:00	ES	Futures	2953.14	2956.14	2952.87	2954.78	7838.0
2018-04-19 08:00:00	ES	Futures	2954.78	2954.78	2947.41	2947.68	28782.0
2018-04-19 09:00:00	ES	Futures	2947.41	2950.14	2938.95	2945.22	182533.0
2018-04-19 10:00:00	ES	Futures	2945.5	2951.23	2938.67	2942.77	210294.0
2018-04-19 11:00:00	ES	Futures	2942.49	2943.31	2933.22	2933.49	180307.0
2018-04-19 12:00:00	ES	Futures	2933.22	2936.49	2930.21	2931.58	173061.0
2018-04-19 13:00:00	ES	Futures	2931.58	2935.94	2927.21	2933.49	130938.0
2018-04-19 14:00:00	ES	Futures	2933.49	2936.49	2928.3	2935.4	154131.0
2018-04-19 15:00:00	ES	Futures	2935.4	2946.32	2932.67	2940.04	283336.0
2018-04-19 16:00:00	ES	Futures	2940.04	2941.4	2937.58	2939.49	79251.0
2018-04-19 18:00:00	ES	Futures	2939.22	2941.4	2938.67	2940.04	3616.0
2018-04-19 19:00:00	ES	Futures	2940.04	2940.04	2934.31	2939.77	4184.0
2018-04-19 20:00:00	ES	Futures	2940.04	2940.04	2935.94	2937.58	5494.0
2018-04-19 21:00:00	ES	Futures	2937.31	2942.77	2936.49	2942.22	6438.0
2018-04-19 22:00:00	ES	Futures	2941.95	2944.4	2939.77	2941.4	6206.0
2018-04-19 23:00:00	ES	Futures	2941.13	2941.68	2938.67	2940.86	3186.0
2018-04-19 00:00:00	NQ	Futures	8111.47	8113.83	8109.99	8111.77	611.0
2018-04-19 01:00:00	NQ	Futures	8111.18	8111.77	8102.31	8106.74	1236.0
2018-04-19 02:00:00	NQ	Futures	8106.45	8110.58	8088.42	8095.81	2735.0
2018-04-19 03:00:00	NQ	Futures	8096.1	8102.9	8091.08	8092.56	3206.0
2018-04-19 04:00:00	NQ	Futures	8092.85	8099.06	8079.26	8081.33	3598.0
2018-04-19 05:00:00	NQ	Futures	8081.33	8090.78	8080.44	8087.24	2508.0
2018-04-19 06:00:00	NQ	Futures	8087.53	8087.53	8070.39	8073.64	4012.0
2018-04-19 07:00:00	NQ	Futures	8073.94	8082.51	8071.87	8080.14	3488.0
2018-04-19 08:00:00	NQ	Futures	8080.44	8081.03	8052.66	8053.55	8912.0
2018-04-19 09:00:00	NQ	Futures	8053.25	8057.98	8023.7	8051.48	55373.0
2018-04-19 10:00:00	NQ	Futures	8051.48	8066.25	8018.97	8031.09	60075.0
2018-04-19 11:00:00	NQ	Futures	8030.79	8033.15	7995.62	7995.92	54085.0
2018-04-19 12:00:00	NQ	Futures	7995.62	8016.01	7987.05	7999.17	38924.0
2018-04-19 13:00:00	NQ	Futures	7998.87	8015.72	7986.76	8007.74	25327.0
2018-04-19 14:00:00	NQ	Futures	8007.74	8015.72	7985.57	8009.81	36024.0
2018-04-19 15:00:00	NQ	Futures	8009.22	8039.66	8002.12	8016.31	55474.0
2018-04-19 16:00:00	NQ	Futures	8016.6	8018.67	8007.15	8011.29	9065.0
2018-04-19 18:00:00	NQ	Futures	8012.17	8018.08	8006.85	8013.35	1253.0
2018-04-19 19:00:00	NQ	Futures	8013.95	8014.83	7992.37	8012.47	2102.0
2018-04-19 20:00:00	NQ	Futures	8012.47	8012.47	7997.1	8000.35	1934.0
2018-04-19 21:00:00	NQ	Futures	8000.94	8020.74	7998.58	8019.56	2158.0
2018-04-19 22:00:00	NQ	Futures	8019.86	8026.95	8010.1	8014.83	2156.0
2018-04-19 23:00:00	NQ	Futures	8015.13	8016.6	8008.03	8012.47	1150.0
2018-04-19 00:00:00	YM	Futures	26901.9	26912.7	26893.2	26903.0	714.0
2018-04-19 01:00:00	YM	Futures	26903.0	26906.2	26876.9	26889.9	895.0
2018-04-19 02:00:00	YM	Futures	26888.8	26900.8	26836.7	26867.1	2529.0
2018-04-19 03:00:00	YM	Futures	26867.1	26881.2	26849.8	26854.1	2296.0

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

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