PREVIEW / etf_1hour / 2025-05-28

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-05-28.parquet
  size:    633 KB
  rows:    24,319

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-28 04:00:00	SPY	ETF	589.98	590.3	589.83	589.87	39770.0
2025-05-28 05:00:00	SPY	ETF	589.8	590.03	589.49	590.0	38149.0
2025-05-28 06:00:00	SPY	ETF	590.1	591.91	589.96	591.88	46670.0
2025-05-28 07:00:00	SPY	ETF	591.87	591.901	591.09	591.46	92967.0
2025-05-28 08:00:00	SPY	ETF	591.43	592.08	589.9204	591.4	231497.0
2025-05-28 09:00:00	SPY	ETF	591.4	592.7688	590.54	590.7885	5966965.0
2025-05-28 10:00:00	SPY	ETF	590.8	591.155	589.22	589.34	5705622.0
2025-05-28 11:00:00	SPY	ETF	589.335	590.14	588.97	589.06	4560507.0
2025-05-28 12:00:00	SPY	ETF	589.06	590.245	589.055	589.93	3379861.0
2025-05-28 13:00:00	SPY	ETF	589.93	590.615	589.43	589.7021	3593895.0
2025-05-28 14:00:00	SPY	ETF	589.7	590.44	587.92	589.76	6191818.0
2025-05-28 15:00:00	SPY	ETF	589.75	590.79	586.985	587.71	13611674.0
2025-05-28 16:00:00	SPY	ETF	587.7	590.19	586.9	590.11	3851904.0
2025-05-28 17:00:00	SPY	ETF	590.0802	590.16	588.85	589.63	418615.0
2025-05-28 18:00:00	SPY	ETF	589.66	592.12	589.19	591.95	348900.0
2025-05-28 19:00:00	SPY	ETF	591.99	597.13	591.99	596.609	1568855.0
2025-05-28 04:00:00	QQQ	ETF	520.59	520.72	520.09	520.15	62392.0
2025-05-28 05:00:00	QQQ	ETF	520.09	520.41	519.88	520.38	41034.0
2025-05-28 06:00:00	QQQ	ETF	520.38	522.52	520.37	522.52	95154.0
2025-05-28 07:00:00	QQQ	ETF	522.48	522.65	521.791	522.21	108664.0
2025-05-28 08:00:00	QQQ	ETF	522.4	522.97	520.054	522.27	249647.0
2025-05-28 09:00:00	QQQ	ETF	522.2799	523.68	520.91	521.27	3969011.0
2025-05-28 10:00:00	QQQ	ETF	521.28	521.7599	520.3	520.4116	3650421.0
2025-05-28 11:00:00	QQQ	ETF	520.4193	521.52	520.33	520.53	2937988.0
2025-05-28 12:00:00	QQQ	ETF	520.5387	521.605	520.53	521.22	1878848.0
2025-05-28 13:00:00	QQQ	ETF	521.22	521.83	521.0	521.34	2437976.0
2025-05-28 14:00:00	QQQ	ETF	521.33	522.12	519.67	521.3	3788445.0
2025-05-28 15:00:00	QQQ	ETF	521.3	522.3802	518.39	518.95	9483950.0
2025-05-28 16:00:00	QQQ	ETF	518.95	522.7397	517.98	522.578	2344590.0
2025-05-28 17:00:00	QQQ	ETF	522.698	523.0	521.6	522.2	320127.0
2025-05-28 18:00:00	QQQ	ETF	522.3	524.35	521.84	524.131	246408.0
2025-05-28 19:00:00	QQQ	ETF	524.2	528.62	524.19	528.45	1315445.0
2025-05-28 04:00:00	IWM	ETF	207.05	207.12	206.87	206.87	26097.0
2025-05-28 05:00:00	IWM	ETF	206.85	206.9	206.56	206.87	27381.0
2025-05-28 06:00:00	IWM	ETF	206.84	207.69	206.84	207.69	16671.0
2025-05-28 07:00:00	IWM	ETF	207.7	207.77	207.34	207.53	51898.0
2025-05-28 08:00:00	IWM	ETF	207.46	207.92	207.0	207.54	96087.0
2025-05-28 09:00:00	IWM	ETF	207.57	208.03	206.735	206.75	2836992.0
2025-05-28 10:00:00	IWM	ETF	206.745	206.93	205.97	206.17	3429019.0
2025-05-28 11:00:00	IWM	ETF	206.16	206.535	205.74	205.77	2371486.0
2025-05-28 12:00:00	IWM	ETF	205.775	206.21	205.775	206.09	1718309.0
2025-05-28 13:00:00	IWM	ETF	206.09	206.545	205.99	206.3	1491509.0
2025-05-28 14:00:00	IWM	ETF	206.29	206.56	205.455	206.035	2439993.0
2025-05-28 15:00:00	IWM	ETF	206.03	206.33	205.2	205.52	5780247.0
2025-05-28 16:00:00	IWM	ETF	205.51	205.66	205.19	205.3	917816.0
2025-05-28 17:00:00	IWM	ETF	205.34	205.48	205.18	205.45	20800.0
2025-05-28 18:00:00	IWM	ETF	205.38	206.4	205.09	206.27	85020.0
2025-05-28 19:00:00	IWM	ETF	206.32	209.72	206.32	209.5	532748.0
2025-05-28 04:00:00	DIA	ETF	423.03	423.04	422.98	422.98	400.0
2025-05-28 05:00:00	DIA	ETF	422.8	422.93	422.69	422.93	600.0

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

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