PREVIEW / etf_1hour / 2025-08-13

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-08-13.parquet
  size:    678 KB
  rows:    26,084

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-13 04:00:00	SPY	ETF	643.55	644.38	643.53	643.84	25080.0
2025-08-13 05:00:00	SPY	ETF	643.91	644.4	643.79	644.34	23993.0
2025-08-13 06:00:00	SPY	ETF	644.36	644.39	643.9	644.09	19623.0
2025-08-13 07:00:00	SPY	ETF	644.13	644.32	643.92	644.25	77837.0
2025-08-13 08:00:00	SPY	ETF	644.15	644.79	642.57	644.55	283186.0
2025-08-13 09:00:00	SPY	ETF	644.58	646.19	644.49	645.62	5973868.0
2025-08-13 10:00:00	SPY	ETF	645.63	645.7188	643.58	643.83	7687823.0
2025-08-13 11:00:00	SPY	ETF	643.82	644.255	643.07	643.43	5650903.0
2025-08-13 12:00:00	SPY	ETF	643.44	643.915	642.68	643.01	3178572.0
2025-08-13 13:00:00	SPY	ETF	643.01	643.76	642.7	643.55	3654221.0
2025-08-13 14:00:00	SPY	ETF	643.56	644.31	643.24	644.015	4103839.0
2025-08-13 15:00:00	SPY	ETF	644.02	645.1	643.8312	644.88	9237609.0
2025-08-13 16:00:00	SPY	ETF	644.87	645.25	644.34	644.39	2073097.0
2025-08-13 17:00:00	SPY	ETF	644.45	644.69	644.4	644.63	46415.0
2025-08-13 18:00:00	SPY	ETF	644.57	644.83	643.99	644.81	43436.0
2025-08-13 19:00:00	SPY	ETF	644.81	644.99	644.63	644.72	22827.0
2025-08-13 04:00:00	QQQ	ETF	581.5	582.05	581.13	581.53	63814.0
2025-08-13 05:00:00	QQQ	ETF	581.55	581.92	581.37	581.89	19374.0
2025-08-13 06:00:00	QQQ	ETF	581.9	581.99	581.46	581.55	21744.0
2025-08-13 07:00:00	QQQ	ETF	581.53	581.78	581.36	581.55	30281.0
2025-08-13 08:00:00	QQQ	ETF	581.59	582.49	579.615	582.15	243940.0
2025-08-13 09:00:00	QQQ	ETF	582.1209	583.3199	581.815	582.0895	3949258.0
2025-08-13 10:00:00	QQQ	ETF	582.1	582.11	580.06	580.6988	5530143.0
2025-08-13 11:00:00	QQQ	ETF	580.69	580.73	579.065	579.87	4507940.0
2025-08-13 12:00:00	QQQ	ETF	579.9	580.2344	578.94	579.2506	2349787.0
2025-08-13 13:00:00	QQQ	ETF	579.2524	580.43	579.17	580.23	2433379.0
2025-08-13 14:00:00	QQQ	ETF	580.23	580.595	578.98	580.1	3143427.0
2025-08-13 15:00:00	QQQ	ETF	580.11	580.64	579.56	580.35	4495159.0
2025-08-13 16:00:00	QQQ	ETF	580.33	580.71	579.81	579.88	979564.0
2025-08-13 17:00:00	QQQ	ETF	579.95	580.06	579.9	580.01	52388.0
2025-08-13 18:00:00	QQQ	ETF	580.04	580.48	579.53	580.41	33673.0
2025-08-13 19:00:00	QQQ	ETF	580.41	580.8	580.241	580.4599	47364.0
2025-08-13 04:00:00	IWM	ETF	227.08	228.27	227.08	227.99	41508.0
2025-08-13 05:00:00	IWM	ETF	227.98	228.42	227.93	228.35	34702.0
2025-08-13 06:00:00	IWM	ETF	228.34	228.45	228.1	228.15	36184.0
2025-08-13 07:00:00	IWM	ETF	228.09	228.61	228.03	228.44	72974.0
2025-08-13 08:00:00	IWM	ETF	228.15	228.721	227.27	228.55	312684.0
2025-08-13 09:00:00	IWM	ETF	228.531	229.265	227.83	228.62	6663474.0
2025-08-13 10:00:00	IWM	ETF	228.61	229.255	228.09	228.19	4840794.0
2025-08-13 11:00:00	IWM	ETF	228.19	229.67	228.17	229.25	4233985.0
2025-08-13 12:00:00	IWM	ETF	229.24	230.04	229.24	229.9	2511854.0
2025-08-13 13:00:00	IWM	ETF	229.91	230.2493	229.565	229.885	2069187.0
2025-08-13 14:00:00	IWM	ETF	229.88	230.42	229.83	230.39	1800310.0
2025-08-13 15:00:00	IWM	ETF	230.4	231.46	230.36	231.25	7580661.0
2025-08-13 16:00:00	IWM	ETF	231.22	231.42	230.93	230.93	1682156.0
2025-08-13 17:00:00	IWM	ETF	230.95	231.3	230.82	231.21	27357.0
2025-08-13 18:00:00	IWM	ETF	231.14	231.22	230.71	231.2	56828.0
2025-08-13 19:00:00	IWM	ETF	231.18	231.22	230.95	230.98	19970.0
2025-08-13 04:00:00	DIA	ETF	445.38	445.88	445.38	445.68	2800.0
2025-08-13 05:00:00	DIA	ETF	445.69	446.08	445.64	446.06	2000.0

> showing 50 of 26,084 rows — these rows as CSV

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