PREVIEW / etf_1hour / 2025-05-20

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-05-20.parquet
  size:    625 KB
  rows:    24,076

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-05-20 04:00:00	SPY	ETF	593.45	593.75	592.93	593.18	18423.0
2025-05-20 05:00:00	SPY	ETF	593.19	593.53	592.9	592.92	22086.0
2025-05-20 06:00:00	SPY	ETF	593.09	594.05	592.87	594.05	37543.0
2025-05-20 07:00:00	SPY	ETF	594.01	594.38	593.939	593.96	102369.0
2025-05-20 08:00:00	SPY	ETF	593.94	594.3692	592.55	593.51	195097.0
2025-05-20 09:00:00	SPY	ETF	593.51	594.0	592.04	592.84	4570671.0
2025-05-20 10:00:00	SPY	ETF	592.85	594.05	592.355	592.97	4879349.0
2025-05-20 11:00:00	SPY	ETF	592.97	593.64	592.47	593.2098	3445455.0
2025-05-20 12:00:00	SPY	ETF	593.1901	593.57	592.235	593.38	3376290.0
2025-05-20 13:00:00	SPY	ETF	593.375	593.8	592.47	592.995	4044025.0
2025-05-20 14:00:00	SPY	ETF	592.985	593.17	590.59	590.88	6866778.0
2025-05-20 15:00:00	SPY	ETF	590.88	592.965	589.6	592.83	12371903.0
2025-05-20 16:00:00	SPY	ETF	592.81	592.89	592.04	592.339	4330803.0
2025-05-20 17:00:00	SPY	ETF	592.37	592.85	592.14	592.22	244315.0
2025-05-20 18:00:00	SPY	ETF	592.17	592.2	590.5	591.7	332141.0
2025-05-20 19:00:00	SPY	ETF	591.71	592.35	591.71	592.35	46920.0
2025-05-20 04:00:00	QQQ	ETF	520.22	520.59	519.45	519.97	58628.0
2025-05-20 05:00:00	QQQ	ETF	520.01	520.39	519.55	519.77	31532.0
2025-05-20 06:00:00	QQQ	ETF	519.93	520.7	519.68	520.7	40734.0
2025-05-20 07:00:00	QQQ	ETF	520.69	521.16	520.56	520.72	115560.0
2025-05-20 08:00:00	QQQ	ETF	520.76	521.619	519.05	520.01	299550.0
2025-05-20 09:00:00	QQQ	ETF	519.991	520.54	518.07	519.03	3896803.0
2025-05-20 10:00:00	QQQ	ETF	519.03	520.38	518.28	519.34	4457170.0
2025-05-20 11:00:00	QQQ	ETF	519.33	520.25	518.86	520.0	2679277.0
2025-05-20 12:00:00	QQQ	ETF	520.0	520.88	519.23	520.565	2279798.0
2025-05-20 13:00:00	QQQ	ETF	520.57	520.93	519.34	519.89	2167401.0
2025-05-20 14:00:00	QQQ	ETF	519.88	520.11	517.7	517.88	3265271.0
2025-05-20 15:00:00	QQQ	ETF	517.86	520.36	516.66	520.24	6853499.0
2025-05-20 16:00:00	QQQ	ETF	520.25	520.35	519.1	519.55	1682248.0
2025-05-20 17:00:00	QQQ	ETF	519.56	519.59	519.2	519.31	35241.0
2025-05-20 18:00:00	QQQ	ETF	519.34	519.49	517.7599	519.15	194596.0
2025-05-20 19:00:00	QQQ	ETF	519.13	519.84	519.11	519.84	58097.0
2025-05-20 04:00:00	IWM	ETF	208.19	208.34	207.99	208.26	21055.0
2025-05-20 05:00:00	IWM	ETF	208.39	208.44	208.19	208.2	6324.0
2025-05-20 06:00:00	IWM	ETF	208.22	208.53	208.1	208.52	25473.0
2025-05-20 07:00:00	IWM	ETF	208.49	208.92	208.43	208.86	18245.0
2025-05-20 08:00:00	IWM	ETF	208.84	209.14	207.89	208.7993	68666.0
2025-05-20 09:00:00	IWM	ETF	208.78	208.97	207.96	208.345	2296378.0
2025-05-20 10:00:00	IWM	ETF	208.35	209.315	208.32	208.7299	2288497.0
2025-05-20 11:00:00	IWM	ETF	208.725	209.285	208.6	209.09	2268526.0
2025-05-20 12:00:00	IWM	ETF	209.1	209.28	208.71	209.27	1360600.0
2025-05-20 13:00:00	IWM	ETF	209.26	209.755	209.23	209.65	1437869.0
2025-05-20 14:00:00	IWM	ETF	209.64	209.73	208.6	208.71	1505548.0
2025-05-20 15:00:00	IWM	ETF	208.7	209.18	208.195	209.075	3440572.0
2025-05-20 16:00:00	IWM	ETF	209.08	209.15	208.81	209.0	419999.0
2025-05-20 17:00:00	IWM	ETF	208.97	209.0	208.82	208.97	18761.0
2025-05-20 18:00:00	IWM	ETF	208.98	209.04	208.3	208.76	52653.0
2025-05-20 19:00:00	IWM	ETF	208.76	208.98	208.76	208.94	13171.0
2025-05-20 04:00:00	DIA	ETF	427.51	427.63	427.51	427.63	600.0
2025-05-20 05:00:00	DIA	ETF	427.34	427.34	427.28	427.28	400.0

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

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