PREVIEW / etf_1hour / 2025-04-16

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-04-16.parquet
  size:    635 KB
  rows:    24,683

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-16 04:00:00	SPY	ETF	530.0	537.44	529.44	533.86	182003.0
2025-04-16 05:00:00	SPY	ETF	534.0	535.27	533.32	533.32	113726.0
2025-04-16 06:00:00	SPY	ETF	533.53	534.5	533.3	533.68	76518.0
2025-04-16 07:00:00	SPY	ETF	533.71	534.65	532.99	533.67	264024.0
2025-04-16 08:00:00	SPY	ETF	533.5	534.42	529.2	532.49	342345.0
2025-04-16 09:00:00	SPY	ETF	532.5	533.86	529.92	529.92	5642283.0
2025-04-16 10:00:00	SPY	ETF	529.9	532.96	529.65	532.27	4628846.0
2025-04-16 11:00:00	SPY	ETF	532.29	535.11	531.38	531.71	4224715.0
2025-04-16 12:00:00	SPY	ETF	531.73	532.12	530.53	530.89	3192383.0
2025-04-16 13:00:00	SPY	ETF	530.93	531.71	523.94	524.1	8066548.0
2025-04-16 14:00:00	SPY	ETF	524.1	526.8398	522.71	522.84	6992512.0
2025-04-16 15:00:00	SPY	ETF	522.83	526.17	520.29	525.73	16149804.0
2025-04-16 16:00:00	SPY	ETF	525.73	528.773	524.34	525.0	3736914.0
2025-04-16 17:00:00	SPY	ETF	524.95	526.58	524.9	526.0	393184.0
2025-04-16 18:00:00	SPY	ETF	526.0	526.4	525.2	525.9681	385168.0
2025-04-16 19:00:00	SPY	ETF	526.19	526.29	524.63	525.95	107098.0
2025-04-16 04:00:00	QQQ	ETF	447.82	455.44	447.31	452.02	215316.0
2025-04-16 05:00:00	QQQ	ETF	452.24	453.24	451.22	451.22	96931.0
2025-04-16 06:00:00	QQQ	ETF	451.24	452.38	451.06	451.51	74934.0
2025-04-16 07:00:00	QQQ	ETF	451.57	452.3	450.63	451.63	122720.0
2025-04-16 08:00:00	QQQ	ETF	451.25	453.5904	447.19	450.22	288154.0
2025-04-16 09:00:00	QQQ	ETF	450.22	451.28	447.53	447.56	3695712.0
2025-04-16 10:00:00	QQQ	ETF	447.53	451.0199	447.22	450.0337	3496445.0
2025-04-16 11:00:00	QQQ	ETF	450.09	452.62	448.83	449.04	2892189.0
2025-04-16 12:00:00	QQQ	ETF	449.12	449.8	448.16	448.42	2018996.0
2025-04-16 13:00:00	QQQ	ETF	448.435	449.26	441.87	441.95	4463555.0
2025-04-16 14:00:00	QQQ	ETF	441.94	444.28	440.0	440.05	4614254.0
2025-04-16 15:00:00	QQQ	ETF	440.07	444.53	437.76	444.22	9756255.0
2025-04-16 16:00:00	QQQ	ETF	444.24	446.0	441.8427	443.76	2353523.0
2025-04-16 17:00:00	QQQ	ETF	443.77	444.8	443.5	444.4493	175651.0
2025-04-16 18:00:00	QQQ	ETF	444.45	445.1	443.9	444.74	114554.0
2025-04-16 19:00:00	QQQ	ETF	444.77	445.0792	443.34	444.54	115101.0
2025-04-16 04:00:00	IWM	ETF	185.0	187.23	184.3	185.93	78222.0
2025-04-16 05:00:00	IWM	ETF	185.93	186.63	185.86	185.95	24465.0
2025-04-16 06:00:00	IWM	ETF	186.05	186.48	186.05	186.12	16282.0
2025-04-16 07:00:00	IWM	ETF	186.16	186.55	185.99	186.29	127945.0
2025-04-16 08:00:00	IWM	ETF	186.17	186.5	184.61	185.86	380506.0
2025-04-16 09:00:00	IWM	ETF	185.82	186.76	185.09	185.16	3695535.0
2025-04-16 10:00:00	IWM	ETF	185.14	186.1	184.99	185.53	2094037.0
2025-04-16 11:00:00	IWM	ETF	185.54	186.73	185.36	185.8	1638391.0
2025-04-16 12:00:00	IWM	ETF	185.85	186.23	185.34	185.5	1476720.0
2025-04-16 13:00:00	IWM	ETF	185.49	186.01	183.05	183.06	3321541.0
2025-04-16 14:00:00	IWM	ETF	183.06	184.48	183.06	183.142	3210026.0
2025-04-16 15:00:00	IWM	ETF	183.15	185.16	182.56	184.93	5576521.0
2025-04-16 16:00:00	IWM	ETF	184.94	185.37	184.5	184.7	1831613.0
2025-04-16 17:00:00	IWM	ETF	184.7	185.07	184.44	184.8	119533.0
2025-04-16 18:00:00	IWM	ETF	184.8	185.23	184.66	184.98	96695.0
2025-04-16 19:00:00	IWM	ETF	185.09	185.1296	184.55	185.07	54965.0
2025-04-16 04:00:00	DIA	ETF	400.32	405.06	400.14	402.7	14328.0
2025-04-16 05:00:00	DIA	ETF	403.11	403.93	402.99	403.57	9147.0

> showing 50 of 24,683 rows — these rows as CSV

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