PREVIEW / etf_30min / 2025-04-25

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-04-25.parquet
  size:    953 KB
  rows:    38,915

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-25 04:00:00	SPY	ETF	549.35	550.0	549.02	549.38	23926.0
2025-04-25 04:30:00	SPY	ETF	549.41	549.41	548.4	548.77	13798.0
2025-04-25 05:00:00	SPY	ETF	548.85	549.08	547.68	548.95	32718.0
2025-04-25 05:30:00	SPY	ETF	548.9	548.92	548.09	548.75	13323.0
2025-04-25 06:00:00	SPY	ETF	548.64	549.3	546.39	546.7	97848.0
2025-04-25 06:30:00	SPY	ETF	547.0	547.2	544.34	544.76	167361.0
2025-04-25 07:00:00	SPY	ETF	544.62	546.75	544.4	546.45	232642.0
2025-04-25 07:30:00	SPY	ETF	546.38	546.49	545.0	545.5	86840.0
2025-04-25 08:00:00	SPY	ETF	545.5	550.64	544.7	545.46	409329.0
2025-04-25 08:30:00	SPY	ETF	545.45	546.4	545.14	545.28	254422.0
2025-04-25 09:00:00	SPY	ETF	545.29	546.85	544.66	546.66	305493.0
2025-04-25 09:30:00	SPY	ETF	546.65	548.1142	544.72	544.88	4214037.0
2025-04-25 10:00:00	SPY	ETF	544.94	547.93	543.89	544.56	4711929.0
2025-04-25 10:30:00	SPY	ETF	544.6	547.01	543.69	546.46	2336661.0
2025-04-25 11:00:00	SPY	ETF	546.47	547.5	545.86	546.46	1504473.0
2025-04-25 11:30:00	SPY	ETF	546.494	547.3452	545.7	547.07	1264773.0
2025-04-25 12:00:00	SPY	ETF	547.09	548.57	546.96	548.33	1427017.0
2025-04-25 12:30:00	SPY	ETF	548.35	549.2	547.98	549.1	1523994.0
2025-04-25 13:00:00	SPY	ETF	549.12	551.05	548.81	550.9744	2229512.0
2025-04-25 13:30:00	SPY	ETF	550.96	550.99	546.76	547.91	4300744.0
2025-04-25 14:00:00	SPY	ETF	547.9	550.15	547.535	549.74	2572584.0
2025-04-25 14:30:00	SPY	ETF	549.75	550.75	549.305	549.84	2110591.0
2025-04-25 15:00:00	SPY	ETF	549.8	550.62	549.515	549.645	1739793.0
2025-04-25 15:30:00	SPY	ETF	549.63	550.91	548.76	550.52	5694487.0
2025-04-25 16:00:00	SPY	ETF	550.55	551.4	550.15	550.84	3880615.0
2025-04-25 16:30:00	SPY	ETF	550.82	551.77	550.55	550.82	169393.0
2025-04-25 17:00:00	SPY	ETF	550.85	551.05	550.85	551.0	103878.0
2025-04-25 17:30:00	SPY	ETF	551.0	551.0	550.64	550.6953	585861.0
2025-04-25 18:00:00	SPY	ETF	550.6896	550.8	550.5792	550.8	46100.0
2025-04-25 18:30:00	SPY	ETF	550.8001	551.1478	550.8	551.1	36163.0
2025-04-25 19:00:00	SPY	ETF	551.15	551.15	550.877	551.1	12358.0
2025-04-25 19:30:00	SPY	ETF	551.15	551.25	551.03	551.23	18429.0
2025-04-25 04:00:00	QQQ	ETF	469.75	470.55	469.31	469.89	36960.0
2025-04-25 04:30:00	QQQ	ETF	469.84	470.11	469.0	469.37	32537.0
2025-04-25 05:00:00	QQQ	ETF	469.31	469.42	468.05	469.33	56302.0
2025-04-25 05:30:00	QQQ	ETF	469.18	469.38	468.58	469.31	15914.0
2025-04-25 06:00:00	QQQ	ETF	469.09	469.7	467.27	467.27	87222.0
2025-04-25 06:30:00	QQQ	ETF	467.2	467.61	464.98	465.27	125408.0
2025-04-25 07:00:00	QQQ	ETF	465.23	467.43	465.23	467.31	132112.0
2025-04-25 07:30:00	QQQ	ETF	467.1	467.26	465.57	465.9	89074.0
2025-04-25 08:00:00	QQQ	ETF	465.6	471.54	465.0304	465.87	354448.0
2025-04-25 08:30:00	QQQ	ETF	465.88	466.74	465.5	465.65	224853.0
2025-04-25 09:00:00	QQQ	ETF	465.56	467.07	464.97	467.05	383213.0
2025-04-25 09:30:00	QQQ	ETF	466.97	468.47	465.39	465.96	3219024.0
2025-04-25 10:00:00	QQQ	ETF	466.1	469.49	465.54	466.22	3096528.0
2025-04-25 10:30:00	QQQ	ETF	466.285	468.45	465.39	467.8572	1513698.0
2025-04-25 11:00:00	QQQ	ETF	467.85	469.2	467.21	468.15	1134303.0
2025-04-25 11:30:00	QQQ	ETF	468.11	468.78	467.2202	468.46	1121148.0
2025-04-25 12:00:00	QQQ	ETF	468.46	470.07	468.16	469.93	1115272.0
2025-04-25 12:30:00	QQQ	ETF	469.94	471.02	469.67	471.0	1327988.0

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

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