PREVIEW / etf_1hour / 2026-04-17

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-04-17.parquet
  size:    728 KB
  rows:    29,055

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-04-17 04:00:00	SPY	ETF	702.72	703.22	701.7	703.22	49284.0
2026-04-17 05:00:00	SPY	ETF	703.21	703.52	702.91	703.44	46951.0
2026-04-17 06:00:00	SPY	ETF	703.39	703.64	702.98	703.34	28534.0
2026-04-17 07:00:00	SPY	ETF	703.26	704.3	703.22	704.19	196160.0
2026-04-17 08:00:00	SPY	ETF	704.22	707.703	704.08	707.61	1095400.0
2026-04-17 09:00:00	SPY	ETF	707.7	708.78	705.76	708.33	7394780.0
2026-04-17 10:00:00	SPY	ETF	708.35	711.335	708.15	710.48	8693530.0
2026-04-17 11:00:00	SPY	ETF	710.48	711.35	709.86	710.74	5850641.0
2026-04-17 12:00:00	SPY	ETF	710.74	712.39	710.54	711.91	3711565.0
2026-04-17 13:00:00	SPY	ETF	711.91	712.17	709.03	710.295	5529638.0
2026-04-17 14:00:00	SPY	ETF	710.31	710.48	709.13	709.64	4513868.0
2026-04-17 15:00:00	SPY	ETF	709.64	710.4	708.99	710.04	8619211.0
2026-04-17 16:00:00	SPY	ETF	710.04	710.49	709.82	710.29	3778542.0
2026-04-17 17:00:00	SPY	ETF	710.3	710.97	710.26	710.9	330791.0
2026-04-17 18:00:00	SPY	ETF	710.91	711.03	710.69	710.75	66628.0
2026-04-17 19:00:00	SPY	ETF	710.74	710.93	710.71	710.75	64226.0
2026-04-17 04:00:00	QQQ	ETF	640.1	641.4	639.55	641.38	131166.0
2026-04-17 05:00:00	QQQ	ETF	641.34	641.88	641.11	641.8	78313.0
2026-04-17 06:00:00	QQQ	ETF	641.8	642.03	641.06	641.65	64538.0
2026-04-17 07:00:00	QQQ	ETF	641.59	642.61	641.48	642.535	207488.0
2026-04-17 08:00:00	QQQ	ETF	642.54	646.83	639.99	646.8	1263633.0
2026-04-17 09:00:00	QQQ	ETF	646.75	648.5	644.07	646.45	7206232.0
2026-04-17 10:00:00	QQQ	ETF	646.46	649.41	646.15	648.76	6572763.0
2026-04-17 11:00:00	QQQ	ETF	648.78	649.9	648.03	648.15	4769826.0
2026-04-17 12:00:00	QQQ	ETF	648.15	650.0	647.86	649.451	3285361.0
2026-04-17 13:00:00	QQQ	ETF	649.46	649.87	646.48	648.21	4037648.0
2026-04-17 14:00:00	QQQ	ETF	648.21	648.53	646.94	647.65	3017650.0
2026-04-17 15:00:00	QQQ	ETF	647.65	648.85	647.01	648.73	5601361.0
2026-04-17 16:00:00	QQQ	ETF	648.71	649.12	648.411	649.06	2111474.0
2026-04-17 17:00:00	QQQ	ETF	649.0	649.21	648.86	649.07	88195.0
2026-04-17 18:00:00	QQQ	ETF	649.09	649.2	648.71	648.742	45369.0
2026-04-17 19:00:00	QQQ	ETF	648.75	649.24	648.61	648.97	42256.0
2026-04-17 04:00:00	IWM	ETF	270.76	271.14	270.22	271.13	89982.0
2026-04-17 05:00:00	IWM	ETF	271.15	271.38	271.0	271.38	22625.0
2026-04-17 06:00:00	IWM	ETF	271.26	271.36	271.1	271.23	32023.0
2026-04-17 07:00:00	IWM	ETF	271.19	271.6	271.09	271.6	103495.0
2026-04-17 08:00:00	IWM	ETF	271.466	274.2	271.17	274.13	1127120.0
2026-04-17 09:00:00	IWM	ETF	274.132	274.91	273.115	274.18	5646151.0
2026-04-17 10:00:00	IWM	ETF	274.19	277.26	274.0	276.15	5695405.0
2026-04-17 11:00:00	IWM	ETF	276.13	276.58	275.38	276.45	2726940.0
2026-04-17 12:00:00	IWM	ETF	276.47	277.63	276.28	277.27	2351431.0
2026-04-17 13:00:00	IWM	ETF	277.265	277.42	275.69	275.995	3574839.0
2026-04-17 14:00:00	IWM	ETF	276.0	276.06	275.255	275.525	1897880.0
2026-04-17 15:00:00	IWM	ETF	275.53	276.03	274.96	275.75	4395660.0
2026-04-17 16:00:00	IWM	ETF	275.76	276.02	275.5	275.7	2447633.0
2026-04-17 17:00:00	IWM	ETF	275.61	276.07	275.5	276.01	40299.0
2026-04-17 18:00:00	IWM	ETF	276.01	276.13	275.87	275.87	15605.0
2026-04-17 19:00:00	IWM	ETF	275.9	276.0	275.85	275.99	19818.0
2026-04-17 04:00:00	DIA	ETF	486.38	487.18	486.34	487.18	3211.0
2026-04-17 05:00:00	DIA	ETF	487.35	487.41	487.29	487.4	2490.0

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

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