PREVIEW / etf_30min / 2025-02-25

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-02-25.parquet
  size:    972 KB
  rows:    40,344

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-02-25 04:00:00	SPY	ETF	595.95	597.04	595.61	596.6	24774.0
2025-02-25 04:30:00	SPY	ETF	596.46	596.75	595.4	595.4	18951.0
2025-02-25 05:00:00	SPY	ETF	595.19	596.07	595.19	596.0	6622.0
2025-02-25 05:30:00	SPY	ETF	596.0	596.0	595.02	595.12	6946.0
2025-02-25 06:00:00	SPY	ETF	595.34	595.82	595.0	595.67	23372.0
2025-02-25 06:30:00	SPY	ETF	595.72	597.01	595.72	596.73	19573.0
2025-02-25 07:00:00	SPY	ETF	596.79	597.43	596.65	597.34	57071.0
2025-02-25 07:30:00	SPY	ETF	597.29	597.88	596.6	597.79	57125.0
2025-02-25 08:00:00	SPY	ETF	596.75	598.22	595.41	598.06	176857.0
2025-02-25 08:30:00	SPY	ETF	598.08	598.2	597.21	597.4	117440.0
2025-02-25 09:00:00	SPY	ETF	597.4	597.5	596.3	597.19	202483.0
2025-02-25 09:30:00	SPY	ETF	597.16	597.89	594.25	595.23	3649380.0
2025-02-25 10:00:00	SPY	ETF	595.25	595.28	590.67	590.85	5454848.0
2025-02-25 10:30:00	SPY	ETF	590.86	593.44	590.5033	592.33	3603198.0
2025-02-25 11:00:00	SPY	ETF	592.34	592.42	590.73	590.87	2191287.0
2025-02-25 11:30:00	SPY	ETF	590.85	593.8084	589.56	593.2	2485974.0
2025-02-25 12:00:00	SPY	ETF	593.13	593.69	592.12	593.68	1362600.0
2025-02-25 12:30:00	SPY	ETF	593.67	594.8	593.46	594.79	1645257.0
2025-02-25 13:00:00	SPY	ETF	594.78	596.18	593.64	593.7	1760358.0
2025-02-25 13:30:00	SPY	ETF	593.705	595.87	593.61	594.71	1485677.0
2025-02-25 14:00:00	SPY	ETF	594.65	594.88	593.01	593.07	1491251.0
2025-02-25 14:30:00	SPY	ETF	593.04	595.58	593.02	595.24	2098439.0
2025-02-25 15:00:00	SPY	ETF	595.23	596.64	594.74	595.89	1986162.0
2025-02-25 15:30:00	SPY	ETF	595.9	596.02	593.57	594.21	5067947.0
2025-02-25 16:00:00	SPY	ETF	594.19	595.38	594.08	595.26	2819393.0
2025-02-25 16:30:00	SPY	ETF	595.24	595.33	594.76	595.03	183852.0
2025-02-25 17:00:00	SPY	ETF	594.93	595.13	594.87	595.07	80437.0
2025-02-25 17:30:00	SPY	ETF	595.0895	595.31	594.96	595.26	66349.0
2025-02-25 18:00:00	SPY	ETF	595.39	595.89	595.39	595.43	76799.0
2025-02-25 18:30:00	SPY	ETF	595.44	595.69	595.3	595.63	24063.0
2025-02-25 19:00:00	SPY	ETF	595.63	595.86	595.41	595.73	17172.0
2025-02-25 19:30:00	SPY	ETF	595.86	595.97	595.61	595.97	13609.0
2025-02-25 20:00:00	SPY	ETF	595.99	596.0	595.99	596.0	300.0
2025-02-25 04:00:00	QQQ	ETF	518.2	518.98	517.3	518.37	66457.0
2025-02-25 04:30:00	QQQ	ETF	518.29	518.64	517.13	517.13	37966.0
2025-02-25 05:00:00	QQQ	ETF	517.43	518.05	517.33	517.87	23951.0
2025-02-25 05:30:00	QQQ	ETF	517.95	518.0	516.72	516.86	68560.0
2025-02-25 06:00:00	QQQ	ETF	517.04	517.83	516.75	517.55	50668.0
2025-02-25 06:30:00	QQQ	ETF	517.62	519.05	517.62	518.65	63320.0
2025-02-25 07:00:00	QQQ	ETF	518.67	519.44	518.53	519.25	86020.0
2025-02-25 07:30:00	QQQ	ETF	519.22	520.3	518.56	520.18	91050.0
2025-02-25 08:00:00	QQQ	ETF	518.62	520.54	517.0096	520.5185	330318.0
2025-02-25 08:30:00	QQQ	ETF	520.48	520.66	519.29	519.41	129661.0
2025-02-25 09:00:00	QQQ	ETF	519.49	519.7	518.45	519.19	103475.0
2025-02-25 09:30:00	QQQ	ETF	519.24	519.32	514.8	516.0	3826096.0
2025-02-25 10:00:00	QQQ	ETF	516.0	516.04	510.39	510.805	4465259.0
2025-02-25 10:30:00	QQQ	ETF	510.84	513.59	510.59	512.21	2633937.0
2025-02-25 11:00:00	QQQ	ETF	512.25	512.31	510.39	510.6005	2084563.0
2025-02-25 11:30:00	QQQ	ETF	510.62	514.58	509.44	513.82	2769933.0
2025-02-25 12:00:00	QQQ	ETF	513.775	514.34	512.35	514.34	1274917.0

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

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