PREVIEW / etf_30min / 2025-01-28

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-01-28.parquet
  size:    944 KB
  rows:    38,018

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-01-28 04:00:00	SPY	ETF	601.0	601.56	601.0	601.09	10782.0
2025-01-28 04:30:00	SPY	ETF	601.01	601.57	600.95	601.55	13107.0
2025-01-28 05:00:00	SPY	ETF	601.77	602.1	601.7	601.91	17477.0
2025-01-28 05:30:00	SPY	ETF	602.0	602.01	601.67	601.67	4202.0
2025-01-28 06:00:00	SPY	ETF	601.84	602.02	601.25	601.29	10118.0
2025-01-28 06:30:00	SPY	ETF	601.26	601.26	600.69	600.83	35692.0
2025-01-28 07:00:00	SPY	ETF	600.83	600.91	599.5	599.86	248674.0
2025-01-28 07:30:00	SPY	ETF	599.66	600.87	599.55	600.62	69992.0
2025-01-28 08:00:00	SPY	ETF	599.97	601.39	598.85	601.2486	133401.0
2025-01-28 08:30:00	SPY	ETF	601.19	601.35	600.05	600.25	61264.0
2025-01-28 09:00:00	SPY	ETF	600.27	600.73	599.99	600.53	148028.0
2025-01-28 09:30:00	SPY	ETF	600.62	600.78	597.25	598.9351	3782515.0
2025-01-28 10:00:00	SPY	ETF	598.9	602.79	598.842	602.46	2792778.0
2025-01-28 10:30:00	SPY	ETF	602.49	603.09	601.73	603.06	2071165.0
2025-01-28 11:00:00	SPY	ETF	603.06	603.57	601.03	601.42	1536826.0
2025-01-28 11:30:00	SPY	ETF	601.34	602.59	600.95	602.57	1304668.0
2025-01-28 12:00:00	SPY	ETF	602.565	603.92	602.4	603.7201	1321759.0
2025-01-28 12:30:00	SPY	ETF	603.73	604.08	603.29	603.8308	805986.0
2025-01-28 13:00:00	SPY	ETF	603.85	604.79	603.7532	604.1798	1174929.0
2025-01-28 13:30:00	SPY	ETF	604.18	604.46	603.56	603.8002	726450.0
2025-01-28 14:00:00	SPY	ETF	603.79	604.145	603.23	604.04	1051302.0
2025-01-28 14:30:00	SPY	ETF	604.06	605.26	604.06	605.14	1251118.0
2025-01-28 15:00:00	SPY	ETF	605.14	605.37	604.68	605.09	1573808.0
2025-01-28 15:30:00	SPY	ETF	605.07	605.23	604.36	604.49	5594044.0
2025-01-28 16:00:00	SPY	ETF	604.47	604.64	603.8693	603.95	3209043.0
2025-01-28 16:30:00	SPY	ETF	603.95	604.1	603.475	604.0	263687.0
2025-01-28 17:00:00	SPY	ETF	604.05	604.05	603.96	603.96	37599.0
2025-01-28 17:30:00	SPY	ETF	603.96	603.9799	603.93	603.97	21271.0
2025-01-28 18:00:00	SPY	ETF	603.78	604.24	603.53	604.09	89073.0
2025-01-28 18:30:00	SPY	ETF	603.93	603.93	603.6	603.6	3224.0
2025-01-28 19:00:00	SPY	ETF	603.6	604.07	603.6	603.81	13004.0
2025-01-28 19:30:00	SPY	ETF	603.89	604.1	603.72	604.1	26940.0
2025-01-28 04:00:00	QQQ	ETF	517.42	517.67	516.69	516.69	58355.0
2025-01-28 04:30:00	QQQ	ETF	516.6	517.5	516.27	517.5	29710.0
2025-01-28 05:00:00	QQQ	ETF	517.4	518.1	517.31	517.92	64791.0
2025-01-28 05:30:00	QQQ	ETF	517.82	517.86	517.34	517.36	42529.0
2025-01-28 06:00:00	QQQ	ETF	517.52	517.82	516.71	516.75	54143.0
2025-01-28 06:30:00	QQQ	ETF	516.76	516.91	515.87	516.14	71077.0
2025-01-28 07:00:00	QQQ	ETF	516.19	516.3	514.39	514.67	151098.0
2025-01-28 07:30:00	QQQ	ETF	514.45	515.5	514.16	515.25	119780.0
2025-01-28 08:00:00	QQQ	ETF	514.28	517.5096	513.825	516.3698	194099.0
2025-01-28 08:30:00	QQQ	ETF	516.38	516.43	514.77	515.18	222940.0
2025-01-28 09:00:00	QQQ	ETF	515.1	515.4	514.39	515.17	238636.0
2025-01-28 09:30:00	QQQ	ETF	515.195	515.63	511.78	514.75	3398555.0
2025-01-28 10:00:00	QQQ	ETF	514.82	519.55	514.73	519.21	3079357.0
2025-01-28 10:30:00	QQQ	ETF	519.22	519.32	517.48	518.9	1791544.0
2025-01-28 11:00:00	QQQ	ETF	518.96	519.4616	517.2934	517.7199	1296830.0
2025-01-28 11:30:00	QQQ	ETF	517.73	519.3855	517.3	519.35	1289036.0
2025-01-28 12:00:00	QQQ	ETF	519.33	521.52	519.28	521.18	1427127.0
2025-01-28 12:30:00	QQQ	ETF	521.215	521.41	520.545	521.03	647184.0

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

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