PREVIEW / etf_1hour / 2025-12-09

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-12-09.parquet
  size:    707 KB
  rows:    27,071

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-12-09 04:00:00	SPY	ETF	684.5	684.5	683.73	683.83	15180.0
2025-12-09 05:00:00	SPY	ETF	683.85	684.39	682.67	684.28	167774.0
2025-12-09 06:00:00	SPY	ETF	684.05	684.3	683.49	684.22	151836.0
2025-12-09 07:00:00	SPY	ETF	684.24	684.27	683.61	683.99	134201.0
2025-12-09 08:00:00	SPY	ETF	683.96	684.85	682.97	683.18	318399.0
2025-12-09 09:00:00	SPY	ETF	683.16	684.53	682.62	684.44	5667239.0
2025-12-09 10:00:00	SPY	ETF	684.47	684.94	683.585	684.505	6206991.0
2025-12-09 11:00:00	SPY	ETF	684.49	685.385	684.44	684.97	5047626.0
2025-12-09 12:00:00	SPY	ETF	684.96	685.34	683.62	684.275	4669438.0
2025-12-09 13:00:00	SPY	ETF	684.27	684.49	683.35	684.05	4217267.0
2025-12-09 14:00:00	SPY	ETF	684.06	684.1399	683.2	683.63	4117677.0
2025-12-09 15:00:00	SPY	ETF	683.63	683.8526	682.59	683.05	12098288.0
2025-12-09 16:00:00	SPY	ETF	683.05	683.08	682.51	682.85	4460912.0
2025-12-09 17:00:00	SPY	ETF	682.77	682.96	682.69	682.933	34379.0
2025-12-09 18:00:00	SPY	ETF	682.8205	683.03	682.76	682.8	54539.0
2025-12-09 19:00:00	SPY	ETF	682.77	683.21	682.5	682.5	82119.0
2025-12-09 04:00:00	QQQ	ETF	624.75	624.9	623.83	623.96	34229.0
2025-12-09 05:00:00	QQQ	ETF	623.95	624.8	622.7	624.27	137592.0
2025-12-09 06:00:00	QQQ	ETF	624.24	624.54	623.35	624.31	78522.0
2025-12-09 07:00:00	QQQ	ETF	624.34	624.41	623.71	624.11	100416.0
2025-12-09 08:00:00	QQQ	ETF	624.13	625.28	622.78	623.0191	354584.0
2025-12-09 09:00:00	QQQ	ETF	623.02	623.87	621.0	623.31	5207340.0
2025-12-09 10:00:00	QQQ	ETF	623.35	624.67	623.0	624.645	4680304.0
2025-12-09 11:00:00	QQQ	ETF	624.63	625.385	624.27	625.225	4666216.0
2025-12-09 12:00:00	QQQ	ETF	625.23	625.81	624.78	625.44	3609108.0
2025-12-09 13:00:00	QQQ	ETF	625.43	625.87	624.8099	625.54	3324015.0
2025-12-09 14:00:00	QQQ	ETF	625.55	625.6	624.63	625.09	3116450.0
2025-12-09 15:00:00	QQQ	ETF	625.09	625.55	624.72	625.11	5365996.0
2025-12-09 16:00:00	QQQ	ETF	625.12	625.14	624.45	624.62	847751.0
2025-12-09 17:00:00	QQQ	ETF	624.56	624.7	624.2	624.46	65661.0
2025-12-09 18:00:00	QQQ	ETF	624.46	624.74	624.32	624.36	36936.0
2025-12-09 19:00:00	QQQ	ETF	624.36	624.8488	623.9287	623.9287	46170.0
2025-12-09 04:00:00	IWM	ETF	250.8	251.09	250.74	250.87	21360.0
2025-12-09 05:00:00	IWM	ETF	250.74	251.33	250.2	251.33	28748.0
2025-12-09 06:00:00	IWM	ETF	251.33	251.33	251.06	251.25	12108.0
2025-12-09 07:00:00	IWM	ETF	251.18	251.2	250.8	250.96	31723.0
2025-12-09 08:00:00	IWM	ETF	250.91	251.33	250.37	250.56	106203.0
2025-12-09 09:00:00	IWM	ETF	250.52	251.95	250.06	251.56	3396264.0
2025-12-09 10:00:00	IWM	ETF	251.545	252.11	250.89	252.085	2472698.0
2025-12-09 11:00:00	IWM	ETF	252.07	252.95	252.0693	252.295	2621318.0
2025-12-09 12:00:00	IWM	ETF	252.295	252.5301	251.655	252.19	2573785.0
2025-12-09 13:00:00	IWM	ETF	252.18	252.26	251.59	251.99	1511421.0
2025-12-09 14:00:00	IWM	ETF	251.98	252.12	251.525	251.97	1686702.0
2025-12-09 15:00:00	IWM	ETF	251.975	252.08	251.2	251.37	3355469.0
2025-12-09 16:00:00	IWM	ETF	251.375	251.45	251.04	251.28	615850.0
2025-12-09 17:00:00	IWM	ETF	251.22	251.35	251.2	251.35	6667.0
2025-12-09 18:00:00	IWM	ETF	251.321	251.36	251.1	251.15	10764.0
2025-12-09 19:00:00	IWM	ETF	251.15	251.3867	251.12	251.1527	11290.0
2025-12-09 04:00:00	DIA	ETF	478.25	478.32	478.25	478.25	765.0
2025-12-09 05:00:00	DIA	ETF	478.32	478.58	477.58	478.57	6282.0

> showing 50 of 27,071 rows — these rows as CSV

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