PREVIEW / etf_30min / 2025-06-04

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-06-04.parquet
  size:    943 KB
  rows:    38,813

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-06-04 04:00:00	SPY	ETF	596.99	597.63	596.84	597.2	15710.0
2025-06-04 04:30:00	SPY	ETF	597.19	597.36	596.84	596.85	9598.0
2025-06-04 05:00:00	SPY	ETF	596.93	597.35	596.83	597.35	3699.0
2025-06-04 05:30:00	SPY	ETF	597.21	597.45	597.14	597.26	5005.0
2025-06-04 06:00:00	SPY	ETF	597.22	597.63	596.95	597.15	13154.0
2025-06-04 06:30:00	SPY	ETF	597.08	597.43	596.92	597.42	15348.0
2025-06-04 07:00:00	SPY	ETF	597.44	597.48	596.95	597.01	24637.0
2025-06-04 07:30:00	SPY	ETF	597.02	597.5	596.92	597.29	23561.0
2025-06-04 08:00:00	SPY	ETF	597.32	597.67	595.46	595.87	291364.0
2025-06-04 08:30:00	SPY	ETF	595.85	596.36	595.58	596.26	214552.0
2025-06-04 09:00:00	SPY	ETF	596.26	596.98	596.1	596.98	242089.0
2025-06-04 09:30:00	SPY	ETF	596.95	597.95	596.79	597.565	4781213.0
2025-06-04 10:00:00	SPY	ETF	597.5	597.7	595.49	597.585	5261882.0
2025-06-04 10:30:00	SPY	ETF	597.58	597.77	596.695	597.525	2561495.0
2025-06-04 11:00:00	SPY	ETF	597.54	597.875	596.97	596.99	2055256.0
2025-06-04 11:30:00	SPY	ETF	596.99	597.41	596.41	596.88	2367442.0
2025-06-04 12:00:00	SPY	ETF	596.87	596.94	595.7909	595.925	2409025.0
2025-06-04 12:30:00	SPY	ETF	595.91	596.84	595.87	596.77	1684130.0
2025-06-04 13:00:00	SPY	ETF	596.77	597.43	596.75	597.315	1749521.0
2025-06-04 13:30:00	SPY	ETF	597.31	597.67	597.05	597.57	1657419.0
2025-06-04 14:00:00	SPY	ETF	597.58	597.93	597.29	597.59	2154175.0
2025-06-04 14:30:00	SPY	ETF	597.59	597.68	596.84	597.0212	2383831.0
2025-06-04 15:00:00	SPY	ETF	597.03	597.6	596.71	597.03	2490255.0
2025-06-04 15:30:00	SPY	ETF	597.03	597.245	595.89	595.9	7143564.0
2025-06-04 16:00:00	SPY	ETF	595.9	596.1	595.66	595.91	2189836.0
2025-06-04 16:30:00	SPY	ETF	595.93	596.0	595.65	595.73	105339.0
2025-06-04 17:00:00	SPY	ETF	595.81	595.89	595.75	595.8	32381.0
2025-06-04 17:30:00	SPY	ETF	595.81	595.89	595.61	595.61	28863.0
2025-06-04 18:00:00	SPY	ETF	595.6	595.9799	595.49	595.9	44969.0
2025-06-04 18:30:00	SPY	ETF	595.95	596.13	595.68	595.68	33317.0
2025-06-04 19:00:00	SPY	ETF	595.78	595.84	595.41	595.56	43109.0
2025-06-04 19:30:00	SPY	ETF	595.5	595.6399	595.37	595.48	16747.0
2025-06-04 04:00:00	QQQ	ETF	527.85	528.55	527.82	528.05	23398.0
2025-06-04 04:30:00	QQQ	ETF	528.08	528.38	527.78	527.78	20995.0
2025-06-04 05:00:00	QQQ	ETF	527.89	528.25	527.86	528.17	14188.0
2025-06-04 05:30:00	QQQ	ETF	528.19	528.45	528.0	528.25	12184.0
2025-06-04 06:00:00	QQQ	ETF	528.26	528.87	527.9	528.11	17709.0
2025-06-04 06:30:00	QQQ	ETF	528.03	528.7	527.9	528.63	37077.0
2025-06-04 07:00:00	QQQ	ETF	528.59	528.66	528.1	528.18	44635.0
2025-06-04 07:30:00	QQQ	ETF	528.19	528.7	528.12	528.54	19136.0
2025-06-04 08:00:00	QQQ	ETF	528.3	528.97	526.31	526.91	277734.0
2025-06-04 08:30:00	QQQ	ETF	526.91	527.66	526.85	527.6288	149488.0
2025-06-04 09:00:00	QQQ	ETF	527.64	528.3	527.39	528.05	116595.0
2025-06-04 09:30:00	QQQ	ETF	528.02	529.66	527.84	528.61	4100443.0
2025-06-04 10:00:00	QQQ	ETF	528.61	528.61	525.9694	528.46	3685895.0
2025-06-04 10:30:00	QQQ	ETF	528.45	528.94	527.56	528.88	1902169.0
2025-06-04 11:00:00	QQQ	ETF	528.89	529.43	528.718	528.73	1783474.0
2025-06-04 11:30:00	QQQ	ETF	528.72	529.2	528.16	528.7	1709987.0
2025-06-04 12:00:00	QQQ	ETF	528.69	528.75	527.5488	527.86	1220931.0
2025-06-04 12:30:00	QQQ	ETF	527.85	528.75	527.69	528.685	975733.0

> showing 50 of 38,813 rows — these rows as CSV

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