PREVIEW / etf_30min / 2025-05-28

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-05-28.parquet
  size:    949 KB
  rows:    39,143

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-05-28 04:00:00	SPY	ETF	589.98	590.25	589.9	590.09	33063.0
2025-05-28 04:30:00	SPY	ETF	590.01	590.3	589.83	589.87	6707.0
2025-05-28 05:00:00	SPY	ETF	589.8	590.03	589.5	589.61	15358.0
2025-05-28 05:30:00	SPY	ETF	589.55	590.0	589.49	590.0	22791.0
2025-05-28 06:00:00	SPY	ETF	590.1	590.52	589.96	590.47	11196.0
2025-05-28 06:30:00	SPY	ETF	590.52	591.91	590.52	591.88	35474.0
2025-05-28 07:00:00	SPY	ETF	591.87	591.901	591.21	591.33	37863.0
2025-05-28 07:30:00	SPY	ETF	591.42	591.65	591.09	591.46	55104.0
2025-05-28 08:00:00	SPY	ETF	591.43	591.9	589.9204	591.6	123429.0
2025-05-28 08:30:00	SPY	ETF	591.56	592.08	591.3	591.4	108068.0
2025-05-28 09:00:00	SPY	ETF	591.4	591.74	591.1	591.58	169357.0
2025-05-28 09:30:00	SPY	ETF	591.57	592.7688	590.54	590.7885	5797608.0
2025-05-28 10:00:00	SPY	ETF	590.8	591.155	589.95	590.22	2997185.0
2025-05-28 10:30:00	SPY	ETF	590.23	590.33	589.22	589.34	2708437.0
2025-05-28 11:00:00	SPY	ETF	589.335	590.14	589.13	589.4	2402143.0
2025-05-28 11:30:00	SPY	ETF	589.39	589.68	588.97	589.06	2158364.0
2025-05-28 12:00:00	SPY	ETF	589.06	589.98	589.055	589.875	1776704.0
2025-05-28 12:30:00	SPY	ETF	589.86	590.245	589.635	589.93	1603157.0
2025-05-28 13:00:00	SPY	ETF	589.93	590.615	589.8	590.2899	1852139.0
2025-05-28 13:30:00	SPY	ETF	590.27	590.31	589.43	589.7021	1741756.0
2025-05-28 14:00:00	SPY	ETF	589.7	590.44	589.66	590.115	1847550.0
2025-05-28 14:30:00	SPY	ETF	590.1	590.3282	587.92	589.76	4344268.0
2025-05-28 15:00:00	SPY	ETF	589.75	590.79	589.29	589.515	4509110.0
2025-05-28 15:30:00	SPY	ETF	589.51	589.645	586.985	587.71	9102564.0
2025-05-28 16:00:00	SPY	ETF	587.7	589.33	586.9	588.85	3267498.0
2025-05-28 16:30:00	SPY	ETF	588.89	590.19	587.68	590.11	584406.0
2025-05-28 17:00:00	SPY	ETF	590.0802	590.16	589.0	589.0	348004.0
2025-05-28 17:30:00	SPY	ETF	589.1	589.7	588.85	589.63	70611.0
2025-05-28 18:00:00	SPY	ETF	589.66	589.9	589.19	589.79	180627.0
2025-05-28 18:30:00	SPY	ETF	589.79	592.12	589.7	591.95	168273.0
2025-05-28 19:00:00	SPY	ETF	591.99	597.1	591.99	595.22	849208.0
2025-05-28 19:30:00	SPY	ETF	595.18	597.13	595.13	596.609	719647.0
2025-05-28 04:00:00	QQQ	ETF	520.59	520.72	520.15	520.42	45847.0
2025-05-28 04:30:00	QQQ	ETF	520.35	520.63	520.09	520.15	16545.0
2025-05-28 05:00:00	QQQ	ETF	520.09	520.41	519.89	520.07	27004.0
2025-05-28 05:30:00	QQQ	ETF	520.01	520.38	519.88	520.38	14030.0
2025-05-28 06:00:00	QQQ	ETF	520.38	521.2	520.37	521.02	23587.0
2025-05-28 06:30:00	QQQ	ETF	521.07	522.52	521.06	522.52	71567.0
2025-05-28 07:00:00	QQQ	ETF	522.48	522.65	521.791	521.95	51609.0
2025-05-28 07:30:00	QQQ	ETF	521.98	522.37	521.83	522.21	57055.0
2025-05-28 08:00:00	QQQ	ETF	522.4	522.77	520.054	522.4	152678.0
2025-05-28 08:30:00	QQQ	ETF	522.4088	522.97	522.13	522.27	96969.0
2025-05-28 09:00:00	QQQ	ETF	522.2799	522.55	521.79	522.16	123709.0
2025-05-28 09:30:00	QQQ	ETF	522.18	523.68	520.91	521.27	3845302.0
2025-05-28 10:00:00	QQQ	ETF	521.28	521.7599	520.59	521.0	1910211.0
2025-05-28 10:30:00	QQQ	ETF	521.01	521.19	520.3	520.4116	1740210.0
2025-05-28 11:00:00	QQQ	ETF	520.4193	521.52	520.33	521.055	1688192.0
2025-05-28 11:30:00	QQQ	ETF	521.05	521.285	520.46	520.53	1249796.0
2025-05-28 12:00:00	QQQ	ETF	520.5387	521.49	520.53	521.33	1018408.0
2025-05-28 12:30:00	QQQ	ETF	521.32	521.605	520.92	521.22	860440.0

> showing 50 of 39,143 rows — these rows as CSV

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