PREVIEW / etf_30min / 2025-10-29

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-10-29.parquet
  size:    1.1 MB
  rows:    46,458

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-29 04:00:00	SPY	ETF	688.98	689.45	688.89	688.89	18227.0
2025-10-29 04:30:00	SPY	ETF	688.98	689.09	688.16	688.25	10113.0
2025-10-29 05:00:00	SPY	ETF	688.25	688.3	687.78	687.84	23063.0
2025-10-29 05:30:00	SPY	ETF	687.84	688.15	687.76	688.14	30742.0
2025-10-29 06:00:00	SPY	ETF	688.11	688.61	688.0	688.53	12052.0
2025-10-29 06:30:00	SPY	ETF	688.53	689.0	688.4	688.44	27724.0
2025-10-29 07:00:00	SPY	ETF	688.41	689.22	688.3	689.2	33431.0
2025-10-29 07:30:00	SPY	ETF	689.16	689.41	688.82	688.83	142968.0
2025-10-29 08:00:00	SPY	ETF	688.83	689.43	687.8	688.56	111987.0
2025-10-29 08:30:00	SPY	ETF	688.7	688.82	688.3	688.72	89099.0
2025-10-29 09:00:00	SPY	ETF	688.77	689.0086	688.6703	688.71	151619.0
2025-10-29 09:30:00	SPY	ETF	688.72	689.69	688.15	689.57	6170522.0
2025-10-29 10:00:00	SPY	ETF	689.59	689.7	688.45	688.98	3644227.0
2025-10-29 10:30:00	SPY	ETF	688.98	689.1101	687.81	688.35	3982618.0
2025-10-29 11:00:00	SPY	ETF	688.36	688.8196	688.05	688.31	3557935.0
2025-10-29 11:30:00	SPY	ETF	688.32	688.38	687.84	688.05	2884175.0
2025-10-29 12:00:00	SPY	ETF	688.04	688.53	687.59	688.47	1771701.0
2025-10-29 12:30:00	SPY	ETF	688.47	688.78	688.3051	688.55	1342906.0
2025-10-29 13:00:00	SPY	ETF	688.55	688.81	687.74	687.93	1282069.0
2025-10-29 13:30:00	SPY	ETF	687.89	688.54	687.62	688.1699	1721920.0
2025-10-29 14:00:00	SPY	ETF	688.11	688.94	687.33	688.0	3170984.0
2025-10-29 14:30:00	SPY	ETF	688.0	688.72	682.87	686.04	11901417.0
2025-10-29 15:00:00	SPY	ETF	686.06	686.83	684.47	685.43	4655433.0
2025-10-29 15:30:00	SPY	ETF	685.39	687.36	684.05	687.3	8221484.0
2025-10-29 16:00:00	SPY	ETF	687.295	689.0	685.0	686.9	2999620.0
2025-10-29 16:30:00	SPY	ETF	686.94	687.42	686.25	686.33	364052.0
2025-10-29 17:00:00	SPY	ETF	686.26	686.75	685.89	685.96	88158.0
2025-10-29 17:30:00	SPY	ETF	685.96	686.6	685.08	685.15	86701.0
2025-10-29 18:00:00	SPY	ETF	685.18	686.63	684.8265	685.4	57164.0
2025-10-29 18:30:00	SPY	ETF	685.41	686.07	685.41	685.829	20408.0
2025-10-29 19:00:00	SPY	ETF	685.8	686.59	685.7	686.46	20607.0
2025-10-29 19:30:00	SPY	ETF	686.5082	686.92	685.46	686.73	38863.0
2025-10-29 04:00:00	QQQ	ETF	636.0	636.65	636.0	636.2	77658.0
2025-10-29 04:30:00	QQQ	ETF	636.17	636.42	635.47	635.69	78838.0
2025-10-29 05:00:00	QQQ	ETF	635.64	635.71	634.8	634.88	92710.0
2025-10-29 05:30:00	QQQ	ETF	634.91	635.0	634.7	634.95	104293.0
2025-10-29 06:00:00	QQQ	ETF	634.85	635.52	634.76	635.41	71558.0
2025-10-29 06:30:00	QQQ	ETF	635.47	635.75	635.14	635.22	74912.0
2025-10-29 07:00:00	QQQ	ETF	635.2	636.22	635.16	636.16	110152.0
2025-10-29 07:30:00	QQQ	ETF	636.15	636.35	635.74	635.81	107892.0
2025-10-29 08:00:00	QQQ	ETF	635.82	636.64	632.446	635.5	293147.0
2025-10-29 08:30:00	QQQ	ETF	635.58	635.74	635.06	635.45	199974.0
2025-10-29 09:00:00	QQQ	ETF	635.43	635.82	635.4	635.58	239585.0
2025-10-29 09:30:00	QQQ	ETF	635.58	636.835	635.31	636.835	4777725.0
2025-10-29 10:00:00	QQQ	ETF	636.85	637.01	635.54	636.32	3404310.0
2025-10-29 10:30:00	QQQ	ETF	636.32	636.58	635.03	635.392	2243322.0
2025-10-29 11:00:00	QQQ	ETF	635.42	635.84	634.88	635.265	1736815.0
2025-10-29 11:30:00	QQQ	ETF	635.265	635.39	634.4101	634.88	2020541.0
2025-10-29 12:00:00	QQQ	ETF	634.87	635.285	634.03	635.15	2083435.0
2025-10-29 12:30:00	QQQ	ETF	635.15	635.55	634.92	635.27	1355563.0

> showing 50 of 46,458 rows — these rows as CSV

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