PREVIEW / etf_1hour / 2025-02-25

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-02-25.parquet
  size:    636 KB
  rows:    24,850

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-02-25 04:00:00	SPY	ETF	595.95	597.04	595.4	595.4	43725.0
2025-02-25 05:00:00	SPY	ETF	595.19	596.07	595.02	595.12	13568.0
2025-02-25 06:00:00	SPY	ETF	595.34	597.01	595.0	596.73	42945.0
2025-02-25 07:00:00	SPY	ETF	596.79	597.88	596.6	597.79	114196.0
2025-02-25 08:00:00	SPY	ETF	596.75	598.22	595.41	597.4	294297.0
2025-02-25 09:00:00	SPY	ETF	597.4	597.89	594.25	595.23	3851863.0
2025-02-25 10:00:00	SPY	ETF	595.25	595.28	590.5033	592.33	9058046.0
2025-02-25 11:00:00	SPY	ETF	592.34	593.8084	589.56	593.2	4677261.0
2025-02-25 12:00:00	SPY	ETF	593.13	594.8	592.12	594.79	3007857.0
2025-02-25 13:00:00	SPY	ETF	594.78	596.18	593.61	594.71	3246035.0
2025-02-25 14:00:00	SPY	ETF	594.65	595.58	593.01	595.24	3589690.0
2025-02-25 15:00:00	SPY	ETF	595.23	596.64	593.57	594.21	7054109.0
2025-02-25 16:00:00	SPY	ETF	594.19	595.38	594.08	595.03	3003245.0
2025-02-25 17:00:00	SPY	ETF	594.93	595.31	594.87	595.26	146786.0
2025-02-25 18:00:00	SPY	ETF	595.39	595.89	595.3	595.63	100862.0
2025-02-25 19:00:00	SPY	ETF	595.63	595.97	595.41	595.97	30781.0
2025-02-25 20:00:00	SPY	ETF	595.99	596.0	595.99	596.0	300.0
2025-02-25 04:00:00	QQQ	ETF	518.2	518.98	517.13	517.13	104423.0
2025-02-25 05:00:00	QQQ	ETF	517.43	518.05	516.72	516.86	92511.0
2025-02-25 06:00:00	QQQ	ETF	517.04	519.05	516.75	518.65	113988.0
2025-02-25 07:00:00	QQQ	ETF	518.67	520.3	518.53	520.18	177070.0
2025-02-25 08:00:00	QQQ	ETF	518.62	520.66	517.0096	519.41	459979.0
2025-02-25 09:00:00	QQQ	ETF	519.49	519.7	514.8	516.0	3929571.0
2025-02-25 10:00:00	QQQ	ETF	516.0	516.04	510.39	512.21	7099196.0
2025-02-25 11:00:00	QQQ	ETF	512.25	514.58	509.44	513.82	4854496.0
2025-02-25 12:00:00	QQQ	ETF	513.775	515.16	512.35	515.02	2613669.0
2025-02-25 13:00:00	QQQ	ETF	515.03	516.5	513.7	514.51	2728453.0
2025-02-25 14:00:00	QQQ	ETF	514.49	514.88	512.67	514.56	3265792.0
2025-02-25 15:00:00	QQQ	ETF	514.56	516.04	512.6	513.29	5020203.0
2025-02-25 16:00:00	QQQ	ETF	513.3	514.69	513.07	514.37	1913530.0
2025-02-25 17:00:00	QQQ	ETF	514.41	515.24	514.24	515.24	125415.0
2025-02-25 18:00:00	QQQ	ETF	515.13	515.43	514.81	515.08	146466.0
2025-02-25 19:00:00	QQQ	ETF	515.12	515.69	514.78	515.68	138468.0
2025-02-25 04:00:00	IWM	ETF	216.0	216.63	215.56	215.59	8659.0
2025-02-25 05:00:00	IWM	ETF	215.5	215.89	215.41	215.41	14231.0
2025-02-25 06:00:00	IWM	ETF	215.43	215.98	215.39	215.97	45497.0
2025-02-25 07:00:00	IWM	ETF	215.95	216.68	215.91	216.63	105271.0
2025-02-25 08:00:00	IWM	ETF	215.97	216.94	215.75	216.4	128669.0
2025-02-25 09:00:00	IWM	ETF	216.43	217.27	215.7404	216.12	2542695.0
2025-02-25 10:00:00	IWM	ETF	216.12	216.12	213.8	215.12	5766197.0
2025-02-25 11:00:00	IWM	ETF	215.13	215.2	213.49	214.7	3036093.0
2025-02-25 12:00:00	IWM	ETF	214.67	215.55	213.9	215.55	2029570.0
2025-02-25 13:00:00	IWM	ETF	215.56	216.25	214.83	215.32	1887291.0
2025-02-25 14:00:00	IWM	ETF	215.32	216.21	214.7	215.91	1961309.0
2025-02-25 15:00:00	IWM	ETF	215.895	216.83	215.285	215.43	4213547.0
2025-02-25 16:00:00	IWM	ETF	215.41	215.99	215.34	215.88	1800206.0
2025-02-25 17:00:00	IWM	ETF	215.84	215.95	215.68	215.91	29603.0
2025-02-25 18:00:00	IWM	ETF	215.95	216.2	215.92	216.0	18247.0
2025-02-25 19:00:00	IWM	ETF	216.12	216.15	215.98	216.069	35207.0
2025-02-25 04:00:00	DIA	ETF	434.35	434.52	433.91	433.91	1356.0

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

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