PREVIEW / etf_30min / 2025-10-23

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-10-23.parquet
  size:    1.0 MB
  rows:    43,690

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
2025-10-23 04:00:00	SPY	ETF	668.88	669.14	668.7	668.81	57010.0
2025-10-23 04:30:00	SPY	ETF	668.87	669.05	668.46	668.73	7893.0
2025-10-23 05:00:00	SPY	ETF	668.66	668.85	667.61	667.9	17196.0
2025-10-23 05:30:00	SPY	ETF	667.85	668.11	667.61	668.1	3740.0
2025-10-23 06:00:00	SPY	ETF	668.19	668.41	668.1	668.25	8807.0
2025-10-23 06:30:00	SPY	ETF	668.29	668.35	668.05	668.3	2045.0
2025-10-23 07:00:00	SPY	ETF	668.18	668.2	667.12	667.78	35389.0
2025-10-23 07:30:00	SPY	ETF	667.76	667.76	666.58	666.74	86726.0
2025-10-23 08:00:00	SPY	ETF	667.97	669.34	666.3	666.98	127892.0
2025-10-23 08:30:00	SPY	ETF	666.94	667.9	666.02	667.81	193899.0
2025-10-23 09:00:00	SPY	ETF	667.77	669.45	666.6	668.1	276819.0
2025-10-23 09:30:00	SPY	ETF	668.09	670.74	667.8	669.96	5486025.0
2025-10-23 10:00:00	SPY	ETF	670.0	670.37	668.12	669.4	3951073.0
2025-10-23 10:30:00	SPY	ETF	669.4	670.39	668.99	670.205	2510492.0
2025-10-23 11:00:00	SPY	ETF	670.21	670.3099	669.0913	670.04	1965469.0
2025-10-23 11:30:00	SPY	ETF	670.03	670.72	668.73	670.25	2015191.0
2025-10-23 12:00:00	SPY	ETF	670.26	671.08	670.14	670.54	1891335.0
2025-10-23 12:30:00	SPY	ETF	670.54	671.53	670.5023	671.435	1939183.0
2025-10-23 13:00:00	SPY	ETF	671.43	671.65	670.4	671.01	2710027.0
2025-10-23 13:30:00	SPY	ETF	671.015	672.4601	670.9903	672.355	2546524.0
2025-10-23 14:00:00	SPY	ETF	672.37	672.55	671.72	672.49	1956570.0
2025-10-23 14:30:00	SPY	ETF	672.485	672.7101	672.29	672.5401	1519754.0
2025-10-23 15:00:00	SPY	ETF	672.55	672.7	672.27	672.451	2360529.0
2025-10-23 15:30:00	SPY	ETF	672.45	672.45	671.3	671.63	8579749.0
2025-10-23 16:00:00	SPY	ETF	671.6	672.0	670.8	671.6003	3211320.0
2025-10-23 16:30:00	SPY	ETF	671.64	671.94	671.58	671.94	82663.0
2025-10-23 17:00:00	SPY	ETF	672.04	672.04	671.89	672.0	31972.0
2025-10-23 17:30:00	SPY	ETF	671.97	672.16	671.97	672.0001	20686.0
2025-10-23 18:00:00	SPY	ETF	672.02	672.33	671.92	672.24	25507.0
2025-10-23 18:30:00	SPY	ETF	672.28	672.37	672.09	672.1188	12347.0
2025-10-23 19:00:00	SPY	ETF	672.26	672.35	672.2	672.26	3488.0
2025-10-23 19:30:00	SPY	ETF	672.28	672.36	672.2	672.3	10067.0
2025-10-23 04:00:00	QQQ	ETF	607.33	607.33	606.67	606.72	42839.0
2025-10-23 04:30:00	QQQ	ETF	606.76	606.96	606.26	606.56	34680.0
2025-10-23 05:00:00	QQQ	ETF	606.54	606.72	605.21	605.6	84219.0
2025-10-23 05:30:00	QQQ	ETF	605.69	606.02	605.16	605.95	36889.0
2025-10-23 06:00:00	QQQ	ETF	605.96	606.14	605.77	605.82	46626.0
2025-10-23 06:30:00	QQQ	ETF	605.84	606.03	605.38	605.7	36596.0
2025-10-23 07:00:00	QQQ	ETF	605.71	605.76	604.25	604.95	121194.0
2025-10-23 07:30:00	QQQ	ETF	604.89	604.91	603.64	603.91	133088.0
2025-10-23 08:00:00	QQQ	ETF	603.87	607.55	603.06	603.84	289232.0
2025-10-23 08:30:00	QQQ	ETF	603.77	604.79	603.0	604.72	269755.0
2025-10-23 09:00:00	QQQ	ETF	604.7	604.95	603.1001	604.9	352518.0
2025-10-23 09:30:00	QQQ	ETF	604.91	608.83	604.52	608.34	4080274.0
2025-10-23 10:00:00	QQQ	ETF	608.38	608.74	606.51	608.035	3037037.0
2025-10-23 10:30:00	QQQ	ETF	608.05	609.27	607.76	609.06	1788567.0
2025-10-23 11:00:00	QQQ	ETF	609.06	609.14	607.88	608.81	1097301.0
2025-10-23 11:30:00	QQQ	ETF	608.85	609.69	607.4	609.1707	1760679.0
2025-10-23 12:00:00	QQQ	ETF	609.17	609.94	608.94	609.32	1426424.0
2025-10-23 12:30:00	QQQ	ETF	609.31	610.28	609.2793	610.26	1084058.0

> showing 50 of 43,690 rows — these rows as CSV

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