PREVIEW / etf_30min / 2025-03-03

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-03-03.parquet
  size:    1002 KB
  rows:    42,276

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-03 04:00:00	SPY	ETF	593.88	594.93	593.88	594.78	78365.0
2025-03-03 04:30:00	SPY	ETF	594.86	595.92	594.86	595.92	15308.0
2025-03-03 05:00:00	SPY	ETF	595.9	596.0	595.22	595.37	10003.0
2025-03-03 05:30:00	SPY	ETF	595.41	595.88	595.36	595.88	10228.0
2025-03-03 06:00:00	SPY	ETF	595.84	596.3	595.84	596.25	14501.0
2025-03-03 06:30:00	SPY	ETF	596.28	596.56	595.99	596.56	22776.0
2025-03-03 07:00:00	SPY	ETF	596.48	597.63	596.35	597.08	189178.0
2025-03-03 07:30:00	SPY	ETF	597.14	597.2	596.7	596.74	88093.0
2025-03-03 08:00:00	SPY	ETF	596.46	597.62	593.5	596.6	142228.0
2025-03-03 08:30:00	SPY	ETF	596.6	596.6	595.75	596.17	158149.0
2025-03-03 09:00:00	SPY	ETF	596.2	596.95	596.0	596.01	237592.0
2025-03-03 09:30:00	SPY	ETF	596.18	597.34	592.44	593.05	5023662.0
2025-03-03 10:00:00	SPY	ETF	592.67	594.115	590.71	594.115	4076545.0
2025-03-03 10:30:00	SPY	ETF	594.09	595.125	592.22	592.4159	2190726.0
2025-03-03 11:00:00	SPY	ETF	592.41	594.55	592.28	592.4	1914377.0
2025-03-03 11:30:00	SPY	ETF	592.43	593.4236	591.17	593.055	1841431.0
2025-03-03 12:00:00	SPY	ETF	593.04	594.15	592.7	593.81	1045887.0
2025-03-03 12:30:00	SPY	ETF	593.8	594.22	591.42	592.015	1009002.0
2025-03-03 13:00:00	SPY	ETF	592.015	592.13	587.87	588.0902	2736422.0
2025-03-03 13:30:00	SPY	ETF	588.115	589.99	587.48	589.17	3479518.0
2025-03-03 14:00:00	SPY	ETF	589.12	590.23	588.2401	588.495	1881733.0
2025-03-03 14:30:00	SPY	ETF	588.49	590.65	585.97	586.05	3838779.0
2025-03-03 15:00:00	SPY	ETF	586.03	586.08	580.83	581.21	8296046.0
2025-03-03 15:30:00	SPY	ETF	581.19	584.11	579.9	583.97	11011122.0
2025-03-03 16:00:00	SPY	ETF	583.98	587.9613	583.77	585.15	4242993.0
2025-03-03 16:30:00	SPY	ETF	585.17	585.3	585.0	585.17	227215.0
2025-03-03 17:00:00	SPY	ETF	585.1541	585.3	584.8	584.87	152744.0
2025-03-03 17:30:00	SPY	ETF	584.87	585.02	584.72	584.92	50235.0
2025-03-03 18:00:00	SPY	ETF	584.92	585.97	584.48	585.5	254239.0
2025-03-03 18:30:00	SPY	ETF	585.5	585.7	584.55	584.65	51782.0
2025-03-03 19:00:00	SPY	ETF	584.73	585.32	584.38	585.09	126111.0
2025-03-03 19:30:00	SPY	ETF	585.0	585.55	584.0	585.4	114606.0
2025-03-03 04:00:00	QQQ	ETF	508.92	509.67	508.44	509.52	77420.0
2025-03-03 04:30:00	QQQ	ETF	509.53	510.63	509.53	510.43	35018.0
2025-03-03 05:00:00	QQQ	ETF	510.52	510.62	509.92	510.0	10790.0
2025-03-03 05:30:00	QQQ	ETF	510.1	510.42	510.1	510.34	11510.0
2025-03-03 06:00:00	QQQ	ETF	510.2	510.92	510.12	510.92	28895.0
2025-03-03 06:30:00	QQQ	ETF	510.9	511.24	510.46	511.18	40128.0
2025-03-03 07:00:00	QQQ	ETF	511.15	512.85	510.64	512.02	205099.0
2025-03-03 07:30:00	QQQ	ETF	512.08	512.13	511.65	511.85	67900.0
2025-03-03 08:00:00	QQQ	ETF	511.36	512.46	507.64	511.8801	252858.0
2025-03-03 08:30:00	QQQ	ETF	511.88	511.9	511.0	511.7209	162106.0
2025-03-03 09:00:00	QQQ	ETF	511.64	512.5	511.31	511.47	185006.0
2025-03-03 09:30:00	QQQ	ETF	511.52	513.04	505.8684	506.31	3869261.0
2025-03-03 10:00:00	QQQ	ETF	506.3	509.13	504.29	509.13	2666308.0
2025-03-03 10:30:00	QQQ	ETF	509.14	509.85	506.455	506.6664	1486847.0
2025-03-03 11:00:00	QQQ	ETF	506.7	509.77	506.69	507.38	1121477.0
2025-03-03 11:30:00	QQQ	ETF	507.42	508.72	506.08	508.25	1385164.0
2025-03-03 12:00:00	QQQ	ETF	508.24	509.0	507.7501	508.72	885315.0
2025-03-03 12:30:00	QQQ	ETF	508.7223	509.26	505.81	506.51	972896.0

> showing 50 of 42,276 rows — these rows as CSV

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