PREVIEW / etf_30min / 2025-09-15

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-09-15.parquet
  size:    1.0 MB
  rows:    43,581

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-09-15 04:00:00	SPY	ETF	658.5	658.52	657.46	658.02	20567.0
2025-09-15 04:30:00	SPY	ETF	658.02	658.42	657.74	658.12	11643.0
2025-09-15 05:00:00	SPY	ETF	658.1	658.1	657.87	658.08	7257.0
2025-09-15 05:30:00	SPY	ETF	658.12	658.22	657.98	658.22	6800.0
2025-09-15 06:00:00	SPY	ETF	658.21	658.41	658.17	658.4	5587.0
2025-09-15 06:30:00	SPY	ETF	658.46	658.6	658.37	658.57	5404.0
2025-09-15 07:00:00	SPY	ETF	658.58	658.78	658.53	658.65	21531.0
2025-09-15 07:30:00	SPY	ETF	658.62	658.95	658.56	658.94	42685.0
2025-09-15 08:00:00	SPY	ETF	658.63	659.5	657.8	659.19	210715.0
2025-09-15 08:30:00	SPY	ETF	659.15	659.6299	658.99	659.6299	80435.0
2025-09-15 09:00:00	SPY	ETF	659.58	659.8	659.35	659.6	184587.0
2025-09-15 09:30:00	SPY	ETF	659.64	660.68	659.475	660.65	6945785.0
2025-09-15 10:00:00	SPY	ETF	660.645	660.735	659.98	660.68	3627609.0
2025-09-15 10:30:00	SPY	ETF	660.66	660.995	660.33	660.95	3439410.0
2025-09-15 11:00:00	SPY	ETF	660.96	661.04	660.23	660.3595	2938890.0
2025-09-15 11:30:00	SPY	ETF	660.35	660.82	660.24	660.62	2186963.0
2025-09-15 12:00:00	SPY	ETF	660.61	660.8901	660.44	660.602	2002072.0
2025-09-15 12:30:00	SPY	ETF	660.605	660.8799	660.07	660.13	1941325.0
2025-09-15 13:00:00	SPY	ETF	660.12	660.385	659.53	659.75	2613148.0
2025-09-15 13:30:00	SPY	ETF	659.74	660.66	659.7	660.6099	2390388.0
2025-09-15 14:00:00	SPY	ETF	660.6	660.6	659.895	659.9	2455959.0
2025-09-15 14:30:00	SPY	ETF	659.9	660.105	659.34	660.0	3093691.0
2025-09-15 15:00:00	SPY	ETF	659.99	660.16	659.7	660.07	2720339.0
2025-09-15 15:30:00	SPY	ETF	660.07	660.91	659.76	660.85	8483460.0
2025-09-15 16:00:00	SPY	ETF	660.85	660.91	660.3	660.3	3163870.0
2025-09-15 16:30:00	SPY	ETF	660.32	660.57	660.29	660.32	118200.0
2025-09-15 17:00:00	SPY	ETF	660.25	660.44	660.25	660.36	33063.0
2025-09-15 17:30:00	SPY	ETF	660.3	660.4	660.26	660.26	27295.0
2025-09-15 18:00:00	SPY	ETF	660.29	660.44	660.18	660.21	59670.0
2025-09-15 18:30:00	SPY	ETF	660.2	660.22	660.08	660.1	51212.0
2025-09-15 19:00:00	SPY	ETF	660.15	660.74	660.15	660.74	20417.0
2025-09-15 19:30:00	SPY	ETF	660.69	660.72	660.47	660.7	15020.0
2025-09-15 04:00:00	QQQ	ETF	587.6	587.6	586.0	586.47	63970.0
2025-09-15 04:30:00	QQQ	ETF	586.47	586.91	586.07	586.48	30546.0
2025-09-15 05:00:00	QQQ	ETF	586.42	586.42	586.09	586.37	19268.0
2025-09-15 05:30:00	QQQ	ETF	586.41	586.54	586.33	586.44	16967.0
2025-09-15 06:00:00	QQQ	ETF	586.41	587.05	586.4	587.05	24927.0
2025-09-15 06:30:00	QQQ	ETF	587.11	587.31	586.96	587.17	21544.0
2025-09-15 07:00:00	QQQ	ETF	587.24	587.6	587.19	587.48	66927.0
2025-09-15 07:30:00	QQQ	ETF	587.34	587.68	587.3	587.59	35971.0
2025-09-15 08:00:00	QQQ	ETF	587.34	588.29	586.18	587.96	197014.0
2025-09-15 08:30:00	QQQ	ETF	587.98	588.31	587.5318	588.29	111743.0
2025-09-15 09:00:00	QQQ	ETF	588.23	588.55	588.09	588.38	156863.0
2025-09-15 09:30:00	QQQ	ETF	588.44	590.47	588.295	590.43	5187576.0
2025-09-15 10:00:00	QQQ	ETF	590.44	590.56	589.68	590.2907	2706086.0
2025-09-15 10:30:00	QQQ	ETF	590.28	590.47	589.875	590.468	2068711.0
2025-09-15 11:00:00	QQQ	ETF	590.47	590.65	589.96	590.278	1947336.0
2025-09-15 11:30:00	QQQ	ETF	590.27	591.13	590.205	590.91	1749547.0
2025-09-15 12:00:00	QQQ	ETF	590.91	591.18	590.59	590.67	1625113.0
2025-09-15 12:30:00	QQQ	ETF	590.67	591.09	590.465	590.58	1166675.0

> showing 50 of 43,581 rows — these rows as CSV

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