PREVIEW / etf_1hour / 2025-01-30

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-01-30.parquet
  size:    612 KB
  rows:    23,358

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-01-30 04:00:00	SPY	ETF	605.0	605.03	604.0	604.08	15496.0
2025-01-30 05:00:00	SPY	ETF	603.97	604.24	603.74	603.81	4903.0
2025-01-30 06:00:00	SPY	ETF	603.9	604.49	603.73	603.84	44201.0
2025-01-30 07:00:00	SPY	ETF	603.7	603.99	602.48	603.32	81154.0
2025-01-30 08:00:00	SPY	ETF	603.24	605.16	602.5	603.98	305825.0
2025-01-30 09:00:00	SPY	ETF	604.09	605.98	603.1	604.94	3016666.0
2025-01-30 10:00:00	SPY	ETF	604.94	604.96	601.43	601.4999	3604840.0
2025-01-30 11:00:00	SPY	ETF	601.445	604.34	600.715	604.0401	2774910.0
2025-01-30 12:00:00	SPY	ETF	604.04	604.04	602.08	603.3303	1729585.0
2025-01-30 13:00:00	SPY	ETF	603.34	605.07	603.19	604.95	1590779.0
2025-01-30 14:00:00	SPY	ETF	604.9403	605.71	604.55	605.6801	2040512.0
2025-01-30 15:00:00	SPY	ETF	605.67	606.6	601.82	604.98	10189273.0
2025-01-30 16:00:00	SPY	ETF	604.96	605.69	603.8	604.2	3294453.0
2025-01-30 17:00:00	SPY	ETF	604.11	606.1	604.07	605.7	236987.0
2025-01-30 18:00:00	SPY	ETF	605.7	606.25	605.16	605.83	71077.0
2025-01-30 19:00:00	SPY	ETF	605.52	606.06	605.44	605.89	28507.0
2025-01-30 04:00:00	QQQ	ETF	524.98	524.98	523.28	523.35	68188.0
2025-01-30 05:00:00	QQQ	ETF	523.25	523.65	522.74	523.05	47709.0
2025-01-30 06:00:00	QQQ	ETF	523.28	524.2	523.23	523.48	61837.0
2025-01-30 07:00:00	QQQ	ETF	523.47	523.79	522.0	523.25	168867.0
2025-01-30 08:00:00	QQQ	ETF	523.22	525.17	521.22	524.15	521503.0
2025-01-30 09:00:00	QQQ	ETF	524.18	526.095	522.4834	524.31	3085230.0
2025-01-30 10:00:00	QQQ	ETF	524.38	524.38	519.22	519.22	3571190.0
2025-01-30 11:00:00	QQQ	ETF	519.21	523.1297	518.21	522.72	2470104.0
2025-01-30 12:00:00	QQQ	ETF	522.7136	522.72	520.235	521.37	1153929.0
2025-01-30 13:00:00	QQQ	ETF	521.34	522.82	520.785	522.63	1121277.0
2025-01-30 14:00:00	QQQ	ETF	522.72	524.0	522.23	523.9403	1126395.0
2025-01-30 15:00:00	QQQ	ETF	523.94	524.92	520.7	523.13	4634434.0
2025-01-30 16:00:00	QQQ	ETF	523.11	524.8	522.32	522.75	1727262.0
2025-01-30 17:00:00	QQQ	ETF	522.7499	525.04	522.4	524.63	431578.0
2025-01-30 18:00:00	QQQ	ETF	524.67	525.45	524.01	524.81	189853.0
2025-01-30 19:00:00	QQQ	ETF	524.55	525.371	524.41	525.18	59375.0
2025-01-30 04:00:00	IWM	ETF	228.0	228.56	228.0	228.31	16176.0
2025-01-30 05:00:00	IWM	ETF	228.26	228.64	228.26	228.35	24765.0
2025-01-30 06:00:00	IWM	ETF	228.37	228.78	228.33	228.5	72584.0
2025-01-30 07:00:00	IWM	ETF	228.34	228.41	228.0	228.36	34036.0
2025-01-30 08:00:00	IWM	ETF	228.2984	228.54	227.7	228.54	207263.0
2025-01-30 09:00:00	IWM	ETF	228.58	229.76	228.15	229.27	2858661.0
2025-01-30 10:00:00	IWM	ETF	229.28	229.72	227.86	227.985	3226412.0
2025-01-30 11:00:00	IWM	ETF	227.97	229.2999	227.95	229.09	1689957.0
2025-01-30 12:00:00	IWM	ETF	229.08	229.13	228.26	228.91	1089799.0
2025-01-30 13:00:00	IWM	ETF	228.9	229.8	228.887	229.68	1072194.0
2025-01-30 14:00:00	IWM	ETF	229.69	229.76	229.5	229.7	745565.0
2025-01-30 15:00:00	IWM	ETF	229.67	230.05	226.92	228.52	5775705.0
2025-01-30 16:00:00	IWM	ETF	228.53	228.96	227.7	228.44	2035485.0
2025-01-30 17:00:00	IWM	ETF	228.44	228.9	228.33	228.85	59499.0
2025-01-30 18:00:00	IWM	ETF	228.63	228.63	228.05	228.3301	42110.0
2025-01-30 19:00:00	IWM	ETF	228.37	228.53	228.11	228.38	26055.0
2025-01-30 04:00:00	DIA	ETF	448.87	448.93	448.78	448.93	700.0
2025-01-30 05:00:00	DIA	ETF	449.04	449.04	449.04	449.04	200.0

> showing 50 of 23,358 rows — these rows as CSV

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