PREVIEW / etf_1hour / 2025-05-14

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-05-14.parquet
  size:    641 KB
  rows:    24,793

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-05-14 04:00:00	SPY	ETF	587.46	587.57	586.84	587.09	29371.0
2025-05-14 05:00:00	SPY	ETF	587.04	587.18	586.26	586.46	28635.0
2025-05-14 06:00:00	SPY	ETF	586.46	587.2	586.19	587.01	22520.0
2025-05-14 07:00:00	SPY	ETF	587.01	588.8	586.99	588.11	245319.0
2025-05-14 08:00:00	SPY	ETF	587.74	588.88	586.8096	588.0	325906.0
2025-05-14 09:00:00	SPY	ETF	587.97	588.98	586.46	587.5308	5601466.0
2025-05-14 10:00:00	SPY	ETF	587.54	587.91	586.39	587.54	5751055.0
2025-05-14 11:00:00	SPY	ETF	587.54	588.35	585.8	588.0002	5207824.0
2025-05-14 12:00:00	SPY	ETF	588.0	588.5651	587.1	587.4601	3214072.0
2025-05-14 13:00:00	SPY	ETF	587.47	587.51	585.535	587.3355	4995929.0
2025-05-14 14:00:00	SPY	ETF	587.34	588.22	586.575	587.625	4632259.0
2025-05-14 15:00:00	SPY	ETF	587.62	588.14	586.39	587.56	12492358.0
2025-05-14 16:00:00	SPY	ETF	587.55	587.66	587.1001	587.14	4527288.0
2025-05-14 17:00:00	SPY	ETF	587.07	587.24	586.58	586.7	82416.0
2025-05-14 18:00:00	SPY	ETF	586.67	586.86	586.522	586.65	74702.0
2025-05-14 19:00:00	SPY	ETF	586.68	586.69	585.72	586.13	199026.0
2025-05-14 04:00:00	QQQ	ETF	516.49	516.73	515.35	515.84	111286.0
2025-05-14 05:00:00	QQQ	ETF	515.71	516.13	514.9	515.5	92762.0
2025-05-14 06:00:00	QQQ	ETF	515.41	516.47	515.29	516.25	55771.0
2025-05-14 07:00:00	QQQ	ETF	516.33	518.4	516.24	517.49	390145.0
2025-05-14 08:00:00	QQQ	ETF	516.4	518.4086	515.204	516.97	495299.0
2025-05-14 09:00:00	QQQ	ETF	516.96	518.92	515.75	517.0992	6043453.0
2025-05-14 10:00:00	QQQ	ETF	517.12	518.05	516.33	517.7536	5363226.0
2025-05-14 11:00:00	QQQ	ETF	517.77	518.53	516.11	518.2	4400536.0
2025-05-14 12:00:00	QQQ	ETF	518.19	519.2279	517.73	517.98	3158576.0
2025-05-14 13:00:00	QQQ	ETF	517.99	518.04	515.92	517.9364	3427355.0
2025-05-14 14:00:00	QQQ	ETF	517.94	518.82	517.24	518.03	2745501.0
2025-05-14 15:00:00	QQQ	ETF	518.03	518.93	517.1	518.7	6270296.0
2025-05-14 16:00:00	QQQ	ETF	518.68	519.1	518.29	518.79	1443666.0
2025-05-14 17:00:00	QQQ	ETF	518.85	518.85	517.79	517.93	87971.0
2025-05-14 18:00:00	QQQ	ETF	518.0	518.37	517.85	518.28	39458.0
2025-05-14 19:00:00	QQQ	ETF	518.29	518.29	517.741	518.15	58811.0
2025-05-14 04:00:00	IWM	ETF	208.26	208.44	208.01	208.15	23573.0
2025-05-14 05:00:00	IWM	ETF	208.13	208.31	207.9	208.27	13085.0
2025-05-14 06:00:00	IWM	ETF	208.0	208.18	207.9	208.09	10547.0
2025-05-14 07:00:00	IWM	ETF	208.08	208.82	208.04	208.5	60485.0
2025-05-14 08:00:00	IWM	ETF	208.44	208.82	208.02	208.53	107720.0
2025-05-14 09:00:00	IWM	ETF	208.48	208.54	207.17	207.45	3702261.0
2025-05-14 10:00:00	IWM	ETF	207.46	207.77	207.15	207.31	3100313.0
2025-05-14 11:00:00	IWM	ETF	207.31	207.58	206.53	207.48	2684154.0
2025-05-14 12:00:00	IWM	ETF	207.46	207.835	207.06	207.34	1386113.0
2025-05-14 13:00:00	IWM	ETF	207.35	207.485	206.71	207.29	1429348.0
2025-05-14 14:00:00	IWM	ETF	207.29	207.48	206.83	207.125	1587536.0
2025-05-14 15:00:00	IWM	ETF	207.13	207.43	206.78	206.81	3771988.0
2025-05-14 16:00:00	IWM	ETF	206.81	207.04	206.67	206.74	1968128.0
2025-05-14 17:00:00	IWM	ETF	206.6323	206.83	206.36	206.63	18827.0
2025-05-14 18:00:00	IWM	ETF	206.63	206.8	206.37	206.42	51662.0
2025-05-14 19:00:00	IWM	ETF	206.4	206.4	206.11	206.28	20766.0
2025-05-14 04:00:00	DIA	ETF	421.98	422.15	421.73	422.15	4436.0
2025-05-14 05:00:00	DIA	ETF	422.07	422.07	421.31	421.35	2190.0

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

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