PREVIEW / etf_30min / 2025-05-15

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-05-15.parquet
  size:    960 KB
  rows:    39,484

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-15 04:00:00	SPY	ETF	584.88	584.97	584.39	584.88	64740.0
2025-05-15 04:30:00	SPY	ETF	584.8	584.81	583.52	583.73	25275.0
2025-05-15 05:00:00	SPY	ETF	583.66	584.3	583.4	584.29	15487.0
2025-05-15 05:30:00	SPY	ETF	584.29	584.82	584.03	584.8	10451.0
2025-05-15 06:00:00	SPY	ETF	584.63	584.63	584.22	584.54	10920.0
2025-05-15 06:30:00	SPY	ETF	584.52	584.75	584.31	584.56	32085.0
2025-05-15 07:00:00	SPY	ETF	584.57	585.39	584.48	585.35	91336.0
2025-05-15 07:30:00	SPY	ETF	585.4	585.56	584.94	585.08	40456.0
2025-05-15 08:00:00	SPY	ETF	584.56	586.48	584.0596	584.72	176202.0
2025-05-15 08:30:00	SPY	ETF	584.6	586.48	584.19	585.38	814961.0
2025-05-15 09:00:00	SPY	ETF	585.39	586.03	585.21	585.58	378917.0
2025-05-15 09:30:00	SPY	ETF	585.56	586.4699	585.0969	586.14	4952484.0
2025-05-15 10:00:00	SPY	ETF	586.13	587.13	585.55	585.89	3615176.0
2025-05-15 10:30:00	SPY	ETF	585.87	586.64	585.31	586.64	2920537.0
2025-05-15 11:00:00	SPY	ETF	586.64	588.91	586.48	588.35	4266106.0
2025-05-15 11:30:00	SPY	ETF	588.37	589.42	588.0649	589.08	2430839.0
2025-05-15 12:00:00	SPY	ETF	589.09	590.1	588.7713	589.17	2618822.0
2025-05-15 12:30:00	SPY	ETF	589.16	590.2	588.83	590.17	2017920.0
2025-05-15 13:00:00	SPY	ETF	590.1875	590.97	590.015	590.685	2433818.0
2025-05-15 13:30:00	SPY	ETF	590.68	590.69	589.73	589.8999	2293887.0
2025-05-15 14:00:00	SPY	ETF	589.895	589.94	588.69	589.5099	2827709.0
2025-05-15 14:30:00	SPY	ETF	589.5	590.33	589.41	589.72	2359617.0
2025-05-15 15:00:00	SPY	ETF	589.73	590.3	588.305	588.77	3479968.0
2025-05-15 15:30:00	SPY	ETF	588.75	590.44	588.74	590.41	9583215.0
2025-05-15 16:00:00	SPY	ETF	590.41	590.72	589.93	590.2	2965438.0
2025-05-15 16:30:00	SPY	ETF	590.21	590.38	590.0	590.0	92040.0
2025-05-15 17:00:00	SPY	ETF	590.05	590.2	589.98	590.0543	41220.0
2025-05-15 17:30:00	SPY	ETF	590.1	590.2	590.02	590.08	20187.0
2025-05-15 18:00:00	SPY	ETF	590.08	590.159	589.78	590.059	60889.0
2025-05-15 18:30:00	SPY	ETF	590.0	590.189	589.76	589.76	30989.0
2025-05-15 19:00:00	SPY	ETF	589.78	589.9	589.6531	589.8299	10649.0
2025-05-15 19:30:00	SPY	ETF	589.81	590.24	589.81	590.16	14886.0
2025-05-15 20:00:00	SPY	ETF	590.18	590.18	590.18	590.18	100.0
2025-05-15 04:00:00	QQQ	ETF	516.97	517.47	515.23	515.71	56326.0
2025-05-15 04:30:00	QQQ	ETF	515.72	515.72	514.0	514.39	78988.0
2025-05-15 05:00:00	QQQ	ETF	514.31	515.0	513.81	514.94	75011.0
2025-05-15 05:30:00	QQQ	ETF	514.95	515.53	514.61	515.42	43865.0
2025-05-15 06:00:00	QQQ	ETF	515.37	515.37	514.63	515.24	46314.0
2025-05-15 06:30:00	QQQ	ETF	515.25	515.34	514.89	515.19	123963.0
2025-05-15 07:00:00	QQQ	ETF	515.19	516.66	515.1	516.33	150436.0
2025-05-15 07:30:00	QQQ	ETF	516.38	516.46	515.74	515.79	55511.0
2025-05-15 08:00:00	QQQ	ETF	514.18	518.54	514.0596	515.62	196655.0
2025-05-15 08:30:00	QQQ	ETF	515.4	517.18	514.95	516.18	398300.0
2025-05-15 09:00:00	QQQ	ETF	516.18	516.88	516.04	516.53	202064.0
2025-05-15 09:30:00	QQQ	ETF	516.52	517.38	515.17	516.4	4095647.0
2025-05-15 10:00:00	QQQ	ETF	516.39	517.525	515.8	516.12	2207916.0
2025-05-15 10:30:00	QQQ	ETF	516.11	517.25	515.39	517.2409	2007359.0
2025-05-15 11:00:00	QQQ	ETF	517.26	519.37	517.075	518.96	2426172.0
2025-05-15 11:30:00	QQQ	ETF	519.0	519.92	518.52	519.5009	2139112.0
2025-05-15 12:00:00	QQQ	ETF	519.52	520.28	519.29	519.85	1739458.0

> showing 50 of 39,484 rows — these rows as CSV

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