PREVIEW / etf_30min / 2025-05-09

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-05-09.parquet
  size:    934 KB
  rows:    37,825

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-09 04:00:00	SPY	ETF	565.38	565.6	564.79	565.5	9631.0
2025-05-09 04:30:00	SPY	ETF	565.47	565.47	565.01	565.01	3304.0
2025-05-09 05:00:00	SPY	ETF	565.28	565.54	565.28	565.31	3303.0
2025-05-09 05:30:00	SPY	ETF	565.21	565.77	565.19	565.77	4440.0
2025-05-09 06:00:00	SPY	ETF	566.03	566.56	566.03	566.4	18597.0
2025-05-09 06:30:00	SPY	ETF	566.56	566.81	566.5	566.62	27843.0
2025-05-09 07:00:00	SPY	ETF	566.57	567.99	564.14	565.81	495183.0
2025-05-09 07:30:00	SPY	ETF	565.71	566.84	564.92	566.22	328379.0
2025-05-09 08:00:00	SPY	ETF	566.13	567.63	564.2	566.0	226575.0
2025-05-09 08:30:00	SPY	ETF	565.98	567.46	565.98	566.775	182915.0
2025-05-09 09:00:00	SPY	ETF	566.79	567.5	566.41	566.41	175258.0
2025-05-09 09:30:00	SPY	ETF	566.48	567.5	565.81	567.0	2387019.0
2025-05-09 10:00:00	SPY	ETF	566.97	567.36	563.83	564.4699	2097777.0
2025-05-09 10:30:00	SPY	ETF	564.4508	564.88	562.7636	564.56	3241502.0
2025-05-09 11:00:00	SPY	ETF	564.58	565.28	563.88	564.55	1760625.0
2025-05-09 11:30:00	SPY	ETF	564.54	565.59	563.88	565.55	1261731.0
2025-05-09 12:00:00	SPY	ETF	565.56	565.6353	563.4401	563.88	1250465.0
2025-05-09 12:30:00	SPY	ETF	563.85	564.52	563.085	563.4	1110992.0
2025-05-09 13:00:00	SPY	ETF	563.4	564.43	562.87	563.96	1504272.0
2025-05-09 13:30:00	SPY	ETF	563.96	565.355	563.53	565.23	1261442.0
2025-05-09 14:00:00	SPY	ETF	565.22	565.2951	564.09	564.3	836821.0
2025-05-09 14:30:00	SPY	ETF	564.3001	565.1	564.245	564.83	713409.0
2025-05-09 15:00:00	SPY	ETF	564.84	565.89	564.8365	564.95	1566813.0
2025-05-09 15:30:00	SPY	ETF	564.96	565.17	564.1	564.29	4626210.0
2025-05-09 16:00:00	SPY	ETF	564.28	564.7702	563.98	564.33	2450459.0
2025-05-09 16:30:00	SPY	ETF	564.28	564.89	564.16	564.87	144818.0
2025-05-09 17:00:00	SPY	ETF	564.8	564.84	564.44	564.76	37598.0
2025-05-09 17:30:00	SPY	ETF	564.76	564.9659	564.68	564.92	28806.0
2025-05-09 18:00:00	SPY	ETF	564.9	565.1	564.63	565.05	20601.0
2025-05-09 18:30:00	SPY	ETF	565.03	565.08	564.91	565.0	4971.0
2025-05-09 19:00:00	SPY	ETF	565.0	565.04	564.88	565.04	18332.0
2025-05-09 19:30:00	SPY	ETF	564.9477	565.13	564.86	565.0	39923.0
2025-05-09 04:00:00	QQQ	ETF	489.42	489.58	488.54	489.38	21883.0
2025-05-09 04:30:00	QQQ	ETF	489.39	489.49	488.78	488.92	18847.0
2025-05-09 05:00:00	QQQ	ETF	488.95	489.41	488.95	489.12	12398.0
2025-05-09 05:30:00	QQQ	ETF	489.1	489.57	488.95	489.57	10520.0
2025-05-09 06:00:00	QQQ	ETF	489.6	490.25	489.6	490.07	12269.0
2025-05-09 06:30:00	QQQ	ETF	490.13	490.47	490.13	490.22	45397.0
2025-05-09 07:00:00	QQQ	ETF	490.27	492.0	488.28	489.66	222849.0
2025-05-09 07:30:00	QQQ	ETF	489.61	490.22	488.43	489.8	111110.0
2025-05-09 08:00:00	QQQ	ETF	490.22	490.64	487.924	489.59	239260.0
2025-05-09 08:30:00	QQQ	ETF	489.6	490.85	489.55	490.36	117178.0
2025-05-09 09:00:00	QQQ	ETF	490.33	490.92	490.15	490.17	164238.0
2025-05-09 09:30:00	QQQ	ETF	490.21	491.54	489.72	490.91	2096412.0
2025-05-09 10:00:00	QQQ	ETF	490.86	491.4	487.5	488.0001	1769291.0
2025-05-09 10:30:00	QQQ	ETF	488.04	488.59	486.195	488.2	2414247.0
2025-05-09 11:00:00	QQQ	ETF	488.2	489.0	487.4101	487.99	1232080.0
2025-05-09 11:30:00	QQQ	ETF	488.0	488.879	487.19	488.8201	1145727.0
2025-05-09 12:00:00	QQQ	ETF	488.91	488.96	486.63	487.1899	816724.0
2025-05-09 12:30:00	QQQ	ETF	487.2	487.965	486.54	486.91	947124.0

> showing 50 of 37,825 rows — these rows as CSV

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