PREVIEW / etf_30min / 2026-07-31

all etf 30-min files

  file:    by_date/etf_30min/2026/2026-07-31.parquet
  size:    1.1 MB
  rows:    47,620

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
2026-07-31 04:00:00	SPY	ETF	745.06	746.08	744.02	746.03	76734.0
2026-07-31 04:30:00	SPY	ETF	745.85	746.15	745.5783	746.09	22993.0
2026-07-31 05:00:00	SPY	ETF	746.05	746.5454	745.93	745.93	33144.0
2026-07-31 05:30:00	SPY	ETF	745.95	746.0	745.18	745.18	21768.0
2026-07-31 06:00:00	SPY	ETF	745.12	745.98	745.05	745.715	20943.0
2026-07-31 06:30:00	SPY	ETF	745.72	745.84	745.24	745.45	23114.0
2026-07-31 07:00:00	SPY	ETF	745.46	745.9	744.78	744.86	82214.0
2026-07-31 07:30:00	SPY	ETF	744.84	744.84	744.3	744.71	54209.0
2026-07-31 08:00:00	SPY	ETF	744.68	744.68	743.41	744.02	91795.0
2026-07-31 08:30:00	SPY	ETF	743.86	744.89	742.79	743.09	130589.0
2026-07-31 09:00:00	SPY	ETF	743.14	744.71	742.95	744.68	294605.0
2026-07-31 09:30:00	SPY	ETF	744.68	746.301	741.55	741.94	5751318.0
2026-07-31 10:00:00	SPY	ETF	741.94	742.365	737.68	740.49	5400011.0
2026-07-31 10:30:00	SPY	ETF	740.48	742.95	740.13	742.5	2829642.0
2026-07-31 11:00:00	SPY	ETF	742.53	743.1	740.09	740.3	1941787.0
2026-07-31 11:30:00	SPY	ETF	740.29	743.33	739.81	743.0908	1910189.0
2026-07-31 12:00:00	SPY	ETF	743.09	744.43	742.46	744.42	1851126.0
2026-07-31 12:30:00	SPY	ETF	744.43	745.03	743.99	744.62	1434985.0
2026-07-31 13:00:00	SPY	ETF	744.62	746.4	744.5	746.29	1467040.0
2026-07-31 13:30:00	SPY	ETF	746.3	746.5	745.19	745.44	1552411.0
2026-07-31 14:00:00	SPY	ETF	745.44	746.43	745.295	746.01	1583167.0
2026-07-31 14:30:00	SPY	ETF	746.04	746.54	745.67	746.155	2053456.0
2026-07-31 15:00:00	SPY	ETF	746.14	747.92	745.79	747.49	2964829.0
2026-07-31 15:30:00	SPY	ETF	747.49	748.895	746.34	746.82	7594716.0
2026-07-31 16:00:00	SPY	ETF	746.82	747.55	746.52	746.75	3823131.0
2026-07-31 16:30:00	SPY	ETF	746.71	746.92	744.9	745.15	477416.0
2026-07-31 17:00:00	SPY	ETF	745.2499	745.5	744.7	744.87	468492.0
2026-07-31 17:30:00	SPY	ETF	744.85	744.98	744.0	744.72	181362.0
2026-07-31 18:00:00	SPY	ETF	744.74	744.79	744.0	744.18	46213.0
2026-07-31 18:30:00	SPY	ETF	744.17	744.75	744.15	744.35	30192.0
2026-07-31 19:00:00	SPY	ETF	744.3	744.64	744.28	744.57	12117.0
2026-07-31 19:30:00	SPY	ETF	744.62	744.65	744.2	744.2	21142.0
2026-07-31 04:00:00	QQQ	ETF	691.26	692.96	688.465	692.66	247939.0
2026-07-31 04:30:00	QQQ	ETF	692.53	692.89	691.83	692.79	48110.0
2026-07-31 05:00:00	QQQ	ETF	692.85	693.62	692.3	692.39	72909.0
2026-07-31 05:30:00	QQQ	ETF	692.36	692.3717	690.95	691.07	72682.0
2026-07-31 06:00:00	QQQ	ETF	690.96	692.12	690.74	691.95	56217.0
2026-07-31 06:30:00	QQQ	ETF	691.91	692.4	691.51	691.77	48408.0
2026-07-31 07:00:00	QQQ	ETF	691.78	693.25	691.41	691.59	155361.0
2026-07-31 07:30:00	QQQ	ETF	691.51	691.71	690.88	691.5	127617.0
2026-07-31 08:00:00	QQQ	ETF	691.58	691.58	689.02	690.17	178802.0
2026-07-31 08:30:00	QQQ	ETF	690.06	690.25	688.59	689.49	191186.0
2026-07-31 09:00:00	QQQ	ETF	689.51	692.2	689.2348	692.08	388381.0
2026-07-31 09:30:00	QQQ	ETF	692.11	695.77	685.29	686.79	7345185.0
2026-07-31 10:00:00	QQQ	ETF	686.76	687.6	680.0512	684.2	5389411.0
2026-07-31 10:30:00	QQQ	ETF	684.22	686.51	683.24	685.61	2912362.0
2026-07-31 11:00:00	QQQ	ETF	685.63	686.43	681.07	681.77	1993865.0
2026-07-31 11:30:00	QQQ	ETF	681.72	685.25	680.94	684.7863	1657826.0
2026-07-31 12:00:00	QQQ	ETF	684.75	686.93	684.02	686.93	1537166.0
2026-07-31 12:30:00	QQQ	ETF	686.95	687.625	685.63	687.06	1468168.0

> showing 50 of 47,620 rows — these rows as CSV

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