PREVIEW / etf_1hour / 2025-04-23

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-04-23.parquet
  size:    642 KB
  rows:    25,374

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
2025-04-23 04:00:00	SPY	ETF	536.79	538.74	536.5	537.95	97538.0
2025-04-23 05:00:00	SPY	ETF	538.0	538.49	537.26	538.01	121224.0
2025-04-23 06:00:00	SPY	ETF	538.0	540.48	538.0	540.17	183627.0
2025-04-23 07:00:00	SPY	ETF	540.12	540.7	538.56	538.57	399690.0
2025-04-23 08:00:00	SPY	ETF	540.17	541.0	534.37	540.99	580134.0
2025-04-23 09:00:00	SPY	ETF	540.95	544.99	539.07	543.56	13964494.0
2025-04-23 10:00:00	SPY	ETF	543.595	545.43	540.75	542.555	8358668.0
2025-04-23 11:00:00	SPY	ETF	542.54	543.77	535.57	537.43	9519901.0
2025-04-23 12:00:00	SPY	ETF	537.42	538.6444	534.0	538.22	6311491.0
2025-04-23 13:00:00	SPY	ETF	538.2	539.59	536.19	538.36	4381698.0
2025-04-23 14:00:00	SPY	ETF	538.34	538.89	535.8	536.36	4955543.0
2025-04-23 15:00:00	SPY	ETF	536.36	537.17	533.88	535.41	12560214.0
2025-04-23 16:00:00	SPY	ETF	535.38	538.83	535.2	536.9	4759489.0
2025-04-23 17:00:00	SPY	ETF	536.93	537.85	535.5	535.94	340739.0
2025-04-23 18:00:00	SPY	ETF	536.31	536.68	534.46	536.1104	138813.0
2025-04-23 19:00:00	SPY	ETF	536.0	537.05	535.92	536.7	66131.0
2025-04-23 04:00:00	QQQ	ETF	453.21	455.89	453.0	455.22	237726.0
2025-04-23 05:00:00	QQQ	ETF	455.43	455.76	454.96	455.67	76074.0
2025-04-23 06:00:00	QQQ	ETF	455.69	457.7	455.58	457.49	308810.0
2025-04-23 07:00:00	QQQ	ETF	457.42	458.07	456.09	456.09	461521.0
2025-04-23 08:00:00	QQQ	ETF	457.51	458.75	451.85	458.6	728118.0
2025-04-23 09:00:00	QQQ	ETF	458.7	462.35	456.81	460.95	8406044.0
2025-04-23 10:00:00	QQQ	ETF	460.97	463.38	458.77	460.852	5999437.0
2025-04-23 11:00:00	QQQ	ETF	460.91	461.83	454.5	456.4	6113174.0
2025-04-23 12:00:00	QQQ	ETF	456.42	457.8198	453.31	457.47	4404354.0
2025-04-23 13:00:00	QQQ	ETF	457.38	458.58	455.45	457.66	2626327.0
2025-04-23 14:00:00	QQQ	ETF	457.66	458.4095	455.68	456.21	2712540.0
2025-04-23 15:00:00	QQQ	ETF	456.24	456.83	452.88	454.37	5460137.0
2025-04-23 16:00:00	QQQ	ETF	454.33	457.64	454.04	455.83	2289213.0
2025-04-23 17:00:00	QQQ	ETF	455.88	456.26	454.55	455.29	127368.0
2025-04-23 18:00:00	QQQ	ETF	455.4	455.41	453.2	455.13	218185.0
2025-04-23 19:00:00	QQQ	ETF	455.0	455.95	454.76	455.63	88560.0
2025-04-23 04:00:00	IWM	ETF	191.13	191.85	191.08	191.57	27498.0
2025-04-23 05:00:00	IWM	ETF	191.71	191.75	191.33	191.54	23793.0
2025-04-23 06:00:00	IWM	ETF	191.54	192.32	191.47	192.32	99637.0
2025-04-23 07:00:00	IWM	ETF	192.27	192.65	191.85	191.95	364726.0
2025-04-23 08:00:00	IWM	ETF	192.31	192.9488	190.69	192.9488	258164.0
2025-04-23 09:00:00	IWM	ETF	192.95	195.51	192.38	194.77	8304389.0
2025-04-23 10:00:00	IWM	ETF	194.79	195.39	193.17	193.39	3870486.0
2025-04-23 11:00:00	IWM	ETF	193.42	193.9	191.05	191.48	4592763.0
2025-04-23 12:00:00	IWM	ETF	191.49	191.54	190.41	191.48	2656408.0
2025-04-23 13:00:00	IWM	ETF	191.45	192.03	190.62	191.6	2063451.0
2025-04-23 14:00:00	IWM	ETF	191.57	191.76	190.19	190.68	2868504.0
2025-04-23 15:00:00	IWM	ETF	190.66	190.94	189.84	190.18	5003618.0
2025-04-23 16:00:00	IWM	ETF	190.25	191.51	190.0	190.88	2363752.0
2025-04-23 17:00:00	IWM	ETF	191.04	191.04	190.45	190.45	12153.0
2025-04-23 18:00:00	IWM	ETF	190.45	190.45	189.78	190.4	15051.0
2025-04-23 19:00:00	IWM	ETF	190.57	190.75	190.26	190.58	14824.0
2025-04-23 04:00:00	DIA	ETF	397.71	398.68	397.71	398.39	2500.0
2025-04-23 05:00:00	DIA	ETF	398.41	398.73	397.88	398.06	5227.0

> showing 50 of 25,374 rows — these rows as CSV

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