PREVIEW / etf_30min / 2026-06-25

all etf 30-min files

  file:    by_date/etf_30min/2026/2026-06-25.parquet
  size:    1.0 MB
  rows:    46,231

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-25 04:00:00	SPY	ETF	739.0	739.48	736.41	738.82	79910.0
2026-06-25 04:30:00	SPY	ETF	738.68	738.87	737.9	738.02	10474.0
2026-06-25 05:00:00	SPY	ETF	738.11	738.55	737.98	738.33	28172.0
2026-06-25 05:30:00	SPY	ETF	738.28	738.72	738.28	738.56	26555.0
2026-06-25 06:00:00	SPY	ETF	738.43	738.96	738.43	738.87	15790.0
2026-06-25 06:30:00	SPY	ETF	738.97	739.0	738.35	738.58	9299.0
2026-06-25 07:00:00	SPY	ETF	738.68	738.99	737.6	737.72	84122.0
2026-06-25 07:30:00	SPY	ETF	737.65	738.35	737.54	738.02	315107.0
2026-06-25 08:00:00	SPY	ETF	737.96	738.58	737.61	737.69	72390.0
2026-06-25 08:30:00	SPY	ETF	737.92	739.92	737.83	739.04	219585.0
2026-06-25 09:00:00	SPY	ETF	739.0	739.23	738.35	738.96	195081.0
2026-06-25 09:30:00	SPY	ETF	738.89	739.37	729.6	729.85	6061270.0
2026-06-25 10:00:00	SPY	ETF	729.84	736.5	729.78	735.475	4271559.0
2026-06-25 10:30:00	SPY	ETF	735.44	737.82	734.75	735.23	2891775.0
2026-06-25 11:00:00	SPY	ETF	735.26	736.52	731.85	734.29	2936316.0
2026-06-25 11:30:00	SPY	ETF	734.29	735.79	733.92	734.14	1328187.0
2026-06-25 12:00:00	SPY	ETF	734.16	736.27	733.67	734.19	1339338.0
2026-06-25 12:30:00	SPY	ETF	734.225	734.225	731.5	732.54	1489970.0
2026-06-25 13:00:00	SPY	ETF	732.56	734.25	732.08	733.26	1259604.0
2026-06-25 13:30:00	SPY	ETF	733.27	733.79	731.6	733.45	1205729.0
2026-06-25 14:00:00	SPY	ETF	733.44	736.06	731.38	735.84	2342937.0
2026-06-25 14:30:00	SPY	ETF	735.83	735.85	732.69	733.88	1838949.0
2026-06-25 15:00:00	SPY	ETF	733.93	733.9414	731.87	732.3924	2047746.0
2026-06-25 15:30:00	SPY	ETF	732.39	733.38	731.33	733.26	5482525.0
2026-06-25 16:00:00	SPY	ETF	733.27	735.86	733.23	735.15	2984699.0
2026-06-25 16:30:00	SPY	ETF	735.15	735.17	733.74	733.74	355321.0
2026-06-25 17:00:00	SPY	ETF	734.0	734.02	733.74	733.95	83915.0
2026-06-25 17:30:00	SPY	ETF	733.96	734.0	733.4	733.5	52394.0
2026-06-25 18:00:00	SPY	ETF	733.5	733.99	732.2461	732.2461	61742.0
2026-06-25 18:30:00	SPY	ETF	732.2	733.12	732.2	733.12	18917.0
2026-06-25 19:00:00	SPY	ETF	733.05	735.86	733.01	735.46	80874.0
2026-06-25 19:30:00	SPY	ETF	735.6	735.6	732.2812	732.7	65446.0
2026-06-25 04:00:00	QQQ	ETF	726.57	727.44	722.24	726.28	223678.0
2026-06-25 04:30:00	QQQ	ETF	726.28	726.53	724.82	725.18	69437.0
2026-06-25 05:00:00	QQQ	ETF	725.1	725.8	725.0	725.44	59651.0
2026-06-25 05:30:00	QQQ	ETF	725.51	725.94	725.26	725.3	62245.0
2026-06-25 06:00:00	QQQ	ETF	725.29	726.24	725.24	726.09	70795.0
2026-06-25 06:30:00	QQQ	ETF	726.12	726.62	725.57	725.99	47908.0
2026-06-25 07:00:00	QQQ	ETF	726.029	726.8	724.8	724.9	161664.0
2026-06-25 07:30:00	QQQ	ETF	724.75	725.81	724.55	725.29	158944.0
2026-06-25 08:00:00	QQQ	ETF	725.28	726.5	725.0	725.28	169888.0
2026-06-25 08:30:00	QQQ	ETF	725.5	728.42	725.5	727.04	340744.0
2026-06-25 09:00:00	QQQ	ETF	727.05	727.29	725.35	726.04	332356.0
2026-06-25 09:30:00	QQQ	ETF	725.9	726.83	705.3	705.76	8767437.0
2026-06-25 10:00:00	QQQ	ETF	705.84	714.8698	705.61	712.31	5900997.0
2026-06-25 10:30:00	QQQ	ETF	712.29	716.77	711.68	713.43	2860643.0
2026-06-25 11:00:00	QQQ	ETF	713.46	716.07	709.24	712.92	2451735.0
2026-06-25 11:30:00	QQQ	ETF	713.0	716.47	712.77	714.05	1503791.0
2026-06-25 12:00:00	QQQ	ETF	714.05	719.11	713.7	716.57	1921196.0
2026-06-25 12:30:00	QQQ	ETF	716.565	716.64	712.3	714.62	1760764.0

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

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