PREVIEW / etf_30min / 2025-07-17

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-07-17.parquet
  size:    1011 KB
  rows:    41,163

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-17 04:00:00	SPY	ETF	624.4	624.64	624.24	624.41	13108.0
2025-07-17 04:30:00	SPY	ETF	624.45	624.7	624.29	624.69	9999.0
2025-07-17 05:00:00	SPY	ETF	624.59	625.01	624.59	624.85	13117.0
2025-07-17 05:30:00	SPY	ETF	624.93	625.02	624.64	624.64	7308.0
2025-07-17 06:00:00	SPY	ETF	624.68	624.72	624.45	624.59	12135.0
2025-07-17 06:30:00	SPY	ETF	624.65	624.74	624.25	624.3	31613.0
2025-07-17 07:00:00	SPY	ETF	624.3	624.34	623.9	624.22	36064.0
2025-07-17 07:30:00	SPY	ETF	624.15	624.15	623.75	623.87	29013.0
2025-07-17 08:00:00	SPY	ETF	624.01	625.0	623.27	624.14	102907.0
2025-07-17 08:30:00	SPY	ETF	624.24	625.41	623.92	625.34	243124.0
2025-07-17 09:00:00	SPY	ETF	625.34	625.61	624.44	624.44	255616.0
2025-07-17 09:30:00	SPY	ETF	624.43	626.1981	624.18	625.78	4942445.0
2025-07-17 10:00:00	SPY	ETF	625.79	626.23	624.84	625.46	3314573.0
2025-07-17 10:30:00	SPY	ETF	625.46	625.92	625.01	625.812	2699557.0
2025-07-17 11:00:00	SPY	ETF	625.815	626.72	625.79	626.67	3322196.0
2025-07-17 11:30:00	SPY	ETF	626.6712	627.27	626.56	627.2147	2637233.0
2025-07-17 12:00:00	SPY	ETF	627.21	627.51	626.78	626.85	2593486.0
2025-07-17 12:30:00	SPY	ETF	626.84	626.92	626.525	626.83	1701692.0
2025-07-17 13:00:00	SPY	ETF	626.83	627.098	626.665	627.025	2126359.0
2025-07-17 13:30:00	SPY	ETF	627.03	627.46	626.98	627.4301	1554239.0
2025-07-17 14:00:00	SPY	ETF	627.44	627.88	627.14	627.8322	2568904.0
2025-07-17 14:30:00	SPY	ETF	627.84	628.14	627.645	627.965	2298957.0
2025-07-17 15:00:00	SPY	ETF	627.97	628.4048	627.945	627.98	3285867.0
2025-07-17 15:30:00	SPY	ETF	627.97	628.32	627.65	627.98	11574344.0
2025-07-17 16:00:00	SPY	ETF	627.98	628.24	627.6144	628.15	2383377.0
2025-07-17 16:30:00	SPY	ETF	628.14	628.32	627.969	628.0	144384.0
2025-07-17 17:00:00	SPY	ETF	628.01	628.03	627.92	627.96	35939.0
2025-07-17 17:30:00	SPY	ETF	627.96	628.05	627.8	628.05	18981.0
2025-07-17 18:00:00	SPY	ETF	628.05	628.19	627.77	628.14	36138.0
2025-07-17 18:30:00	SPY	ETF	628.14	628.14	627.97	628.02	13884.0
2025-07-17 19:00:00	SPY	ETF	628.19	628.66	628.07	628.35	21215.0
2025-07-17 19:30:00	SPY	ETF	628.26	628.8502	628.25	628.71	23336.0
2025-07-17 04:00:00	QQQ	ETF	557.62	558.43	557.62	558.02	19836.0
2025-07-17 04:30:00	QQQ	ETF	558.09	558.34	557.9	558.23	7110.0
2025-07-17 05:00:00	QQQ	ETF	558.17	558.66	558.17	558.42	7230.0
2025-07-17 05:30:00	QQQ	ETF	558.51	558.64	558.26	558.27	5765.0
2025-07-17 06:00:00	QQQ	ETF	558.28	558.38	558.17	558.35	9312.0
2025-07-17 06:30:00	QQQ	ETF	558.35	558.36	557.78	557.86	24369.0
2025-07-17 07:00:00	QQQ	ETF	557.81	557.95	557.41	557.8	17849.0
2025-07-17 07:30:00	QQQ	ETF	557.8	557.8	557.44	557.74	17817.0
2025-07-17 08:00:00	QQQ	ETF	557.7	559.2	556.38	557.91	122507.0
2025-07-17 08:30:00	QQQ	ETF	557.99	559.19	557.74	559.13	146033.0
2025-07-17 09:00:00	QQQ	ETF	559.12	559.4	557.51	558.01	205407.0
2025-07-17 09:30:00	QQQ	ETF	557.99	559.42	557.21	559.2	3530514.0
2025-07-17 10:00:00	QQQ	ETF	559.22	559.81	558.39	559.31	2317785.0
2025-07-17 10:30:00	QQQ	ETF	559.32	560.37	559.15	560.2625	1908459.0
2025-07-17 11:00:00	QQQ	ETF	560.27	561.44	560.245	561.0849	2355857.0
2025-07-17 11:30:00	QQQ	ETF	561.085	561.68	560.81	561.58	1535448.0
2025-07-17 12:00:00	QQQ	ETF	561.58	562.21	561.48	561.825	1846943.0
2025-07-17 12:30:00	QQQ	ETF	561.82	561.9601	561.52	561.775	1110492.0

> showing 50 of 41,163 rows — these rows as CSV

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