PREVIEW / etf_1hour / 2025-08-19

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-08-19.parquet
  size:    671 KB
  rows:    25,579

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-08-19 04:00:00	SPY	ETF	642.63	643.0	642.41	642.99	7207.0
2025-08-19 05:00:00	SPY	ETF	643.0	643.35	642.97	643.05	23043.0
2025-08-19 06:00:00	SPY	ETF	643.01	643.01	642.5	642.67	25578.0
2025-08-19 07:00:00	SPY	ETF	642.66	643.28	642.66	643.23	40369.0
2025-08-19 08:00:00	SPY	ETF	643.21	643.34	642.0	642.85	181568.0
2025-08-19 09:00:00	SPY	ETF	642.81	643.43	641.99	642.87	5878628.0
2025-08-19 10:00:00	SPY	ETF	642.86	644.105	641.21	641.215	8729329.0
2025-08-19 11:00:00	SPY	ETF	641.22	641.91	640.47	640.75	5841623.0
2025-08-19 12:00:00	SPY	ETF	640.73	641.1	639.331	639.67	5272188.0
2025-08-19 13:00:00	SPY	ETF	639.67	640.11	638.805	639.83	4751505.0
2025-08-19 14:00:00	SPY	ETF	639.82	639.88	638.66	639.1	4510905.0
2025-08-19 15:00:00	SPY	ETF	639.12	639.91	638.48	639.77	11658012.0
2025-08-19 16:00:00	SPY	ETF	639.77	640.11	639.74	640.01	2878889.0
2025-08-19 17:00:00	SPY	ETF	639.98	640.04	639.65	639.7	81180.0
2025-08-19 18:00:00	SPY	ETF	639.72	640.19	639.5	639.8101	250837.0
2025-08-19 19:00:00	SPY	ETF	639.7407	639.88	638.94	639.2	92266.0
2025-08-19 20:00:00	SPY	ETF	639.22	639.22	639.22	639.22	500.0
2025-08-19 04:00:00	QQQ	ETF	576.75	577.0	576.07	577.0	19414.0
2025-08-19 05:00:00	QQQ	ETF	576.91	577.36	576.88	576.99	16073.0
2025-08-19 06:00:00	QQQ	ETF	576.98	576.98	576.14	576.44	21016.0
2025-08-19 07:00:00	QQQ	ETF	576.41	576.7	576.22	576.68	26281.0
2025-08-19 08:00:00	QQQ	ETF	576.46	577.31	575.67	575.89	122622.0
2025-08-19 09:00:00	QQQ	ETF	575.93	576.56	573.42	574.32	6271390.0
2025-08-19 10:00:00	QQQ	ETF	574.33	575.53	571.02	571.0399	7339258.0
2025-08-19 11:00:00	QQQ	ETF	571.03	572.175	570.39	571.46	4737940.0
2025-08-19 12:00:00	QQQ	ETF	571.45	571.91	569.38	569.6	4901729.0
2025-08-19 13:00:00	QQQ	ETF	569.595	570.42	568.71	570.2	4073270.0
2025-08-19 14:00:00	QQQ	ETF	570.2	570.22	568.69	569.12	3040626.0
2025-08-19 15:00:00	QQQ	ETF	569.13	569.45	568.25	569.28	6489637.0
2025-08-19 16:00:00	QQQ	ETF	569.29	569.69	569.16	569.32	1508323.0
2025-08-19 17:00:00	QQQ	ETF	569.3892	569.49	568.72	568.84	279814.0
2025-08-19 18:00:00	QQQ	ETF	568.88	569.6	568.88	568.98	151418.0
2025-08-19 19:00:00	QQQ	ETF	569.01	569.16	567.93	568.08	180588.0
2025-08-19 04:00:00	IWM	ETF	227.52	227.68	227.4	227.64	13480.0
2025-08-19 05:00:00	IWM	ETF	227.62	227.8	227.61	227.61	8304.0
2025-08-19 06:00:00	IWM	ETF	227.61	227.7	227.5	227.62	10790.0
2025-08-19 07:00:00	IWM	ETF	227.63	227.93	227.6	227.93	32755.0
2025-08-19 08:00:00	IWM	ETF	227.6291	227.92	227.25	227.9	152596.0
2025-08-19 09:00:00	IWM	ETF	227.87	228.38	227.75	227.945	2529527.0
2025-08-19 10:00:00	IWM	ETF	227.94	228.98	227.24	227.24	3876110.0
2025-08-19 11:00:00	IWM	ETF	227.23	227.505	226.3199	226.505	2637521.0
2025-08-19 12:00:00	IWM	ETF	226.5	226.845	226.09	226.325	2124360.0
2025-08-19 13:00:00	IWM	ETF	226.33	226.38	225.752	226.16	2049443.0
2025-08-19 14:00:00	IWM	ETF	226.18	226.22	225.71	226.115	1688315.0
2025-08-19 15:00:00	IWM	ETF	226.11	226.28	225.685	226.2	3762943.0
2025-08-19 16:00:00	IWM	ETF	226.21	226.4	226.21	226.4	692281.0
2025-08-19 17:00:00	IWM	ETF	226.3	226.45	226.1	226.12	8140.0
2025-08-19 18:00:00	IWM	ETF	226.35	226.5	226.18	226.24	37257.0
2025-08-19 19:00:00	IWM	ETF	226.26	226.27	225.96	226.04	24984.0
2025-08-19 04:00:00	DIA	ETF	448.75	449.15	448.72	449.15	1600.0

> showing 50 of 25,579 rows — these rows as CSV

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