PREVIEW / etf_30min / 2025-07-15

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-07-15.parquet
  size:    933 KB
  rows:    37,842

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-07-15 04:00:00	SPY	ETF	626.65	626.97	626.4	626.95	27965.0
2025-07-15 04:30:00	SPY	ETF	626.9	626.96	626.62	626.62	11743.0
2025-07-15 05:00:00	SPY	ETF	626.62	627.02	626.54	626.94	14382.0
2025-07-15 05:30:00	SPY	ETF	626.99	627.28	626.94	627.21	36994.0
2025-07-15 06:00:00	SPY	ETF	627.2	627.52	627.03	627.52	16407.0
2025-07-15 06:30:00	SPY	ETF	627.53	627.86	627.0	627.21	56251.0
2025-07-15 07:00:00	SPY	ETF	627.2	627.9	625.91	627.24	162467.0
2025-07-15 07:30:00	SPY	ETF	627.18	627.39	626.72	627.11	59464.0
2025-07-15 08:00:00	SPY	ETF	627.2	627.64	625.4	626.4712	293005.0
2025-07-15 08:30:00	SPY	ETF	626.85	627.97	626.62	627.24	581067.0
2025-07-15 09:00:00	SPY	ETF	627.25	627.91	627.0	627.54	222782.0
2025-07-15 09:30:00	SPY	ETF	627.51	627.86	625.585	625.65	5879668.0
2025-07-15 10:00:00	SPY	ETF	625.67	626.3953	625.26	625.48	3613473.0
2025-07-15 10:30:00	SPY	ETF	625.49	625.58	623.8	623.889	5038021.0
2025-07-15 11:00:00	SPY	ETF	623.89	625.21	623.88	625.1007	3974960.0
2025-07-15 11:30:00	SPY	ETF	625.12	625.39	624.51	624.8348	2744739.0
2025-07-15 12:00:00	SPY	ETF	624.85	624.99	624.01	624.2748	2748928.0
2025-07-15 12:30:00	SPY	ETF	624.27	624.575	623.01	623.22	3295902.0
2025-07-15 13:00:00	SPY	ETF	623.22	623.89	622.95	623.86	3258157.0
2025-07-15 13:30:00	SPY	ETF	623.85	624.62	623.85	624.5835	2410553.0
2025-07-15 14:00:00	SPY	ETF	624.59	624.87	624.29	624.6	2363089.0
2025-07-15 14:30:00	SPY	ETF	624.6	624.83	623.255	623.28	3853782.0
2025-07-15 15:00:00	SPY	ETF	623.27	623.7799	623.015	623.29	4257721.0
2025-07-15 15:30:00	SPY	ETF	623.31	623.8	622.075	622.12	8592662.0
2025-07-15 16:00:00	SPY	ETF	622.11	622.3	621.2	621.37	3319374.0
2025-07-15 16:30:00	SPY	ETF	621.35	621.4	621.11	621.26	253359.0
2025-07-15 17:00:00	SPY	ETF	621.39	621.41	621.3	621.36	34463.0
2025-07-15 17:30:00	SPY	ETF	621.35	621.36	621.21	621.22	45131.0
2025-07-15 18:00:00	SPY	ETF	621.23	621.55	620.9	621.15	93931.0
2025-07-15 18:30:00	SPY	ETF	621.05	621.06	620.33	620.88	91612.0
2025-07-15 19:00:00	SPY	ETF	620.8607	621.03	620.4	620.7	37788.0
2025-07-15 19:30:00	SPY	ETF	620.72	621.18	620.71	621.04	36968.0
2025-07-15 04:00:00	QQQ	ETF	558.62	559.75	558.12	559.54	42182.0
2025-07-15 04:30:00	QQQ	ETF	559.65	559.68	559.12	559.21	21008.0
2025-07-15 05:00:00	QQQ	ETF	559.2	559.65	559.12	559.61	36701.0
2025-07-15 05:30:00	QQQ	ETF	559.58	559.81	559.42	559.58	20429.0
2025-07-15 06:00:00	QQQ	ETF	559.68	559.86	559.44	559.84	15624.0
2025-07-15 06:30:00	QQQ	ETF	559.82	560.0	559.41	559.59	94785.0
2025-07-15 07:00:00	QQQ	ETF	559.56	560.05	559.31	559.6	77355.0
2025-07-15 07:30:00	QQQ	ETF	559.63	559.74	559.2	559.48	44000.0
2025-07-15 08:00:00	QQQ	ETF	559.87	559.98	555.793	559.08	194376.0
2025-07-15 08:30:00	QQQ	ETF	559.0	560.44	559.0	560.15	366953.0
2025-07-15 09:00:00	QQQ	ETF	560.19	560.73	559.9892	560.35	258823.0
2025-07-15 09:30:00	QQQ	ETF	560.26	560.8	558.4201	558.7812	4343667.0
2025-07-15 10:00:00	QQQ	ETF	558.8	560.2104	558.37	559.75	2930163.0
2025-07-15 10:30:00	QQQ	ETF	559.77	559.92	557.76	557.845	2781422.0
2025-07-15 11:00:00	QQQ	ETF	557.86	559.59	557.86	559.505	2018275.0
2025-07-15 11:30:00	QQQ	ETF	559.52	559.78	558.85	559.25	1570315.0
2025-07-15 12:00:00	QQQ	ETF	559.25	559.48	558.68	558.96	1195995.0
2025-07-15 12:30:00	QQQ	ETF	558.965	559.31	557.46	557.84	1548985.0

> showing 50 of 37,842 rows — these rows as CSV

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