PREVIEW / etf_30min / 2025-05-13

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-05-13.parquet
  size:    1002 KB
  rows:    41,269

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-05-13 04:00:00	SPY	ETF	580.7	581.21	580.38	580.86	17147.0
2025-05-13 04:30:00	SPY	ETF	581.01	581.19	580.36	580.46	4600.0
2025-05-13 05:00:00	SPY	ETF	580.45	581.0	580.32	581.0	8208.0
2025-05-13 05:30:00	SPY	ETF	581.02	581.5	581.01	581.41	7777.0
2025-05-13 06:00:00	SPY	ETF	581.55	581.57	581.15	581.32	10155.0
2025-05-13 06:30:00	SPY	ETF	581.24	581.84	581.07	581.47	27454.0
2025-05-13 07:00:00	SPY	ETF	581.25	582.0	581.23	581.5	64987.0
2025-05-13 07:30:00	SPY	ETF	581.47	582.2	581.42	582.19	115990.0
2025-05-13 08:00:00	SPY	ETF	581.55	583.83	580.22	582.92	195349.0
2025-05-13 08:30:00	SPY	ETF	583.23	587.4	582.5	583.33	680602.0
2025-05-13 09:00:00	SPY	ETF	583.29	583.67	564.61	583.44	175413.0
2025-05-13 09:30:00	SPY	ETF	583.46	585.47	582.84	585.28	4908851.0
2025-05-13 10:00:00	SPY	ETF	585.29	587.9	585.22	586.82	5507627.0
2025-05-13 10:30:00	SPY	ETF	586.84	587.3789	586.11	587.0801	2748266.0
2025-05-13 11:00:00	SPY	ETF	587.11	588.09	586.74	587.7	2566131.0
2025-05-13 11:30:00	SPY	ETF	587.69	588.44	587.33	587.65	2564896.0
2025-05-13 12:00:00	SPY	ETF	587.67	587.81	586.96	587.6917	1801911.0
2025-05-13 12:30:00	SPY	ETF	587.66	588.355	587.29	587.955	1733949.0
2025-05-13 13:00:00	SPY	ETF	587.96	588.39	587.66	588.33	1763545.0
2025-05-13 13:30:00	SPY	ETF	588.335	589.0699	587.86	587.9192	2460752.0
2025-05-13 14:00:00	SPY	ETF	587.92	588.33	587.46	587.89	2177868.0
2025-05-13 14:30:00	SPY	ETF	587.92	588.7	587.49	588.6	1965728.0
2025-05-13 15:00:00	SPY	ETF	588.59	588.96	588.23	588.45	2285537.0
2025-05-13 15:30:00	SPY	ETF	588.44	589.08	586.73	586.81	7583852.0
2025-05-13 16:00:00	SPY	ETF	586.8	587.1	586.39	586.49	2513592.0
2025-05-13 16:30:00	SPY	ETF	586.51	586.75	586.5	586.6	89801.0
2025-05-13 17:00:00	SPY	ETF	586.62	586.9998	586.42	586.4594	69666.0
2025-05-13 17:30:00	SPY	ETF	586.53	586.8	586.53	586.75	19107.0
2025-05-13 18:00:00	SPY	ETF	586.65	586.87	586.42	586.791	55277.0
2025-05-13 18:30:00	SPY	ETF	586.78	586.8996	586.7	586.78	5660.0
2025-05-13 19:00:00	SPY	ETF	586.75	587.0	586.6	586.84	18665.0
2025-05-13 19:30:00	SPY	ETF	586.82	587.35	586.82	587.26	19996.0
2025-05-13 04:00:00	QQQ	ETF	505.37	505.97	504.82	505.44	30084.0
2025-05-13 04:30:00	QQQ	ETF	505.7	506.07	504.9	505.04	30215.0
2025-05-13 05:00:00	QQQ	ETF	505.06	505.74	504.9	505.59	31385.0
2025-05-13 05:30:00	QQQ	ETF	505.66	506.12	505.62	506.12	13317.0
2025-05-13 06:00:00	QQQ	ETF	506.21	506.37	505.69	506.0	25779.0
2025-05-13 06:30:00	QQQ	ETF	506.11	506.88	505.98	506.49	37057.0
2025-05-13 07:00:00	QQQ	ETF	506.45	507.44	506.39	507.01	41544.0
2025-05-13 07:30:00	QQQ	ETF	506.99	507.75	506.92	507.74	47634.0
2025-05-13 08:00:00	QQQ	ETF	506.78	508.79	504.78	508.75	226917.0
2025-05-13 08:30:00	QQQ	ETF	508.88	510.5	507.47	509.25	473180.0
2025-05-13 09:00:00	QQQ	ETF	509.25	509.59	508.86	509.15	162457.0
2025-05-13 09:30:00	QQQ	ETF	509.19	512.26	508.42	512.1175	4943941.0
2025-05-13 10:00:00	QQQ	ETF	512.12	514.95	511.88	514.13	4758475.0
2025-05-13 10:30:00	QQQ	ETF	514.15	515.29	513.555	515.09	3063692.0
2025-05-13 11:00:00	QQQ	ETF	515.1	516.1	514.62	515.755	2537938.0
2025-05-13 11:30:00	QQQ	ETF	515.75	516.35	515.52	515.89	2575119.0
2025-05-13 12:00:00	QQQ	ETF	515.9	516.47	515.13	516.36	1865786.0
2025-05-13 12:30:00	QQQ	ETF	516.3209	517.18	515.92	516.78	2226840.0

> showing 50 of 41,269 rows — these rows as CSV

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