PREVIEW / etf_1hour / 2025-02-24

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-02-24.parquet
  size:    641 KB
  rows:    24,933

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-24 04:00:00	SPY	ETF	601.74	603.78	601.74	603.25	90418.0
2025-02-24 05:00:00	SPY	ETF	603.26	603.32	602.91	603.0	41752.0
2025-02-24 06:00:00	SPY	ETF	602.71	603.35	602.71	603.14	87599.0
2025-02-24 07:00:00	SPY	ETF	603.13	603.15	602.4	602.87	253626.0
2025-02-24 08:00:00	SPY	ETF	602.91	603.5996	601.5	603.2091	306667.0
2025-02-24 09:00:00	SPY	ETF	603.2	603.27	598.6313	598.76	4357085.0
2025-02-24 10:00:00	SPY	ETF	598.76	599.445	596.49	597.7	6309254.0
2025-02-24 11:00:00	SPY	ETF	597.72	600.8	597.47	599.97	3536624.0
2025-02-24 12:00:00	SPY	ETF	599.98	601.85	599.8202	600.635	2042393.0
2025-02-24 13:00:00	SPY	ETF	600.644	601.71	600.36	600.64	1205497.0
2025-02-24 14:00:00	SPY	ETF	600.62	601.43	599.39	599.78	2587478.0
2025-02-24 15:00:00	SPY	ETF	599.81	600.03	596.64	597.2	10243695.0
2025-02-24 16:00:00	SPY	ETF	597.2	597.98	596.93	597.63	3910234.0
2025-02-24 17:00:00	SPY	ETF	597.6	597.64	597.4	597.52	40326.0
2025-02-24 18:00:00	SPY	ETF	597.57	597.9	596.64	597.0	99659.0
2025-02-24 19:00:00	SPY	ETF	597.1	598.21	597.09	598.03	75116.0
2025-02-24 04:00:00	QQQ	ETF	528.43	529.35	527.77	528.69	92528.0
2025-02-24 05:00:00	QQQ	ETF	528.67	528.72	528.05	528.16	19267.0
2025-02-24 06:00:00	QQQ	ETF	528.14	528.72	527.82	528.55	43566.0
2025-02-24 07:00:00	QQQ	ETF	528.48	528.5	527.63	528.04	126600.0
2025-02-24 08:00:00	QQQ	ETF	527.92	529.194	526.85	529.0699	297973.0
2025-02-24 09:00:00	QQQ	ETF	529.0601	529.14	523.2	523.34	4297184.0
2025-02-24 10:00:00	QQQ	ETF	523.34	523.79	520.1892	521.55	6150852.0
2025-02-24 11:00:00	QQQ	ETF	521.59	524.775	521.18	523.66	3445877.0
2025-02-24 12:00:00	QQQ	ETF	523.66	525.65	523.48	524.3346	2318429.0
2025-02-24 13:00:00	QQQ	ETF	524.33	525.66	524.08	524.42	1380268.0
2025-02-24 14:00:00	QQQ	ETF	524.38	525.13	522.71	523.04	1704246.0
2025-02-24 15:00:00	QQQ	ETF	523.04	523.43	519.53	519.83	5621841.0
2025-02-24 16:00:00	QQQ	ETF	519.83	522.537	519.54	520.02	1974723.0
2025-02-24 17:00:00	QQQ	ETF	520.09	520.19	519.87	520.1	121460.0
2025-02-24 18:00:00	QQQ	ETF	520.26	520.54	518.6	519.0	186880.0
2025-02-24 19:00:00	QQQ	ETF	519.16	520.5	519.16	520.14	177700.0
2025-02-24 04:00:00	IWM	ETF	218.69	219.22	218.37	219.1	50311.0
2025-02-24 05:00:00	IWM	ETF	219.11	219.51	219.11	219.49	39298.0
2025-02-24 06:00:00	IWM	ETF	219.57	219.74	219.41	219.57	21462.0
2025-02-24 07:00:00	IWM	ETF	219.49	219.5	219.04	219.19	105290.0
2025-02-24 08:00:00	IWM	ETF	219.4513	219.5396	218.44	219.14	163728.0
2025-02-24 09:00:00	IWM	ETF	219.14	219.24	216.24	216.24	3464567.0
2025-02-24 10:00:00	IWM	ETF	216.25	216.97	215.15	215.77	4305705.0
2025-02-24 11:00:00	IWM	ETF	215.78	217.8225	215.66	217.12	2655726.0
2025-02-24 12:00:00	IWM	ETF	217.105	218.2	217.04	217.8	2340512.0
2025-02-24 13:00:00	IWM	ETF	217.8	218.475	217.61	217.81	1584234.0
2025-02-24 14:00:00	IWM	ETF	217.82	218.28	217.105	217.28	1791241.0
2025-02-24 15:00:00	IWM	ETF	217.275	217.45	216.16	216.22	3834775.0
2025-02-24 16:00:00	IWM	ETF	216.23	216.59	216.0814	216.44	916047.0
2025-02-24 17:00:00	IWM	ETF	216.44	216.44	216.11	216.3	138426.0
2025-02-24 18:00:00	IWM	ETF	216.29	216.55	216.01	216.23	69330.0
2025-02-24 19:00:00	IWM	ETF	216.3	216.67	216.3	216.55	26439.0
2025-02-24 04:00:00	DIA	ETF	436.22	437.27	436.22	437.17	5319.0
2025-02-24 05:00:00	DIA	ETF	436.95	437.25	436.95	437.25	4400.0

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

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