PREVIEW / etf_1hour / 2025-06-02

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-06-02.parquet
  size:    636 KB
  rows:    24,893

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-06-02 04:00:00	SPY	ETF	586.8	587.34	585.99	586.82	116040.0
2025-06-02 05:00:00	SPY	ETF	586.7	586.84	585.7	586.23	49273.0
2025-06-02 06:00:00	SPY	ETF	586.23	587.04	586.13	586.98	45113.0
2025-06-02 07:00:00	SPY	ETF	587.04	588.0	586.74	587.18	115992.0
2025-06-02 08:00:00	SPY	ETF	586.98	589.39	584.97	587.85	660865.0
2025-06-02 09:00:00	SPY	ETF	587.87	589.74	586.64	586.8499	6313252.0
2025-06-02 10:00:00	SPY	ETF	586.63	589.94	585.06	589.33	9038119.0
2025-06-02 11:00:00	SPY	ETF	589.34	590.06	588.13	589.81	4716456.0
2025-06-02 12:00:00	SPY	ETF	589.8	590.19	588.98	590.0	2628479.0
2025-06-02 13:00:00	SPY	ETF	589.9817	590.61	589.5	589.98	2461984.0
2025-06-02 14:00:00	SPY	ETF	589.98	591.96	589.54	591.86	4922554.0
2025-06-02 15:00:00	SPY	ETF	591.86	592.79	591.65	592.65	11178420.0
2025-06-02 16:00:00	SPY	ETF	592.63	593.44	592.05	592.79	2865688.0
2025-06-02 17:00:00	SPY	ETF	592.85	593.15	592.85	592.97	49265.0
2025-06-02 18:00:00	SPY	ETF	592.96	592.96	592.17	592.18	102100.0
2025-06-02 19:00:00	SPY	ETF	592.17	592.65	591.04	591.48	91706.0
2025-06-02 04:00:00	QQQ	ETF	515.62	516.64	515.33	516.02	63006.0
2025-06-02 05:00:00	QQQ	ETF	515.98	516.1	515.2	515.64	68148.0
2025-06-02 06:00:00	QQQ	ETF	515.66	516.4	515.52	516.28	40212.0
2025-06-02 07:00:00	QQQ	ETF	516.37	517.35	516.07	516.49	83194.0
2025-06-02 08:00:00	QQQ	ETF	516.5	519.499	514.42	517.19	286616.0
2025-06-02 09:00:00	QQQ	ETF	517.18	521.35	516.52	517.75	4896832.0
2025-06-02 10:00:00	QQQ	ETF	517.73	520.47	515.97	519.87	6702500.0
2025-06-02 11:00:00	QQQ	ETF	519.88	521.02	518.88	520.78	4173066.0
2025-06-02 12:00:00	QQQ	ETF	520.77	521.27	520.0	521.06	2483423.0
2025-06-02 13:00:00	QQQ	ETF	521.1	521.75	520.57	521.08	2403720.0
2025-06-02 14:00:00	QQQ	ETF	521.05	523.0	520.62	522.81	3562861.0
2025-06-02 15:00:00	QQQ	ETF	522.8	523.45	522.29	523.21	5100717.0
2025-06-02 16:00:00	QQQ	ETF	523.22	524.22	523.0	523.75	1302394.0
2025-06-02 17:00:00	QQQ	ETF	523.6617	523.8899	523.66	523.71	23789.0
2025-06-02 18:00:00	QQQ	ETF	523.68	523.68	522.78	522.9	69501.0
2025-06-02 19:00:00	QQQ	ETF	522.85	523.4598	521.8	522.25	104811.0
2025-06-02 04:00:00	IWM	ETF	203.58	204.56	203.5	204.32	34254.0
2025-06-02 05:00:00	IWM	ETF	204.22	204.31	203.76	203.98	21181.0
2025-06-02 06:00:00	IWM	ETF	203.99	204.4	203.85	204.38	25526.0
2025-06-02 07:00:00	IWM	ETF	204.36	205.09	204.3	204.81	101592.0
2025-06-02 08:00:00	IWM	ETF	204.72	205.34	203.02	205.34	214684.0
2025-06-02 09:00:00	IWM	ETF	205.33	205.815	203.16	203.375	4268466.0
2025-06-02 10:00:00	IWM	ETF	203.34	204.995	202.67	204.9	4697242.0
2025-06-02 11:00:00	IWM	ETF	204.9	205.58	204.66	205.35	2384347.0
2025-06-02 12:00:00	IWM	ETF	205.36	205.46	204.91	205.34	1874118.0
2025-06-02 13:00:00	IWM	ETF	205.34	205.49	204.76	204.97	2214097.0
2025-06-02 14:00:00	IWM	ETF	204.96	205.56	204.64	205.54	2297214.0
2025-06-02 15:00:00	IWM	ETF	205.54	205.84	205.39	205.76	4969875.0
2025-06-02 16:00:00	IWM	ETF	205.75	206.08	205.71	205.81	1162208.0
2025-06-02 17:00:00	IWM	ETF	205.87	206.02	205.71	205.96	7260.0
2025-06-02 18:00:00	IWM	ETF	205.91	205.91	205.52	205.56	30823.0
2025-06-02 19:00:00	IWM	ETF	205.53	205.66	205.15	205.18	19618.0
2025-06-02 04:00:00	DIA	ETF	420.76	421.51	420.51	421.31	1100.0
2025-06-02 05:00:00	DIA	ETF	420.96	420.97	420.45	420.52	3200.0

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

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