PREVIEW / etf_1hour / 2026-07-29

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-07-29.parquet
  size:    730 KB
  rows:    29,404

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-29 04:00:00	SPY	ETF	743.26	743.48	738.2	742.2614	78200.0
2026-07-29 05:00:00	SPY	ETF	742.38	743.44	742.05	742.91	31158.0
2026-07-29 06:00:00	SPY	ETF	742.75	743.06	741.9	741.92	62032.0
2026-07-29 07:00:00	SPY	ETF	742.04	742.7276	742.0	742.25	158318.0
2026-07-29 08:00:00	SPY	ETF	742.36	742.42	739.9	740.65	262051.0
2026-07-29 09:00:00	SPY	ETF	740.67	740.81	736.61	737.36	3634457.0
2026-07-29 10:00:00	SPY	ETF	737.43	738.33	733.79	734.82	5575859.0
2026-07-29 11:00:00	SPY	ETF	734.82	735.66	733.02	733.73	2991541.0
2026-07-29 12:00:00	SPY	ETF	733.76	734.87	731.73	734.87	3582141.0
2026-07-29 13:00:00	SPY	ETF	734.88	737.24	734.74	736.4074	3416044.0
2026-07-29 14:00:00	SPY	ETF	736.37	742.68	735.95	741.95	7636794.0
2026-07-29 15:00:00	SPY	ETF	741.945	742.59	729.1	729.51	18435181.0
2026-07-29 16:00:00	SPY	ETF	729.53	730.2	725.98	728.11	4264597.0
2026-07-29 17:00:00	SPY	ETF	728.11	737.2756	726.68	727.89	742036.0
2026-07-29 18:00:00	SPY	ETF	727.94	732.06	727.75	731.257	271687.0
2026-07-29 19:00:00	SPY	ETF	731.6	733.0	731.52	732.4	93951.0
2026-07-29 04:00:00	QQQ	ETF	676.2	676.53	668.95	675.1	384751.0
2026-07-29 05:00:00	QQQ	ETF	675.43	678.98	675.05	678.03	265954.0
2026-07-29 06:00:00	QQQ	ETF	678.03	678.46	675.92	676.15	148727.0
2026-07-29 07:00:00	QQQ	ETF	676.38	678.09	676.01	677.61	163901.0
2026-07-29 08:00:00	QQQ	ETF	677.6	677.7	673.8124	675.33	398604.0
2026-07-29 09:00:00	QQQ	ETF	675.32	677.46	669.56	671.1899	4259175.0
2026-07-29 10:00:00	QQQ	ETF	671.19	673.4	665.76	668.0	5263286.0
2026-07-29 11:00:00	QQQ	ETF	667.99	669.3	664.64	665.93	2955346.0
2026-07-29 12:00:00	QQQ	ETF	665.93	668.0	663.28	667.96	3829025.0
2026-07-29 13:00:00	QQQ	ETF	667.98	671.51	667.82	670.8	3541737.0
2026-07-29 14:00:00	QQQ	ETF	670.43	679.95	670.43	679.05	7542708.0
2026-07-29 15:00:00	QQQ	ETF	679.0648	680.05	661.14	661.53	10557083.0
2026-07-29 16:00:00	QQQ	ETF	661.59	662.48	658.42	659.91	2296452.0
2026-07-29 17:00:00	QQQ	ETF	659.91	674.1867	656.3	658.15	574433.0
2026-07-29 18:00:00	QQQ	ETF	658.15	665.11	658.15	664.2408	753650.0
2026-07-29 19:00:00	QQQ	ETF	664.36	666.929	664.27	666.07	229329.0
2026-07-29 04:00:00	IWM	ETF	293.16	294.27	292.05	294.15	28550.0
2026-07-29 05:00:00	IWM	ETF	294.19	294.58	293.89	294.33	5651.0
2026-07-29 06:00:00	IWM	ETF	294.26	294.35	293.72	293.73	8357.0
2026-07-29 07:00:00	IWM	ETF	293.79	294.1401	293.7	294.05	22308.0
2026-07-29 08:00:00	IWM	ETF	294.1	294.11	292.5	292.89	129799.0
2026-07-29 09:00:00	IWM	ETF	292.94	293.51	291.5	291.81	2513050.0
2026-07-29 10:00:00	IWM	ETF	291.83	292.7	289.14	289.85	4226242.0
2026-07-29 11:00:00	IWM	ETF	289.87	290.34	288.97	289.38	1826886.0
2026-07-29 12:00:00	IWM	ETF	289.4	289.56	288.42	289.28	1334122.0
2026-07-29 13:00:00	IWM	ETF	289.3	290.3	289.27	290.22	1709968.0
2026-07-29 14:00:00	IWM	ETF	290.18	293.55	289.89	293.19	6793217.0
2026-07-29 15:00:00	IWM	ETF	293.21	293.665	288.26	288.59	7746675.0
2026-07-29 16:00:00	IWM	ETF	288.6	288.73	287.4	287.5	1353829.0
2026-07-29 17:00:00	IWM	ETF	287.47	292.0857	287.26	287.8	75950.0
2026-07-29 18:00:00	IWM	ETF	287.83	288.59	287.77	288.4	56067.0
2026-07-29 19:00:00	IWM	ETF	288.57	289.11	288.51	289.01	25566.0
2026-07-29 04:00:00	DIA	ETF	527.01	527.46	525.61	527.3	7769.0
2026-07-29 05:00:00	DIA	ETF	527.04	527.04	526.0	526.45	8886.0

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

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