PREVIEW / etf_30min / 2025-05-29

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-05-29.parquet
  size:    930 KB
  rows:    38,936

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-29 04:00:00	SPY	ETF	596.62	598.31	596.62	596.96	94019.0
2025-05-29 04:30:00	SPY	ETF	596.83	596.97	596.56	596.59	42189.0
2025-05-29 05:00:00	SPY	ETF	596.59	596.94	596.4	596.71	36941.0
2025-05-29 05:30:00	SPY	ETF	596.82	597.0	595.97	596.0	14179.0
2025-05-29 06:00:00	SPY	ETF	595.96	595.96	594.4	594.49	122308.0
2025-05-29 06:30:00	SPY	ETF	594.49	595.03	594.08	594.5	85017.0
2025-05-29 07:00:00	SPY	ETF	594.56	594.61	593.3	593.4	152058.0
2025-05-29 07:30:00	SPY	ETF	593.47	594.0	592.7	592.8	225245.0
2025-05-29 08:00:00	SPY	ETF	592.81	598.0	591.87	592.42	596461.0
2025-05-29 08:30:00	SPY	ETF	592.31	593.1	591.67	592.24	513018.0
2025-05-29 09:00:00	SPY	ETF	592.34	593.33	592.14	593.05	379907.0
2025-05-29 09:30:00	SPY	ETF	593.06	593.2	590.26	591.2308	6165534.0
2025-05-29 10:00:00	SPY	ETF	591.21	591.61	588.5	590.09	4667957.0
2025-05-29 10:30:00	SPY	ETF	590.08	591.09	589.29	590.93	2491785.0
2025-05-29 11:00:00	SPY	ETF	590.92	591.01	589.56	590.72	2286600.0
2025-05-29 11:30:00	SPY	ETF	590.71	590.805	586.54	587.19	3631111.0
2025-05-29 12:00:00	SPY	ETF	587.18	589.24	586.07	588.99	3600217.0
2025-05-29 12:30:00	SPY	ETF	588.99	590.149	588.9001	589.795	1932719.0
2025-05-29 13:00:00	SPY	ETF	589.7908	590.45	589.14	589.32	2009673.0
2025-05-29 13:30:00	SPY	ETF	589.33	589.81	588.41	588.5551	2049831.0
2025-05-29 14:00:00	SPY	ETF	588.58	589.3	587.61	588.03	2482439.0
2025-05-29 14:30:00	SPY	ETF	588.01	589.54	588.01	588.7901	2273032.0
2025-05-29 15:00:00	SPY	ETF	588.81	589.73	588.3	588.89	3650745.0
2025-05-29 15:30:00	SPY	ETF	588.89	590.665	588.88	590.0	7403108.0
2025-05-29 16:00:00	SPY	ETF	590.0	590.27	589.2	589.91	2960187.0
2025-05-29 16:30:00	SPY	ETF	589.89	590.06	589.27	589.4	122335.0
2025-05-29 17:00:00	SPY	ETF	589.38	589.54	589.35	589.45	29482.0
2025-05-29 17:30:00	SPY	ETF	589.45	590.05	589.0012	589.0012	197368.0
2025-05-29 18:00:00	SPY	ETF	589.0	589.64	588.55	588.66	82395.0
2025-05-29 18:30:00	SPY	ETF	588.66	589.01	588.3	588.7784	26790.0
2025-05-29 19:00:00	SPY	ETF	588.72	589.1	588.7	588.95	11741.0
2025-05-29 19:30:00	SPY	ETF	589.01	589.11	588.1	588.1	28108.0
2025-05-29 04:00:00	QQQ	ETF	530.47	530.77	529.15	529.18	90329.0
2025-05-29 04:30:00	QQQ	ETF	529.11	529.2	528.58	528.98	91780.0
2025-05-29 05:00:00	QQQ	ETF	528.92	529.66	528.88	529.17	37897.0
2025-05-29 05:30:00	QQQ	ETF	529.25	529.79	529.01	529.06	24287.0
2025-05-29 06:00:00	QQQ	ETF	528.92	528.93	527.67	527.72	81458.0
2025-05-29 06:30:00	QQQ	ETF	527.76	528.2	527.22	527.83	61268.0
2025-05-29 07:00:00	QQQ	ETF	527.85	527.91	526.48	526.48	70827.0
2025-05-29 07:30:00	QQQ	ETF	526.59	527.07	525.76	525.91	100546.0
2025-05-29 08:00:00	QQQ	ETF	527.76	530.49	518.521	526.0	517520.0
2025-05-29 08:30:00	QQQ	ETF	526.0	526.66	525.24	525.67	318215.0
2025-05-29 09:00:00	QQQ	ETF	525.76	526.81	525.54	526.33	392764.0
2025-05-29 09:30:00	QQQ	ETF	526.32	526.48	521.78	522.59	5984350.0
2025-05-29 10:00:00	QQQ	ETF	522.56	522.95	519.25	521.08	4908507.0
2025-05-29 10:30:00	QQQ	ETF	521.07	522.66	520.46	522.52	2970166.0
2025-05-29 11:00:00	QQQ	ETF	522.51	522.59	521.09	522.15	2921857.0
2025-05-29 11:30:00	QQQ	ETF	522.14	522.23	517.905	518.4691	3293971.0
2025-05-29 12:00:00	QQQ	ETF	518.42	520.6	517.32	520.32	3052407.0
2025-05-29 12:30:00	QQQ	ETF	520.33	521.43	520.275	521.06	1760077.0

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

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