PREVIEW / etf_1hour / 2026-07-23

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-07-23.parquet
  size:    706 KB
  rows:    28,628

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-23 04:00:00	SPY	ETF	744.92	747.33	743.49	745.67	69954.0
2026-07-23 05:00:00	SPY	ETF	745.61	746.41	744.8	744.86	45588.0
2026-07-23 06:00:00	SPY	ETF	744.96	746.21	744.69	745.75	53982.0
2026-07-23 07:00:00	SPY	ETF	745.79	745.92	742.88	743.93	287302.0
2026-07-23 08:00:00	SPY	ETF	743.8796	743.98	740.15	740.49	652969.0
2026-07-23 09:00:00	SPY	ETF	740.43	742.56	738.47	739.575	6189052.0
2026-07-23 10:00:00	SPY	ETF	739.58	740.93	738.01	738.31	4879768.0
2026-07-23 11:00:00	SPY	ETF	738.32	738.48	735.21	737.845	6013830.0
2026-07-23 12:00:00	SPY	ETF	737.845	739.72	737.53	738.66	3632337.0
2026-07-23 13:00:00	SPY	ETF	738.67	739.2	737.13	737.19	2796528.0
2026-07-23 14:00:00	SPY	ETF	737.16	737.69	736.61	737.05	2676167.0
2026-07-23 15:00:00	SPY	ETF	737.08	738.65	735.72	738.24	9428984.0
2026-07-23 16:00:00	SPY	ETF	738.22	739.67	738.18	739.37	2521513.0
2026-07-23 17:00:00	SPY	ETF	739.31	739.5	738.62	738.69	98169.0
2026-07-23 18:00:00	SPY	ETF	738.7	739.2607	738.22	739.2607	124165.0
2026-07-23 19:00:00	SPY	ETF	739.19	739.25	738.35	738.79	22601.0
2026-07-23 04:00:00	QQQ	ETF	702.02	705.8	699.65	704.09	191573.0
2026-07-23 05:00:00	QQQ	ETF	703.89	704.7	702.565	702.6	42718.0
2026-07-23 06:00:00	QQQ	ETF	702.76	704.4	702.41	703.87	133954.0
2026-07-23 07:00:00	QQQ	ETF	703.94	704.0	699.38	700.63	291962.0
2026-07-23 08:00:00	QQQ	ETF	700.6355	700.6355	695.57	696.32	650562.0
2026-07-23 09:00:00	QQQ	ETF	696.34	698.66	693.21	694.46	5659117.0
2026-07-23 10:00:00	QQQ	ETF	694.49	696.71	691.29	691.75	5084494.0
2026-07-23 11:00:00	QQQ	ETF	691.8	691.9399	687.79	691.56	5236242.0
2026-07-23 12:00:00	QQQ	ETF	691.59	695.15	691.2	692.77	3717750.0
2026-07-23 13:00:00	QQQ	ETF	692.78	693.65	690.945	691.02	1658965.0
2026-07-23 14:00:00	QQQ	ETF	691.01	691.85	689.97	690.56	1750518.0
2026-07-23 15:00:00	QQQ	ETF	690.55	692.43	688.93	691.99	4940900.0
2026-07-23 16:00:00	QQQ	ETF	692.05	696.0	691.96	695.15	2610851.0
2026-07-23 17:00:00	QQQ	ETF	695.1824	695.65	692.18	693.85	520362.0
2026-07-23 18:00:00	QQQ	ETF	693.85	694.81	692.3115	694.79	221972.0
2026-07-23 19:00:00	QQQ	ETF	694.79	694.88	693.21	693.54	184341.0
2026-07-23 04:00:00	IWM	ETF	292.7	294.16	292.59	293.78	30124.0
2026-07-23 05:00:00	IWM	ETF	293.74	294.03	293.4	293.63	6824.0
2026-07-23 06:00:00	IWM	ETF	293.58	294.07	293.35	293.96	42746.0
2026-07-23 07:00:00	IWM	ETF	293.88	293.88	292.18	292.92	356912.0
2026-07-23 08:00:00	IWM	ETF	292.78	292.78	290.85	291.18	452463.0
2026-07-23 09:00:00	IWM	ETF	291.18	293.01	290.25	291.51	4397687.0
2026-07-23 10:00:00	IWM	ETF	291.51	292.61	291.35	291.98	3222442.0
2026-07-23 11:00:00	IWM	ETF	291.985	292.09	290.17	291.4	3178538.0
2026-07-23 12:00:00	IWM	ETF	291.43	292.04	291.16	291.73	1948094.0
2026-07-23 13:00:00	IWM	ETF	291.75	291.89	290.96	291.04	1258071.0
2026-07-23 14:00:00	IWM	ETF	291.03	291.45	290.825	291.305	1515414.0
2026-07-23 15:00:00	IWM	ETF	291.34	292.14	291.0	292.1	3497944.0
2026-07-23 16:00:00	IWM	ETF	292.09	292.23	291.622	291.88	732268.0
2026-07-23 17:00:00	IWM	ETF	291.93	292.15	291.69	291.83	32970.0
2026-07-23 18:00:00	IWM	ETF	291.9	291.97	291.56	291.83	23399.0
2026-07-23 19:00:00	IWM	ETF	291.82	291.83	291.5	291.55	24950.0
2026-07-23 04:00:00	DIA	ETF	521.28	521.28	518.75	519.57	1986.0
2026-07-23 05:00:00	DIA	ETF	519.54	519.73	519.54	519.5999	848.0

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

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