PREVIEW / etf_1hour / 2025-08-14

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-08-14.parquet
  size:    674 KB
  rows:    25,802

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-14 04:00:00	SPY	ETF	644.56	644.85	644.51	644.58	11573.0
2025-08-14 05:00:00	SPY	ETF	644.52	644.95	644.49	644.78	9213.0
2025-08-14 06:00:00	SPY	ETF	644.75	644.86	644.46	644.58	8362.0
2025-08-14 07:00:00	SPY	ETF	644.56	645.19	644.48	645.13	56437.0
2025-08-14 08:00:00	SPY	ETF	644.47	645.21	641.4	642.6	2151850.0
2025-08-14 09:00:00	SPY	ETF	642.55	644.25	642.05	644.02	6209304.0
2025-08-14 10:00:00	SPY	ETF	644.02	645.545	643.7	644.74	5668945.0
2025-08-14 11:00:00	SPY	ETF	644.74	644.79	642.96	644.07	5378814.0
2025-08-14 12:00:00	SPY	ETF	644.04	644.26	642.665	644.17	3542345.0
2025-08-14 13:00:00	SPY	ETF	644.16	645.06	644.09	644.71	3274792.0
2025-08-14 14:00:00	SPY	ETF	644.72	644.95	643.91	644.6	4699072.0
2025-08-14 15:00:00	SPY	ETF	644.59	645.62	644.48	644.94	9433696.0
2025-08-14 16:00:00	SPY	ETF	644.93	645.3974	644.2306	645.07	2438489.0
2025-08-14 17:00:00	SPY	ETF	645.09	645.12	644.8	644.92	79260.0
2025-08-14 18:00:00	SPY	ETF	644.95	645.329	644.77	645.25	33879.0
2025-08-14 19:00:00	SPY	ETF	645.28	645.527	645.16	645.16	36107.0
2025-08-14 04:00:00	QQQ	ETF	580.15	580.36	579.9	579.96	12545.0
2025-08-14 05:00:00	QQQ	ETF	579.92	580.27	579.82	579.96	19884.0
2025-08-14 06:00:00	QQQ	ETF	580.0	580.26	579.86	580.16	8024.0
2025-08-14 07:00:00	QQQ	ETF	580.2	580.75	580.05	580.68	91152.0
2025-08-14 08:00:00	QQQ	ETF	580.14	580.9	576.74	577.98	1313864.0
2025-08-14 09:00:00	QQQ	ETF	577.95	580.8	577.3	580.19	5799475.0
2025-08-14 10:00:00	QQQ	ETF	580.2	581.88	579.45	580.6822	4684354.0
2025-08-14 11:00:00	QQQ	ETF	580.68	580.79	578.45	580.1	4445200.0
2025-08-14 12:00:00	QQQ	ETF	580.09	580.55	578.46	580.46	3745615.0
2025-08-14 13:00:00	QQQ	ETF	580.46	581.23	580.2475	580.83	2743864.0
2025-08-14 14:00:00	QQQ	ETF	580.84	580.84	579.18	579.91	2992464.0
2025-08-14 15:00:00	QQQ	ETF	579.9	580.745	579.75	579.86	4770289.0
2025-08-14 16:00:00	QQQ	ETF	579.86	580.0331	578.65	579.18	1650143.0
2025-08-14 17:00:00	QQQ	ETF	578.9625	579.07	578.95	579.02	31707.0
2025-08-14 18:00:00	QQQ	ETF	578.98	579.29	578.74	579.2	74307.0
2025-08-14 19:00:00	QQQ	ETF	579.25	579.59	579.05	579.05	42959.0
2025-08-14 04:00:00	IWM	ETF	231.01	231.24	230.94	230.94	16907.0
2025-08-14 05:00:00	IWM	ETF	230.94	231.04	230.84	230.84	5924.0
2025-08-14 06:00:00	IWM	ETF	230.89	230.91	230.54	230.63	19693.0
2025-08-14 07:00:00	IWM	ETF	230.63	230.89	230.54	230.86	60598.0
2025-08-14 08:00:00	IWM	ETF	230.68	231.36	227.4701	228.24	1852676.0
2025-08-14 09:00:00	IWM	ETF	228.252	228.8	227.61	228.24	5531445.0
2025-08-14 10:00:00	IWM	ETF	228.24	228.57	227.54	228.07	4045804.0
2025-08-14 11:00:00	IWM	ETF	228.07	228.14	226.945	227.32	3888747.0
2025-08-14 12:00:00	IWM	ETF	227.335	227.335	226.17	226.9	3669389.0
2025-08-14 13:00:00	IWM	ETF	226.9	227.59	226.855	227.42	3296910.0
2025-08-14 14:00:00	IWM	ETF	227.43	228.105	227.17	228.08	2989991.0
2025-08-14 15:00:00	IWM	ETF	228.075	228.645	227.9	228.21	5827701.0
2025-08-14 16:00:00	IWM	ETF	228.24	228.42	227.96	228.3	1403445.0
2025-08-14 17:00:00	IWM	ETF	228.32	228.42	228.16	228.23	12632.0
2025-08-14 18:00:00	IWM	ETF	228.24	228.534	228.2	228.33	12254.0
2025-08-14 19:00:00	IWM	ETF	228.45	228.57	228.39	228.4389	6716.0
2025-08-14 04:00:00	DIA	ETF	449.56	449.58	449.42	449.48	1900.0
2025-08-14 05:00:00	DIA	ETF	449.45	449.81	449.45	449.6	1400.0

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

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