PREVIEW / etf_1hour / 2025-03-03

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-03-03.parquet
  size:    653 KB
  rows:    25,949

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-03-03 04:00:00	SPY	ETF	593.88	595.92	593.88	595.92	93673.0
2025-03-03 05:00:00	SPY	ETF	595.9	596.0	595.22	595.88	20231.0
2025-03-03 06:00:00	SPY	ETF	595.84	596.56	595.84	596.56	37277.0
2025-03-03 07:00:00	SPY	ETF	596.48	597.63	596.35	596.74	277271.0
2025-03-03 08:00:00	SPY	ETF	596.46	597.62	593.5	596.17	300377.0
2025-03-03 09:00:00	SPY	ETF	596.2	597.34	592.44	593.05	5261254.0
2025-03-03 10:00:00	SPY	ETF	592.67	595.125	590.71	592.4159	6267271.0
2025-03-03 11:00:00	SPY	ETF	592.41	594.55	591.17	593.055	3755808.0
2025-03-03 12:00:00	SPY	ETF	593.04	594.22	591.42	592.015	2054889.0
2025-03-03 13:00:00	SPY	ETF	592.015	592.13	587.48	589.17	6215940.0
2025-03-03 14:00:00	SPY	ETF	589.12	590.65	585.97	586.05	5720512.0
2025-03-03 15:00:00	SPY	ETF	586.03	586.08	579.9	583.97	19307168.0
2025-03-03 16:00:00	SPY	ETF	583.98	587.9613	583.77	585.17	4470208.0
2025-03-03 17:00:00	SPY	ETF	585.1541	585.3	584.72	584.92	202979.0
2025-03-03 18:00:00	SPY	ETF	584.92	585.97	584.48	584.65	306021.0
2025-03-03 19:00:00	SPY	ETF	584.73	585.55	584.0	585.4	240717.0
2025-03-03 04:00:00	QQQ	ETF	508.92	510.63	508.44	510.43	112438.0
2025-03-03 05:00:00	QQQ	ETF	510.52	510.62	509.92	510.34	22300.0
2025-03-03 06:00:00	QQQ	ETF	510.2	511.24	510.12	511.18	69023.0
2025-03-03 07:00:00	QQQ	ETF	511.15	512.85	510.64	511.85	272999.0
2025-03-03 08:00:00	QQQ	ETF	511.36	512.46	507.64	511.7209	414964.0
2025-03-03 09:00:00	QQQ	ETF	511.64	513.04	505.8684	506.31	4054267.0
2025-03-03 10:00:00	QQQ	ETF	506.3	509.85	504.29	506.6664	4153155.0
2025-03-03 11:00:00	QQQ	ETF	506.7	509.77	506.08	508.25	2506641.0
2025-03-03 12:00:00	QQQ	ETF	508.24	509.26	505.81	506.51	1858211.0
2025-03-03 13:00:00	QQQ	ETF	506.475	506.67	501.72	504.0	3806136.0
2025-03-03 14:00:00	QQQ	ETF	503.95	505.75	500.42	500.51	2914985.0
2025-03-03 15:00:00	QQQ	ETF	500.5	500.5681	493.58	497.32	9224089.0
2025-03-03 16:00:00	QQQ	ETF	497.36	498.85	496.96	498.69	2417788.0
2025-03-03 17:00:00	QQQ	ETF	498.6899	498.69	497.85	498.02	134285.0
2025-03-03 18:00:00	QQQ	ETF	498.29	499.33	497.72	498.191	244638.0
2025-03-03 19:00:00	QQQ	ETF	498.25	499.27	497.4	499.17	222627.0
2025-03-03 04:00:00	IWM	ETF	215.37	216.23	215.23	216.11	91752.0
2025-03-03 05:00:00	IWM	ETF	216.24	216.27	215.87	216.2	30701.0
2025-03-03 06:00:00	IWM	ETF	216.18	216.39	215.99	216.28	16537.0
2025-03-03 07:00:00	IWM	ETF	216.25	216.94	216.18	216.5	162622.0
2025-03-03 08:00:00	IWM	ETF	216.4	216.61	215.22	215.72	133551.0
2025-03-03 09:00:00	IWM	ETF	215.7	216.08	213.52	213.675	3670121.0
2025-03-03 10:00:00	IWM	ETF	213.65	214.83	212.7	213.61	3519150.0
2025-03-03 11:00:00	IWM	ETF	213.63	214.04	212.75	213.74	2303327.0
2025-03-03 12:00:00	IWM	ETF	213.73	214.4487	213.34	213.46	1120714.0
2025-03-03 13:00:00	IWM	ETF	213.46	213.49	211.24	211.73	2764542.0
2025-03-03 14:00:00	IWM	ETF	211.71	212.36	210.02	210.07	2864757.0
2025-03-03 15:00:00	IWM	ETF	210.04	210.04	207.42	208.79	9062944.0
2025-03-03 16:00:00	IWM	ETF	208.8	209.6	208.75	209.45	2070950.0
2025-03-03 17:00:00	IWM	ETF	209.43	209.43	208.96	209.04	118170.0
2025-03-03 18:00:00	IWM	ETF	209.34	209.68	208.9	208.9	217264.0
2025-03-03 19:00:00	IWM	ETF	208.98	209.3	208.79	209.05	221940.0
2025-03-03 04:00:00	DIA	ETF	437.89	439.28	437.83	439.16	2301.0
2025-03-03 05:00:00	DIA	ETF	439.35	439.35	439.31	439.31	300.0

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

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