PREVIEW / futures_1hour / 2019-02-11

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-02-11.parquet
  size:    56 KB
  rows:    1,757

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
2019-02-11 00:00:00	ES	Futures	2938.27	2938.82	2935.01	2937.46	3921.0
2019-02-11 01:00:00	ES	Futures	2937.46	2939.9	2936.64	2939.63	2874.0
2019-02-11 02:00:00	ES	Futures	2939.63	2939.9	2937.19	2939.36	5302.0
2019-02-11 03:00:00	ES	Futures	2939.63	2951.85	2937.46	2951.31	27148.0
2019-02-11 04:00:00	ES	Futures	2951.04	2956.47	2949.41	2952.94	21555.0
2019-02-11 05:00:00	ES	Futures	2952.94	2953.48	2949.95	2950.22	13460.0
2019-02-11 06:00:00	ES	Futures	2950.49	2951.31	2945.88	2947.24	13826.0
2019-02-11 07:00:00	ES	Futures	2947.24	2951.58	2945.88	2950.77	15433.0
2019-02-11 08:00:00	ES	Futures	2951.04	2955.93	2948.59	2950.49	28587.0
2019-02-11 09:00:00	ES	Futures	2950.22	2952.12	2942.08	2944.25	163401.0
2019-02-11 10:00:00	ES	Futures	2944.25	2948.32	2939.36	2942.89	187571.0
2019-02-11 11:00:00	ES	Futures	2942.89	2945.06	2937.19	2941.26	124732.0
2019-02-11 12:00:00	ES	Futures	2941.53	2946.15	2940.72	2944.52	77720.0
2019-02-11 13:00:00	ES	Futures	2944.52	2945.88	2938.0	2940.99	69111.0
2019-02-11 14:00:00	ES	Futures	2940.72	2942.35	2936.1	2939.09	88567.0
2019-02-11 15:00:00	ES	Futures	2939.09	2945.33	2938.82	2942.62	151653.0
2019-02-11 16:00:00	ES	Futures	2942.62	2943.98	2939.9	2941.53	47941.0
2019-02-11 18:00:00	ES	Futures	2940.72	2943.16	2939.09	2942.62	4694.0
2019-02-11 19:00:00	ES	Futures	2942.62	2950.49	2942.08	2948.32	13977.0
2019-02-11 20:00:00	ES	Futures	2948.05	2953.75	2945.61	2953.75	18808.0
2019-02-11 21:00:00	ES	Futures	2953.75	2958.91	2951.31	2957.28	14778.0
2019-02-11 22:00:00	ES	Futures	2957.56	2959.46	2956.2	2959.19	7493.0
2019-02-11 23:00:00	ES	Futures	2959.19	2959.46	2956.47	2957.01	5633.0
2019-02-11 00:00:00	NQ	Futures	8072.02	8075.24	8060.04	8069.98	1925.0
2019-02-11 01:00:00	NQ	Futures	8069.98	8079.04	8067.64	8077.87	1621.0
2019-02-11 02:00:00	NQ	Futures	8078.16	8079.62	8072.31	8078.16	2277.0
2019-02-11 03:00:00	NQ	Futures	8077.87	8122.28	8072.31	8121.69	10719.0
2019-02-11 04:00:00	NQ	Futures	8121.4	8145.65	8118.19	8129.29	9524.0
2019-02-11 05:00:00	NQ	Futures	8129.29	8131.92	8119.36	8120.82	4415.0
2019-02-11 06:00:00	NQ	Futures	8121.4	8124.03	8106.21	8111.47	6651.0
2019-02-11 07:00:00	NQ	Futures	8111.76	8130.46	8105.62	8127.83	9215.0
2019-02-11 08:00:00	NQ	Futures	8127.83	8141.56	8115.56	8121.69	9833.0
2019-02-11 09:00:00	NQ	Futures	8121.69	8139.81	8089.85	8100.36	67562.0
2019-02-11 10:00:00	NQ	Futures	8099.78	8120.53	8089.26	8097.74	63696.0
2019-02-11 11:00:00	NQ	Futures	8097.74	8104.46	8075.53	8089.26	51044.0
2019-02-11 12:00:00	NQ	Futures	8089.55	8106.5	8086.34	8098.03	29807.0
2019-02-11 13:00:00	NQ	Futures	8098.32	8099.78	8068.52	8079.33	24811.0
2019-02-11 14:00:00	NQ	Futures	8079.04	8086.34	8061.8	8072.02	26117.0
2019-02-11 15:00:00	NQ	Futures	8072.02	8090.72	8070.56	8082.83	38844.0
2019-02-11 16:00:00	NQ	Futures	8082.83	8086.63	8073.19	8076.41	7688.0
2019-02-11 18:00:00	NQ	Futures	8074.36	8082.83	8067.93	8081.08	1793.0
2019-02-11 19:00:00	NQ	Futures	8081.08	8106.79	8078.45	8098.03	5741.0
2019-02-11 20:00:00	NQ	Futures	8098.32	8115.85	8090.72	8114.68	6185.0
2019-02-11 21:00:00	NQ	Futures	8114.97	8133.09	8107.67	8130.17	5729.0
2019-02-11 22:00:00	NQ	Futures	8130.75	8138.06	8125.2	8136.3	3413.0
2019-02-11 23:00:00	NQ	Futures	8136.01	8138.93	8127.54	8129.29	2084.0
2019-02-11 00:00:00	YM	Futures	27198.0	27204.6	27163.3	27189.4	1048.0
2019-02-11 01:00:00	YM	Futures	27190.4	27214.3	27181.8	27212.2	885.0
2019-02-11 02:00:00	YM	Futures	27211.1	27213.2	27185.0	27206.7	2035.0
2019-02-11 03:00:00	YM	Futures	27205.6	27316.4	27186.1	27312.0	6955.0

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

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