PREVIEW / etf_1hour / 2026-07-28

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-07-28.parquet
  size:    727 KB
  rows:    28,711

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
2026-07-28 04:00:00	SPY	ETF	737.0	739.06	736.16	738.45	89236.0
2026-07-28 05:00:00	SPY	ETF	738.45	738.85	738.1	738.26	18478.0
2026-07-28 06:00:00	SPY	ETF	738.28	738.63	737.69	738.52	49429.0
2026-07-28 07:00:00	SPY	ETF	738.471	739.49	737.59	739.36	178347.0
2026-07-28 08:00:00	SPY	ETF	739.39	741.0	737.51	739.88	454466.0
2026-07-28 09:00:00	SPY	ETF	739.87	740.48	735.98	736.5	5454534.0
2026-07-28 10:00:00	SPY	ETF	736.49	739.82	736.27	738.64	4903525.0
2026-07-28 11:00:00	SPY	ETF	738.7	742.45	738.01	742.215	3889166.0
2026-07-28 12:00:00	SPY	ETF	742.205	742.7901	740.92	742.61	2335619.0
2026-07-28 13:00:00	SPY	ETF	742.61	742.78	740.51	741.19	2245773.0
2026-07-28 14:00:00	SPY	ETF	741.2	741.615	740.42	741.45	2735819.0
2026-07-28 15:00:00	SPY	ETF	741.45	741.96	740.43	740.76	6282032.0
2026-07-28 16:00:00	SPY	ETF	740.79	741.6	740.08	741.03	2907000.0
2026-07-28 17:00:00	SPY	ETF	740.95	741.19	740.78	740.78	44912.0
2026-07-28 18:00:00	SPY	ETF	740.91	741.6	739.3	739.61	268243.0
2026-07-28 19:00:00	SPY	ETF	739.38	743.63	739.15	743.57	173244.0
2026-07-28 04:00:00	QQQ	ETF	676.82	678.69	673.67	677.31	339152.0
2026-07-28 05:00:00	QQQ	ETF	677.34	677.92	676.18	676.35	64054.0
2026-07-28 06:00:00	QQQ	ETF	676.47	677.04	675.3	676.14	161876.0
2026-07-28 07:00:00	QQQ	ETF	676.17	676.85	673.97	676.64	476557.0
2026-07-28 08:00:00	QQQ	ETF	676.6	682.631	676.03	677.41	343829.0
2026-07-28 09:00:00	QQQ	ETF	677.44	678.19	668.8564	669.38	8126335.0
2026-07-28 10:00:00	QQQ	ETF	669.33	674.83	667.88	672.69	7327363.0
2026-07-28 11:00:00	QQQ	ETF	672.71	678.99	671.83	678.61	5210410.0
2026-07-28 12:00:00	QQQ	ETF	678.63	679.4	676.33	678.81	3016288.0
2026-07-28 13:00:00	QQQ	ETF	678.82	679.0299	675.65	676.7742	2277767.0
2026-07-28 14:00:00	QQQ	ETF	676.84	677.4401	675.35	676.8005	1846515.0
2026-07-28 15:00:00	QQQ	ETF	676.8	678.06	675.27	675.5	4363185.0
2026-07-28 16:00:00	QQQ	ETF	675.5	677.18	674.7	676.43	1586097.0
2026-07-28 17:00:00	QQQ	ETF	676.55	677.3451	676.21	677.16	163010.0
2026-07-28 18:00:00	QQQ	ETF	677.01	677.7	671.54	671.54	350923.0
2026-07-28 19:00:00	QQQ	ETF	671.62	679.88	671.0	679.88	366885.0
2026-07-28 04:00:00	IWM	ETF	292.12	293.24	292.01	292.93	40178.0
2026-07-28 05:00:00	IWM	ETF	292.9	293.09	292.77	292.82	4007.0
2026-07-28 06:00:00	IWM	ETF	292.81	292.88	292.31	292.68	7936.0
2026-07-28 07:00:00	IWM	ETF	292.83	293.17	292.25	293.03	118082.0
2026-07-28 08:00:00	IWM	ETF	293.04	293.6	292.88	293.26	79013.0
2026-07-28 09:00:00	IWM	ETF	293.2	293.47	290.85	291.1705	2103615.0
2026-07-28 10:00:00	IWM	ETF	291.18	292.15	290.375	291.4805	2658468.0
2026-07-28 11:00:00	IWM	ETF	291.49	293.66	291.17	293.37	2684621.0
2026-07-28 12:00:00	IWM	ETF	293.37	293.73	292.7	293.68	1643079.0
2026-07-28 13:00:00	IWM	ETF	293.67	293.77	292.72	293.05	2032382.0
2026-07-28 14:00:00	IWM	ETF	293.06	293.28	292.5118	293.03	2104511.0
2026-07-28 15:00:00	IWM	ETF	293.02	293.68	292.97	293.36	3019502.0
2026-07-28 16:00:00	IWM	ETF	293.37	293.6001	293.2	293.52	446878.0
2026-07-28 17:00:00	IWM	ETF	293.33	293.55	293.28	293.41	14320.0
2026-07-28 18:00:00	IWM	ETF	293.54	293.57	292.58	293.001	95304.0
2026-07-28 19:00:00	IWM	ETF	292.86	294.39	292.8	294.28	29412.0
2026-07-28 04:00:00	DIA	ETF	522.06	522.79	520.97	522.38	9996.0
2026-07-28 05:00:00	DIA	ETF	522.57	523.13	522.57	523.13	946.0

> showing 50 of 28,711 rows — these rows as CSV

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