PREVIEW / futures_1hour / 2021-08-02

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-08-02.parquet
  size:    64 KB
  rows:    1,968

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
2021-08-02 00:00:00	ES	Futures	4969.08	4970.49	4968.24	4969.93	2638.0
2021-08-02 01:00:00	ES	Futures	4969.93	4973.31	4968.24	4968.52	7743.0
2021-08-02 02:00:00	ES	Futures	4968.52	4972.18	4965.98	4969.93	8442.0
2021-08-02 03:00:00	ES	Futures	4970.21	4978.09	4968.52	4973.59	30448.0
2021-08-02 04:00:00	ES	Futures	4973.87	4975.56	4971.05	4974.15	13520.0
2021-08-02 05:00:00	ES	Futures	4974.43	4976.4	4971.9	4973.59	9381.0
2021-08-02 06:00:00	ES	Futures	4973.59	4973.87	4959.79	4961.2	19587.0
2021-08-02 07:00:00	ES	Futures	4961.2	4966.83	4958.1	4966.83	22217.0
2021-08-02 08:00:00	ES	Futures	4966.83	4968.8	4960.35	4963.45	25789.0
2021-08-02 09:00:00	ES	Futures	4963.45	4971.62	4960.63	4963.73	149918.0
2021-08-02 10:00:00	ES	Futures	4963.45	4969.64	4957.54	4960.92	162863.0
2021-08-02 11:00:00	ES	Futures	4961.2	4965.7	4947.12	4947.96	115163.0
2021-08-02 12:00:00	ES	Futures	4947.96	4951.62	4940.64	4947.68	140393.0
2021-08-02 13:00:00	ES	Futures	4947.4	4952.19	4939.8	4944.58	91204.0
2021-08-02 14:00:00	ES	Futures	4944.3	4949.09	4942.61	4946.84	67759.0
2021-08-02 15:00:00	ES	Futures	4947.12	4948.53	4930.22	4933.6	188504.0
2021-08-02 16:00:00	ES	Futures	4933.6	4937.83	4932.76	4937.54	42665.0
2021-08-02 18:00:00	ES	Futures	4937.54	4942.61	4936.14	4940.92	5446.0
2021-08-02 19:00:00	ES	Futures	4940.92	4941.49	4936.98	4940.36	3885.0
2021-08-02 20:00:00	ES	Futures	4940.36	4948.53	4940.08	4945.43	11963.0
2021-08-02 21:00:00	ES	Futures	4945.43	4945.99	4935.85	4938.67	11586.0
2021-08-02 22:00:00	ES	Futures	4938.95	4938.95	4934.45	4938.11	6970.0
2021-08-02 23:00:00	ES	Futures	4937.83	4943.46	4937.26	4941.2	5758.0
2021-08-02 00:00:00	NQ	Futures	17413.03	17418.82	17409.26	17414.48	1261.0
2021-08-02 01:00:00	NQ	Futures	17415.35	17432.15	17411.0	17419.11	2880.0
2021-08-02 02:00:00	NQ	Futures	17419.69	17433.89	17410.42	17424.04	3682.0
2021-08-02 03:00:00	NQ	Futures	17423.46	17446.05	17420.56	17425.49	6184.0
2021-08-02 04:00:00	NQ	Futures	17426.07	17428.96	17413.61	17427.8	3667.0
2021-08-02 05:00:00	NQ	Futures	17427.8	17433.6	17415.93	17428.67	2579.0
2021-08-02 06:00:00	NQ	Futures	17428.96	17429.83	17380.88	17386.09	5677.0
2021-08-02 07:00:00	NQ	Futures	17385.51	17417.67	17377.69	17414.48	6881.0
2021-08-02 08:00:00	NQ	Futures	17414.48	17419.98	17393.91	17404.92	7431.0
2021-08-02 09:00:00	NQ	Futures	17405.21	17432.44	17306.43	17353.07	82042.0
2021-08-02 10:00:00	NQ	Futures	17353.07	17416.51	17314.54	17411.0	78099.0
2021-08-02 11:00:00	NQ	Futures	17411.29	17440.55	17377.4	17382.32	52943.0
2021-08-02 12:00:00	NQ	Futures	17382.32	17386.96	17336.26	17368.42	50401.0
2021-08-02 13:00:00	NQ	Futures	17369.29	17397.39	17349.3	17364.65	29788.0
2021-08-02 14:00:00	NQ	Futures	17364.36	17380.59	17355.38	17370.45	24195.0
2021-08-02 15:00:00	NQ	Futures	17370.45	17379.43	17302.37	17328.44	52063.0
2021-08-02 16:00:00	NQ	Futures	17328.15	17342.06	17326.99	17334.24	8132.0
2021-08-02 18:00:00	NQ	Futures	17337.13	17350.17	17331.92	17342.35	2692.0
2021-08-02 19:00:00	NQ	Futures	17342.93	17345.53	17325.26	17335.97	2099.0
2021-08-02 20:00:00	NQ	Futures	17336.26	17366.97	17334.24	17354.22	5178.0
2021-08-02 21:00:00	NQ	Futures	17354.51	17357.41	17320.33	17328.44	5176.0
2021-08-02 22:00:00	NQ	Futures	17329.89	17335.11	17313.67	17326.13	4278.0
2021-08-02 23:00:00	NQ	Futures	17326.13	17350.75	17323.81	17341.19	3284.0
2021-08-02 00:00:00	YM	Futures	39085.9	39104.9	39078.1	39096.0	842.0
2021-08-02 01:00:00	YM	Futures	39096.0	39116.1	39079.2	39081.5	1295.0
2021-08-02 02:00:00	YM	Futures	39080.4	39104.9	39058.0	39091.5	1684.0
2021-08-02 03:00:00	YM	Futures	39091.5	39165.3	39085.9	39117.2	6242.0

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

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