PREVIEW / etf_1hour / 2026-04-22

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-04-22.parquet
  size:    702 KB
  rows:    28,000

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-22 04:00:00	SPY	ETF	708.48	708.8	707.1	708.01	100617.0
2026-04-22 05:00:00	SPY	ETF	707.88	708.74	707.59	707.99	47953.0
2026-04-22 06:00:00	SPY	ETF	708.01	708.46	707.48	708.03	47128.0
2026-04-22 07:00:00	SPY	ETF	708.02	708.44	707.71	708.35	188345.0
2026-04-22 08:00:00	SPY	ETF	708.35	709.74	707.94	707.99	585018.0
2026-04-22 09:00:00	SPY	ETF	708.0	709.49	707.88	709.39	3521728.0
2026-04-22 10:00:00	SPY	ETF	709.39	710.7	708.76	710.04	4773692.0
2026-04-22 11:00:00	SPY	ETF	710.05	710.53	709.16	709.64	2993940.0
2026-04-22 12:00:00	SPY	ETF	709.65	710.12	708.8	708.89	2838603.0
2026-04-22 13:00:00	SPY	ETF	708.91	710.42	708.89	709.99	2592961.0
2026-04-22 14:00:00	SPY	ETF	709.97	710.22	709.2	709.65	3787318.0
2026-04-22 15:00:00	SPY	ETF	709.66	711.45	709.19	711.21	8043898.0
2026-04-22 16:00:00	SPY	ETF	711.22	711.39	704.0421	710.56	3403676.0
2026-04-22 17:00:00	SPY	ETF	710.57	710.9	710.25	710.3	81021.0
2026-04-22 18:00:00	SPY	ETF	710.38	710.5	710.0	710.24	85166.0
2026-04-22 19:00:00	SPY	ETF	710.1686	710.48	710.11	710.43	21215.0
2026-04-22 04:00:00	QQQ	ETF	648.8	649.76	647.51	648.74	285012.0
2026-04-22 05:00:00	QQQ	ETF	648.62	649.67	648.41	648.86	109357.0
2026-04-22 06:00:00	QQQ	ETF	648.91	649.39	648.375	648.9	74056.0
2026-04-22 07:00:00	QQQ	ETF	648.82	649.14	648.36	649.05	101556.0
2026-04-22 08:00:00	QQQ	ETF	649.05	650.6136	648.7	648.73	491836.0
2026-04-22 09:00:00	QQQ	ETF	648.76	650.46	648.52	649.7501	3055215.0
2026-04-22 10:00:00	QQQ	ETF	649.75	653.18	649.47	652.35	6368164.0
2026-04-22 11:00:00	QQQ	ETF	652.34	653.23	651.61	652.55	2557702.0
2026-04-22 12:00:00	QQQ	ETF	652.56	653.12	652.03	652.25	1741290.0
2026-04-22 13:00:00	QQQ	ETF	652.23	654.25	652.23	653.78	2694817.0
2026-04-22 14:00:00	QQQ	ETF	653.79	654.05	652.8896	653.3991	2018848.0
2026-04-22 15:00:00	QQQ	ETF	653.4	655.33	652.53	655.08	6126663.0
2026-04-22 16:00:00	QQQ	ETF	655.06	656.34	654.8	655.7	2340198.0
2026-04-22 17:00:00	QQQ	ETF	655.72	655.99	654.8	654.9	122021.0
2026-04-22 18:00:00	QQQ	ETF	654.82	655.47	654.73	655.24	225167.0
2026-04-22 19:00:00	QQQ	ETF	655.25	655.55	655.1	655.45	81805.0
2026-04-22 04:00:00	IWM	ETF	277.0	277.57	276.11	276.6	84857.0
2026-04-22 05:00:00	IWM	ETF	276.71	277.11	276.49	276.76	36119.0
2026-04-22 06:00:00	IWM	ETF	276.71	277.16	276.46	276.94	32955.0
2026-04-22 07:00:00	IWM	ETF	276.96	277.06	276.7	277.0	93305.0
2026-04-22 08:00:00	IWM	ETF	277.05	277.55	276.5	276.53	179269.0
2026-04-22 09:00:00	IWM	ETF	276.58	278.01	276.43	277.44	3081585.0
2026-04-22 10:00:00	IWM	ETF	277.41	277.4301	276.035	276.61	2152314.0
2026-04-22 11:00:00	IWM	ETF	276.62	276.69	275.38	275.9	1824736.0
2026-04-22 12:00:00	IWM	ETF	275.9	276.22	274.94	275.03	1487349.0
2026-04-22 13:00:00	IWM	ETF	275.04	276.03	274.9	275.66	1627673.0
2026-04-22 14:00:00	IWM	ETF	275.66	275.86	275.29	275.68	994619.0
2026-04-22 15:00:00	IWM	ETF	275.675	276.56	275.33	276.48	2108467.0
2026-04-22 16:00:00	IWM	ETF	276.48	276.5	275.63	276.12	970518.0
2026-04-22 17:00:00	IWM	ETF	276.1462	276.16	275.62	276.02	31919.0
2026-04-22 18:00:00	IWM	ETF	276.07	276.26	275.8	275.88	18086.0
2026-04-22 19:00:00	IWM	ETF	275.88	276.02	275.85	275.98	14352.0
2026-04-22 04:00:00	DIA	ETF	493.39	494.34	493.39	493.51	2961.0
2026-04-22 05:00:00	DIA	ETF	494.06	494.2	493.5	493.52	4839.0

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

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