PREVIEW / etf_30min / 2025-08-11

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-08-11.parquet
  size:    1007 KB
  rows:    42,114

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-08-11 04:00:00	SPY	ETF	637.98	638.32	636.85	637.15	54906.0
2025-08-11 04:30:00	SPY	ETF	637.11	637.4	637.07	637.24	52494.0
2025-08-11 05:00:00	SPY	ETF	637.25	637.71	637.18	637.68	23627.0
2025-08-11 05:30:00	SPY	ETF	637.83	637.85	637.71	637.78	3375.0
2025-08-11 06:00:00	SPY	ETF	637.71	638.14	637.71	638.01	2835.0
2025-08-11 06:30:00	SPY	ETF	638.05	638.1	637.67	638.09	3661.0
2025-08-11 07:00:00	SPY	ETF	638.06	638.31	637.97	637.99	64583.0
2025-08-11 07:30:00	SPY	ETF	638.0	638.4	637.98	638.32	19588.0
2025-08-11 08:00:00	SPY	ETF	638.11	638.66	637.18	638.03	154270.0
2025-08-11 08:30:00	SPY	ETF	638.03	638.07	637.49	637.69	95010.0
2025-08-11 09:00:00	SPY	ETF	637.68	637.78	637.27	637.48	176601.0
2025-08-11 09:30:00	SPY	ETF	637.47	637.76	636.88	637.69	4306100.0
2025-08-11 10:00:00	SPY	ETF	637.68	637.97	637.2	637.2501	2858871.0
2025-08-11 10:30:00	SPY	ETF	637.2419	637.43	636.57	636.78	2453649.0
2025-08-11 11:00:00	SPY	ETF	636.77	637.3	636.53	637.09	1979901.0
2025-08-11 11:30:00	SPY	ETF	637.095	637.89	636.7899	637.86	2030582.0
2025-08-11 12:00:00	SPY	ETF	637.87	638.95	637.79	638.55	2827344.0
2025-08-11 12:30:00	SPY	ETF	638.54	638.61	637.32	637.3301	2186209.0
2025-08-11 13:00:00	SPY	ETF	637.33	637.61	636.91	637.185	1648785.0
2025-08-11 13:30:00	SPY	ETF	637.18	637.42	636.4	636.8019	2161505.0
2025-08-11 14:00:00	SPY	ETF	636.81	636.88	636.28	636.49	3178742.0
2025-08-11 14:30:00	SPY	ETF	636.5	636.8799	635.56	636.51	2491323.0
2025-08-11 15:00:00	SPY	ETF	636.5	636.64	635.995	636.262	1627546.0
2025-08-11 15:30:00	SPY	ETF	636.25	636.38	634.66	635.83	10242844.0
2025-08-11 16:00:00	SPY	ETF	635.84	635.99	635.32	635.49	1696096.0
2025-08-11 16:30:00	SPY	ETF	635.48	635.58	635.37	635.44	106662.0
2025-08-11 17:00:00	SPY	ETF	635.47	635.52	635.3764	635.52	20223.0
2025-08-11 17:30:00	SPY	ETF	635.53	635.6	635.45	635.57	14697.0
2025-08-11 18:00:00	SPY	ETF	635.52	635.85	635.19	635.2	44634.0
2025-08-11 18:30:00	SPY	ETF	635.211	635.8	635.2	635.8	15810.0
2025-08-11 19:00:00	SPY	ETF	635.85	635.88	635.5003	635.6	18417.0
2025-08-11 19:30:00	SPY	ETF	635.7107	635.92	635.6697	635.75	59198.0
2025-08-11 04:00:00	QQQ	ETF	575.48	575.48	573.55	574.05	34743.0
2025-08-11 04:30:00	QQQ	ETF	574.08	574.45	574.03	574.36	16405.0
2025-08-11 05:00:00	QQQ	ETF	574.37	574.85	574.35	574.85	19740.0
2025-08-11 05:30:00	QQQ	ETF	574.9	575.07	574.83	574.86	9501.0
2025-08-11 06:00:00	QQQ	ETF	574.9	575.35	574.78	575.25	14599.0
2025-08-11 06:30:00	QQQ	ETF	575.29	575.3	574.58	575.0	24391.0
2025-08-11 07:00:00	QQQ	ETF	574.94	575.2	574.88	574.93	37556.0
2025-08-11 07:30:00	QQQ	ETF	574.82	575.27	574.82	575.19	19478.0
2025-08-11 08:00:00	QQQ	ETF	575.18	575.76	573.66	575.15	132335.0
2025-08-11 08:30:00	QQQ	ETF	575.16	575.16	574.54	574.86	65068.0
2025-08-11 09:00:00	QQQ	ETF	574.89	574.95	574.36	574.7	122338.0
2025-08-11 09:30:00	QQQ	ETF	574.68	575.38	573.83	575.36	3232754.0
2025-08-11 10:00:00	QQQ	ETF	575.38	575.925	574.84	575.55	1942834.0
2025-08-11 10:30:00	QQQ	ETF	575.56	575.765	574.765	574.95	1225840.0
2025-08-11 11:00:00	QQQ	ETF	574.94	575.52	574.65	575.12	1099460.0
2025-08-11 11:30:00	QQQ	ETF	575.08	575.83	574.685	575.825	1297556.0
2025-08-11 12:00:00	QQQ	ETF	575.825	576.8	575.67	576.345	1548957.0
2025-08-11 12:30:00	QQQ	ETF	576.35	576.442	575.15	575.185	1142683.0

> showing 50 of 42,114 rows — these rows as CSV

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