PREVIEW / etf_30min / 2025-02-27

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-02-27.parquet
  size:    949 KB
  rows:    39,410

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-27 04:00:00	SPY	ETF	597.61	597.66	597.11	597.65	23248.0
2025-02-27 04:30:00	SPY	ETF	597.62	597.93	597.58	597.8	9349.0
2025-02-27 05:00:00	SPY	ETF	597.83	598.06	597.71	597.8	6188.0
2025-02-27 05:30:00	SPY	ETF	597.72	597.82	597.5	597.81	3610.0
2025-02-27 06:00:00	SPY	ETF	597.78	598.17	597.78	598.07	14118.0
2025-02-27 06:30:00	SPY	ETF	597.92	598.23	597.82	598.23	17360.0
2025-02-27 07:00:00	SPY	ETF	598.33	598.53	598.1	598.3	306993.0
2025-02-27 07:30:00	SPY	ETF	598.35	598.68	597.87	597.98	144859.0
2025-02-27 08:00:00	SPY	ETF	598.5	598.63	594.79	597.4001	215380.0
2025-02-27 08:30:00	SPY	ETF	597.33	598.2	595.06	595.88	1313703.0
2025-02-27 09:00:00	SPY	ETF	595.85	597.29	595.6	596.86	402043.0
2025-02-27 09:30:00	SPY	ETF	596.85	598.02	592.14	592.435	4888777.0
2025-02-27 10:00:00	SPY	ETF	592.43	596.52	590.52	595.45	5146511.0
2025-02-27 10:30:00	SPY	ETF	595.45	595.72	593.29	593.432	2053561.0
2025-02-27 11:00:00	SPY	ETF	593.44	596.24	593.22	594.1213	1729411.0
2025-02-27 11:30:00	SPY	ETF	594.13	594.9589	592.28	592.45	1069252.0
2025-02-27 12:00:00	SPY	ETF	592.49	593.99	591.4	593.95	1645743.0
2025-02-27 12:30:00	SPY	ETF	593.96	594.475	592.37	593.42	1378823.0
2025-02-27 13:00:00	SPY	ETF	593.44	595.16	593.305	594.59	1424938.0
2025-02-27 13:30:00	SPY	ETF	594.63	594.95	593.641	593.71	932277.0
2025-02-27 14:00:00	SPY	ETF	593.76	593.84	590.68	590.7697	1869625.0
2025-02-27 14:30:00	SPY	ETF	590.782	590.8	588.34	589.28	4057498.0
2025-02-27 15:00:00	SPY	ETF	589.3	589.35	586.24	586.31	4975431.0
2025-02-27 15:30:00	SPY	ETF	586.363	587.57	584.65	585.04	9963229.0
2025-02-27 16:00:00	SPY	ETF	585.045	585.91	584.72	585.73	3802953.0
2025-02-27 16:30:00	SPY	ETF	585.77	586.07	585.4	585.5699	169026.0
2025-02-27 17:00:00	SPY	ETF	585.61	585.66	585.18	585.4	116286.0
2025-02-27 17:30:00	SPY	ETF	585.4	585.59	585.28	585.51	51449.0
2025-02-27 18:00:00	SPY	ETF	585.55	586.25	585.55	585.7208	97124.0
2025-02-27 18:30:00	SPY	ETF	585.85	586.21	585.6	586.05	143074.0
2025-02-27 19:00:00	SPY	ETF	586.15	586.25	585.4	585.56	25654.0
2025-02-27 19:30:00	SPY	ETF	585.56	585.73	584.89	584.89	36403.0
2025-02-27 04:00:00	QQQ	ETF	516.77	517.85	516.77	517.66	39837.0
2025-02-27 04:30:00	QQQ	ETF	517.86	517.96	517.51	517.69	12687.0
2025-02-27 05:00:00	QQQ	ETF	517.72	518.2	517.49	517.75	13244.0
2025-02-27 05:30:00	QQQ	ETF	517.7	517.78	517.4	517.71	30195.0
2025-02-27 06:00:00	QQQ	ETF	517.68	518.2	517.65	517.72	32730.0
2025-02-27 06:30:00	QQQ	ETF	517.71	518.21	517.47	518.19	21591.0
2025-02-27 07:00:00	QQQ	ETF	518.17	518.88	518.0	518.669	72326.0
2025-02-27 07:30:00	QQQ	ETF	518.72	519.19	518.32	518.42	74255.0
2025-02-27 08:00:00	QQQ	ETF	518.17	519.0988	514.0	518.24	189923.0
2025-02-27 08:30:00	QQQ	ETF	518.22	518.79	516.4	517.35	386305.0
2025-02-27 09:00:00	QQQ	ETF	517.22	518.92	516.9912	518.19	187069.0
2025-02-27 09:30:00	QQQ	ETF	518.13	519.0699	509.77	510.03	4843544.0
2025-02-27 10:00:00	QQQ	ETF	510.03	513.88	507.335	512.945	7298817.0
2025-02-27 10:30:00	QQQ	ETF	512.93	513.19	510.14	510.3117	1728087.0
2025-02-27 11:00:00	QQQ	ETF	510.36	513.744	510.09	511.46	1312419.0
2025-02-27 11:30:00	QQQ	ETF	511.47	512.34	509.77	510.0104	883853.0
2025-02-27 12:00:00	QQQ	ETF	510.06	511.27	508.83	511.23	1201950.0
2025-02-27 12:30:00	QQQ	ETF	511.22	511.75	509.68	510.78	910142.0

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

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