PREVIEW / etf_30min / 2025-04-28

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-04-28.parquet
  size:    952 KB
  rows:    39,051

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-04-28 04:00:00	SPY	ETF	548.92	549.23	548.56	548.77	28407.0
2025-04-28 04:30:00	SPY	ETF	549.05	549.78	548.77	549.7	5466.0
2025-04-28 05:00:00	SPY	ETF	549.78	550.33	549.39	550.33	8462.0
2025-04-28 05:30:00	SPY	ETF	550.42	550.62	550.08	550.08	5180.0
2025-04-28 06:00:00	SPY	ETF	550.02	550.07	549.06	549.5	13296.0
2025-04-28 06:30:00	SPY	ETF	549.61	549.9	548.83	549.07	13736.0
2025-04-28 07:00:00	SPY	ETF	549.02	549.9	548.77	549.82	52006.0
2025-04-28 07:30:00	SPY	ETF	549.8	550.41	549.71	550.02	53104.0
2025-04-28 08:00:00	SPY	ETF	549.11	550.31	547.39	550.21	349909.0
2025-04-28 08:30:00	SPY	ETF	550.26	551.09	550.17	550.97	129629.0
2025-04-28 09:00:00	SPY	ETF	550.84	551.97	550.8	551.42	195912.0
2025-04-28 09:30:00	SPY	ETF	551.39	553.55	550.13	550.29	4870745.0
2025-04-28 10:00:00	SPY	ETF	550.35	552.1	549.66	550.94	2437194.0
2025-04-28 10:30:00	SPY	ETF	550.95	551.88	549.74	550.53	1796652.0
2025-04-28 11:00:00	SPY	ETF	550.51	551.16	547.03	547.21	2653951.0
2025-04-28 11:30:00	SPY	ETF	547.2	548.5413	547.0934	547.48	2034312.0
2025-04-28 12:00:00	SPY	ETF	547.42	547.6338	545.7	546.02	1953049.0
2025-04-28 12:30:00	SPY	ETF	546.03	547.47	545.94	546.47	1578662.0
2025-04-28 13:00:00	SPY	ETF	546.46	546.85	545.18	545.37	1447377.0
2025-04-28 13:30:00	SPY	ETF	545.345	547.88	545.02	547.705	1446391.0
2025-04-28 14:00:00	SPY	ETF	547.72	548.83	547.3825	548.59	1708401.0
2025-04-28 14:30:00	SPY	ETF	548.56	549.04	547.97	548.73	1314418.0
2025-04-28 15:00:00	SPY	ETF	548.75	550.84	548.64	550.5924	2832938.0
2025-04-28 15:30:00	SPY	ETF	550.52	552.28	550.01	550.94	5543060.0
2025-04-28 16:00:00	SPY	ETF	550.94	551.1136	549.0189	550.23	2883912.0
2025-04-28 16:30:00	SPY	ETF	550.2	550.85	550.0902	550.18	135639.0
2025-04-28 17:00:00	SPY	ETF	550.3	550.3	550.0	550.0207	33440.0
2025-04-28 17:30:00	SPY	ETF	550.11	550.11	549.9	550.04	31104.0
2025-04-28 18:00:00	SPY	ETF	550.0	550.2985	549.57	549.86	57115.0
2025-04-28 18:30:00	SPY	ETF	549.76	550.22	549.5	550.0999	47716.0
2025-04-28 19:00:00	SPY	ETF	550.02	550.9	549.99	550.78	19995.0
2025-04-28 19:30:00	SPY	ETF	550.74	551.2073	550.74	551.1	40728.0
2025-04-28 04:00:00	QQQ	ETF	470.22	471.32	470.0	470.87	41500.0
2025-04-28 04:30:00	QQQ	ETF	470.83	471.93	470.68	471.88	26632.0
2025-04-28 05:00:00	QQQ	ETF	471.89	472.59	471.52	472.58	39536.0
2025-04-28 05:30:00	QQQ	ETF	472.62	472.81	472.29	472.29	23349.0
2025-04-28 06:00:00	QQQ	ETF	472.28	472.35	471.5	471.8	15348.0
2025-04-28 06:30:00	QQQ	ETF	471.79	472.3	471.1	471.29	25578.0
2025-04-28 07:00:00	QQQ	ETF	471.33	472.15	471.04	472.07	101876.0
2025-04-28 07:30:00	QQQ	ETF	472.0	472.62	472.0	472.2	32415.0
2025-04-28 08:00:00	QQQ	ETF	471.2	472.8296	469.48	472.2	185166.0
2025-04-28 08:30:00	QQQ	ETF	472.16	473.01	472.12	472.76	94318.0
2025-04-28 09:00:00	QQQ	ETF	472.73	473.5	472.66	473.01	222085.0
2025-04-28 09:30:00	QQQ	ETF	473.01	474.808	470.75	470.98	3452992.0
2025-04-28 10:00:00	QQQ	ETF	471.04	472.783	470.26	471.58	1772306.0
2025-04-28 10:30:00	QQQ	ETF	471.61	472.79	470.55	471.13	1280827.0
2025-04-28 11:00:00	QQQ	ETF	471.13	471.79	467.28	467.45	2252563.0
2025-04-28 11:30:00	QQQ	ETF	467.454	469.16	467.36	468.1688	1436551.0
2025-04-28 12:00:00	QQQ	ETF	468.09	468.32	466.2055	466.55	1657707.0
2025-04-28 12:30:00	QQQ	ETF	466.62	468.38	466.556	467.4401	1053250.0

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

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