PREVIEW / etf_1hour / 2025-04-17

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-04-17.parquet
  size:    630 KB
  rows:    24,255

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-17 04:00:00	SPY	ETF	531.5	531.5	529.86	530.04	43249.0
2025-04-17 05:00:00	SPY	ETF	529.8	531.16	529.59	530.38	31799.0
2025-04-17 06:00:00	SPY	ETF	530.26	530.32	527.68	528.33	199406.0
2025-04-17 07:00:00	SPY	ETF	528.4	528.79	527.19	528.25	159511.0
2025-04-17 08:00:00	SPY	ETF	528.36	532.31	527.2104	528.83	719680.0
2025-04-17 09:00:00	SPY	ETF	528.7	529.31	526.36	528.74	4914079.0
2025-04-17 10:00:00	SPY	ETF	528.68	529.15	523.91	525.08	5424112.0
2025-04-17 11:00:00	SPY	ETF	525.09	528.85	525.025	526.76	3927631.0
2025-04-17 12:00:00	SPY	ETF	526.76	530.41	526.22	529.9105	7410954.0
2025-04-17 13:00:00	SPY	ETF	529.92	530.3386	527.61	529.57	2713328.0
2025-04-17 14:00:00	SPY	ETF	529.5796	531.165	528.52	528.52	4699959.0
2025-04-17 15:00:00	SPY	ETF	528.54	528.8	525.71	526.39	9351607.0
2025-04-17 16:00:00	SPY	ETF	526.37	528.37	526.18	527.79	4893495.0
2025-04-17 17:00:00	SPY	ETF	527.9	528.0	526.65	526.7	139095.0
2025-04-17 18:00:00	SPY	ETF	526.6701	526.7913	526.41	526.68	447326.0
2025-04-17 19:00:00	SPY	ETF	526.68	527.21	526.68	527.1	41443.0
2025-04-17 04:00:00	QQQ	ETF	450.08	450.08	448.05	448.05	41771.0
2025-04-17 05:00:00	QQQ	ETF	448.15	449.39	447.83	449.11	35688.0
2025-04-17 06:00:00	QQQ	ETF	449.1	449.15	447.18	447.47	62812.0
2025-04-17 07:00:00	QQQ	ETF	447.39	447.9	446.18	447.5	140199.0
2025-04-17 08:00:00	QQQ	ETF	447.38	450.61	446.2393	447.95	535100.0
2025-04-17 09:00:00	QQQ	ETF	447.77	448.25	444.18	446.355	3419872.0
2025-04-17 10:00:00	QQQ	ETF	446.34	446.8566	441.36	442.36	4586746.0
2025-04-17 11:00:00	QQQ	ETF	442.37	445.75	442.09	443.3	3403463.0
2025-04-17 12:00:00	QQQ	ETF	443.28	446.6264	442.72	446.07	3748570.0
2025-04-17 13:00:00	QQQ	ETF	446.01	446.7979	443.95	446.0	2463184.0
2025-04-17 14:00:00	QQQ	ETF	446.0	447.75	445.15	445.16	3423182.0
2025-04-17 15:00:00	QQQ	ETF	445.17	445.4391	443.0	444.06	4989150.0
2025-04-17 16:00:00	QQQ	ETF	444.08	445.91	443.86	445.3	2232420.0
2025-04-17 17:00:00	QQQ	ETF	445.023	445.3	444.8	444.97	107817.0
2025-04-17 18:00:00	QQQ	ETF	445.01	445.13	444.7	444.88	24296.0
2025-04-17 19:00:00	QQQ	ETF	444.9635	445.7	444.89	445.64	28286.0
2025-04-17 04:00:00	IWM	ETF	186.08	186.81	186.05	186.15	20384.0
2025-04-17 05:00:00	IWM	ETF	186.02	186.44	186.0	186.44	14201.0
2025-04-17 06:00:00	IWM	ETF	186.35	186.48	185.77	185.9	47913.0
2025-04-17 07:00:00	IWM	ETF	185.94	186.03	185.15	185.5	42640.0
2025-04-17 08:00:00	IWM	ETF	185.72	187.2	185.17	185.7	175546.0
2025-04-17 09:00:00	IWM	ETF	185.64	186.8	184.91	186.29	3236065.0
2025-04-17 10:00:00	IWM	ETF	186.28	186.54	184.47	184.49	4254796.0
2025-04-17 11:00:00	IWM	ETF	184.47	185.96	184.46	185.34	2889200.0
2025-04-17 12:00:00	IWM	ETF	185.34	186.96	185.17	186.68	4151327.0
2025-04-17 13:00:00	IWM	ETF	186.68	187.18	185.87	186.85	2138065.0
2025-04-17 14:00:00	IWM	ETF	186.87	187.43	186.45	186.5	2465475.0
2025-04-17 15:00:00	IWM	ETF	186.495	187.02	185.95	186.57	5274296.0
2025-04-17 16:00:00	IWM	ETF	186.59	187.3	186.48	187.1	1462276.0
2025-04-17 17:00:00	IWM	ETF	186.97	187.22	186.74	186.9	12850.0
2025-04-17 18:00:00	IWM	ETF	186.9	186.9	186.55	186.67	13183.0
2025-04-17 19:00:00	IWM	ETF	186.79	186.99	186.7301	186.97	8094.0
2025-04-17 04:00:00	DIA	ETF	400.05	400.16	400.01	400.05	2100.0
2025-04-17 05:00:00	DIA	ETF	400.0	400.0	397.82	397.82	4880.0

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

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