PREVIEW / etf_30min / 2025-09-17

all etf 30-min files

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

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-17 04:00:00	SPY	ETF	660.22	660.26	659.75	659.78	8482.0
2025-09-17 04:30:00	SPY	ETF	659.73	659.83	658.57	659.59	22291.0
2025-09-17 05:00:00	SPY	ETF	659.72	659.92	659.67	659.9	6370.0
2025-09-17 05:30:00	SPY	ETF	659.96	660.05	659.77	659.81	4611.0
2025-09-17 06:00:00	SPY	ETF	659.8	659.86	659.55	659.56	5179.0
2025-09-17 06:30:00	SPY	ETF	659.56	659.56	659.19	659.19	8965.0
2025-09-17 07:00:00	SPY	ETF	659.37	659.72	659.14	659.59	26100.0
2025-09-17 07:30:00	SPY	ETF	659.55	659.59	659.14	659.45	13161.0
2025-09-17 08:00:00	SPY	ETF	659.57	660.39	659.0	659.69	92615.0
2025-09-17 08:30:00	SPY	ETF	659.69	659.88	659.54	659.87	190556.0
2025-09-17 09:00:00	SPY	ETF	659.86	660.18	659.779	660.06	143786.0
2025-09-17 09:30:00	SPY	ETF	660.01	660.655	659.64	659.88	5538333.0
2025-09-17 10:00:00	SPY	ETF	659.88	659.96	659.09	659.16	3707834.0
2025-09-17 10:30:00	SPY	ETF	659.17	659.64	659.04	659.32	2445014.0
2025-09-17 11:00:00	SPY	ETF	659.32	659.67	658.865	658.94	1586785.0
2025-09-17 11:30:00	SPY	ETF	658.945	659.33	658.875	659.265	1398219.0
2025-09-17 12:00:00	SPY	ETF	659.26	659.34	658.73	658.93	1097585.0
2025-09-17 12:30:00	SPY	ETF	658.93	658.985	658.13	658.32	1935923.0
2025-09-17 13:00:00	SPY	ETF	658.31	658.74	658.295	658.645	1476406.0
2025-09-17 13:30:00	SPY	ETF	658.65	659.66	658.65	659.66	2068969.0
2025-09-17 14:00:00	SPY	ETF	659.658	661.72	657.13	660.35	10995208.0
2025-09-17 14:30:00	SPY	ETF	660.36	660.57	654.3	657.715	13684267.0
2025-09-17 15:00:00	SPY	ETF	657.69	660.68	657.505	660.185	9474303.0
2025-09-17 15:30:00	SPY	ETF	660.2	660.57	658.5	659.18	9871242.0
2025-09-17 16:00:00	SPY	ETF	659.15	660.01	659.13	659.67	3438009.0
2025-09-17 16:30:00	SPY	ETF	659.68	659.99	659.4	659.71	136803.0
2025-09-17 17:00:00	SPY	ETF	659.66	659.7	659.5504	659.6	13194.0
2025-09-17 17:30:00	SPY	ETF	659.62	659.65	659.58	659.65	8788.0
2025-09-17 18:00:00	SPY	ETF	659.7	660.44	659.55	660.34	40260.0
2025-09-17 18:30:00	SPY	ETF	660.37	661.39	660.34	661.18	147683.0
2025-09-17 19:00:00	SPY	ETF	661.21	661.77	661.21	661.36	86964.0
2025-09-17 19:30:00	SPY	ETF	661.45	661.5201	661.2	661.49	28932.0
2025-09-17 04:00:00	QQQ	ETF	591.78	591.8	591.19	591.3	19738.0
2025-09-17 04:30:00	QQQ	ETF	591.28	591.34	589.64	590.92	43625.0
2025-09-17 05:00:00	QQQ	ETF	591.0	591.22	590.9	591.14	11063.0
2025-09-17 05:30:00	QQQ	ETF	591.15	591.29	590.81	590.92	7083.0
2025-09-17 06:00:00	QQQ	ETF	590.84	591.06	590.57	590.61	12472.0
2025-09-17 06:30:00	QQQ	ETF	590.71	590.74	590.1	590.59	33809.0
2025-09-17 07:00:00	QQQ	ETF	590.61	590.969	590.43	590.74	25877.0
2025-09-17 07:30:00	QQQ	ETF	590.74	590.78	590.3	590.63	31300.0
2025-09-17 08:00:00	QQQ	ETF	590.7	591.82	590.33	591.0	63488.0
2025-09-17 08:30:00	QQQ	ETF	591.12	591.18	590.76	591.15	59649.0
2025-09-17 09:00:00	QQQ	ETF	591.14	591.35	590.89	591.12	75717.0
2025-09-17 09:30:00	QQQ	ETF	591.1	591.57	589.63	589.99	4925934.0
2025-09-17 10:00:00	QQQ	ETF	590.0	590.07	589.0	589.0807	2312267.0
2025-09-17 10:30:00	QQQ	ETF	589.09	589.55	588.38	588.61	2131782.0
2025-09-17 11:00:00	QQQ	ETF	588.61	589.17	588.2301	588.4388	1613867.0
2025-09-17 11:30:00	QQQ	ETF	588.44	588.71	588.15	588.3936	1350505.0
2025-09-17 12:00:00	QQQ	ETF	588.4	588.64	587.99	588.6157	1122754.0
2025-09-17 12:30:00	QQQ	ETF	588.61	588.61	587.525	587.88	1656088.0

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

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