PREVIEW / futures_1hour / 2023-06-19

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-06-19.parquet
  size:    52 KB
  rows:    1,610

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
2023-06-19 00:00:00	ES	Futures	4885.48	4886.03	4883.01	4883.83	3623.0
2023-06-19 01:00:00	ES	Futures	4883.83	4890.15	4883.01	4889.87	4488.0
2023-06-19 02:00:00	ES	Futures	4889.87	4891.24	4888.22	4889.32	4851.0
2023-06-19 03:00:00	ES	Futures	4889.6	4898.11	4887.13	4890.42	17875.0
2023-06-19 04:00:00	ES	Futures	4890.42	4892.62	4886.3	4888.77	9106.0
2023-06-19 05:00:00	ES	Futures	4888.5	4892.62	4886.85	4891.52	8249.0
2023-06-19 06:00:00	ES	Futures	4891.52	4892.07	4885.75	4887.13	6071.0
2023-06-19 07:00:00	ES	Futures	4886.85	4888.5	4883.83	4885.2	6260.0
2023-06-19 08:00:00	ES	Futures	4885.2	4886.3	4882.19	4886.03	6802.0
2023-06-19 09:00:00	ES	Futures	4886.3	4886.85	4879.99	4880.54	15743.0
2023-06-19 10:00:00	ES	Futures	4880.81	4883.01	4878.62	4880.54	15523.0
2023-06-19 11:00:00	ES	Futures	4880.81	4884.11	4879.99	4883.83	11580.0
2023-06-19 12:00:00	ES	Futures	4884.11	4885.2	4882.19	4884.38	5944.0
2023-06-19 18:00:00	ES	Futures	4885.2	4887.4	4881.09	4881.64	3827.0
2023-06-19 19:00:00	ES	Futures	4881.91	4884.11	4880.54	4882.73	3629.0
2023-06-19 20:00:00	ES	Futures	4882.46	4884.66	4880.26	4882.19	5051.0
2023-06-19 21:00:00	ES	Futures	4882.19	4883.83	4877.79	4879.17	4926.0
2023-06-19 22:00:00	ES	Futures	4879.17	4880.26	4876.97	4878.62	6014.0
2023-06-19 23:00:00	ES	Futures	4878.62	4880.26	4878.07	4879.71	2484.0
2023-06-19 00:00:00	NQ	Futures	16989.36	16995.2	16980.18	16987.97	2866.0
2023-06-19 01:00:00	NQ	Futures	16987.42	17004.94	16984.36	17002.71	2863.0
2023-06-19 02:00:00	NQ	Futures	17002.71	17009.39	16996.59	17002.71	2582.0
2023-06-19 03:00:00	NQ	Futures	17002.71	17028.02	16990.48	16996.59	7525.0
2023-06-19 04:00:00	NQ	Futures	16996.32	16999.93	16968.5	16986.3	6341.0
2023-06-19 05:00:00	NQ	Futures	16986.03	17001.32	16969.89	16992.42	3616.0
2023-06-19 06:00:00	NQ	Futures	16992.42	16997.43	16967.39	16975.46	3346.0
2023-06-19 07:00:00	NQ	Futures	16974.9	16977.96	16952.93	16957.38	3411.0
2023-06-19 08:00:00	NQ	Futures	16957.93	16975.18	16948.2	16971.84	4560.0
2023-06-19 09:00:00	NQ	Futures	16972.12	16982.13	16951.54	16955.43	9483.0
2023-06-19 10:00:00	NQ	Futures	16955.15	16964.89	16944.31	16959.88	9066.0
2023-06-19 11:00:00	NQ	Futures	16960.16	16963.77	16946.81	16962.66	6853.0
2023-06-19 12:00:00	NQ	Futures	16962.66	16966.56	16951.54	16954.04	4492.0
2023-06-19 18:00:00	NQ	Futures	16959.88	16968.78	16949.59	16952.09	2038.0
2023-06-19 19:00:00	NQ	Futures	16952.65	16968.5	16946.81	16964.33	2758.0
2023-06-19 20:00:00	NQ	Futures	16964.05	16974.62	16958.77	16965.72	3461.0
2023-06-19 21:00:00	NQ	Futures	16965.72	16972.95	16942.91	16949.59	3849.0
2023-06-19 22:00:00	NQ	Futures	16949.59	16954.04	16937.07	16947.92	3751.0
2023-06-19 23:00:00	NQ	Futures	16947.92	16954.04	16942.64	16952.09	2097.0
2023-06-19 00:00:00	YM	Futures	37840.1	37842.3	37820.4	37825.9	421.0
2023-06-19 01:00:00	YM	Futures	37827.0	37866.4	37823.7	37865.3	737.0
2023-06-19 02:00:00	YM	Futures	37865.3	37886.1	37856.6	37874.1	2007.0
2023-06-19 03:00:00	YM	Futures	37875.2	37921.2	37864.2	37897.1	4496.0
2023-06-19 04:00:00	YM	Futures	37896.0	37916.8	37864.2	37871.9	3310.0
2023-06-19 05:00:00	YM	Futures	37869.7	37900.4	37858.8	37891.6	3318.0
2023-06-19 06:00:00	YM	Futures	37891.6	37898.2	37863.1	37873.0	2488.0
2023-06-19 07:00:00	YM	Futures	37873.0	37890.5	37866.4	37878.5	2411.0
2023-06-19 08:00:00	YM	Futures	37876.3	37881.8	37847.8	37873.0	2435.0
2023-06-19 09:00:00	YM	Futures	37873.0	37874.1	37781.0	37782.1	6603.0
2023-06-19 10:00:00	YM	Futures	37783.2	37802.9	37766.7	37771.1	5714.0
2023-06-19 11:00:00	YM	Futures	37771.1	37818.2	37767.8	37808.4	2732.0

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

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