PREVIEW / etf_30min / 2025-05-23

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-05-23.parquet
  size:    928 KB
  rows:    38,752

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-23 04:00:00	SPY	ETF	584.22	584.66	583.8	584.32	15532.0
2025-05-23 04:30:00	SPY	ETF	584.44	584.45	583.57	583.64	5440.0
2025-05-23 05:00:00	SPY	ETF	583.5	583.5	581.9	581.99	8010.0
2025-05-23 05:30:00	SPY	ETF	581.99	583.5	581.99	583.5	10395.0
2025-05-23 06:00:00	SPY	ETF	583.29	583.49	582.69	582.89	4501.0
2025-05-23 06:30:00	SPY	ETF	582.85	583.18	582.48	583.14	14991.0
2025-05-23 07:00:00	SPY	ETF	583.16	583.4	580.89	581.37	126485.0
2025-05-23 07:30:00	SPY	ETF	581.35	581.88	574.33	575.09	1662781.0
2025-05-23 08:00:00	SPY	ETF	575.13	584.4	573.26	575.59	1400887.0
2025-05-23 08:30:00	SPY	ETF	575.51	576.0	574.58	575.04	712163.0
2025-05-23 09:00:00	SPY	ETF	575.05	576.03	573.94	575.98	798989.0
2025-05-23 09:30:00	SPY	ETF	575.98	578.16	575.6	576.77	8695885.0
2025-05-23 10:00:00	SPY	ETF	576.84	578.87	576.69	577.72	4719317.0
2025-05-23 10:30:00	SPY	ETF	577.71	578.9499	577.01	577.12	2778460.0
2025-05-23 11:00:00	SPY	ETF	577.13	578.5399	576.8094	578.48	2533551.0
2025-05-23 11:30:00	SPY	ETF	578.49	579.73	577.98	578.03	2455576.0
2025-05-23 12:00:00	SPY	ETF	578.04	579.1	577.52	578.66	2141277.0
2025-05-23 12:30:00	SPY	ETF	578.65	579.62	577.9508	579.0	1965759.0
2025-05-23 13:00:00	SPY	ETF	579.0	581.16	578.73	581.09	2440945.0
2025-05-23 13:30:00	SPY	ETF	581.07	581.46	580.04	580.82	1990961.0
2025-05-23 14:00:00	SPY	ETF	580.82	581.8101	579.99	580.765	3177557.0
2025-05-23 14:30:00	SPY	ETF	580.74	581.53	580.37	580.73	1797554.0
2025-05-23 15:00:00	SPY	ETF	580.73	581.45	579.38	579.9	3055690.0
2025-05-23 15:30:00	SPY	ETF	579.88	581.03	578.49	579.16	7806636.0
2025-05-23 16:00:00	SPY	ETF	579.17	579.18	578.321	578.9	2343254.0
2025-05-23 16:30:00	SPY	ETF	578.82	579.01	578.22	579.0	107835.0
2025-05-23 17:00:00	SPY	ETF	578.81	579.02	578.81	578.95	38031.0
2025-05-23 17:30:00	SPY	ETF	579.08	579.08	578.8	578.8	11582.0
2025-05-23 18:00:00	SPY	ETF	578.8	578.95	578.71	578.7101	6167.0
2025-05-23 18:30:00	SPY	ETF	578.75	578.92	578.7	578.8882	9143.0
2025-05-23 19:00:00	SPY	ETF	578.78	579.05	578.75	579.02	6883.0
2025-05-23 19:30:00	SPY	ETF	579.0	579.1	578.9	579.0	13153.0
2025-05-23 04:00:00	QQQ	ETF	514.84	515.4	514.5	515.21	41562.0
2025-05-23 04:30:00	QQQ	ETF	515.13	515.17	514.26	514.4	15028.0
2025-05-23 05:00:00	QQQ	ETF	514.27	514.49	512.78	512.85	47229.0
2025-05-23 05:30:00	QQQ	ETF	512.82	514.42	512.82	514.23	33708.0
2025-05-23 06:00:00	QQQ	ETF	514.26	514.45	513.66	514.05	13247.0
2025-05-23 06:30:00	QQQ	ETF	513.95	514.09	513.36	514.09	16391.0
2025-05-23 07:00:00	QQQ	ETF	514.1	514.26	511.0	512.1	197693.0
2025-05-23 07:30:00	QQQ	ETF	512.02	512.61	505.18	505.67	884188.0
2025-05-23 08:00:00	QQQ	ETF	514.23	515.327	503.28	505.4	1184111.0
2025-05-23 08:30:00	QQQ	ETF	505.42	505.9	504.5	505.09	473508.0
2025-05-23 09:00:00	QQQ	ETF	504.87	506.22	504.0	506.16	509427.0
2025-05-23 09:30:00	QQQ	ETF	506.2	508.715	505.58	507.14	7004100.0
2025-05-23 10:00:00	QQQ	ETF	507.15	509.68	506.98	508.45	3534652.0
2025-05-23 10:30:00	QQQ	ETF	508.45	509.5392	507.6	507.67	2260784.0
2025-05-23 11:00:00	QQQ	ETF	507.67	508.98	507.06	508.88	2325659.0
2025-05-23 11:30:00	QQQ	ETF	508.84	510.03	508.25	508.27	2030372.0
2025-05-23 12:00:00	QQQ	ETF	508.265	509.47	507.88	509.01	2424072.0
2025-05-23 12:30:00	QQQ	ETF	509.03	509.96	508.29	509.43	1765802.0

> showing 50 of 38,752 rows — these rows as CSV

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