PREVIEW / etf_1hour / 2025-09-04

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-09-04.parquet
  size:    677 KB
  rows:    25,675

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
2025-09-04 04:00:00	SPY	ETF	644.46	644.71	644.28	644.49	10381.0
2025-09-04 05:00:00	SPY	ETF	644.52	644.78	644.5	644.75	4142.0
2025-09-04 06:00:00	SPY	ETF	644.9	645.24	644.58	644.85	26122.0
2025-09-04 07:00:00	SPY	ETF	644.7	645.05	644.17	644.42	57598.0
2025-09-04 08:00:00	SPY	ETF	644.95	645.05	643.8	644.4082	237753.0
2025-09-04 09:00:00	SPY	ETF	644.3	645.3	643.97	644.85	5357320.0
2025-09-04 10:00:00	SPY	ETF	644.8	645.78	643.51	645.645	8067047.0
2025-09-04 11:00:00	SPY	ETF	645.64	646.59	645.31	646.175	4987735.0
2025-09-04 12:00:00	SPY	ETF	646.175	646.56	645.81	645.943	3216524.0
2025-09-04 13:00:00	SPY	ETF	645.95	647.462	645.92	647.14	3975706.0
2025-09-04 14:00:00	SPY	ETF	647.14	647.68	647.08	647.63	3789032.0
2025-09-04 15:00:00	SPY	ETF	647.63	649.15	647.595	648.99	12255216.0
2025-09-04 16:00:00	SPY	ETF	648.99	649.53	648.73	649.12	3641503.0
2025-09-04 17:00:00	SPY	ETF	649.1249	649.79	649.05	649.5	177137.0
2025-09-04 18:00:00	SPY	ETF	649.34	649.6	649.13	649.5	93983.0
2025-09-04 19:00:00	SPY	ETF	649.5	649.6	649.39	649.46	33649.0
2025-09-04 04:00:00	QQQ	ETF	570.82	571.4	570.7	571.13	35260.0
2025-09-04 05:00:00	QQQ	ETF	571.25	571.65	571.02	571.62	43021.0
2025-09-04 06:00:00	QQQ	ETF	571.62	572.03	571.26	571.44	60270.0
2025-09-04 07:00:00	QQQ	ETF	571.43	571.71	570.75	571.09	62261.0
2025-09-04 08:00:00	QQQ	ETF	571.5	571.7904	570.17	570.84	338863.0
2025-09-04 09:00:00	QQQ	ETF	570.8	572.35	570.18	570.61	5172240.0
2025-09-04 10:00:00	QQQ	ETF	570.83	571.92	569.025	571.738	6342581.0
2025-09-04 11:00:00	QQQ	ETF	571.73	572.53	571.01	572.12	4288233.0
2025-09-04 12:00:00	QQQ	ETF	572.125	572.775	571.52	572.13	2759131.0
2025-09-04 13:00:00	QQQ	ETF	572.14	573.715	572.09	573.225	3118886.0
2025-09-04 14:00:00	QQQ	ETF	573.22	574.215	573.21	574.11	3448115.0
2025-09-04 15:00:00	QQQ	ETF	574.1058	575.6	574.02	575.27	6907081.0
2025-09-04 16:00:00	QQQ	ETF	575.27	576.25	575.08	575.67	1525842.0
2025-09-04 17:00:00	QQQ	ETF	575.62	576.36	575.6	576.14	167157.0
2025-09-04 18:00:00	QQQ	ETF	576.05	576.34	575.85	576.21	103375.0
2025-09-04 19:00:00	QQQ	ETF	576.22	576.41	576.14	576.22	84577.0
2025-09-04 04:00:00	IWM	ETF	234.25	234.25	233.76	233.85	28781.0
2025-09-04 05:00:00	IWM	ETF	233.86	234.18	233.86	234.18	10712.0
2025-09-04 06:00:00	IWM	ETF	234.12	234.51	234.12	234.37	13262.0
2025-09-04 07:00:00	IWM	ETF	234.36	234.48	234.11	234.2	22347.0
2025-09-04 08:00:00	IWM	ETF	234.4786	234.53	233.9301	234.26	283547.0
2025-09-04 09:00:00	IWM	ETF	234.23	234.76	233.58	234.48	3455042.0
2025-09-04 10:00:00	IWM	ETF	234.51	234.79	233.66	234.37	3576696.0
2025-09-04 11:00:00	IWM	ETF	234.3697	235.09	234.22	234.83	2999837.0
2025-09-04 12:00:00	IWM	ETF	234.82	235.06	234.48	234.6	2192011.0
2025-09-04 13:00:00	IWM	ETF	234.6	235.37	234.575	235.36	2152227.0
2025-09-04 14:00:00	IWM	ETF	235.35	235.61	235.325	235.47	1957565.0
2025-09-04 15:00:00	IWM	ETF	235.475	236.6665	235.435	236.58	5400911.0
2025-09-04 16:00:00	IWM	ETF	236.59	236.77	236.48	236.59	1884304.0
2025-09-04 17:00:00	IWM	ETF	236.57	236.73	236.4	236.54	25613.0
2025-09-04 18:00:00	IWM	ETF	236.5	236.59	236.38	236.5	52530.0
2025-09-04 19:00:00	IWM	ETF	236.5	236.6	236.41	236.4885	21226.0
2025-09-04 04:00:00	DIA	ETF	453.02	453.13	452.97	453.01	600.0
2025-09-04 05:00:00	DIA	ETF	453.1	453.21	453.1	453.18	1450.0

> showing 50 of 25,675 rows — these rows as CSV

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