PREVIEW / futures_1hour / 2023-12-12

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-12-12.parquet
  size:    63 KB
  rows:    1,989

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-12-12 00:00:00	ES	Futures	5026.0	5028.17	5025.73	5027.09	1776.0
2023-12-12 01:00:00	ES	Futures	5026.82	5027.36	5024.1	5026.27	2715.0
2023-12-12 02:00:00	ES	Futures	5026.27	5028.99	5025.46	5026.55	2868.0
2023-12-12 03:00:00	ES	Futures	5026.55	5031.16	5025.73	5026.55	4950.0
2023-12-12 04:00:00	ES	Futures	5026.55	5032.25	5026.0	5031.7	3724.0
2023-12-12 05:00:00	ES	Futures	5031.7	5031.7	5024.92	5025.46	4454.0
2023-12-12 06:00:00	ES	Futures	5025.19	5027.9	5024.37	5024.92	2652.0
2023-12-12 07:00:00	ES	Futures	5024.64	5032.52	5024.37	5030.35	6566.0
2023-12-12 08:00:00	ES	Futures	5030.35	5046.1	5019.21	5020.84	37415.0
2023-12-12 09:00:00	ES	Futures	5020.84	5025.46	5008.08	5017.86	56539.0
2023-12-12 10:00:00	ES	Futures	5017.86	5030.62	5015.68	5030.62	40597.0
2023-12-12 11:00:00	ES	Futures	5030.62	5032.52	5027.36	5029.53	23914.0
2023-12-12 12:00:00	ES	Futures	5029.8	5035.78	5025.73	5030.08	18809.0
2023-12-12 13:00:00	ES	Futures	5030.08	5037.14	5028.72	5036.32	14319.0
2023-12-12 14:00:00	ES	Futures	5036.32	5040.94	5034.42	5040.39	12677.0
2023-12-12 15:00:00	ES	Futures	5040.39	5047.73	5039.58	5046.91	41020.0
2023-12-12 16:00:00	ES	Futures	5046.91	5050.71	5045.55	5050.17	36126.0
2023-12-12 18:00:00	ES	Futures	5049.9	5053.97	5049.36	5053.16	1169.0
2023-12-12 19:00:00	ES	Futures	5052.89	5053.97	5051.26	5053.16	1631.0
2023-12-12 20:00:00	ES	Futures	5052.89	5054.24	5050.99	5053.43	1723.0
2023-12-12 21:00:00	ES	Futures	5053.43	5054.52	5051.8	5052.89	991.0
2023-12-12 22:00:00	ES	Futures	5052.61	5052.61	5051.26	5052.34	656.0
2023-12-12 23:00:00	ES	Futures	5052.07	5053.7	5051.26	5053.43	1762.0
2023-12-12 00:00:00	NQ	Futures	17858.39	17871.85	17857.02	17867.73	865.0
2023-12-12 01:00:00	NQ	Futures	17868.0	17870.48	17861.14	17866.63	1036.0
2023-12-12 02:00:00	NQ	Futures	17866.63	17874.32	17863.06	17866.63	1850.0
2023-12-12 03:00:00	NQ	Futures	17866.36	17887.51	17861.14	17861.96	3785.0
2023-12-12 04:00:00	NQ	Futures	17862.24	17875.42	17855.37	17874.6	1861.0
2023-12-12 05:00:00	NQ	Futures	17873.22	17873.22	17856.47	17859.49	1709.0
2023-12-12 06:00:00	NQ	Futures	17859.22	17869.38	17856.19	17858.12	1664.0
2023-12-12 07:00:00	NQ	Futures	17857.84	17892.17	17857.29	17886.13	3695.0
2023-12-12 08:00:00	NQ	Futures	17885.58	17957.54	17834.22	17843.28	16997.0
2023-12-12 09:00:00	NQ	Futures	17842.46	17861.41	17782.03	17859.22	25562.0
2023-12-12 10:00:00	NQ	Futures	17859.49	17895.2	17845.76	17893.27	19632.0
2023-12-12 11:00:00	NQ	Futures	17893.27	17915.8	17875.15	17880.91	11694.0
2023-12-12 12:00:00	NQ	Futures	17881.19	17899.32	17858.12	17893.27	9596.0
2023-12-12 13:00:00	NQ	Futures	17893.0	17932.28	17885.31	17928.43	9049.0
2023-12-12 14:00:00	NQ	Futures	17927.88	17950.4	17920.19	17947.66	6579.0
2023-12-12 15:00:00	NQ	Futures	17948.21	17981.72	17942.44	17979.52	13959.0
2023-12-12 16:00:00	NQ	Futures	17978.69	18006.44	17975.12	18002.59	4227.0
2023-12-12 18:00:00	NQ	Futures	17999.29	18019.34	17993.8	18013.58	827.0
2023-12-12 19:00:00	NQ	Futures	18013.3	18015.22	18000.67	18009.73	936.0
2023-12-12 20:00:00	NQ	Futures	18008.63	18013.3	18003.41	18009.18	747.0
2023-12-12 21:00:00	NQ	Futures	18008.36	18013.3	18003.14	18006.71	418.0
2023-12-12 22:00:00	NQ	Futures	18008.08	18008.63	18003.14	18007.53	319.0
2023-12-12 23:00:00	NQ	Futures	18006.98	18014.13	18004.51	18013.03	626.0
2023-12-12 00:00:00	YM	Futures	39548.6	39558.3	39544.3	39546.5	533.0
2023-12-12 01:00:00	YM	Futures	39546.5	39550.8	39529.3	39540.0	563.0
2023-12-12 02:00:00	YM	Futures	39538.9	39564.7	39531.4	39552.9	1364.0
2023-12-12 03:00:00	YM	Futures	39552.9	39587.3	39542.2	39558.3	1865.0

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

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