PREVIEW / etf_30min / 2025-12-31

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-12-31.parquet
  size:    1.0 MB
  rows:    44,226

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-12-31 04:00:00	SPY	ETF	685.14	685.53	685.0	685.28	14228.0
2025-12-31 04:30:00	SPY	ETF	685.29	685.45	685.2	685.24	4291.0
2025-12-31 05:00:00	SPY	ETF	685.12	685.44	685.04	685.43	11015.0
2025-12-31 05:30:00	SPY	ETF	685.46	685.55	685.3	685.38	8399.0
2025-12-31 06:00:00	SPY	ETF	685.45	685.69	685.4	685.63	2484.0
2025-12-31 06:30:00	SPY	ETF	685.71	685.89	685.7	685.89	55113.0
2025-12-31 07:00:00	SPY	ETF	685.88	686.28	685.68	686.22	17752.0
2025-12-31 07:30:00	SPY	ETF	686.22	686.41	686.16	686.32	51475.0
2025-12-31 08:00:00	SPY	ETF	685.77	686.61	685.0	686.6	83145.0
2025-12-31 08:30:00	SPY	ETF	686.55	687.77	686.43	687.52	201848.0
2025-12-31 09:00:00	SPY	ETF	687.52	687.74	687.11	687.11	239658.0
2025-12-31 09:30:00	SPY	ETF	687.13	687.36	685.28	685.96	6414906.0
2025-12-31 10:00:00	SPY	ETF	685.96	686.06	684.915	685.55	3879566.0
2025-12-31 10:30:00	SPY	ETF	685.54	685.655	684.18	684.33	3563874.0
2025-12-31 11:00:00	SPY	ETF	684.32	685.13	684.3	685.12	2992043.0
2025-12-31 11:30:00	SPY	ETF	685.125	685.43	684.74	685.35	1812192.0
2025-12-31 12:00:00	SPY	ETF	685.355	685.43	684.61	685.0	1946939.0
2025-12-31 12:30:00	SPY	ETF	684.99	685.31	684.65	684.805	1508102.0
2025-12-31 13:00:00	SPY	ETF	684.8	685.39	684.72	685.3698	1685940.0
2025-12-31 13:30:00	SPY	ETF	685.3688	686.05	685.25	685.84	2323284.0
2025-12-31 14:00:00	SPY	ETF	685.83	686.24	685.01	685.035	2649799.0
2025-12-31 14:30:00	SPY	ETF	685.04	685.14	684.04	684.14	4057078.0
2025-12-31 15:00:00	SPY	ETF	684.14	684.2	682.545	682.72	5960553.0
2025-12-31 15:30:00	SPY	ETF	682.72	683.72	681.71	681.84	12545417.0
2025-12-31 16:00:00	SPY	ETF	681.84	682.5	681.8091	682.24	4042932.0
2025-12-31 16:30:00	SPY	ETF	682.24	682.24	681.81	682.08	670660.0
2025-12-31 17:00:00	SPY	ETF	682.11	682.21	682.01	682.21	15975.0
2025-12-31 17:30:00	SPY	ETF	682.24	682.69	682.2	682.6515	55344.0
2025-12-31 18:00:00	SPY	ETF	682.65	682.76	682.65	682.73	37033.0
2025-12-31 18:30:00	SPY	ETF	682.7588	682.9	682.65	682.67	14762.0
2025-12-31 19:00:00	SPY	ETF	682.68	682.84	682.65	682.7	10055.0
2025-12-31 19:30:00	SPY	ETF	682.6601	682.7	682.5	682.5	14444.0
2025-12-31 04:00:00	QQQ	ETF	618.23	618.23	616.69	617.04	40411.0
2025-12-31 04:30:00	QQQ	ETF	617.07	617.28	617.02	617.02	4968.0
2025-12-31 05:00:00	QQQ	ETF	617.0	617.45	616.88	617.4	21349.0
2025-12-31 05:30:00	QQQ	ETF	617.48	617.56	617.22	617.41	6514.0
2025-12-31 06:00:00	QQQ	ETF	617.49	617.73	617.36	617.64	7327.0
2025-12-31 06:30:00	QQQ	ETF	617.65	618.05	617.63	618.05	10179.0
2025-12-31 07:00:00	QQQ	ETF	617.99	618.45	617.84	618.35	13484.0
2025-12-31 07:30:00	QQQ	ETF	618.32	618.54	618.27	618.5	50465.0
2025-12-31 08:00:00	QQQ	ETF	617.99	618.96	616.77	618.95	104511.0
2025-12-31 08:30:00	QQQ	ETF	618.95	620.5	618.771	620.2	182294.0
2025-12-31 09:00:00	QQQ	ETF	620.22	620.57	619.64	619.64	142779.0
2025-12-31 09:30:00	QQQ	ETF	619.65	619.96	617.3312	617.92	4470435.0
2025-12-31 10:00:00	QQQ	ETF	617.93	618.2	617.03	617.84	2466471.0
2025-12-31 10:30:00	QQQ	ETF	617.83	617.99	616.45	616.745	1989152.0
2025-12-31 11:00:00	QQQ	ETF	616.73	617.74	616.69	617.72	1737573.0
2025-12-31 11:30:00	QQQ	ETF	617.73	617.97	617.12	617.9154	1324229.0
2025-12-31 12:00:00	QQQ	ETF	617.91	617.94	617.04	617.485	1288493.0
2025-12-31 12:30:00	QQQ	ETF	617.49	617.91	617.13	617.35	1124666.0

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

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