PREVIEW / etf_1hour / 2025-07-18

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-07-18.parquet
  size:    647 KB
  rows:    24,860

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-18 04:00:00	SPY	ETF	628.74	629.15	628.68	628.98	48410.0
2025-07-18 05:00:00	SPY	ETF	629.01	629.16	628.94	628.99	27583.0
2025-07-18 06:00:00	SPY	ETF	628.95	629.02	628.33	628.51	29538.0
2025-07-18 07:00:00	SPY	ETF	628.45	628.67	628.18	628.48	108600.0
2025-07-18 08:00:00	SPY	ETF	629.2	629.65	628.21	628.88	390229.0
2025-07-18 09:00:00	SPY	ETF	628.91	629.47	628.44	628.64	5039434.0
2025-07-18 10:00:00	SPY	ETF	628.65	629.35	627.12	627.13	6601714.0
2025-07-18 11:00:00	SPY	ETF	627.13	628.17	626.91	628.115	4005556.0
2025-07-18 12:00:00	SPY	ETF	628.115	628.16	626.48	626.68	5382581.0
2025-07-18 13:00:00	SPY	ETF	626.67	627.53	626.46	627.08	3420539.0
2025-07-18 14:00:00	SPY	ETF	627.09	627.41	626.66	627.215	3462212.0
2025-07-18 15:00:00	SPY	ETF	627.21	627.76	627.01	627.58	8553802.0
2025-07-18 16:00:00	SPY	ETF	627.59	627.7	627.43	627.59	3046292.0
2025-07-18 17:00:00	SPY	ETF	627.59	627.9	627.46	627.59	64680.0
2025-07-18 18:00:00	SPY	ETF	627.59	627.86	627.58	627.83	43314.0
2025-07-18 19:00:00	SPY	ETF	627.84	627.98	627.67	627.9	49930.0
2025-07-18 04:00:00	QQQ	ETF	562.31	562.73	562.25	562.66	17439.0
2025-07-18 05:00:00	QQQ	ETF	562.65	562.8	562.51	562.54	14061.0
2025-07-18 06:00:00	QQQ	ETF	562.54	562.62	561.98	562.26	28584.0
2025-07-18 07:00:00	QQQ	ETF	562.26	562.47	561.95	562.25	52903.0
2025-07-18 08:00:00	QQQ	ETF	562.35	563.24	561.94	562.33	161399.0
2025-07-18 09:00:00	QQQ	ETF	562.35	563.8	561.95	562.08	4385487.0
2025-07-18 10:00:00	QQQ	ETF	562.12	562.87	560.33	560.778	4752554.0
2025-07-18 11:00:00	QQQ	ETF	560.78	561.92	560.32	561.805	2937844.0
2025-07-18 12:00:00	QQQ	ETF	561.81	561.85	559.98	560.36	3330891.0
2025-07-18 13:00:00	QQQ	ETF	560.36	561.21	560.01	560.6114	3155355.0
2025-07-18 14:00:00	QQQ	ETF	560.64	561.2981	560.51	560.735	2160953.0
2025-07-18 15:00:00	QQQ	ETF	560.73	561.38	560.61	561.26	4482117.0
2025-07-18 16:00:00	QQQ	ETF	561.26	561.33	560.92	561.29	1256633.0
2025-07-18 17:00:00	QQQ	ETF	561.26	561.58	561.26	561.3763	74188.0
2025-07-18 18:00:00	QQQ	ETF	561.32	561.48	561.28	561.46	7380.0
2025-07-18 19:00:00	QQQ	ETF	561.4838	561.59	561.39	561.45	24021.0
2025-07-18 04:00:00	IWM	ETF	224.05	224.34	224.05	224.07	23631.0
2025-07-18 05:00:00	IWM	ETF	224.07	224.22	223.96	224.22	17212.0
2025-07-18 06:00:00	IWM	ETF	224.2	224.22	223.81	223.94	13859.0
2025-07-18 07:00:00	IWM	ETF	223.99	224.5	223.8	224.5	40029.0
2025-07-18 08:00:00	IWM	ETF	223.89	225.35	223.83	225.18	212428.0
2025-07-18 09:00:00	IWM	ETF	225.21	225.47	224.24	224.32	3318638.0
2025-07-18 10:00:00	IWM	ETF	224.36	224.82	222.7	222.78	5481547.0
2025-07-18 11:00:00	IWM	ETF	222.77	223.6299	222.68	223.46	2956374.0
2025-07-18 12:00:00	IWM	ETF	223.46	223.61	222.04	222.155	4033048.0
2025-07-18 13:00:00	IWM	ETF	222.14	222.66	221.99	222.49	2729093.0
2025-07-18 14:00:00	IWM	ETF	222.49	222.6	221.98	222.06	3399405.0
2025-07-18 15:00:00	IWM	ETF	222.075	222.55	222.0	222.3	5766973.0
2025-07-18 16:00:00	IWM	ETF	222.33	223.44	222.13	222.25	1158348.0
2025-07-18 17:00:00	IWM	ETF	222.33	222.49	222.25	222.29	9609.0
2025-07-18 18:00:00	IWM	ETF	222.39	222.48	222.2734	222.48	1197.0
2025-07-18 19:00:00	IWM	ETF	222.49	222.59	222.33	222.3317	4783.0
2025-07-18 04:00:00	DIA	ETF	445.84	445.84	445.63	445.64	1200.0
2025-07-18 05:00:00	DIA	ETF	445.69	445.69	445.59	445.66	4850.0

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

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