PREVIEW / etf_1hour / 2025-12-08

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-12-08.parquet
  size:    710 KB
  rows:    27,512

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-08 04:00:00	SPY	ETF	686.59	686.98	686.41	686.45	37478.0
2025-12-08 05:00:00	SPY	ETF	686.54	686.86	686.3	686.76	16602.0
2025-12-08 06:00:00	SPY	ETF	686.71	686.71	686.17	686.25	15903.0
2025-12-08 07:00:00	SPY	ETF	686.27	686.97	686.1	686.84	168087.0
2025-12-08 08:00:00	SPY	ETF	686.12	687.32	686.12	686.89	272710.0
2025-12-08 09:00:00	SPY	ETF	686.9	687.2	684.98	685.44	5652959.0
2025-12-08 10:00:00	SPY	ETF	685.42	685.775	683.57	683.7	6398046.0
2025-12-08 11:00:00	SPY	ETF	683.7	684.12	682.91	683.3882	4208159.0
2025-12-08 12:00:00	SPY	ETF	683.39	684.31	682.19	684.1222	4599158.0
2025-12-08 13:00:00	SPY	ETF	684.13	684.4	681.57	682.11	4730258.0
2025-12-08 14:00:00	SPY	ETF	682.13	682.82	681.66	682.33	4204882.0
2025-12-08 15:00:00	SPY	ETF	682.34	683.76	682.06	683.63	10761687.0
2025-12-08 16:00:00	SPY	ETF	683.635	684.44	683.34	684.42	3510613.0
2025-12-08 17:00:00	SPY	ETF	684.41	684.66	684.17	684.52	129883.0
2025-12-08 18:00:00	SPY	ETF	684.52	684.86	683.63	684.84	274374.0
2025-12-08 19:00:00	SPY	ETF	684.7316	684.8	684.48	684.68	38087.0
2025-12-08 04:00:00	QQQ	ETF	626.8	627.32	626.68	626.73	48672.0
2025-12-08 05:00:00	QQQ	ETF	626.79	627.34	626.5	627.22	52713.0
2025-12-08 06:00:00	QQQ	ETF	627.15	627.3	626.69	626.79	24015.0
2025-12-08 07:00:00	QQQ	ETF	626.78	627.68	626.56	627.49	123701.0
2025-12-08 08:00:00	QQQ	ETF	627.48	628.19	625.949	627.64	437660.0
2025-12-08 09:00:00	QQQ	ETF	627.64	628.84	625.5	626.03	5664418.0
2025-12-08 10:00:00	QQQ	ETF	626.02	626.84	623.74	624.06	5610529.0
2025-12-08 11:00:00	QQQ	ETF	624.06	624.26	623.2	623.5	4861865.0
2025-12-08 12:00:00	QQQ	ETF	623.5	624.73	622.37	624.49	3929293.0
2025-12-08 13:00:00	QQQ	ETF	624.49	624.87	621.69	622.35	4597446.0
2025-12-08 14:00:00	QQQ	ETF	622.36	623.06	621.75	622.34	3555226.0
2025-12-08 15:00:00	QQQ	ETF	622.34	624.28	622.09	624.18	5623938.0
2025-12-08 16:00:00	QQQ	ETF	624.2	625.11	623.91	625.1	1388362.0
2025-12-08 17:00:00	QQQ	ETF	625.09	625.2	624.98	625.1	413895.0
2025-12-08 18:00:00	QQQ	ETF	625.14	625.61	624.78	625.59	130586.0
2025-12-08 19:00:00	QQQ	ETF	625.6	625.6	625.23	625.41	112438.0
2025-12-08 04:00:00	IWM	ETF	251.39	251.73	251.39	251.61	19044.0
2025-12-08 05:00:00	IWM	ETF	251.63	251.88	251.54	251.87	12250.0
2025-12-08 06:00:00	IWM	ETF	251.85	252.0	251.73	251.96	8789.0
2025-12-08 07:00:00	IWM	ETF	251.91	252.08	251.79	251.95	111157.0
2025-12-08 08:00:00	IWM	ETF	251.98	252.32	251.36	252.32	70853.0
2025-12-08 09:00:00	IWM	ETF	252.28	252.9	251.29	251.925	3568827.0
2025-12-08 10:00:00	IWM	ETF	251.93	252.23	250.97	250.98	3223620.0
2025-12-08 11:00:00	IWM	ETF	250.98	251.94	250.61	251.45	3176572.0
2025-12-08 12:00:00	IWM	ETF	251.45	251.7	251.0	251.65	2529752.0
2025-12-08 13:00:00	IWM	ETF	251.64	251.69	250.18	250.41	2151181.0
2025-12-08 14:00:00	IWM	ETF	250.42	251.33	250.26	250.98	2065687.0
2025-12-08 15:00:00	IWM	ETF	250.98	251.305	250.64	250.89	4790489.0
2025-12-08 16:00:00	IWM	ETF	250.9	251.04	250.6	250.72	681206.0
2025-12-08 17:00:00	IWM	ETF	250.79	250.8	250.5	250.7516	9695.0
2025-12-08 18:00:00	IWM	ETF	250.68	250.75	250.42	250.75	14712.0
2025-12-08 19:00:00	IWM	ETF	250.82	250.82	250.56	250.77	34178.0
2025-12-08 04:00:00	DIA	ETF	480.36	480.36	480.08	480.08	190.0
2025-12-08 05:00:00	DIA	ETF	480.01	480.32	480.01	480.3	1392.0

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

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