PREVIEW / etf_30min / 2025-05-07

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-05-07.parquet
  size:    947 KB
  rows:    38,667

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-07 04:00:00	SPY	ETF	562.68	562.68	561.51	562.14	20472.0
2025-05-07 04:30:00	SPY	ETF	562.07	562.38	561.81	562.33	4810.0
2025-05-07 05:00:00	SPY	ETF	562.3	562.51	561.84	561.93	8585.0
2025-05-07 05:30:00	SPY	ETF	561.95	562.4	561.7	562.0	9956.0
2025-05-07 06:00:00	SPY	ETF	561.92	562.3	561.51	562.0	10260.0
2025-05-07 06:30:00	SPY	ETF	561.85	562.57	561.83	562.3	40312.0
2025-05-07 07:00:00	SPY	ETF	562.27	563.02	562.2	562.5	73208.0
2025-05-07 07:30:00	SPY	ETF	562.5	562.54	561.84	562.25	56299.0
2025-05-07 08:00:00	SPY	ETF	562.59	562.9381	560.55	560.7	195427.0
2025-05-07 08:30:00	SPY	ETF	560.68	561.53	560.61	560.87	106564.0
2025-05-07 09:00:00	SPY	ETF	560.85	560.85	559.67	560.15	260457.0
2025-05-07 09:30:00	SPY	ETF	560.15	561.6	559.5202	561.4599	3228563.0
2025-05-07 10:00:00	SPY	ETF	561.46	561.96	560.98	561.82	1726812.0
2025-05-07 10:30:00	SPY	ETF	561.84	561.98	559.01	559.45	1841273.0
2025-05-07 11:00:00	SPY	ETF	559.45	559.565	558.38	559.1608	2129583.0
2025-05-07 11:30:00	SPY	ETF	559.1	560.16	558.6	559.94	1647487.0
2025-05-07 12:00:00	SPY	ETF	559.91	560.4	559.11	559.18	1012672.0
2025-05-07 12:30:00	SPY	ETF	559.19	561.37	559.07	561.255	947002.0
2025-05-07 13:00:00	SPY	ETF	561.24	561.85	560.83	561.2434	923794.0
2025-05-07 13:30:00	SPY	ETF	561.25	561.4121	558.8	559.27	1853195.0
2025-05-07 14:00:00	SPY	ETF	559.235	560.5189	556.04	557.98	3934966.0
2025-05-07 14:30:00	SPY	ETF	557.95	562.64	557.3101	560.85	3830152.0
2025-05-07 15:00:00	SPY	ETF	560.83	560.98	557.72	557.87	2831580.0
2025-05-07 15:30:00	SPY	ETF	557.86	563.82	557.52	561.23	9141797.0
2025-05-07 16:00:00	SPY	ETF	561.23	562.36	560.65	560.79	2804446.0
2025-05-07 16:30:00	SPY	ETF	560.73	561.05	560.63	560.99	159045.0
2025-05-07 17:00:00	SPY	ETF	561.0	561.12	560.97	560.99	95510.0
2025-05-07 17:30:00	SPY	ETF	560.97	560.98	560.77	560.85	40139.0
2025-05-07 18:00:00	SPY	ETF	560.75	560.941	560.13	560.941	83812.0
2025-05-07 18:30:00	SPY	ETF	560.96	561.15	560.87	560.87	16801.0
2025-05-07 19:00:00	SPY	ETF	561.07	561.45	561.0	561.38	69091.0
2025-05-07 19:30:00	SPY	ETF	561.3401	561.5284	560.89	561.01	33114.0
2025-05-07 04:00:00	QQQ	ETF	484.89	485.2	483.87	484.57	100313.0
2025-05-07 04:30:00	QQQ	ETF	484.54	484.86	484.2	484.73	23563.0
2025-05-07 05:00:00	QQQ	ETF	484.67	484.92	484.07	484.22	23205.0
2025-05-07 05:30:00	QQQ	ETF	484.26	484.62	483.91	484.3	17666.0
2025-05-07 06:00:00	QQQ	ETF	484.29	484.52	483.79	484.18	20110.0
2025-05-07 06:30:00	QQQ	ETF	484.03	484.77	483.95	484.48	57515.0
2025-05-07 07:00:00	QQQ	ETF	484.5	485.26	484.37	484.68	112039.0
2025-05-07 07:30:00	QQQ	ETF	484.63	484.7	484.12	484.44	63259.0
2025-05-07 08:00:00	QQQ	ETF	484.83	485.26	481.049	482.41	305508.0
2025-05-07 08:30:00	QQQ	ETF	482.49	483.83	482.45	482.97	197544.0
2025-05-07 09:00:00	QQQ	ETF	482.91	482.91	481.66	482.09	240883.0
2025-05-07 09:30:00	QQQ	ETF	482.08	483.1799	481.18	483.0144	2384839.0
2025-05-07 10:00:00	QQQ	ETF	483.04	484.01	482.37	483.88	1092643.0
2025-05-07 10:30:00	QQQ	ETF	483.88	483.9852	480.44	480.7843	1387512.0
2025-05-07 11:00:00	QQQ	ETF	480.79	480.88	479.46	480.0101	1866872.0
2025-05-07 11:30:00	QQQ	ETF	479.99	481.05	479.42	480.87	1395330.0
2025-05-07 12:00:00	QQQ	ETF	480.83	481.05	479.94	480.0	646711.0
2025-05-07 12:30:00	QQQ	ETF	480.02	482.1856	479.86	482.04	956572.0

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

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