PREVIEW / etf_1hour / 2025-02-12

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-02-12.parquet
  size:    637 KB
  rows:    23,865

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-02-12 04:00:00	SPY	ETF	604.89	604.89	603.68	604.25	31490.0
2025-02-12 05:00:00	SPY	ETF	604.24	604.69	604.01	604.64	37723.0
2025-02-12 06:00:00	SPY	ETF	604.58	604.67	604.54	604.66	5683.0
2025-02-12 07:00:00	SPY	ETF	604.65	605.4	604.62	605.34	97834.0
2025-02-12 08:00:00	SPY	ETF	604.66	605.72	598.54	599.31	2540581.0
2025-02-12 09:00:00	SPY	ETF	599.22	601.68	598.231	601.355	4533549.0
2025-02-12 10:00:00	SPY	ETF	601.36	603.32	599.58	602.43	3911657.0
2025-02-12 11:00:00	SPY	ETF	602.45	603.54	600.17	603.39	2888017.0
2025-02-12 12:00:00	SPY	ETF	603.41	604.53	602.84	604.39	2808057.0
2025-02-12 13:00:00	SPY	ETF	604.4	604.55	602.92	603.21	1620741.0
2025-02-12 14:00:00	SPY	ETF	603.22	604.23	602.53	603.9	2816975.0
2025-02-12 15:00:00	SPY	ETF	603.9	604.05	602.57	603.36	4941611.0
2025-02-12 16:00:00	SPY	ETF	603.36	604.1	602.99	604.04	2270622.0
2025-02-12 17:00:00	SPY	ETF	604.0	604.1	603.92	603.99	39071.0
2025-02-12 18:00:00	SPY	ETF	603.99	604.58	603.76	604.4104	57855.0
2025-02-12 19:00:00	SPY	ETF	604.5	604.689	604.2	604.59	52826.0
2025-02-12 04:00:00	QQQ	ETF	528.24	528.24	526.76	527.49	59536.0
2025-02-12 05:00:00	QQQ	ETF	527.47	528.04	527.25	527.87	40209.0
2025-02-12 06:00:00	QQQ	ETF	528.0	528.25	527.57	527.95	10670.0
2025-02-12 07:00:00	QQQ	ETF	528.0	529.08	527.98	528.95	113998.0
2025-02-12 08:00:00	QQQ	ETF	527.3958	529.4	521.42	522.1	1709589.0
2025-02-12 09:00:00	QQQ	ETF	522.12	525.8742	521.32	525.3	3294369.0
2025-02-12 10:00:00	QQQ	ETF	525.32	527.61	523.0	526.5697	3153844.0
2025-02-12 11:00:00	QQQ	ETF	526.57	527.88	524.6	527.771	1932473.0
2025-02-12 12:00:00	QQQ	ETF	527.77	528.89	527.22	528.71	1898268.0
2025-02-12 13:00:00	QQQ	ETF	528.68	528.89	527.54	528.06	1132365.0
2025-02-12 14:00:00	QQQ	ETF	528.07	529.19	527.3	528.95	1406968.0
2025-02-12 15:00:00	QQQ	ETF	528.93	529.14	527.67	528.32	2574691.0
2025-02-12 16:00:00	QQQ	ETF	528.31	529.72	527.88	529.65	906413.0
2025-02-12 17:00:00	QQQ	ETF	529.749	529.749	529.46	529.52	59453.0
2025-02-12 18:00:00	QQQ	ETF	529.66	530.54	529.35	530.292	85318.0
2025-02-12 19:00:00	QQQ	ETF	530.43	530.72	530.0	530.52	73562.0
2025-02-12 04:00:00	IWM	ETF	225.84	225.96	225.7	225.92	5819.0
2025-02-12 05:00:00	IWM	ETF	225.94	226.04	225.82	226.04	3972.0
2025-02-12 06:00:00	IWM	ETF	226.11	226.44	226.01	226.41	43150.0
2025-02-12 07:00:00	IWM	ETF	226.4	226.83	226.34	226.72	149811.0
2025-02-12 08:00:00	IWM	ETF	226.4001	227.18	220.41	222.3205	2209903.0
2025-02-12 09:00:00	IWM	ETF	222.35	223.2	221.68	223.1902	3925682.0
2025-02-12 10:00:00	IWM	ETF	223.2	223.93	222.21	223.41	2836798.0
2025-02-12 11:00:00	IWM	ETF	223.402	223.555	222.05	223.51	2335917.0
2025-02-12 12:00:00	IWM	ETF	223.49	224.41	223.19	224.32	1776983.0
2025-02-12 13:00:00	IWM	ETF	224.32	224.48	223.53	223.71	1560107.0
2025-02-12 14:00:00	IWM	ETF	223.725	224.08	223.24	223.87	1787646.0
2025-02-12 15:00:00	IWM	ETF	223.87	224.09	223.46	223.67	2828071.0
2025-02-12 16:00:00	IWM	ETF	223.62	223.8	223.34	223.66	1365798.0
2025-02-12 17:00:00	IWM	ETF	223.67	223.79	223.46	223.51	8708.0
2025-02-12 18:00:00	IWM	ETF	223.59	223.93	223.55	223.88	8673.0
2025-02-12 19:00:00	IWM	ETF	223.86	224.05	223.75	223.97	48959.0
2025-02-12 04:00:00	DIA	ETF	445.34	445.45	445.34	445.45	293.0
2025-02-12 05:00:00	DIA	ETF	445.52	445.52	445.33	445.5	351.0

> showing 50 of 23,865 rows — these rows as CSV

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