PREVIEW / etf_1hour / 2025-07-22

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-07-22.parquet
  size:    659 KB
  rows:    25,564

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-07-22 04:00:00	SPY	ETF	628.31	628.66	627.93	628.05	31387.0
2025-07-22 05:00:00	SPY	ETF	628.03	628.18	627.87	628.04	21423.0
2025-07-22 06:00:00	SPY	ETF	628.11	628.35	628.01	628.28	21454.0
2025-07-22 07:00:00	SPY	ETF	628.28	629.01	628.06	628.96	68809.0
2025-07-22 08:00:00	SPY	ETF	628.91	629.21	628.0902	629.09	348472.0
2025-07-22 09:00:00	SPY	ETF	629.11	629.25	626.19	626.88	7065144.0
2025-07-22 10:00:00	SPY	ETF	626.89	628.035	626.2499	627.95	6433625.0
2025-07-22 11:00:00	SPY	ETF	627.955	628.115	627.33	627.65	4309954.0
2025-07-22 12:00:00	SPY	ETF	627.66	628.125	627.04	627.855	4135177.0
2025-07-22 13:00:00	SPY	ETF	627.86	629.22	627.78	628.3547	4176039.0
2025-07-22 14:00:00	SPY	ETF	628.35	629.53	627.52	629.34	5730793.0
2025-07-22 15:00:00	SPY	ETF	629.34	629.73	628.75	628.83	10009103.0
2025-07-22 16:00:00	SPY	ETF	628.83	628.98	628.57	628.97	2908509.0
2025-07-22 17:00:00	SPY	ETF	628.9	628.99	628.87	628.92	45506.0
2025-07-22 18:00:00	SPY	ETF	628.91	629.26	628.57	628.68	68795.0
2025-07-22 19:00:00	SPY	ETF	628.75	630.62	628.74	630.51	185271.0
2025-07-22 04:00:00	QQQ	ETF	563.28	563.55	562.53	562.64	51952.0
2025-07-22 05:00:00	QQQ	ETF	562.62	562.87	562.46	562.8	144726.0
2025-07-22 06:00:00	QQQ	ETF	562.85	563.25	562.7	563.2	63510.0
2025-07-22 07:00:00	QQQ	ETF	563.23	564.0	563.12	564.0	73646.0
2025-07-22 08:00:00	QQQ	ETF	563.65	564.3	562.75	564.03	188093.0
2025-07-22 09:00:00	QQQ	ETF	564.03	564.36	558.63	559.335	6787319.0
2025-07-22 10:00:00	QQQ	ETF	559.34	561.48	558.61	561.352	5686347.0
2025-07-22 11:00:00	QQQ	ETF	561.36	561.61	560.635	560.935	2793976.0
2025-07-22 12:00:00	QQQ	ETF	560.95	561.3599	559.78	560.71	3064458.0
2025-07-22 13:00:00	QQQ	ETF	560.715	561.975	560.64	561.19	2439670.0
2025-07-22 14:00:00	QQQ	ETF	561.18	562.06	560.06	562.035	2845296.0
2025-07-22 15:00:00	QQQ	ETF	562.02	562.14	561.21	561.29	5282577.0
2025-07-22 16:00:00	QQQ	ETF	561.28	561.32	560.47	560.6901	1732549.0
2025-07-22 17:00:00	QQQ	ETF	560.71	560.7584	560.36	560.45	40270.0
2025-07-22 18:00:00	QQQ	ETF	560.5	560.83	560.06	560.25	141593.0
2025-07-22 19:00:00	QQQ	ETF	560.31	562.3419	560.31	562.27	218795.0
2025-07-22 04:00:00	IWM	ETF	221.2	221.41	221.08	221.19	36285.0
2025-07-22 05:00:00	IWM	ETF	221.22	221.25	220.9	220.99	11155.0
2025-07-22 06:00:00	IWM	ETF	221.04	221.27	220.95	221.27	8295.0
2025-07-22 07:00:00	IWM	ETF	221.27	221.68	221.06	221.66	43898.0
2025-07-22 08:00:00	IWM	ETF	221.2782	222.0	221.12	221.85	101658.0
2025-07-22 09:00:00	IWM	ETF	221.85	222.6	220.66	220.98	4554074.0
2025-07-22 10:00:00	IWM	ETF	220.99	222.8299	220.92	222.55	5020166.0
2025-07-22 11:00:00	IWM	ETF	222.55	223.005	222.08	222.67	2300230.0
2025-07-22 12:00:00	IWM	ETF	222.68	222.895	222.08	222.52	1630228.0
2025-07-22 13:00:00	IWM	ETF	222.515	223.2	222.4	222.92	1777113.0
2025-07-22 14:00:00	IWM	ETF	222.92	223.68	222.78	223.53	2571949.0
2025-07-22 15:00:00	IWM	ETF	223.53	223.81	223.22	223.26	4410527.0
2025-07-22 16:00:00	IWM	ETF	223.27	223.6	223.19	223.55	1111661.0
2025-07-22 17:00:00	IWM	ETF	223.62	223.7	223.3482	223.7	9627.0
2025-07-22 18:00:00	IWM	ETF	223.53	223.73	223.42	223.48	22722.0
2025-07-22 19:00:00	IWM	ETF	223.47	224.45	223.47	224.37	85447.0
2025-07-22 04:00:00	DIA	ETF	443.63	443.63	443.37	443.57	2081.0
2025-07-22 05:00:00	DIA	ETF	443.43	443.43	443.4	443.4	600.0

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

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