PREVIEW / etf_30min / 2025-08-05

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-08-05.parquet
  size:    996 KB
  rows:    41,361

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-08-05 04:00:00	SPY	ETF	631.62	632.96	631.33	631.89	43311.0
2025-08-05 04:30:00	SPY	ETF	631.94	631.94	631.7	631.74	10555.0
2025-08-05 05:00:00	SPY	ETF	631.69	631.97	631.64	631.87	38262.0
2025-08-05 05:30:00	SPY	ETF	631.8	632.27	631.8	631.96	23455.0
2025-08-05 06:00:00	SPY	ETF	632.1	632.85	632.05	632.64	21976.0
2025-08-05 06:30:00	SPY	ETF	632.69	632.87	632.35	632.73	11459.0
2025-08-05 07:00:00	SPY	ETF	632.7	632.86	632.11	632.45	108923.0
2025-08-05 07:30:00	SPY	ETF	632.44	632.88	632.15	632.65	69264.0
2025-08-05 08:00:00	SPY	ETF	632.67	633.1	631.62	632.17	267197.0
2025-08-05 08:30:00	SPY	ETF	632.13	632.26	631.77	631.86	185294.0
2025-08-05 09:00:00	SPY	ETF	631.86	632.04	631.43	631.78	278385.0
2025-08-05 09:30:00	SPY	ETF	631.81	632.6052	631.22	631.9	4775754.0
2025-08-05 10:00:00	SPY	ETF	631.63	631.85	629.19	629.859	4882651.0
2025-08-05 10:30:00	SPY	ETF	629.865	629.865	627.04	627.91	6683389.0
2025-08-05 11:00:00	SPY	ETF	627.915	628.67	627.43	628.01	3704454.0
2025-08-05 11:30:00	SPY	ETF	627.98	628.395	627.16	628.09	2774607.0
2025-08-05 12:00:00	SPY	ETF	628.075	629.1851	627.96	629.05	2254391.0
2025-08-05 12:30:00	SPY	ETF	629.03	629.8	627.8	628.92	3074598.0
2025-08-05 13:00:00	SPY	ETF	628.89	629.825	628.68	629.695	1464562.0
2025-08-05 13:30:00	SPY	ETF	629.7048	630.32	629.52	630.13	1879806.0
2025-08-05 14:00:00	SPY	ETF	630.14	630.225	628.6	628.71	3306635.0
2025-08-05 14:30:00	SPY	ETF	628.71	629.01	627.87	628.43	2821824.0
2025-08-05 15:00:00	SPY	ETF	628.44	629.11	628.36	628.9799	2645660.0
2025-08-05 15:30:00	SPY	ETF	628.98	629.04	627.81	628.0	6171556.0
2025-08-05 16:00:00	SPY	ETF	628.02	628.85	627.64	627.91	2176247.0
2025-08-05 16:30:00	SPY	ETF	627.97	628.09	627.58	627.89	232536.0
2025-08-05 17:00:00	SPY	ETF	627.73	628.16	627.69	628.04	59655.0
2025-08-05 17:30:00	SPY	ETF	628.08	628.09	627.7	627.78	41096.0
2025-08-05 18:00:00	SPY	ETF	627.88	628.24	626.86	627.4	106279.0
2025-08-05 18:30:00	SPY	ETF	627.5	627.81	627.4619	627.76	9309.0
2025-08-05 19:00:00	SPY	ETF	627.67	628.0596	627.67	627.72	32869.0
2025-08-05 19:30:00	SPY	ETF	627.6699	628.0	627.12	627.23	32801.0
2025-08-05 04:00:00	QQQ	ETF	565.0	566.0	564.59	565.2	50259.0
2025-08-05 04:30:00	QQQ	ETF	565.17	565.17	564.9	565.03	9202.0
2025-08-05 05:00:00	QQQ	ETF	565.07	565.22	564.98	565.04	14232.0
2025-08-05 05:30:00	QQQ	ETF	565.17	565.47	565.14	565.4	13958.0
2025-08-05 06:00:00	QQQ	ETF	565.39	566.21	565.39	566.09	23569.0
2025-08-05 06:30:00	QQQ	ETF	566.06	566.45	565.88	566.29	25164.0
2025-08-05 07:00:00	QQQ	ETF	566.25	566.52	566.05	566.06	46286.0
2025-08-05 07:30:00	QQQ	ETF	566.04	566.57	565.8	566.26	72979.0
2025-08-05 08:00:00	QQQ	ETF	566.31	566.721	563.677	565.85	271403.0
2025-08-05 08:30:00	QQQ	ETF	565.9	566.21	565.51	565.76	219605.0
2025-08-05 09:00:00	QQQ	ETF	565.72	565.9108	565.2	565.39	186527.0
2025-08-05 09:30:00	QQQ	ETF	565.39	566.5608	564.315	566.07	3956013.0
2025-08-05 10:00:00	QQQ	ETF	566.01	566.15	563.28	563.95	3104060.0
2025-08-05 10:30:00	QQQ	ETF	563.95	563.995	560.3	561.36	4015144.0
2025-08-05 11:00:00	QQQ	ETF	561.35	562.2671	560.64	561.11	2874357.0
2025-08-05 11:30:00	QQQ	ETF	561.09	561.43	559.73	560.76	2205985.0
2025-08-05 12:00:00	QQQ	ETF	560.74	562.08	560.7	561.76	1761302.0
2025-08-05 12:30:00	QQQ	ETF	561.73	562.41	560.3	561.33	1820132.0

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

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