PREVIEW / etf_30min / 2026-06-23

all etf 30-min files

  file:    by_date/etf_30min/2026/2026-06-23.parquet
  size:    1.1 MB
  rows:    47,136

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-23 04:00:00	SPY	ETF	733.97	741.63	732.91	733.02	208980.0
2026-06-23 04:30:00	SPY	ETF	733.2	734.52	733.06	733.61	78017.0
2026-06-23 05:00:00	SPY	ETF	733.8	735.3	733.79	735.18	110482.0
2026-06-23 05:30:00	SPY	ETF	735.04	735.27	734.54	735.05	68348.0
2026-06-23 06:00:00	SPY	ETF	735.12	735.64	734.7	734.8	64815.0
2026-06-23 06:30:00	SPY	ETF	734.67	734.67	733.49	734.38	72268.0
2026-06-23 07:00:00	SPY	ETF	734.42	735.5	734.03	734.7	210868.0
2026-06-23 07:30:00	SPY	ETF	734.7	736.16	734.55	735.95	175579.0
2026-06-23 08:00:00	SPY	ETF	735.88	736.25	734.13	734.58	152982.0
2026-06-23 08:30:00	SPY	ETF	734.61	734.81	733.64	734.08	137039.0
2026-06-23 09:00:00	SPY	ETF	734.145	734.37	733.22	733.77	284357.0
2026-06-23 09:30:00	SPY	ETF	733.74	737.23	732.3	737.17	6173936.0
2026-06-23 10:00:00	SPY	ETF	737.125	739.63	737.0	738.9	3341854.0
2026-06-23 10:30:00	SPY	ETF	738.9	739.11	736.5	737.03	2266418.0
2026-06-23 11:00:00	SPY	ETF	737.07	737.43	734.26	734.59	1979763.0
2026-06-23 11:30:00	SPY	ETF	734.6	736.22	734.21	735.97	1947443.0
2026-06-23 12:00:00	SPY	ETF	735.98	737.6699	735.86	737.38	1583460.0
2026-06-23 12:30:00	SPY	ETF	737.38	737.98	736.94	737.444	1299887.0
2026-06-23 13:00:00	SPY	ETF	737.43	738.1	736.51	737.53	1213090.0
2026-06-23 13:30:00	SPY	ETF	737.56	738.03	735.75	735.795	1440079.0
2026-06-23 14:00:00	SPY	ETF	735.83	736.57	735.22	735.4	1834400.0
2026-06-23 14:30:00	SPY	ETF	735.39	735.5088	733.32	734.0225	3442094.0
2026-06-23 15:00:00	SPY	ETF	734.0	735.6	733.7	735.01	3849993.0
2026-06-23 15:30:00	SPY	ETF	735.02	735.56	733.5	733.67	10875387.0
2026-06-23 16:00:00	SPY	ETF	733.69	734.54	733.38	734.37	2988077.0
2026-06-23 16:30:00	SPY	ETF	734.4	734.9	734.15	734.8789	149868.0
2026-06-23 17:00:00	SPY	ETF	734.85	734.99	734.21	734.61	122780.0
2026-06-23 17:30:00	SPY	ETF	734.65	735.04	734.61	734.87	22609.0
2026-06-23 18:00:00	SPY	ETF	734.95	735.42	733.96	733.97	69509.0
2026-06-23 18:30:00	SPY	ETF	734.27	734.27	733.25	733.88	106256.0
2026-06-23 19:00:00	SPY	ETF	733.67	734.1	732.43	734.0	29112.0
2026-06-23 19:30:00	SPY	ETF	734.0	735.3839	733.17	735.02	50422.0
2026-06-23 04:00:00	QQQ	ETF	720.02	732.3	717.05	717.56	570531.0
2026-06-23 04:30:00	QQQ	ETF	717.76	719.43	717.14	718.24	106021.0
2026-06-23 05:00:00	QQQ	ETF	718.29	720.92	718.29	720.36	140894.0
2026-06-23 05:30:00	QQQ	ETF	720.48	720.48	719.05	719.69	55003.0
2026-06-23 06:00:00	QQQ	ETF	719.7	720.49	718.06	718.27	83647.0
2026-06-23 06:30:00	QQQ	ETF	718.21	718.25	716.55	718.1526	117289.0
2026-06-23 07:00:00	QQQ	ETF	718.14	719.32	717.42	718.03	317847.0
2026-06-23 07:30:00	QQQ	ETF	717.9	719.79	717.76	719.54	167298.0
2026-06-23 08:00:00	QQQ	ETF	719.51	737.397	716.44	717.18	306362.0
2026-06-23 08:30:00	QQQ	ETF	717.15	717.6	715.54	716.12	234366.0
2026-06-23 09:00:00	QQQ	ETF	716.24	716.65	714.76	715.82	451528.0
2026-06-23 09:30:00	QQQ	ETF	715.74	720.9	713.28	720.71	6309353.0
2026-06-23 10:00:00	QQQ	ETF	720.69	723.61	720.58	722.015	3524462.0
2026-06-23 10:30:00	QQQ	ETF	722.05	722.36	717.89	718.8716	2736394.0
2026-06-23 11:00:00	QQQ	ETF	718.88	719.65	715.39	715.77	2410668.0
2026-06-23 11:30:00	QQQ	ETF	715.7	718.05	715.09	717.5314	1835347.0
2026-06-23 12:00:00	QQQ	ETF	717.54	720.3	717.33	719.39	2026070.0
2026-06-23 12:30:00	QQQ	ETF	719.371	720.0699	718.28	719.045	1142854.0

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

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