PREVIEW / futures_1hour / 2023-07-14

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-07-14.parquet
  size:    56 KB
  rows:    1,637

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-07-14 00:00:00	ES	Futures	4987.05	4987.32	4985.13	4985.68	3781.0
2023-07-14 01:00:00	ES	Futures	4985.68	4987.87	4983.75	4987.87	6130.0
2023-07-14 02:00:00	ES	Futures	4987.6	4988.7	4981.01	4981.56	7996.0
2023-07-14 03:00:00	ES	Futures	4981.56	4987.6	4981.56	4986.77	13426.0
2023-07-14 04:00:00	ES	Futures	4986.77	4988.42	4985.13	4985.4	10922.0
2023-07-14 05:00:00	ES	Futures	4985.4	4987.05	4982.93	4985.13	10041.0
2023-07-14 06:00:00	ES	Futures	4985.4	4992.81	4985.13	4991.44	20090.0
2023-07-14 07:00:00	ES	Futures	4991.72	4996.38	4991.72	4993.91	18418.0
2023-07-14 08:00:00	ES	Futures	4994.19	4999.68	4993.91	4997.75	26129.0
2023-07-14 09:00:00	ES	Futures	4997.75	5004.62	4994.19	5003.79	156800.0
2023-07-14 10:00:00	ES	Futures	5004.07	5007.64	4987.05	4994.19	250733.0
2023-07-14 11:00:00	ES	Futures	4993.91	5001.6	4992.81	4998.03	127335.0
2023-07-14 12:00:00	ES	Futures	4998.03	4998.3	4987.32	4990.07	107093.0
2023-07-14 13:00:00	ES	Futures	4990.34	4993.91	4983.21	4990.62	110730.0
2023-07-14 14:00:00	ES	Futures	4990.62	4995.28	4983.21	4984.03	105266.0
2023-07-14 15:00:00	ES	Futures	4984.3	4987.32	4975.24	4984.03	247445.0
2023-07-14 16:00:00	ES	Futures	4984.03	4984.3	4979.36	4979.91	55567.0
2023-07-14 00:00:00	NQ	Futures	17493.06	17495.28	17483.6	17491.67	2407.0
2023-07-14 01:00:00	NQ	Futures	17491.67	17497.79	17481.65	17497.23	2992.0
2023-07-14 02:00:00	NQ	Futures	17496.95	17501.68	17464.69	17467.19	4773.0
2023-07-14 03:00:00	NQ	Futures	17467.75	17492.78	17467.47	17486.1	5784.0
2023-07-14 04:00:00	NQ	Futures	17485.83	17509.47	17476.37	17477.76	7663.0
2023-07-14 05:00:00	NQ	Futures	17477.76	17483.05	17452.73	17456.07	6422.0
2023-07-14 06:00:00	NQ	Futures	17456.9	17469.97	17450.78	17456.07	9025.0
2023-07-14 07:00:00	NQ	Futures	17456.34	17485.83	17456.34	17478.6	9565.0
2023-07-14 08:00:00	NQ	Futures	17478.87	17494.17	17473.31	17478.32	11689.0
2023-07-14 09:00:00	NQ	Futures	17477.76	17590.96	17468.86	17585.12	83102.0
2023-07-14 10:00:00	NQ	Futures	17586.79	17641.58	17525.88	17563.15	127313.0
2023-07-14 11:00:00	NQ	Futures	17563.43	17613.77	17558.14	17595.97	65581.0
2023-07-14 12:00:00	NQ	Futures	17596.24	17598.75	17527.55	17539.23	58067.0
2023-07-14 13:00:00	NQ	Futures	17539.23	17541.17	17494.17	17511.41	54938.0
2023-07-14 14:00:00	NQ	Futures	17511.41	17537.28	17461.35	17463.02	52209.0
2023-07-14 15:00:00	NQ	Futures	17463.85	17474.15	17425.47	17469.97	80291.0
2023-07-14 16:00:00	NQ	Futures	17469.97	17479.15	17456.62	17459.68	14185.0
2023-07-14 00:00:00	YM	Futures	37836.8	37837.9	37819.3	37823.7	574.0
2023-07-14 01:00:00	YM	Futures	37823.7	37834.7	37806.2	37833.6	1007.0
2023-07-14 02:00:00	YM	Futures	37832.5	37846.7	37790.8	37799.6	1445.0
2023-07-14 03:00:00	YM	Futures	37799.6	37845.6	37798.5	37843.4	2083.0
2023-07-14 04:00:00	YM	Futures	37843.4	37870.8	37828.1	37853.3	2885.0
2023-07-14 05:00:00	YM	Futures	37852.2	37938.7	37843.4	37920.1	4876.0
2023-07-14 06:00:00	YM	Futures	37920.1	38068.0	37917.9	38061.4	7371.0
2023-07-14 07:00:00	YM	Futures	38062.5	38075.7	38040.6	38054.9	4130.0
2023-07-14 08:00:00	YM	Futures	38054.9	38100.9	38050.5	38095.4	4822.0
2023-07-14 09:00:00	YM	Futures	38094.3	38111.8	38022.0	38079.0	19332.0
2023-07-14 10:00:00	YM	Futures	38080.1	38086.6	37938.7	37989.1	23244.0
2023-07-14 11:00:00	YM	Futures	37989.1	38034.0	37958.5	38016.5	10390.0
2023-07-14 12:00:00	YM	Futures	38016.5	38038.4	37974.9	38011.0	8901.0
2023-07-14 13:00:00	YM	Futures	38013.2	38057.1	37973.8	38037.3	7875.0
2023-07-14 14:00:00	YM	Futures	38037.3	38075.7	38009.9	38026.4	8205.0
2023-07-14 15:00:00	YM	Futures	38028.6	38058.1	37965.0	38008.8	18426.0

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

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