PREVIEW / futures_1hour / 2023-05-08

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-05-08.parquet
  size:    63 KB
  rows:    1,959

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-05-08 00:00:00	ES	Futures	4600.18	4601.29	4599.35	4600.18	3572.0
2023-05-08 01:00:00	ES	Futures	4600.18	4602.96	4599.63	4600.74	4734.0
2023-05-08 02:00:00	ES	Futures	4600.74	4604.62	4600.18	4603.23	5816.0
2023-05-08 03:00:00	ES	Futures	4603.51	4611.0	4602.68	4606.56	15468.0
2023-05-08 04:00:00	ES	Futures	4606.56	4608.23	4604.07	4604.9	8175.0
2023-05-08 05:00:00	ES	Futures	4604.9	4608.78	4604.34	4608.78	6800.0
2023-05-08 06:00:00	ES	Futures	4608.5	4612.11	4607.95	4611.0	6834.0
2023-05-08 07:00:00	ES	Futures	4611.0	4614.88	4610.45	4612.94	14135.0
2023-05-08 08:00:00	ES	Futures	4612.94	4616.27	4608.78	4611.28	21696.0
2023-05-08 09:00:00	ES	Futures	4611.0	4611.83	4597.13	4600.46	129918.0
2023-05-08 10:00:00	ES	Futures	4600.46	4604.62	4594.64	4602.68	157065.0
2023-05-08 11:00:00	ES	Futures	4602.68	4607.67	4596.58	4605.45	105134.0
2023-05-08 12:00:00	ES	Futures	4605.45	4606.84	4598.24	4601.29	74642.0
2023-05-08 13:00:00	ES	Futures	4601.57	4608.78	4599.35	4606.84	70684.0
2023-05-08 14:00:00	ES	Futures	4606.84	4612.39	4590.2	4611.0	165923.0
2023-05-08 15:00:00	ES	Futures	4611.0	4611.83	4603.23	4607.67	134347.0
2023-05-08 16:00:00	ES	Futures	4607.39	4608.78	4604.62	4605.73	30632.0
2023-05-08 18:00:00	ES	Futures	4604.62	4605.73	4603.51	4604.34	3083.0
2023-05-08 19:00:00	ES	Futures	4604.34	4605.45	4603.23	4604.62	1940.0
2023-05-08 20:00:00	ES	Futures	4604.34	4604.9	4601.85	4602.12	4679.0
2023-05-08 21:00:00	ES	Futures	4602.4	4606.29	4601.29	4604.9	5610.0
2023-05-08 22:00:00	ES	Futures	4604.62	4605.73	4603.79	4604.9	2531.0
2023-05-08 23:00:00	ES	Futures	4605.18	4606.29	4604.07	4605.73	3023.0
2023-05-08 00:00:00	NQ	Futures	14993.26	14998.05	14991.01	14992.98	1411.0
2023-05-08 01:00:00	NQ	Futures	14993.26	15004.52	14991.01	14994.39	2543.0
2023-05-08 02:00:00	NQ	Futures	14994.11	15005.65	14988.76	14997.77	2826.0
2023-05-08 03:00:00	NQ	Futures	14997.77	15018.04	14991.85	15000.3	5270.0
2023-05-08 04:00:00	NQ	Futures	15000.58	15003.12	14976.09	14981.44	5621.0
2023-05-08 05:00:00	NQ	Futures	14981.44	14995.8	14976.37	14995.23	3335.0
2023-05-08 06:00:00	NQ	Futures	14995.23	15002.27	14984.25	14992.98	3949.0
2023-05-08 07:00:00	NQ	Futures	14992.7	15006.49	14989.32	14995.51	6352.0
2023-05-08 08:00:00	NQ	Futures	14995.23	15001.99	14964.82	14972.43	12651.0
2023-05-08 09:00:00	NQ	Futures	14972.14	14990.16	14934.98	14945.12	79719.0
2023-05-08 10:00:00	NQ	Futures	14945.4	14975.24	14927.38	14965.95	86674.0
2023-05-08 11:00:00	NQ	Futures	14965.95	15003.68	14955.25	15002.55	57811.0
2023-05-08 12:00:00	NQ	Futures	15002.83	15011.0	14986.79	15008.47	38799.0
2023-05-08 13:00:00	NQ	Futures	15008.75	15040.0	14997.2	15029.86	41716.0
2023-05-08 14:00:00	NQ	Futures	15030.14	15055.2	14966.23	15048.16	65197.0
2023-05-08 15:00:00	NQ	Futures	15048.45	15052.39	15020.29	15040.0	52879.0
2023-05-08 16:00:00	NQ	Futures	15039.72	15040.0	15017.76	15019.45	14789.0
2023-05-08 18:00:00	NQ	Futures	15021.98	15022.26	15007.06	15017.76	1838.0
2023-05-08 19:00:00	NQ	Futures	15017.47	15023.67	15011.84	15020.85	1318.0
2023-05-08 20:00:00	NQ	Futures	15020.29	15022.54	15009.03	15012.13	2069.0
2023-05-08 21:00:00	NQ	Futures	15012.13	15022.54	15010.15	15019.45	2647.0
2023-05-08 22:00:00	NQ	Futures	15020.01	15025.92	15016.07	15023.11	1831.0
2023-05-08 23:00:00	NQ	Futures	15023.39	15026.77	15019.45	15024.51	1253.0
2023-05-08 00:00:00	YM	Futures	37263.3	37271.0	37258.8	37266.6	328.0
2023-05-08 01:00:00	YM	Futures	37265.5	37280.9	37259.9	37272.1	752.0
2023-05-08 02:00:00	YM	Futures	37272.1	37303.1	37271.0	37292.0	1162.0
2023-05-08 03:00:00	YM	Futures	37294.2	37351.7	37289.8	37321.8	2320.0

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

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