PREVIEW / etf_30min / 2026-06-29

all etf 30-min files

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

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-29 04:00:00	SPY	ETF	736.02	737.0001	734.52	736.45	129434.0
2026-06-29 04:30:00	SPY	ETF	736.33	736.85	735.875	735.96	18113.0
2026-06-29 05:00:00	SPY	ETF	735.86	736.62	735.85	736.51	22393.0
2026-06-29 05:30:00	SPY	ETF	736.65	736.7	735.57	736.28	24239.0
2026-06-29 06:00:00	SPY	ETF	736.34	736.88	736.08	736.76	6938.0
2026-06-29 06:30:00	SPY	ETF	736.85	737.45	736.29	737.45	25049.0
2026-06-29 07:00:00	SPY	ETF	737.38	737.84	736.5	737.06	147205.0
2026-06-29 07:30:00	SPY	ETF	736.98	738.1	736.87	737.0655	84865.0
2026-06-29 08:00:00	SPY	ETF	737.03	737.57	736.92	737.42	102107.0
2026-06-29 08:30:00	SPY	ETF	737.19	737.61	736.31	737.171	128319.0
2026-06-29 09:00:00	SPY	ETF	737.271	737.69	736.33	736.5	293467.0
2026-06-29 09:30:00	SPY	ETF	736.56	739.895	735.3	736.8899	4659922.0
2026-06-29 10:00:00	SPY	ETF	736.87	737.07	732.09	736.07	4758003.0
2026-06-29 10:30:00	SPY	ETF	736.08	738.32	735.88	737.86	2864771.0
2026-06-29 11:00:00	SPY	ETF	737.88	738.02	736.33	737.77	1669994.0
2026-06-29 11:30:00	SPY	ETF	737.76	738.58	737.21	738.51	1597380.0
2026-06-29 12:00:00	SPY	ETF	738.54	739.13	738.26	738.33	1439953.0
2026-06-29 12:30:00	SPY	ETF	738.34	738.95	737.97	738.68	1109749.0
2026-06-29 13:00:00	SPY	ETF	738.69	740.375	738.69	740.14	1656531.0
2026-06-29 13:30:00	SPY	ETF	740.135	740.82	739.98	740.41	994721.0
2026-06-29 14:00:00	SPY	ETF	740.4	740.77	740.12	740.215	1362505.0
2026-06-29 14:30:00	SPY	ETF	740.215	741.19	740.15	740.685	1647434.0
2026-06-29 15:00:00	SPY	ETF	740.69	741.12	740.34	740.87	2857146.0
2026-06-29 15:30:00	SPY	ETF	740.87	741.56	740.23	740.88	7983225.0
2026-06-29 16:00:00	SPY	ETF	740.85	741.2041	740.35	740.89	2943972.0
2026-06-29 16:30:00	SPY	ETF	740.87	740.87	740.0	740.57	147213.0
2026-06-29 17:00:00	SPY	ETF	740.5301	740.83	740.5301	740.73	34131.0
2026-06-29 17:30:00	SPY	ETF	740.62	740.82	740.5	740.79	35926.0
2026-06-29 18:00:00	SPY	ETF	740.65	740.89	740.27	740.64	23593.0
2026-06-29 18:30:00	SPY	ETF	740.52	740.81	740.35	740.67	12834.0
2026-06-29 19:00:00	SPY	ETF	740.51	741.0	740.51	740.87	4826.0
2026-06-29 19:30:00	SPY	ETF	740.71	740.96	740.44	740.76	20133.0
2026-06-29 04:00:00	QQQ	ETF	714.52	716.04	710.4	715.268	329992.0
2026-06-29 04:30:00	QQQ	ETF	715.14	715.78	714.1	714.56	67826.0
2026-06-29 05:00:00	QQQ	ETF	714.34	715.074	713.91	714.87	27778.0
2026-06-29 05:30:00	QQQ	ETF	715.02	715.02	713.5	714.58	51804.0
2026-06-29 06:00:00	QQQ	ETF	714.64	715.84	714.64	715.72	26987.0
2026-06-29 06:30:00	QQQ	ETF	715.76	716.44	715.37	716.35	43424.0
2026-06-29 07:00:00	QQQ	ETF	716.3	716.8	714.88	715.55	207962.0
2026-06-29 07:30:00	QQQ	ETF	715.51	716.6	715.23	715.46	134029.0
2026-06-29 08:00:00	QQQ	ETF	715.29	716.16	705.991	715.62	102336.0
2026-06-29 08:30:00	QQQ	ETF	715.7114	716.05	714.09	715.32	188003.0
2026-06-29 09:00:00	QQQ	ETF	715.39	716.05	713.6	713.98	230436.0
2026-06-29 09:30:00	QQQ	ETF	713.99	718.66	711.88	713.3899	4681963.0
2026-06-29 10:00:00	QQQ	ETF	713.46	713.73	705.172	711.84	5105499.0
2026-06-29 10:30:00	QQQ	ETF	711.86	715.96	710.65	715.93	2761143.0
2026-06-29 11:00:00	QQQ	ETF	715.93	717.32	714.54	717.22	2016509.0
2026-06-29 11:30:00	QQQ	ETF	717.24	719.06	716.41	718.949	2099985.0
2026-06-29 12:00:00	QQQ	ETF	718.92	720.55	718.78	719.61	1692534.0
2026-06-29 12:30:00	QQQ	ETF	719.64	721.12	718.935	720.7088	1008927.0

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

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