PREVIEW / etf_30min / 2025-07-01

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-07-01.parquet
  size:    1009 KB
  rows:    41,928

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-07-01 04:00:00	SPY	ETF	617.03	617.24	616.67	617.18	78909.0
2025-07-01 04:30:00	SPY	ETF	617.31	617.46	616.86	617.12	18899.0
2025-07-01 05:00:00	SPY	ETF	617.2	617.21	616.68	616.86	18683.0
2025-07-01 05:30:00	SPY	ETF	616.79	616.95	616.41	616.95	17440.0
2025-07-01 06:00:00	SPY	ETF	617.0	617.08	616.82	616.82	6812.0
2025-07-01 06:30:00	SPY	ETF	616.75	616.97	616.67	616.97	6489.0
2025-07-01 07:00:00	SPY	ETF	616.96	617.14	616.8	616.97	40786.0
2025-07-01 07:30:00	SPY	ETF	617.09	617.13	616.56	616.91	46321.0
2025-07-01 08:00:00	SPY	ETF	616.94	617.51	615.52	615.87	159375.0
2025-07-01 08:30:00	SPY	ETF	615.87	616.45	615.81	616.22	132971.0
2025-07-01 09:00:00	SPY	ETF	616.22	616.64	616.05	616.36	176479.0
2025-07-01 09:30:00	SPY	ETF	616.36	617.74	616.255	617.27	4631998.0
2025-07-01 10:00:00	SPY	ETF	617.23	618.065	616.75	617.12	4058716.0
2025-07-01 10:30:00	SPY	ETF	617.1	617.61	616.13	616.5011	4012291.0
2025-07-01 11:00:00	SPY	ETF	616.51	617.4901	615.52	617.28	4795341.0
2025-07-01 11:30:00	SPY	ETF	617.27	617.49	616.08	616.94	2604412.0
2025-07-01 12:00:00	SPY	ETF	616.96	618.1	616.71	617.32	3229490.0
2025-07-01 12:30:00	SPY	ETF	617.32	618.135	617.05	617.09	2270667.0
2025-07-01 13:00:00	SPY	ETF	617.09	618.2599	617.0	618.075	2357584.0
2025-07-01 13:30:00	SPY	ETF	618.08	618.83	617.76	618.5681	2139297.0
2025-07-01 14:00:00	SPY	ETF	618.57	618.6993	617.9193	618.01	2759935.0
2025-07-01 14:30:00	SPY	ETF	618.01	618.51	617.91	617.96	2109629.0
2025-07-01 15:00:00	SPY	ETF	617.95	618.37	616.7	618.365	5465824.0
2025-07-01 15:30:00	SPY	ETF	618.37	618.72	617.43	617.56	8451132.0
2025-07-01 16:00:00	SPY	ETF	617.56	617.65	616.859	617.37	1998955.0
2025-07-01 16:30:00	SPY	ETF	617.37	617.6	617.32	617.45	170873.0
2025-07-01 17:00:00	SPY	ETF	617.45	617.6396	617.35	617.36	10470.0
2025-07-01 17:30:00	SPY	ETF	617.35	617.39	617.21	617.39	13094.0
2025-07-01 18:00:00	SPY	ETF	617.39	617.8	617.3	617.65	70048.0
2025-07-01 18:30:00	SPY	ETF	617.5413	618.06	617.5413	618.0	23992.0
2025-07-01 19:00:00	SPY	ETF	618.04	618.15	617.8	617.85	43253.0
2025-07-01 19:30:00	SPY	ETF	617.8897	617.96	617.7684	617.929	25842.0
2025-07-01 04:00:00	QQQ	ETF	550.56	550.81	550.18	550.81	20426.0
2025-07-01 04:30:00	QQQ	ETF	550.9	551.05	550.32	550.69	14443.0
2025-07-01 05:00:00	QQQ	ETF	550.76	550.83	550.18	550.4	21609.0
2025-07-01 05:30:00	QQQ	ETF	550.4	550.46	550.0	550.46	21724.0
2025-07-01 06:00:00	QQQ	ETF	550.43	550.6	550.34	550.34	14295.0
2025-07-01 06:30:00	QQQ	ETF	550.38	550.61	550.28	550.58	13637.0
2025-07-01 07:00:00	QQQ	ETF	550.6	550.79	550.37	550.6	18632.0
2025-07-01 07:30:00	QQQ	ETF	550.66	550.71	549.91	550.36	25203.0
2025-07-01 08:00:00	QQQ	ETF	550.6	551.5	548.65	549.08	212338.0
2025-07-01 08:30:00	QQQ	ETF	549.06	549.7	549.01	549.54	143597.0
2025-07-01 09:00:00	QQQ	ETF	549.65	550.11	549.48	549.78	171941.0
2025-07-01 09:30:00	QQQ	ETF	549.73	550.46	549.14	549.93	3623780.0
2025-07-01 10:00:00	QQQ	ETF	549.76	550.71	548.42	548.835	3242878.0
2025-07-01 10:30:00	QQQ	ETF	548.84	549.21	546.6	546.92	4912427.0
2025-07-01 11:00:00	QQQ	ETF	546.91	547.63	544.66	546.83	5439196.0
2025-07-01 11:30:00	QQQ	ETF	546.83	547.07	545.21	546.22	2371203.0
2025-07-01 12:00:00	QQQ	ETF	546.23	547.37	545.58	546.7	1781760.0
2025-07-01 12:30:00	QQQ	ETF	546.68	548.14	546.42	547.23	1643921.0

> showing 50 of 41,928 rows — these rows as CSV

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