PREVIEW / etf_1hour / 2026-07-30

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-07-30.parquet
  size:    733 KB
  rows:    29,280

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-30 04:00:00	SPY	ETF	730.72	732.7952	729.88	731.88	136022.0
2026-07-30 05:00:00	SPY	ETF	731.86	733.38	731.8	732.03	54934.0
2026-07-30 06:00:00	SPY	ETF	732.0	733.8	731.82	733.11	77506.0
2026-07-30 07:00:00	SPY	ETF	733.07	734.71	733.07	734.54	349569.0
2026-07-30 08:00:00	SPY	ETF	734.52	735.13	733.93	734.38	458858.0
2026-07-30 09:00:00	SPY	ETF	734.41	738.66	734.35	738.625	7105462.0
2026-07-30 10:00:00	SPY	ETF	738.62	739.3	735.6099	736.23	7196834.0
2026-07-30 11:00:00	SPY	ETF	736.23	737.67	734.59	737.13	5011097.0
2026-07-30 12:00:00	SPY	ETF	737.15	739.22	736.87	738.985	3326841.0
2026-07-30 13:00:00	SPY	ETF	738.98	740.38	738.9799	739.78	3090119.0
2026-07-30 14:00:00	SPY	ETF	739.785	740.83	739.705	740.77	3465305.0
2026-07-30 15:00:00	SPY	ETF	740.75	742.45	740.74	741.71	11835910.0
2026-07-30 16:00:00	SPY	ETF	741.71	744.2	741.33	742.04	2921114.0
2026-07-30 17:00:00	SPY	ETF	742.0	742.4	741.44	742.1878	256542.0
2026-07-30 18:00:00	SPY	ETF	742.04	743.02	741.31	742.98	92135.0
2026-07-30 19:00:00	SPY	ETF	743.0	743.69	742.59	743.33	41224.0
2026-07-30 04:00:00	QQQ	ETF	664.95	666.66	661.78	665.27	323956.0
2026-07-30 05:00:00	QQQ	ETF	665.37	667.72	665.02	666.07	129949.0
2026-07-30 06:00:00	QQQ	ETF	665.9	669.25	665.46	668.5599	202838.0
2026-07-30 07:00:00	QQQ	ETF	668.48	671.6	668.42	671.15	608151.0
2026-07-30 08:00:00	QQQ	ETF	671.11	673.4	670.37	673.08	629244.0
2026-07-30 09:00:00	QQQ	ETF	673.18	681.65	672.76	681.515	7331255.0
2026-07-30 10:00:00	QQQ	ETF	681.49	683.73	678.36	679.53	6529050.0
2026-07-30 11:00:00	QQQ	ETF	679.56	681.16	677.75	679.79	4721068.0
2026-07-30 12:00:00	QQQ	ETF	679.77	682.55	679.25	680.96	4099057.0
2026-07-30 13:00:00	QQQ	ETF	680.97	682.92	680.95	682.17	3000405.0
2026-07-30 14:00:00	QQQ	ETF	682.22	682.85	681.51	682.31	2338644.0
2026-07-30 15:00:00	QQQ	ETF	682.31	685.12	682.29	683.6	8987483.0
2026-07-30 16:00:00	QQQ	ETF	683.6	687.69	683.0	685.93	2526407.0
2026-07-30 17:00:00	QQQ	ETF	685.92	687.26	683.69	686.2721	513584.0
2026-07-30 18:00:00	QQQ	ETF	686.01	687.89	685.37	687.61	293900.0
2026-07-30 19:00:00	QQQ	ETF	687.57	688.74	686.76	688.28	121572.0
2026-07-30 04:00:00	IWM	ETF	288.67	289.74	288.23	289.3	61067.0
2026-07-30 05:00:00	IWM	ETF	289.23	289.93	289.11	289.11	19842.0
2026-07-30 06:00:00	IWM	ETF	289.12	290.17	289.11	289.97	25881.0
2026-07-30 07:00:00	IWM	ETF	289.8611	290.51	289.81	290.47	99810.0
2026-07-30 08:00:00	IWM	ETF	290.5	290.96	290.12	290.43	193783.0
2026-07-30 09:00:00	IWM	ETF	290.5	291.71	289.79	291.19	2600842.0
2026-07-30 10:00:00	IWM	ETF	291.16	291.315	289.14	289.52	3824234.0
2026-07-30 11:00:00	IWM	ETF	289.53	290.85	288.96	290.63	2116400.0
2026-07-30 12:00:00	IWM	ETF	290.65	291.32	290.46	291.21	2004580.0
2026-07-30 13:00:00	IWM	ETF	291.19	291.59	290.89	291.36	1142899.0
2026-07-30 14:00:00	IWM	ETF	291.38	291.8128	291.21	291.78	1152184.0
2026-07-30 15:00:00	IWM	ETF	291.78	292.84	291.775	292.54	3848585.0
2026-07-30 16:00:00	IWM	ETF	292.53	292.99	292.35	292.67	956825.0
2026-07-30 17:00:00	IWM	ETF	292.82	292.89	292.51	292.7	18548.0
2026-07-30 18:00:00	IWM	ETF	292.59	293.19	292.48	293.19	14085.0
2026-07-30 19:00:00	IWM	ETF	293.2	293.31	293.02	293.22	8444.0
2026-07-30 04:00:00	DIA	ETF	516.19	516.83	515.3	516.35	6061.0
2026-07-30 05:00:00	DIA	ETF	517.15	517.32	516.96	516.96	22673.0

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

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