PREVIEW / etf_30min / 2025-05-27

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-05-27.parquet
  size:    977 KB
  rows:    40,604

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-27 04:00:00	SPY	ETF	585.12	588.32	585.12	587.76	56658.0
2025-05-27 04:30:00	SPY	ETF	587.88	587.92	587.24	587.6	50727.0
2025-05-27 05:00:00	SPY	ETF	587.57	588.4	587.5	587.56	36940.0
2025-05-27 05:30:00	SPY	ETF	587.56	588.34	587.5	588.0	21737.0
2025-05-27 06:00:00	SPY	ETF	588.02	588.24	587.73	588.18	12627.0
2025-05-27 06:30:00	SPY	ETF	588.24	588.38	587.47	587.61	87531.0
2025-05-27 07:00:00	SPY	ETF	587.45	587.5	586.9	587.36	185310.0
2025-05-27 07:30:00	SPY	ETF	587.37	587.88	587.3	587.49	155062.0
2025-05-27 08:00:00	SPY	ETF	587.27	588.66	584.01	587.08	282465.0
2025-05-27 08:30:00	SPY	ETF	587.22	587.4	586.12	586.65	254813.0
2025-05-27 09:00:00	SPY	ETF	586.62	587.47	586.0	586.08	410983.0
2025-05-27 09:30:00	SPY	ETF	586.07	586.37	584.37	586.13	6624798.0
2025-05-27 10:00:00	SPY	ETF	586.17	588.25	586.14	587.87	4859306.0
2025-05-27 10:30:00	SPY	ETF	587.87	588.59	587.625	588.04	2885034.0
2025-05-27 11:00:00	SPY	ETF	588.04	589.01	587.94	588.81	2847102.0
2025-05-27 11:30:00	SPY	ETF	588.8	589.12	588.475	588.965	2466911.0
2025-05-27 12:00:00	SPY	ETF	588.96	589.62	588.89	589.37	2637482.0
2025-05-27 12:30:00	SPY	ETF	589.37	590.67	589.355	589.93	3403496.0
2025-05-27 13:00:00	SPY	ETF	589.9483	590.4648	578.43	590.1701	1760439.0
2025-05-27 13:30:00	SPY	ETF	590.18	591.08	590.0	591.01	1997768.0
2025-05-27 14:00:00	SPY	ETF	591.0	591.31	590.52	590.67	2539929.0
2025-05-27 14:30:00	SPY	ETF	590.67	590.9394	590.35	590.4	2481742.0
2025-05-27 15:00:00	SPY	ETF	590.39	590.785	590.175	590.295	3966342.0
2025-05-27 15:30:00	SPY	ETF	590.29	591.08	589.88	591.06	10042635.0
2025-05-27 16:00:00	SPY	ETF	591.06	591.77	590.5009	591.33	2822523.0
2025-05-27 16:30:00	SPY	ETF	591.3296	591.57	591.25	591.48	130131.0
2025-05-27 17:00:00	SPY	ETF	591.4717	591.75	591.42	591.7204	66815.0
2025-05-27 17:30:00	SPY	ETF	591.7205	591.75	591.4	591.53	40588.0
2025-05-27 18:00:00	SPY	ETF	591.51	591.51	591.05	591.22	65837.0
2025-05-27 18:30:00	SPY	ETF	591.18	591.39	591.06	591.39	15721.0
2025-05-27 19:00:00	SPY	ETF	591.29	591.62	591.27	591.27	48728.0
2025-05-27 19:30:00	SPY	ETF	591.28	591.5	591.25	591.3	43996.0
2025-05-27 04:00:00	QQQ	ETF	517.85	518.29	514.8	517.78	87410.0
2025-05-27 04:30:00	QQQ	ETF	517.81	517.93	517.12	517.5	58473.0
2025-05-27 05:00:00	QQQ	ETF	517.47	518.33	517.46	517.6	49045.0
2025-05-27 05:30:00	QQQ	ETF	517.57	518.43	517.49	517.97	66594.0
2025-05-27 06:00:00	QQQ	ETF	517.85	518.27	517.73	518.24	17203.0
2025-05-27 06:30:00	QQQ	ETF	518.36	518.38	517.22	517.28	48502.0
2025-05-27 07:00:00	QQQ	ETF	517.21	517.21	516.47	516.99	119368.0
2025-05-27 07:30:00	QQQ	ETF	517.01	517.39	516.95	517.06	54822.0
2025-05-27 08:00:00	QQQ	ETF	516.71	518.49	508.859	516.88	238269.0
2025-05-27 08:30:00	QQQ	ETF	516.7804	517.17	516.05	516.62	144791.0
2025-05-27 09:00:00	QQQ	ETF	516.64	517.52	516.06	516.1	333263.0
2025-05-27 09:30:00	QQQ	ETF	516.15	517.1	514.59	516.9901	4839147.0
2025-05-27 10:00:00	QQQ	ETF	517.03	519.17	516.98	518.85	3591698.0
2025-05-27 10:30:00	QQQ	ETF	518.86	519.31	518.35	518.496	2028139.0
2025-05-27 11:00:00	QQQ	ETF	518.49	519.575	518.44	519.34	1755335.0
2025-05-27 11:30:00	QQQ	ETF	519.32	519.71	518.82	519.56	1673897.0
2025-05-27 12:00:00	QQQ	ETF	519.57	520.15	519.47	519.825	1780477.0
2025-05-27 12:30:00	QQQ	ETF	519.84	520.99	519.815	520.31	2186786.0

> showing 50 of 40,604 rows — these rows as CSV

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