PREVIEW / etf_1hour / 2025-12-12

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-12-12.parquet
  size:    717 KB
  rows:    27,812

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-12 04:00:00	SPY	ETF	688.65	689.65	687.82	688.36	235080.0
2025-12-12 05:00:00	SPY	ETF	688.3	688.83	687.81	688.41	26839.0
2025-12-12 06:00:00	SPY	ETF	688.39	688.67	687.6	687.83	54935.0
2025-12-12 07:00:00	SPY	ETF	687.9	688.75	687.55	688.28	271050.0
2025-12-12 08:00:00	SPY	ETF	687.63	689.86	687.63	689.39	341565.0
2025-12-12 09:00:00	SPY	ETF	689.3936	689.45	687.17	687.49	6593521.0
2025-12-12 10:00:00	SPY	ETF	687.46	687.54	681.31	681.72	17458956.0
2025-12-12 11:00:00	SPY	ETF	681.72	682.46	679.1744	680.5994	15640941.0
2025-12-12 12:00:00	SPY	ETF	680.59	683.24	680.33	682.67	7353759.0
2025-12-12 13:00:00	SPY	ETF	682.68	684.34	682.38	682.55	6701752.0
2025-12-12 14:00:00	SPY	ETF	682.56	682.67	681.21	681.9699	7763475.0
2025-12-12 15:00:00	SPY	ETF	681.96	682.515	680.07	681.72	17631323.0
2025-12-12 16:00:00	SPY	ETF	681.73	682.28	681.61	681.97	4159685.0
2025-12-12 17:00:00	SPY	ETF	681.9514	682.2	681.93	682.0	51551.0
2025-12-12 18:00:00	SPY	ETF	682.0	682.13	681.76	681.95	44962.0
2025-12-12 19:00:00	SPY	ETF	681.92	681.95	681.76	681.8874	22544.0
2025-12-12 04:00:00	QQQ	ETF	624.0	624.7	618.29	622.75	138225.0
2025-12-12 05:00:00	QQQ	ETF	622.7	623.57	622.23	622.64	46338.0
2025-12-12 06:00:00	QQQ	ETF	622.65	622.72	621.45	621.87	83948.0
2025-12-12 07:00:00	QQQ	ETF	621.93	622.97	621.61	622.28	244968.0
2025-12-12 08:00:00	QQQ	ETF	621.83	626.049	621.56	623.68	502265.0
2025-12-12 09:00:00	QQQ	ETF	623.66	623.81	620.64	622.01	8613995.0
2025-12-12 10:00:00	QQQ	ETF	621.995	622.06	613.72	614.33	13229593.0
2025-12-12 11:00:00	QQQ	ETF	614.3	615.22	611.36	612.76	11998284.0
2025-12-12 12:00:00	QQQ	ETF	612.74	616.02	612.44	615.22	7189533.0
2025-12-12 13:00:00	QQQ	ETF	615.23	617.47	614.88	615.23	5350744.0
2025-12-12 14:00:00	QQQ	ETF	615.245	615.41	613.69	614.4	4640898.0
2025-12-12 15:00:00	QQQ	ETF	614.41	614.86	612.02	613.57	9373342.0
2025-12-12 16:00:00	QQQ	ETF	613.58	613.93	613.33	613.4399	1760544.0
2025-12-12 17:00:00	QQQ	ETF	613.42	613.5401	613.3	613.38	44443.0
2025-12-12 18:00:00	QQQ	ETF	613.38	613.38	612.85	612.8566	26583.0
2025-12-12 19:00:00	QQQ	ETF	612.85	612.99	612.75	612.8023	34294.0
2025-12-12 04:00:00	IWM	ETF	258.59	258.71	257.93	258.19	31524.0
2025-12-12 05:00:00	IWM	ETF	258.26	258.61	258.19	258.55	13335.0
2025-12-12 06:00:00	IWM	ETF	258.51	258.77	258.31	258.33	31866.0
2025-12-12 07:00:00	IWM	ETF	258.31	258.48	257.96	258.11	39907.0
2025-12-12 08:00:00	IWM	ETF	258.3101	258.95	257.81	257.96	158594.0
2025-12-12 09:00:00	IWM	ETF	257.97	258.2	257.19	257.3	3568252.0
2025-12-12 10:00:00	IWM	ETF	257.29	257.485	254.92	255.32	5353093.0
2025-12-12 11:00:00	IWM	ETF	255.33	255.75	253.51	253.89	6247398.0
2025-12-12 12:00:00	IWM	ETF	253.86	255.43	253.73	255.16	4539615.0
2025-12-12 13:00:00	IWM	ETF	255.18	255.9	254.99	255.15	3462012.0
2025-12-12 14:00:00	IWM	ETF	255.16	255.21	254.32	254.41	2731222.0
2025-12-12 15:00:00	IWM	ETF	254.43	254.57	253.44	253.89	6854304.0
2025-12-12 16:00:00	IWM	ETF	253.9	254.07	253.75	253.86	2673315.0
2025-12-12 17:00:00	IWM	ETF	253.84	254.01	253.8	253.94	19488.0
2025-12-12 18:00:00	IWM	ETF	253.89	254.27	253.75	253.78	13068.0
2025-12-12 19:00:00	IWM	ETF	253.73	253.8497	253.66	253.83	4275.0
2025-12-12 04:00:00	DIA	ETF	489.3	489.47	488.91	489.1	10381.0
2025-12-12 05:00:00	DIA	ETF	489.13	489.13	488.74	489.05	1842.0

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

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