PREVIEW / etf_1hour / 2026-07-24

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-07-24.parquet
  size:    695 KB
  rows:    27,528

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-24 04:00:00	SPY	ETF	739.84	740.47	737.68	739.9	55616.0
2026-07-24 05:00:00	SPY	ETF	739.9	740.84	739.82	740.8	20235.0
2026-07-24 06:00:00	SPY	ETF	740.69	740.79	739.98	740.1604	37697.0
2026-07-24 07:00:00	SPY	ETF	740.03	740.94	739.5	740.63	104531.0
2026-07-24 08:00:00	SPY	ETF	740.7	741.02	739.08	739.15	181150.0
2026-07-24 09:00:00	SPY	ETF	739.27	739.88	737.43	737.53	3202445.0
2026-07-24 10:00:00	SPY	ETF	737.5	740.7	737.333	740.59	4955352.0
2026-07-24 11:00:00	SPY	ETF	740.59	743.25	739.58	743.015	4197466.0
2026-07-24 12:00:00	SPY	ETF	743.04	743.72	740.74	741.45	2866042.0
2026-07-24 13:00:00	SPY	ETF	741.47	742.1692	740.2301	740.98	2320889.0
2026-07-24 14:00:00	SPY	ETF	740.99	741.29	737.64	738.38	3972066.0
2026-07-24 15:00:00	SPY	ETF	738.39	739.1	737.29	738.85	8794199.0
2026-07-24 16:00:00	SPY	ETF	738.86	739.07	738.01	738.45	1855418.0
2026-07-24 17:00:00	SPY	ETF	738.55	739.29	737.7	738.82	219856.0
2026-07-24 18:00:00	SPY	ETF	738.8849	739.06	738.59	738.6	37548.0
2026-07-24 19:00:00	SPY	ETF	738.59	738.93	738.22	738.66	20464.0
2026-07-24 04:00:00	QQQ	ETF	692.46	693.4	688.75	692.35	204299.0
2026-07-24 05:00:00	QQQ	ETF	692.5131	694.44	692.31	694.36	100466.0
2026-07-24 06:00:00	QQQ	ETF	694.39	694.48	692.75	692.83	99872.0
2026-07-24 07:00:00	QQQ	ETF	692.89	694.26	692.0	693.82	135307.0
2026-07-24 08:00:00	QQQ	ETF	693.6	694.39	691.64	691.74	233990.0
2026-07-24 09:00:00	QQQ	ETF	691.84	692.45	685.025	685.22	4878254.0
2026-07-24 10:00:00	QQQ	ETF	685.17	688.539	683.546	688.28	5292949.0
2026-07-24 11:00:00	QQQ	ETF	688.3	691.49	685.975	691.2804	4453385.0
2026-07-24 12:00:00	QQQ	ETF	691.3	692.63	688.505	689.32	2414338.0
2026-07-24 13:00:00	QQQ	ETF	689.38	690.5063	687.7	688.65	1878317.0
2026-07-24 14:00:00	QQQ	ETF	688.66	689.11	683.63	684.6798	4080384.0
2026-07-24 15:00:00	QQQ	ETF	684.64	685.297	682.48	684.22	6029002.0
2026-07-24 16:00:00	QQQ	ETF	684.23	687.7263	683.67	684.81	1428599.0
2026-07-24 17:00:00	QQQ	ETF	684.88	685.35	684.12	684.72	122901.0
2026-07-24 18:00:00	QQQ	ETF	684.75	684.84	684.1	684.1742	32337.0
2026-07-24 19:00:00	QQQ	ETF	684.18	684.56	683.53	683.9	56403.0
2026-07-24 04:00:00	IWM	ETF	292.45	292.86	291.39	292.76	25655.0
2026-07-24 05:00:00	IWM	ETF	292.84	293.3	292.84	293.3	8265.0
2026-07-24 06:00:00	IWM	ETF	293.325	293.42	293.12	293.31	12876.0
2026-07-24 07:00:00	IWM	ETF	293.37	293.88	293.0	293.62	67523.0
2026-07-24 08:00:00	IWM	ETF	293.43	293.67	293.07	293.11	80773.0
2026-07-24 09:00:00	IWM	ETF	293.13	293.54	291.33	291.57	2588224.0
2026-07-24 10:00:00	IWM	ETF	291.57	292.25	290.48	291.7775	2646961.0
2026-07-24 11:00:00	IWM	ETF	291.78	293.87	291.42	293.47	2305167.0
2026-07-24 12:00:00	IWM	ETF	293.49	293.97	292.31	292.77	1200997.0
2026-07-24 13:00:00	IWM	ETF	292.79	293.2	292.01	292.74	925379.0
2026-07-24 14:00:00	IWM	ETF	292.73	292.825	291.33	291.67	1359998.0
2026-07-24 15:00:00	IWM	ETF	291.665	291.74	290.76	291.2	3079244.0
2026-07-24 16:00:00	IWM	ETF	291.2	291.57	291.05	291.43	811688.0
2026-07-24 17:00:00	IWM	ETF	291.31	291.86	291.22	291.48	19736.0
2026-07-24 18:00:00	IWM	ETF	291.51	291.6822	291.33	291.39	3179.0
2026-07-24 19:00:00	IWM	ETF	291.33	291.57	291.2	291.4	4592.0
2026-07-24 04:00:00	DIA	ETF	516.54	518.77	516.54	518.77	2702.0
2026-07-24 05:00:00	DIA	ETF	518.98	519.18	518.79	519.14	789.0

> showing 50 of 27,528 rows — these rows as CSV

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