PREVIEW / etf_30min / 2025-10-22

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-10-22.parquet
  size:    1.0 MB
  rows:    44,785

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-22 04:00:00	SPY	ETF	671.72	672.31	671.34	671.61	13955.0
2025-10-22 04:30:00	SPY	ETF	671.79	671.8	671.46	671.7	3578.0
2025-10-22 05:00:00	SPY	ETF	671.67	671.72	671.14	671.58	5560.0
2025-10-22 05:30:00	SPY	ETF	671.62	671.94	671.45	671.94	4136.0
2025-10-22 06:00:00	SPY	ETF	671.96	672.2	671.78	672.13	6091.0
2025-10-22 06:30:00	SPY	ETF	672.2	672.32	671.9	671.9	6046.0
2025-10-22 07:00:00	SPY	ETF	671.9	672.0	670.82	671.13	45678.0
2025-10-22 07:30:00	SPY	ETF	671.17	671.42	670.71	671.05	105544.0
2025-10-22 08:00:00	SPY	ETF	672.19	672.84	670.83	671.73	182557.0
2025-10-22 08:30:00	SPY	ETF	671.75	672.14	671.57	671.97	63333.0
2025-10-22 09:00:00	SPY	ETF	671.98	672.27	671.77	671.95	129656.0
2025-10-22 09:30:00	SPY	ETF	671.98	672.01	670.45	671.27	4045980.0
2025-10-22 10:00:00	SPY	ETF	671.25	671.61	669.32	669.43	3110425.0
2025-10-22 10:30:00	SPY	ETF	669.45	670.13	668.09	670.07	5134698.0
2025-10-22 11:00:00	SPY	ETF	670.07	670.41	667.6	667.85	3663731.0
2025-10-22 11:30:00	SPY	ETF	667.86	669.765	667.39	669.01	2986469.0
2025-10-22 12:00:00	SPY	ETF	669.0	669.2	667.15	667.62	2087499.0
2025-10-22 12:30:00	SPY	ETF	667.59	668.22	664.01	667.35	8464758.0
2025-10-22 13:00:00	SPY	ETF	667.3	667.65	664.73	665.42	2911168.0
2025-10-22 13:30:00	SPY	ETF	665.41	665.86	663.3	664.74	3805097.0
2025-10-22 14:00:00	SPY	ETF	664.75	666.2	663.76	665.66	3291814.0
2025-10-22 14:30:00	SPY	ETF	665.65	666.56	665.05	666.49	2465859.0
2025-10-22 15:00:00	SPY	ETF	666.46	667.64	665.54	667.43	4692724.0
2025-10-22 15:30:00	SPY	ETF	667.4201	668.36	667.29	667.79	7467456.0
2025-10-22 16:00:00	SPY	ETF	667.81	668.52	667.25	667.37	3206133.0
2025-10-22 16:30:00	SPY	ETF	667.42	667.84	667.33	667.84	127056.0
2025-10-22 17:00:00	SPY	ETF	667.74	667.84	667.42	667.55	46241.0
2025-10-22 17:30:00	SPY	ETF	667.5	667.68	667.35	667.5	23464.0
2025-10-22 18:00:00	SPY	ETF	667.49	668.0	667.08	667.68	87048.0
2025-10-22 18:30:00	SPY	ETF	667.58	667.89	667.58	667.8	9513.0
2025-10-22 19:00:00	SPY	ETF	667.769	668.0801	667.76	667.81	26657.0
2025-10-22 19:30:00	SPY	ETF	667.9	667.9	666.78	666.8096	31966.0
2025-10-22 04:00:00	QQQ	ETF	611.6	611.7	610.62	610.87	66843.0
2025-10-22 04:30:00	QQQ	ETF	610.91	611.09	610.54	610.89	44046.0
2025-10-22 05:00:00	QQQ	ETF	610.86	610.88	610.06	610.65	57837.0
2025-10-22 05:30:00	QQQ	ETF	610.64	611.04	610.4	611.0	53970.0
2025-10-22 06:00:00	QQQ	ETF	610.99	611.4	610.56	611.29	51402.0
2025-10-22 06:30:00	QQQ	ETF	611.3	612.0	611.24	611.31	51150.0
2025-10-22 07:00:00	QQQ	ETF	611.31	611.43	609.961	610.16	93410.0
2025-10-22 07:30:00	QQQ	ETF	610.17	610.37	609.499	609.89	60804.0
2025-10-22 08:00:00	QQQ	ETF	611.41	612.55	609.5	610.58	212940.0
2025-10-22 08:30:00	QQQ	ETF	610.49	610.9	610.35	610.73	122047.0
2025-10-22 09:00:00	QQQ	ETF	610.76	611.1101	610.46	610.82	186127.0
2025-10-22 09:30:00	QQQ	ETF	610.82	611.41	608.6302	610.645	3756974.0
2025-10-22 10:00:00	QQQ	ETF	610.64	611.19	607.24	607.42	3371076.0
2025-10-22 10:30:00	QQQ	ETF	607.43	609.8	605.63	608.598	4368122.0
2025-10-22 11:00:00	QQQ	ETF	608.6	609.02	604.98	605.11	2967172.0
2025-10-22 11:30:00	QQQ	ETF	605.11	607.57	604.495	606.82	2375079.0
2025-10-22 12:00:00	QQQ	ETF	606.87	607.07	604.63	605.135	1741639.0
2025-10-22 12:30:00	QQQ	ETF	605.16	605.7	601.26	604.26	4126558.0

> showing 50 of 44,785 rows — these rows as CSV

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