PREVIEW / etf_1hour / 2025-05-29

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-05-29.parquet
  size:    615 KB
  rows:    24,236

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.56	596.59	136208.0
2025-05-29 05:00:00	SPY	ETF	596.59	597.0	595.97	596.0	51120.0
2025-05-29 06:00:00	SPY	ETF	595.96	595.96	594.08	594.5	207325.0
2025-05-29 07:00:00	SPY	ETF	594.56	594.61	592.7	592.8	377303.0
2025-05-29 08:00:00	SPY	ETF	592.81	598.0	591.67	592.24	1109479.0
2025-05-29 09:00:00	SPY	ETF	592.34	593.33	590.26	591.2308	6545441.0
2025-05-29 10:00:00	SPY	ETF	591.21	591.61	588.5	590.93	7159742.0
2025-05-29 11:00:00	SPY	ETF	590.92	591.01	586.54	587.19	5917711.0
2025-05-29 12:00:00	SPY	ETF	587.18	590.149	586.07	589.795	5532936.0
2025-05-29 13:00:00	SPY	ETF	589.7908	590.45	588.41	588.5551	4059504.0
2025-05-29 14:00:00	SPY	ETF	588.58	589.54	587.61	588.7901	4755471.0
2025-05-29 15:00:00	SPY	ETF	588.81	590.665	588.3	590.0	11053853.0
2025-05-29 16:00:00	SPY	ETF	590.0	590.27	589.2	589.4	3082522.0
2025-05-29 17:00:00	SPY	ETF	589.38	590.05	589.0012	589.0012	226850.0
2025-05-29 18:00:00	SPY	ETF	589.0	589.64	588.3	588.7784	109185.0
2025-05-29 19:00:00	SPY	ETF	588.72	589.11	588.1	588.1	39849.0
2025-05-29 04:00:00	QQQ	ETF	530.47	530.77	528.58	528.98	182109.0
2025-05-29 05:00:00	QQQ	ETF	528.92	529.79	528.88	529.06	62184.0
2025-05-29 06:00:00	QQQ	ETF	528.92	528.93	527.22	527.83	142726.0
2025-05-29 07:00:00	QQQ	ETF	527.85	527.91	525.76	525.91	171373.0
2025-05-29 08:00:00	QQQ	ETF	527.76	530.49	518.521	525.67	835735.0
2025-05-29 09:00:00	QQQ	ETF	525.76	526.81	521.78	522.59	6377114.0
2025-05-29 10:00:00	QQQ	ETF	522.56	522.95	519.25	522.52	7878673.0
2025-05-29 11:00:00	QQQ	ETF	522.51	522.59	517.905	518.4691	6215828.0
2025-05-29 12:00:00	QQQ	ETF	518.42	521.43	517.32	521.06	4812484.0
2025-05-29 13:00:00	QQQ	ETF	521.05	521.64	518.92	519.0287	3748906.0
2025-05-29 14:00:00	QQQ	ETF	519.03	519.81	517.71	518.78	3660219.0
2025-05-29 15:00:00	QQQ	ETF	518.795	520.91	518.2	519.96	6540170.0
2025-05-29 16:00:00	QQQ	ETF	519.97	520.35	518.97	519.27	768330.0
2025-05-29 17:00:00	QQQ	ETF	519.31	519.4534	518.63	518.8	54467.0
2025-05-29 18:00:00	QQQ	ETF	518.79	519.511	518.18	518.57	125949.0
2025-05-29 19:00:00	QQQ	ETF	518.46	518.92	517.6201	517.65	115919.0
2025-05-29 04:00:00	IWM	ETF	210.43	210.54	209.46	209.64	65963.0
2025-05-29 05:00:00	IWM	ETF	209.57	209.58	208.57	208.57	81350.0
2025-05-29 06:00:00	IWM	ETF	208.61	208.65	207.67	207.75	153866.0
2025-05-29 07:00:00	IWM	ETF	207.76	208.15	207.3	207.4	298259.0
2025-05-29 08:00:00	IWM	ETF	207.71	211.27	206.65	206.71	601691.0
2025-05-29 09:00:00	IWM	ETF	206.73	207.06	205.755	206.1199	4055170.0
2025-05-29 10:00:00	IWM	ETF	206.1	206.46	204.86	205.775	4537557.0
2025-05-29 11:00:00	IWM	ETF	205.77	206.02	204.62	204.84	3670448.0
2025-05-29 12:00:00	IWM	ETF	204.83	205.86	204.47	205.7	2911181.0
2025-05-29 13:00:00	IWM	ETF	205.69	206.045	205.43	205.485	2409911.0
2025-05-29 14:00:00	IWM	ETF	205.49	206.22	205.41	205.89	2060736.0
2025-05-29 15:00:00	IWM	ETF	205.91	206.205	205.75	206.15	5012328.0
2025-05-29 16:00:00	IWM	ETF	206.12	206.27	205.83	206.001	1364635.0
2025-05-29 17:00:00	IWM	ETF	206.05	206.1973	205.82	205.83	10162.0
2025-05-29 18:00:00	IWM	ETF	205.81	206.12	205.62	205.8113	27889.0
2025-05-29 19:00:00	IWM	ETF	205.83	205.93	205.47	205.47	26351.0
2025-05-29 04:00:00	DIA	ETF	427.0	427.08	426.24	426.26	1225.0
2025-05-29 05:00:00	DIA	ETF	426.19	426.19	425.02	425.02	6100.0

> showing 50 of 24,236 rows — these rows as CSV

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