PREVIEW / etf_1hour / 2025-01-03

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-01-03.parquet
  size:    615 KB
  rows:    22,781

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-01-03 04:00:00	SPY	ETF	586.0	587.25	585.89	587.12	35019.0
2025-01-03 05:00:00	SPY	ETF	586.9	586.9	585.96	586.1	22778.0
2025-01-03 06:00:00	SPY	ETF	586.02	586.19	585.7	585.99	6833.0
2025-01-03 07:00:00	SPY	ETF	586.01	586.35	585.4	586.28	258691.0
2025-01-03 08:00:00	SPY	ETF	586.0	586.92	585.48	586.1194	190038.0
2025-01-03 09:00:00	SPY	ETF	586.2	589.545	586.2	588.01	4365583.0
2025-01-03 10:00:00	SPY	ETF	588.02	589.46	586.43	589.15	3844588.0
2025-01-03 11:00:00	SPY	ETF	589.18	590.99	588.12	590.3861	2635260.0
2025-01-03 12:00:00	SPY	ETF	590.39	591.01	589.9	590.69	2199178.0
2025-01-03 13:00:00	SPY	ETF	590.69	591.8401	590.2	591.29	2932991.0
2025-01-03 14:00:00	SPY	ETF	591.31	592.6	591.11	592.07	2781453.0
2025-01-03 15:00:00	SPY	ETF	592.04	592.21	591.05	591.87	6843121.0
2025-01-03 16:00:00	SPY	ETF	591.84	591.95	591.4	591.49	2711963.0
2025-01-03 17:00:00	SPY	ETF	591.54	591.7	591.5	591.62	20281.0
2025-01-03 18:00:00	SPY	ETF	591.72	591.91	591.63	591.84	22162.0
2025-01-03 19:00:00	SPY	ETF	591.9	592.07	591.86	592.0401	23836.0
2025-01-03 04:00:00	QQQ	ETF	511.92	513.21	511.89	512.9	39252.0
2025-01-03 05:00:00	QQQ	ETF	512.78	512.78	511.9	512.03	25500.0
2025-01-03 06:00:00	QQQ	ETF	511.98	512.33	511.63	512.33	20359.0
2025-01-03 07:00:00	QQQ	ETF	512.2	512.2	511.39	512.15	80746.0
2025-01-03 08:00:00	QQQ	ETF	511.98	512.87	511.36	511.83	222744.0
2025-01-03 09:00:00	QQQ	ETF	511.81	516.5899	511.761	515.48	3393512.0
2025-01-03 10:00:00	QQQ	ETF	515.4	516.73	512.53	515.27	3461538.0
2025-01-03 11:00:00	QQQ	ETF	515.28	517.97	514.35	517.31	2281257.0
2025-01-03 12:00:00	QQQ	ETF	517.34	517.87	516.81	517.47	1238898.0
2025-01-03 13:00:00	QQQ	ETF	517.48	518.9339	517.01	518.43	1782601.0
2025-01-03 14:00:00	QQQ	ETF	518.41	519.6454	518.15	519.07	1872201.0
2025-01-03 15:00:00	QQQ	ETF	519.07	519.07	517.71	518.56	4830420.0
2025-01-03 16:00:00	QQQ	ETF	518.56	518.69	516.772	518.1	1750084.0
2025-01-03 17:00:00	QQQ	ETF	518.1	518.6196	518.1	518.6196	33563.0
2025-01-03 18:00:00	QQQ	ETF	518.65	518.94	518.55	518.88	26663.0
2025-01-03 19:00:00	QQQ	ETF	518.84	519.0682	518.79	519.0682	15298.0
2025-01-03 04:00:00	IWM	ETF	221.52	222.02	221.52	221.81	14104.0
2025-01-03 05:00:00	IWM	ETF	221.77	221.77	221.34	221.42	5438.0
2025-01-03 06:00:00	IWM	ETF	221.42	221.45	221.17	221.4	4048.0
2025-01-03 07:00:00	IWM	ETF	221.38	221.67	221.25	221.64	40449.0
2025-01-03 08:00:00	IWM	ETF	221.2101	221.98	221.2101	221.53	118727.0
2025-01-03 09:00:00	IWM	ETF	221.58	223.14	221.47	221.63	2169358.0
2025-01-03 10:00:00	IWM	ETF	221.64	223.375	221.38	223.28	2146793.0
2025-01-03 11:00:00	IWM	ETF	223.31	223.56	222.5	223.35	1762024.0
2025-01-03 12:00:00	IWM	ETF	223.36	223.75	222.75	223.27	1196551.0
2025-01-03 13:00:00	IWM	ETF	223.26	224.14	223.05	224.07	1855973.0
2025-01-03 14:00:00	IWM	ETF	224.06	224.67	224.02	224.32	2205470.0
2025-01-03 15:00:00	IWM	ETF	224.32	224.82	224.01	224.48	3808947.0
2025-01-03 16:00:00	IWM	ETF	224.47	224.6	224.0	224.44	1558903.0
2025-01-03 17:00:00	IWM	ETF	224.44	224.57	224.43	224.46	2140.0
2025-01-03 18:00:00	IWM	ETF	224.58	224.5899	224.45	224.5813	5821.0
2025-01-03 19:00:00	IWM	ETF	224.67	224.81	224.54	224.75	6411.0
2025-01-03 04:00:00	DIA	ETF	425.51	425.51	425.38	425.41	1463.0
2025-01-03 05:00:00	DIA	ETF	424.61	424.64	424.61	424.64	660.0

> showing 50 of 22,781 rows — these rows as CSV

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