PREVIEW / etf_30min / 2025-03-12

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-03-12.parquet
  size:    979 KB
  rows:    40,235

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-03-12 04:00:00	SPY	ETF	558.17	558.67	557.4	557.4	33369.0
2025-03-12 04:30:00	SPY	ETF	557.65	559.66	557.65	559.66	10968.0
2025-03-12 05:00:00	SPY	ETF	559.8	559.91	559.35	559.68	9376.0
2025-03-12 05:30:00	SPY	ETF	559.8	560.14	559.47	560.14	14622.0
2025-03-12 06:00:00	SPY	ETF	560.14	560.25	559.18	559.3	15982.0
2025-03-12 06:30:00	SPY	ETF	559.32	560.25	559.32	559.92	36174.0
2025-03-12 07:00:00	SPY	ETF	559.91	561.03	559.9	560.65	142818.0
2025-03-12 07:30:00	SPY	ETF	560.8	561.25	560.49	560.84	108287.0
2025-03-12 08:00:00	SPY	ETF	560.43	561.2483	555.92	561.0	361584.0
2025-03-12 08:30:00	SPY	ETF	561.15	567.0	561.07	562.96	1957496.0
2025-03-12 09:00:00	SPY	ETF	562.89	563.16	561.44	562.17	1834858.0
2025-03-12 09:30:00	SPY	ETF	562.17	563.11	558.34	559.48	8158259.0
2025-03-12 10:00:00	SPY	ETF	559.46	560.5805	557.98	559.01	3178315.0
2025-03-12 10:30:00	SPY	ETF	559.07	559.27	555.5	555.6001	3296201.0
2025-03-12 11:00:00	SPY	ETF	555.62	557.2	553.69	556.9	3904391.0
2025-03-12 11:30:00	SPY	ETF	556.94	559.23	556.575	559.12	2225452.0
2025-03-12 12:00:00	SPY	ETF	559.1	560.86	558.24	560.27	2514928.0
2025-03-12 12:30:00	SPY	ETF	560.31	561.26	558.69	559.07	2322201.0
2025-03-12 13:00:00	SPY	ETF	559.1	561.46	558.66	561.42	1493500.0
2025-03-12 13:30:00	SPY	ETF	561.4	561.78	557.94	558.01	1915993.0
2025-03-12 14:00:00	SPY	ETF	558.04	560.24	557.81	560.2	1798274.0
2025-03-12 14:30:00	SPY	ETF	560.21	561.9	559.89	561.2246	1884768.0
2025-03-12 15:00:00	SPY	ETF	561.2	561.2	558.87	559.64	2256483.0
2025-03-12 15:30:00	SPY	ETF	559.64	560.29	558.17	558.91	6957391.0
2025-03-12 16:00:00	SPY	ETF	558.91	559.0844	556.3729	558.56	3528855.0
2025-03-12 16:30:00	SPY	ETF	558.589	558.75	558.12	558.39	91697.0
2025-03-12 17:00:00	SPY	ETF	558.37	558.52	558.31	558.4	42994.0
2025-03-12 17:30:00	SPY	ETF	558.46	558.61	558.4	558.4	19896.0
2025-03-12 18:00:00	SPY	ETF	558.52	559.71	558.15	559.45	74789.0
2025-03-12 18:30:00	SPY	ETF	559.44	559.5	559.03	559.36	23416.0
2025-03-12 19:00:00	SPY	ETF	559.5	560.15	559.5	560.0	36963.0
2025-03-12 19:30:00	SPY	ETF	559.95	560.72	559.893	560.71	47086.0
2025-03-12 20:00:00	SPY	ETF	560.67	560.67	560.67	560.67	340.0
2025-03-12 04:00:00	QQQ	ETF	473.74	474.38	472.95	473.22	47917.0
2025-03-12 04:30:00	QQQ	ETF	473.39	475.68	473.39	475.47	47956.0
2025-03-12 05:00:00	QQQ	ETF	475.55	475.74	475.01	475.35	44417.0
2025-03-12 05:30:00	QQQ	ETF	475.29	475.83	475.0	475.79	32106.0
2025-03-12 06:00:00	QQQ	ETF	475.68	475.82	474.93	475.08	21184.0
2025-03-12 06:30:00	QQQ	ETF	475.16	475.78	474.99	475.62	42117.0
2025-03-12 07:00:00	QQQ	ETF	475.53	476.7	475.51	476.38	100836.0
2025-03-12 07:30:00	QQQ	ETF	476.45	476.94	476.1	476.4	192425.0
2025-03-12 08:00:00	QQQ	ETF	475.89	476.94	471.79	476.32	376078.0
2025-03-12 08:30:00	QQQ	ETF	476.6	481.6	476.6	479.7	1535654.0
2025-03-12 09:00:00	QQQ	ETF	479.74	480.06	478.4201	479.07	458636.0
2025-03-12 09:30:00	QQQ	ETF	479.15	481.06	476.54	477.86	5547854.0
2025-03-12 10:00:00	QQQ	ETF	477.81	479.8	476.33	477.55	2817185.0
2025-03-12 10:30:00	QQQ	ETF	477.57	477.8593	473.6438	473.73	2384686.0
2025-03-12 11:00:00	QQQ	ETF	473.745	475.41	471.79	474.925	2674822.0
2025-03-12 11:30:00	QQQ	ETF	474.98	477.7	474.62	477.59	2334823.0
2025-03-12 12:00:00	QQQ	ETF	477.61	479.29	476.46	478.71	1965758.0

> showing 50 of 40,235 rows — these rows as CSV

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