PREVIEW / etf_30min / 2026-06-30

all etf 30-min files

  file:    by_date/etf_30min/2026/2026-06-30.parquet
  size:    1.1 MB
  rows:    46,003

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-06-30 04:00:00	SPY	ETF	742.0	742.74	741.38	742.09	72054.0
2026-06-30 04:30:00	SPY	ETF	742.25	742.26	740.74	741.5	10769.0
2026-06-30 05:00:00	SPY	ETF	741.47	741.83	741.36	741.75	5912.0
2026-06-30 05:30:00	SPY	ETF	741.54	742.05	741.14	741.98	4054.0
2026-06-30 06:00:00	SPY	ETF	741.89	742.12	741.79	741.94	5719.0
2026-06-30 06:30:00	SPY	ETF	742.0	742.66	741.74	742.65	9550.0
2026-06-30 07:00:00	SPY	ETF	742.5278	742.97	742.2	742.38	52701.0
2026-06-30 07:30:00	SPY	ETF	742.44	743.0	742.21	742.34	67563.0
2026-06-30 08:00:00	SPY	ETF	742.3	742.4	740.9	740.9	136685.0
2026-06-30 08:30:00	SPY	ETF	740.93	741.5	740.4925	741.0	121287.0
2026-06-30 09:00:00	SPY	ETF	741.0	741.34	740.56	741.26	132437.0
2026-06-30 09:30:00	SPY	ETF	741.29	743.96	740.89	743.92	4262160.0
2026-06-30 10:00:00	SPY	ETF	743.91	744.575	742.86	744.48	2069035.0
2026-06-30 10:30:00	SPY	ETF	744.47	745.38	742.93	743.3199	1816556.0
2026-06-30 11:00:00	SPY	ETF	743.32	745.36	743.24	745.26	1484325.0
2026-06-30 11:30:00	SPY	ETF	745.275	746.0	744.794	745.79	1420424.0
2026-06-30 12:00:00	SPY	ETF	745.8	746.62	745.76	746.29	1587635.0
2026-06-30 12:30:00	SPY	ETF	746.29	747.04	746.12	746.77	1471931.0
2026-06-30 13:00:00	SPY	ETF	746.78	747.14	746.37	746.49	1196298.0
2026-06-30 13:30:00	SPY	ETF	746.51	746.67	746.15	746.49	1198280.0
2026-06-30 14:00:00	SPY	ETF	746.49	747.08	746.32	746.8	1389024.0
2026-06-30 14:30:00	SPY	ETF	746.77	747.44	746.56	747.13	1621194.0
2026-06-30 15:00:00	SPY	ETF	747.13	748.02	747.11	747.42	2801705.0
2026-06-30 15:30:00	SPY	ETF	747.43	747.86	746.3	746.32	9664146.0
2026-06-30 16:00:00	SPY	ETF	746.36	747.1341	745.8	745.9	3771169.0
2026-06-30 16:30:00	SPY	ETF	745.88	745.99	745.56	745.86	150525.0
2026-06-30 17:00:00	SPY	ETF	745.86	746.18	745.86	746.01	51179.0
2026-06-30 17:30:00	SPY	ETF	746.0448	746.05	745.79	745.97	67471.0
2026-06-30 18:00:00	SPY	ETF	745.95	746.68	745.88	746.66	88752.0
2026-06-30 18:30:00	SPY	ETF	746.56	746.59	745.89	746.0	28588.0
2026-06-30 19:00:00	SPY	ETF	746.01	746.27	745.89	746.09	9851.0
2026-06-30 19:30:00	SPY	ETF	746.09	746.4	745.98	746.3	27842.0
2026-06-30 04:00:00	QQQ	ETF	724.96	728.26	724.81	726.06	185469.0
2026-06-30 04:30:00	QQQ	ETF	726.25	726.3	723.54	724.69	45561.0
2026-06-30 05:00:00	QQQ	ETF	724.79	725.1	724.52	724.62	17888.0
2026-06-30 05:30:00	QQQ	ETF	724.52	725.32	724.0	725.05	16733.0
2026-06-30 06:00:00	QQQ	ETF	725.07	725.89	724.76	725.89	29779.0
2026-06-30 06:30:00	QQQ	ETF	725.7	726.72	725.24	726.51	27164.0
2026-06-30 07:00:00	QQQ	ETF	726.43	727.12	725.87	726.28	116276.0
2026-06-30 07:30:00	QQQ	ETF	726.35	727.27	725.99	726.41	92929.0
2026-06-30 08:00:00	QQQ	ETF	726.4	726.52	723.537	723.96	234050.0
2026-06-30 08:30:00	QQQ	ETF	724.04	724.51	723.21	723.38	224272.0
2026-06-30 09:00:00	QQQ	ETF	723.51	724.22	723.0	724.1	203832.0
2026-06-30 09:30:00	QQQ	ETF	724.18	731.94	723.91	731.8701	4433569.0
2026-06-30 10:00:00	QQQ	ETF	731.89	733.31	729.72	732.9884	2688480.0
2026-06-30 10:30:00	QQQ	ETF	733.01	733.775	729.94	730.47	1824564.0
2026-06-30 11:00:00	QQQ	ETF	730.5	733.17	730.37	733.025	1419734.0
2026-06-30 11:30:00	QQQ	ETF	733.06	734.7198	732.59	734.229	1339369.0
2026-06-30 12:00:00	QQQ	ETF	734.22	735.39	734.03	735.035	956600.0
2026-06-30 12:30:00	QQQ	ETF	735.04	736.35	734.64	735.82	823352.0

> showing 50 of 46,003 rows — these rows as CSV

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