PREVIEW / etf_30min / 2025-05-01

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-05-01.parquet
  size:    976 KB
  rows:    39,966

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-01 04:00:00	SPY	ETF	560.07	560.67	559.65	560.46	41840.0
2025-05-01 04:30:00	SPY	ETF	560.44	561.04	560.17	561.0	13690.0
2025-05-01 05:00:00	SPY	ETF	560.99	561.36	560.89	561.16	12281.0
2025-05-01 05:30:00	SPY	ETF	561.32	562.05	561.28	561.9	39466.0
2025-05-01 06:00:00	SPY	ETF	561.93	562.07	561.32	561.39	26821.0
2025-05-01 06:30:00	SPY	ETF	561.32	561.34	560.62	561.05	63417.0
2025-05-01 07:00:00	SPY	ETF	561.05	561.74	560.36	560.61	249069.0
2025-05-01 07:30:00	SPY	ETF	560.735	561.6	560.7	561.31	177163.0
2025-05-01 08:00:00	SPY	ETF	560.75	561.91	554.125	560.6	285960.0
2025-05-01 08:30:00	SPY	ETF	560.42	560.83	559.6	559.85	424055.0
2025-05-01 09:00:00	SPY	ETF	559.88	560.77	559.36	560.38	272185.0
2025-05-01 09:30:00	SPY	ETF	560.37	561.36	558.65	558.85	5442340.0
2025-05-01 10:00:00	SPY	ETF	558.85	562.21	558.83	562.0318	3865226.0
2025-05-01 10:30:00	SPY	ETF	562.05	563.395	561.16	563.35	2849928.0
2025-05-01 11:00:00	SPY	ETF	563.36	564.0699	562.68	563.26	2711124.0
2025-05-01 11:30:00	SPY	ETF	563.26	563.44	559.69	560.38	2555509.0
2025-05-01 12:00:00	SPY	ETF	560.4	561.26	559.06	560.31	1897973.0
2025-05-01 12:30:00	SPY	ETF	560.31	560.96	559.2	559.69	1430603.0
2025-05-01 13:00:00	SPY	ETF	559.64	561.9462	559.64	561.34	1456624.0
2025-05-01 13:30:00	SPY	ETF	561.35	561.72	559.8932	560.57	1146911.0
2025-05-01 14:00:00	SPY	ETF	560.58	562.35	560.47	561.89	1932810.0
2025-05-01 14:30:00	SPY	ETF	561.9	562.69	561.62	561.705	1882340.0
2025-05-01 15:00:00	SPY	ETF	561.73	562.13	560.855	562.03	2713665.0
2025-05-01 15:30:00	SPY	ETF	562.02	562.49	557.86	558.46	7570651.0
2025-05-01 16:00:00	SPY	ETF	558.43	559.8	556.0	557.91	2947209.0
2025-05-01 16:30:00	SPY	ETF	557.9	558.67	556.55	557.0	548552.0
2025-05-01 17:00:00	SPY	ETF	557.06	558.02	555.6	557.601	121636.0
2025-05-01 17:30:00	SPY	ETF	557.79	558.47	555.3	556.95	98175.0
2025-05-01 18:00:00	SPY	ETF	556.89	557.2	556.06	557.0	71181.0
2025-05-01 18:30:00	SPY	ETF	556.94	557.2	556.71	556.88	34736.0
2025-05-01 19:00:00	SPY	ETF	556.9	557.77	556.8315	557.52	43414.0
2025-05-01 19:30:00	SPY	ETF	557.44	557.44	556.81	557.18	71070.0
2025-05-01 04:00:00	QQQ	ETF	483.0	483.37	482.48	483.19	30522.0
2025-05-01 04:30:00	QQQ	ETF	483.16	483.79	482.83	483.73	24889.0
2025-05-01 05:00:00	QQQ	ETF	483.74	484.02	483.51	484.0	51098.0
2025-05-01 05:30:00	QQQ	ETF	483.99	484.65	483.94	484.53	40436.0
2025-05-01 06:00:00	QQQ	ETF	484.5	484.78	484.15	484.2	23492.0
2025-05-01 06:30:00	QQQ	ETF	484.24	484.24	483.75	484.21	42344.0
2025-05-01 07:00:00	QQQ	ETF	484.21	484.7	483.72	483.88	93994.0
2025-05-01 07:30:00	QQQ	ETF	483.875	484.73	483.87	484.29	93904.0
2025-05-01 08:00:00	QQQ	ETF	484.62	484.95	481.9	484.06	323843.0
2025-05-01 08:30:00	QQQ	ETF	483.91	484.06	483.0	483.09	284053.0
2025-05-01 09:00:00	QQQ	ETF	483.0699	483.91	482.67	483.34	266733.0
2025-05-01 09:30:00	QQQ	ETF	483.41	483.95	480.8201	481.0	4072237.0
2025-05-01 10:00:00	QQQ	ETF	481.09	484.29	480.91	484.15	2741360.0
2025-05-01 10:30:00	QQQ	ETF	484.15	485.93	483.58	485.92	2149067.0
2025-05-01 11:00:00	QQQ	ETF	485.92	487.18	485.36	486.02	3132578.0
2025-05-01 11:30:00	QQQ	ETF	486.08	486.168	482.54	483.24	2288475.0
2025-05-01 12:00:00	QQQ	ETF	483.21	484.145	482.0	483.4	1709187.0
2025-05-01 12:30:00	QQQ	ETF	483.3426	483.9882	482.31	482.798	984626.0

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

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