PREVIEW / etf_30min / 2025-08-28

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-08-28.parquet
  size:    1019 KB
  rows:    40,812

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-08-28 04:00:00	SPY	ETF	647.61	647.91	647.45	647.58	16904.0
2025-08-28 04:30:00	SPY	ETF	647.45	647.49	647.13	647.2	14380.0
2025-08-28 05:00:00	SPY	ETF	647.19	647.41	647.09	647.15	5752.0
2025-08-28 05:30:00	SPY	ETF	647.02	647.18	646.99	647.05	4321.0
2025-08-28 06:00:00	SPY	ETF	646.91	647.14	646.88	647.0	3410.0
2025-08-28 06:30:00	SPY	ETF	646.92	647.03	646.5	646.74	14599.0
2025-08-28 07:00:00	SPY	ETF	646.8	646.88	646.29	646.43	43808.0
2025-08-28 07:30:00	SPY	ETF	646.44	646.97	646.3	646.97	98389.0
2025-08-28 08:00:00	SPY	ETF	646.87	647.67	645.92	646.54	123376.0
2025-08-28 08:30:00	SPY	ETF	646.55	647.58	646.55	647.1302	344294.0
2025-08-28 09:00:00	SPY	ETF	647.14	647.66	647.12	647.24	277825.0
2025-08-28 09:30:00	SPY	ETF	647.27	648.09	645.34	645.94	6442070.0
2025-08-28 10:00:00	SPY	ETF	645.93	646.68	645.58	645.955	3115645.0
2025-08-28 10:30:00	SPY	ETF	645.98	647.17	645.94	646.89	2597106.0
2025-08-28 11:00:00	SPY	ETF	646.89	647.6558	646.08	646.25	2605145.0
2025-08-28 11:30:00	SPY	ETF	646.275	647.19	646.24	647.02	1850830.0
2025-08-28 12:00:00	SPY	ETF	647.02	648.42	646.94	648.15	2116122.0
2025-08-28 12:30:00	SPY	ETF	648.15	648.365	647.62	647.67	1712700.0
2025-08-28 13:00:00	SPY	ETF	647.67	648.15	647.45	648.125	1451194.0
2025-08-28 13:30:00	SPY	ETF	648.13	648.515	648.075	648.38	1810238.0
2025-08-28 14:00:00	SPY	ETF	648.37	648.68	648.315	648.645	2053957.0
2025-08-28 14:30:00	SPY	ETF	648.65	649.055	648.63	648.965	2842453.0
2025-08-28 15:00:00	SPY	ETF	648.96	649.25	648.84	648.96	2380774.0
2025-08-28 15:30:00	SPY	ETF	648.95	649.48	648.73	648.89	7941648.0
2025-08-28 16:00:00	SPY	ETF	648.87	649.79	648.58	648.98	2113339.0
2025-08-28 16:30:00	SPY	ETF	648.98	649.21	648.81	648.87	192621.0
2025-08-28 17:00:00	SPY	ETF	648.9256	649.03	648.76	648.86	20524.0
2025-08-28 17:30:00	SPY	ETF	648.85	648.92	648.76	648.81	31968.0
2025-08-28 18:00:00	SPY	ETF	648.84	648.92	648.63	648.78	30034.0
2025-08-28 18:30:00	SPY	ETF	648.66	648.66	648.41	648.48	26827.0
2025-08-28 19:00:00	SPY	ETF	648.6	648.63	648.3905	648.53	6586.0
2025-08-28 19:30:00	SPY	ETF	648.57	648.7	648.57	648.65	6838.0
2025-08-28 04:00:00	QQQ	ETF	573.83	574.57	573.0	574.11	84802.0
2025-08-28 04:30:00	QQQ	ETF	574.14	574.17	573.46	573.52	18318.0
2025-08-28 05:00:00	QQQ	ETF	573.52	573.79	573.52	573.68	21531.0
2025-08-28 05:30:00	QQQ	ETF	573.67	573.67	573.37	573.43	11783.0
2025-08-28 06:00:00	QQQ	ETF	573.47	573.69	573.35	573.57	13533.0
2025-08-28 06:30:00	QQQ	ETF	573.47	573.71	573.1	573.35	17976.0
2025-08-28 07:00:00	QQQ	ETF	573.37	573.45	572.68	572.88	17747.0
2025-08-28 07:30:00	QQQ	ETF	572.86	573.52	572.81	573.52	19490.0
2025-08-28 08:00:00	QQQ	ETF	573.5	574.28	571.7	573.1865	138985.0
2025-08-28 08:30:00	QQQ	ETF	573.22	574.55	573.2	573.95	229733.0
2025-08-28 09:00:00	QQQ	ETF	573.94	574.5	573.91	574.08	127966.0
2025-08-28 09:30:00	QQQ	ETF	574.11	576.53	572.46	573.348	6809972.0
2025-08-28 10:00:00	QQQ	ETF	573.34	574.97	572.97	573.8118	3393907.0
2025-08-28 10:30:00	QQQ	ETF	573.84	576.22	573.8	575.85	2483771.0
2025-08-28 11:00:00	QQQ	ETF	575.87	576.77	574.67	574.8599	2312276.0
2025-08-28 11:30:00	QQQ	ETF	574.86	575.96	574.82	575.2	1636322.0
2025-08-28 12:00:00	QQQ	ETF	575.21	577.09	575.09	576.82	1723298.0
2025-08-28 12:30:00	QQQ	ETF	576.81	576.97	576.18	576.26	1977641.0

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

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