PREVIEW / etf_30min / 2025-05-21

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-05-21.parquet
  size:    981 KB
  rows:    40,549

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-21 04:00:00	SPY	ETF	590.25	590.88	589.76	589.91	26982.0
2025-05-21 04:30:00	SPY	ETF	589.86	589.86	589.09	589.68	24652.0
2025-05-21 05:00:00	SPY	ETF	589.77	590.04	589.24	589.26	14751.0
2025-05-21 05:30:00	SPY	ETF	589.28	589.32	588.37	588.55	19255.0
2025-05-21 06:00:00	SPY	ETF	588.58	588.58	587.6	587.96	61700.0
2025-05-21 06:30:00	SPY	ETF	588.0	589.02	587.99	589.02	79889.0
2025-05-21 07:00:00	SPY	ETF	589.05	590.0	589.0	589.88	69959.0
2025-05-21 07:30:00	SPY	ETF	589.83	590.44	589.6	590.159	66907.0
2025-05-21 08:00:00	SPY	ETF	589.08	591.25	587.7896	589.79	213591.0
2025-05-21 08:30:00	SPY	ETF	589.75	589.75	588.74	589.33	130811.0
2025-05-21 09:00:00	SPY	ETF	589.4	589.44	587.94	588.45	259195.0
2025-05-21 09:30:00	SPY	ETF	588.47	590.5102	588.42	589.84	5434630.0
2025-05-21 10:00:00	SPY	ETF	589.84	591.43	589.585	589.62	4052870.0
2025-05-21 10:30:00	SPY	ETF	589.63	590.7	588.87	590.65	2699502.0
2025-05-21 11:00:00	SPY	ETF	590.66	592.24	590.37	591.79	3436613.0
2025-05-21 11:30:00	SPY	ETF	591.77	592.19	591.25	591.74	2100651.0
2025-05-21 12:00:00	SPY	ETF	591.73	592.295	591.42	591.7896	2133161.0
2025-05-21 12:30:00	SPY	ETF	591.8	592.58	591.56	591.61	2288852.0
2025-05-21 13:00:00	SPY	ETF	591.62	591.79	584.55	584.69	8201046.0
2025-05-21 13:30:00	SPY	ETF	584.7	587.76	583.79	586.1665	8323739.0
2025-05-21 14:00:00	SPY	ETF	586.16	586.39	584.15	585.26	3730378.0
2025-05-21 14:30:00	SPY	ETF	585.28	586.28	583.78	584.02	3560115.0
2025-05-21 15:00:00	SPY	ETF	584.03	584.6062	581.82	582.25	6004106.0
2025-05-21 15:30:00	SPY	ETF	582.26	584.62	582.26	582.96	11085526.0
2025-05-21 16:00:00	SPY	ETF	582.98	583.214	582.2	582.61	3948378.0
2025-05-21 16:30:00	SPY	ETF	582.71	583.05	582.61	582.9	114012.0
2025-05-21 17:00:00	SPY	ETF	582.92	583.26	582.74	583.0702	123363.0
2025-05-21 17:30:00	SPY	ETF	583.15	583.15	582.9	582.9	21948.0
2025-05-21 18:00:00	SPY	ETF	582.9	583.59	582.25	582.9	120326.0
2025-05-21 18:30:00	SPY	ETF	582.86	583.06	582.701	582.89	25784.0
2025-05-21 19:00:00	SPY	ETF	582.8	583.5994	582.7101	583.33	35125.0
2025-05-21 19:30:00	SPY	ETF	583.309	583.31	582.97	583.111	15625.0
2025-05-21 04:00:00	QQQ	ETF	517.79	517.93	517.2	517.39	27626.0
2025-05-21 04:30:00	QQQ	ETF	517.32	517.34	516.6	517.32	37445.0
2025-05-21 05:00:00	QQQ	ETF	517.33	517.64	516.87	516.87	14593.0
2025-05-21 05:30:00	QQQ	ETF	516.8	516.97	516.0	516.09	22612.0
2025-05-21 06:00:00	QQQ	ETF	516.16	516.16	515.0	515.53	94362.0
2025-05-21 06:30:00	QQQ	ETF	515.6	516.8	515.57	516.73	56856.0
2025-05-21 07:00:00	QQQ	ETF	516.75	517.81	516.69	517.73	42179.0
2025-05-21 07:30:00	QQQ	ETF	517.66	518.4	517.36	517.77	61722.0
2025-05-21 08:00:00	QQQ	ETF	516.75	519.88	515.245	517.39	158786.0
2025-05-21 08:30:00	QQQ	ETF	517.3701	517.3701	516.44	517.07	76934.0
2025-05-21 09:00:00	QQQ	ETF	517.13	517.2	515.91	516.24	142163.0
2025-05-21 09:30:00	QQQ	ETF	516.29	519.3	516.21	518.57	4504396.0
2025-05-21 10:00:00	QQQ	ETF	518.57	520.08	518.3	518.81	3307704.0
2025-05-21 10:30:00	QQQ	ETF	518.8	520.59	518.53	520.5594	2531517.0
2025-05-21 11:00:00	QQQ	ETF	520.54	522.43	520.32	522.06	3326890.0
2025-05-21 11:30:00	QQQ	ETF	522.05	522.4	521.42	521.96	1936959.0
2025-05-21 12:00:00	QQQ	ETF	521.96	522.79	521.83	522.31	1975434.0
2025-05-21 12:30:00	QQQ	ETF	522.34	523.0	521.89	521.9699	1531261.0

> showing 50 of 40,549 rows — these rows as CSV

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