PREVIEW / etf_30min / 2025-09-02

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-09-02.parquet
  size:    1.0 MB
  rows:    44,765

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-02 04:00:00	SPY	ETF	640.74	643.88	640.6	641.6	37955.0
2025-09-02 04:30:00	SPY	ETF	641.58	642.24	641.38	641.8	20396.0
2025-09-02 05:00:00	SPY	ETF	641.8	642.05	641.52	641.93	8099.0
2025-09-02 05:30:00	SPY	ETF	641.91	642.05	641.42	641.5	8487.0
2025-09-02 06:00:00	SPY	ETF	641.39	641.71	640.4	640.48	12301.0
2025-09-02 06:30:00	SPY	ETF	640.52	640.66	639.86	640.32	41987.0
2025-09-02 07:00:00	SPY	ETF	640.35	640.48	639.9	640.17	118443.0
2025-09-02 07:30:00	SPY	ETF	640.11	640.27	639.79	640.02	216105.0
2025-09-02 08:00:00	SPY	ETF	644.49	644.71	638.5	638.66	383602.0
2025-09-02 08:30:00	SPY	ETF	638.6	638.8	636.44	637.34	435141.0
2025-09-02 09:00:00	SPY	ETF	637.34	637.96	636.96	637.53	266664.0
2025-09-02 09:30:00	SPY	ETF	637.5	639.36	636.05	639.07	9838362.0
2025-09-02 10:00:00	SPY	ETF	639.01	640.14	638.18	639.47	4187569.0
2025-09-02 10:30:00	SPY	ETF	639.45	639.63	637.23	637.65	3289517.0
2025-09-02 11:00:00	SPY	ETF	637.65	637.94	636.17	636.56	2715882.0
2025-09-02 11:30:00	SPY	ETF	636.55	636.568	634.92	635.21	3119329.0
2025-09-02 12:00:00	SPY	ETF	635.215	636.07	635.0301	635.61	2297856.0
2025-09-02 12:30:00	SPY	ETF	635.61	636.97	635.61	636.95	2234117.0
2025-09-02 13:00:00	SPY	ETF	636.95	637.85	636.53	637.64	2271889.0
2025-09-02 13:30:00	SPY	ETF	637.63	639.035	637.63	638.35	3002297.0
2025-09-02 14:00:00	SPY	ETF	638.33	638.81	637.65	637.7265	1747722.0
2025-09-02 14:30:00	SPY	ETF	637.72	638.94	637.32	638.0518	2616108.0
2025-09-02 15:00:00	SPY	ETF	638.06	639.31	638.04	639.14	2632082.0
2025-09-02 15:30:00	SPY	ETF	639.13	640.49	639.04	640.31	10559555.0
2025-09-02 16:00:00	SPY	ETF	640.33	642.22	640.17	642.04	3339320.0
2025-09-02 16:30:00	SPY	ETF	642.03	642.45	641.8	642.4	428750.0
2025-09-02 17:00:00	SPY	ETF	642.32	642.45	642.1701	642.44	107142.0
2025-09-02 17:30:00	SPY	ETF	642.42	642.45	642.32	642.4	46389.0
2025-09-02 18:00:00	SPY	ETF	642.42	642.42	641.87	641.93	70656.0
2025-09-02 18:30:00	SPY	ETF	641.97	642.19	641.35	641.38	56543.0
2025-09-02 19:00:00	SPY	ETF	641.43	641.47	641.07	641.31	24220.0
2025-09-02 19:30:00	SPY	ETF	641.32	641.35	641.15	641.18	26495.0
2025-09-02 04:00:00	QQQ	ETF	565.6	569.69	565.44	566.41	64633.0
2025-09-02 04:30:00	QQQ	ETF	566.4	566.98	566.22	566.4	31208.0
2025-09-02 05:00:00	QQQ	ETF	566.44	566.89	566.23	566.76	40821.0
2025-09-02 05:30:00	QQQ	ETF	566.81	566.87	565.97	566.0	27716.0
2025-09-02 06:00:00	QQQ	ETF	565.96	566.44	564.9	565.11	60606.0
2025-09-02 06:30:00	QQQ	ETF	565.03	565.28	564.59	565.0	99827.0
2025-09-02 07:00:00	QQQ	ETF	565.07	565.19	564.35	564.56	40315.0
2025-09-02 07:30:00	QQQ	ETF	564.43	565.0	564.23	564.36	84800.0
2025-09-02 08:00:00	QQQ	ETF	564.77	570.827	562.74	562.92	387850.0
2025-09-02 08:30:00	QQQ	ETF	562.8982	562.99	560.57	561.29	333698.0
2025-09-02 09:00:00	QQQ	ETF	561.25	562.02	560.83	561.32	229521.0
2025-09-02 09:30:00	QQQ	ETF	561.31	565.23	559.535	564.585	10205642.0
2025-09-02 10:00:00	QQQ	ETF	564.61	565.7	563.44	565.24	5709467.0
2025-09-02 10:30:00	QQQ	ETF	565.22	565.22	562.19	562.85	3734921.0
2025-09-02 11:00:00	QQQ	ETF	562.86	563.25	561.24	561.58	2887551.0
2025-09-02 11:30:00	QQQ	ETF	561.57	561.57	559.57	560.09	3151908.0
2025-09-02 12:00:00	QQQ	ETF	560.09	560.97	559.84	560.55	2356125.0
2025-09-02 12:30:00	QQQ	ETF	560.545	562.1	560.54	561.99	2047440.0

> showing 50 of 44,765 rows — these rows as CSV

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