PREVIEW / etf_1hour / 2026-07-31

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-07-31.parquet
  size:    720 KB
  rows:    29,069

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-31 04:00:00	SPY	ETF	745.06	746.15	744.02	746.09	99727.0
2026-07-31 05:00:00	SPY	ETF	746.05	746.5454	745.18	745.18	54912.0
2026-07-31 06:00:00	SPY	ETF	745.12	745.98	745.05	745.45	44057.0
2026-07-31 07:00:00	SPY	ETF	745.46	745.9	744.3	744.71	136423.0
2026-07-31 08:00:00	SPY	ETF	744.68	744.89	742.79	743.09	222384.0
2026-07-31 09:00:00	SPY	ETF	743.14	746.301	741.55	741.94	6045923.0
2026-07-31 10:00:00	SPY	ETF	741.94	742.95	737.68	742.5	8229653.0
2026-07-31 11:00:00	SPY	ETF	742.53	743.33	739.81	743.0908	3851976.0
2026-07-31 12:00:00	SPY	ETF	743.09	745.03	742.46	744.62	3286111.0
2026-07-31 13:00:00	SPY	ETF	744.62	746.5	744.5	745.44	3019451.0
2026-07-31 14:00:00	SPY	ETF	745.44	746.54	745.295	746.155	3636623.0
2026-07-31 15:00:00	SPY	ETF	746.14	748.895	745.79	746.82	10559545.0
2026-07-31 16:00:00	SPY	ETF	746.82	747.55	744.9	745.15	4300547.0
2026-07-31 17:00:00	SPY	ETF	745.2499	745.5	744.0	744.72	649854.0
2026-07-31 18:00:00	SPY	ETF	744.74	744.79	744.0	744.35	76405.0
2026-07-31 19:00:00	SPY	ETF	744.3	744.65	744.2	744.2	33259.0
2026-07-31 04:00:00	QQQ	ETF	691.26	692.96	688.465	692.79	296049.0
2026-07-31 05:00:00	QQQ	ETF	692.85	693.62	690.95	691.07	145591.0
2026-07-31 06:00:00	QQQ	ETF	690.96	692.4	690.74	691.77	104625.0
2026-07-31 07:00:00	QQQ	ETF	691.78	693.25	690.88	691.5	282978.0
2026-07-31 08:00:00	QQQ	ETF	691.58	691.58	688.59	689.49	369988.0
2026-07-31 09:00:00	QQQ	ETF	689.51	695.77	685.29	686.79	7733566.0
2026-07-31 10:00:00	QQQ	ETF	686.76	687.6	680.0512	685.61	8301773.0
2026-07-31 11:00:00	QQQ	ETF	685.63	686.43	680.94	684.7863	3651691.0
2026-07-31 12:00:00	QQQ	ETF	684.75	687.625	684.02	687.06	3005334.0
2026-07-31 13:00:00	QQQ	ETF	687.04	690.35	686.89	688.55	2771249.0
2026-07-31 14:00:00	QQQ	ETF	688.565	689.4	687.76	688.71	2100859.0
2026-07-31 15:00:00	QQQ	ETF	688.7	690.88	687.45	687.92	5622729.0
2026-07-31 16:00:00	QQQ	ETF	687.94	688.69	684.7	685.3	2589713.0
2026-07-31 17:00:00	QQQ	ETF	685.33	686.08	684.0	684.5	339002.0
2026-07-31 18:00:00	QQQ	ETF	684.8	685.179	684.05	684.792	50111.0
2026-07-31 19:00:00	QQQ	ETF	684.8	685.36	684.34	684.47	44349.0
2026-07-31 04:00:00	IWM	ETF	294.33	294.63	293.54	294.18	47332.0
2026-07-31 05:00:00	IWM	ETF	294.15	294.73	293.98	294.0	8833.0
2026-07-31 06:00:00	IWM	ETF	293.98	294.27	293.89	294.15	14256.0
2026-07-31 07:00:00	IWM	ETF	294.3077	294.53	293.46	293.82	102905.0
2026-07-31 08:00:00	IWM	ETF	293.79	293.81	293.2	293.25	152652.0
2026-07-31 09:00:00	IWM	ETF	293.26	293.95	289.97	290.02	3237791.0
2026-07-31 10:00:00	IWM	ETF	290.02	290.69	287.83	290.48	4904908.0
2026-07-31 11:00:00	IWM	ETF	290.5	290.9	289.32	290.5	2679695.0
2026-07-31 12:00:00	IWM	ETF	290.5	291.205	289.72	291.06	2246404.0
2026-07-31 13:00:00	IWM	ETF	291.05	291.88	290.8	291.57	2554857.0
2026-07-31 14:00:00	IWM	ETF	291.575	291.81	291.28	291.53	1709929.0
2026-07-31 15:00:00	IWM	ETF	291.53	291.87	290.93	291.19	3768124.0
2026-07-31 16:00:00	IWM	ETF	291.21	291.38	289.99	290.03	1341762.0
2026-07-31 17:00:00	IWM	ETF	290.09	290.56	289.14	289.54	65392.0
2026-07-31 18:00:00	IWM	ETF	289.54	289.81	288.5	289.62	26894.0
2026-07-31 19:00:00	IWM	ETF	289.63	289.93	289.36	289.8199	4604.0
2026-07-31 04:00:00	DIA	ETF	524.19	524.88	523.57	524.6	8754.0
2026-07-31 05:00:00	DIA	ETF	524.6	524.6	524.19	524.35	2134.0

> showing 50 of 29,069 rows — these rows as CSV

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