PREVIEW / etf_30min / 2025-05-22

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-05-22.parquet
  size:    953 KB
  rows:    39,551

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-22 04:00:00	SPY	ETF	584.0	584.44	583.63	584.27	32260.0
2025-05-22 04:30:00	SPY	ETF	584.32	584.39	583.82	584.05	8391.0
2025-05-22 05:00:00	SPY	ETF	584.0	584.09	583.48	584.09	22568.0
2025-05-22 05:30:00	SPY	ETF	584.05	584.28	583.59	583.95	7529.0
2025-05-22 06:00:00	SPY	ETF	583.81	584.17	583.33	584.14	17670.0
2025-05-22 06:30:00	SPY	ETF	584.08	584.1	583.5	583.62	22372.0
2025-05-22 07:00:00	SPY	ETF	583.62	584.64	583.17	583.17	106617.0
2025-05-22 07:30:00	SPY	ETF	583.09	583.43	580.98	581.02	177088.0
2025-05-22 08:00:00	SPY	ETF	581.02	591.9255	580.05	580.09	483891.0
2025-05-22 08:30:00	SPY	ETF	580.01	583.17	580.0	583.1	426447.0
2025-05-22 09:00:00	SPY	ETF	583.13	583.75	582.46	582.64	332065.0
2025-05-22 09:30:00	SPY	ETF	582.66	584.35	581.405	584.18	6048435.0
2025-05-22 10:00:00	SPY	ETF	584.19	585.17	582.51	582.84	3851881.0
2025-05-22 10:30:00	SPY	ETF	582.84	583.36	581.51	582.9	3650537.0
2025-05-22 11:00:00	SPY	ETF	582.92	583.84	582.3499	582.55	2998814.0
2025-05-22 11:30:00	SPY	ETF	582.54	584.37	582.42	584.25	2707495.0
2025-05-22 12:00:00	SPY	ETF	584.25	585.61	583.78	584.325	2837772.0
2025-05-22 12:30:00	SPY	ETF	584.32	584.45	583.02	583.12	2099933.0
2025-05-22 13:00:00	SPY	ETF	583.13	584.87	582.63	584.67	2639173.0
2025-05-22 13:30:00	SPY	ETF	584.68	585.83	584.31	585.39	2262444.0
2025-05-22 14:00:00	SPY	ETF	585.38	586.0	585.04	585.57	2639651.0
2025-05-22 14:30:00	SPY	ETF	585.58	586.1	584.89	585.84	2319814.0
2025-05-22 15:00:00	SPY	ETF	585.845	586.62	585.67	586.51	3307024.0
2025-05-22 15:30:00	SPY	ETF	586.5	586.5666	582.58	583.03	10479931.0
2025-05-22 16:00:00	SPY	ETF	583.02	583.45	582.81	582.88	2198192.0
2025-05-22 16:30:00	SPY	ETF	582.95	584.1	582.85	583.94	175610.0
2025-05-22 17:00:00	SPY	ETF	583.9384	584.1	583.88	583.9886	53579.0
2025-05-22 17:30:00	SPY	ETF	583.92	584.08	583.9	584.08	16559.0
2025-05-22 18:00:00	SPY	ETF	584.1	584.3	583.38	583.38	57382.0
2025-05-22 18:30:00	SPY	ETF	583.4	583.4	582.3	582.48	25207.0
2025-05-22 19:00:00	SPY	ETF	582.47	583.05	582.22	583.0	38431.0
2025-05-22 19:30:00	SPY	ETF	582.9704	583.2	582.7	583.11	13669.0
2025-05-22 04:00:00	QQQ	ETF	514.25	514.99	514.0	514.73	35077.0
2025-05-22 04:30:00	QQQ	ETF	514.75	514.78	514.19	514.39	28022.0
2025-05-22 05:00:00	QQQ	ETF	514.33	514.51	513.93	514.51	40234.0
2025-05-22 05:30:00	QQQ	ETF	514.55	514.78	514.14	514.56	41289.0
2025-05-22 06:00:00	QQQ	ETF	514.41	514.58	513.75	514.56	78887.0
2025-05-22 06:30:00	QQQ	ETF	514.59	514.63	514.03	514.14	36028.0
2025-05-22 07:00:00	QQQ	ETF	514.11	515.45	513.94	513.94	176918.0
2025-05-22 07:30:00	QQQ	ETF	513.93	514.27	511.52	511.54	147964.0
2025-05-22 08:00:00	QQQ	ETF	514.87	515.4	510.51	510.76	420551.0
2025-05-22 08:30:00	QQQ	ETF	510.62	514.26	510.57	514.17	255020.0
2025-05-22 09:00:00	QQQ	ETF	514.22	515.02	513.54	513.62	445431.0
2025-05-22 09:30:00	QQQ	ETF	513.67	516.62	512.3	516.5	5635111.0
2025-05-22 10:00:00	QQQ	ETF	516.52	517.54	514.658	515.19	3494397.0
2025-05-22 10:30:00	QQQ	ETF	515.21	515.95	513.58	515.17	3497250.0
2025-05-22 11:00:00	QQQ	ETF	515.1491	516.02	514.48	514.55	2593844.0
2025-05-22 11:30:00	QQQ	ETF	514.54	516.34	514.38	516.14	2402077.0
2025-05-22 12:00:00	QQQ	ETF	516.13	517.39	515.55	516.0512	2489711.0
2025-05-22 12:30:00	QQQ	ETF	516.05	516.19	514.63	514.81	1620876.0

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

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