PREVIEW / etf_1hour / 2026-02-27

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-02-27.parquet
  size:    740 KB
  rows:    29,121

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
2026-02-27 04:00:00	SPY	ETF	687.51	688.97	687.51	687.61	81598.0
2026-02-27 05:00:00	SPY	ETF	687.56	687.59	686.16	686.86	65496.0
2026-02-27 06:00:00	SPY	ETF	686.99	687.08	685.37	685.99	119281.0
2026-02-27 07:00:00	SPY	ETF	685.97	686.8	684.85	685.25	227805.0
2026-02-27 08:00:00	SPY	ETF	687.45	688.9914	682.01	684.09	1388165.0
2026-02-27 09:00:00	SPY	ETF	684.15	684.25	681.64	682.8664	8514061.0
2026-02-27 10:00:00	SPY	ETF	682.86	686.05	682.66	685.22	9091274.0
2026-02-27 11:00:00	SPY	ETF	685.24	686.2899	684.565	684.87	6100603.0
2026-02-27 12:00:00	SPY	ETF	684.86	686.28	683.29	684.375	6992221.0
2026-02-27 13:00:00	SPY	ETF	684.37	684.68	683.06	683.95	4752680.0
2026-02-27 14:00:00	SPY	ETF	683.95	684.98	682.99	683.35	5871079.0
2026-02-27 15:00:00	SPY	ETF	683.34	686.86	683.32	686.22	19924266.0
2026-02-27 16:00:00	SPY	ETF	686.25	686.5	684.78	685.06	5121615.0
2026-02-27 17:00:00	SPY	ETF	685.0	685.44	684.4482	684.5	246056.0
2026-02-27 18:00:00	SPY	ETF	684.59	684.59	683.85	684.1155	100372.0
2026-02-27 19:00:00	SPY	ETF	684.19	684.5	683.6106	683.69	98925.0
2026-02-27 04:00:00	QQQ	ETF	609.13	609.85	608.07	608.23	155580.0
2026-02-27 05:00:00	QQQ	ETF	608.13	608.51	606.67	607.52	93826.0
2026-02-27 06:00:00	QQQ	ETF	607.53	607.6	605.75	606.36	112112.0
2026-02-27 07:00:00	QQQ	ETF	606.33	607.29	605.01	605.53	187884.0
2026-02-27 08:00:00	QQQ	ETF	606.92	609.57	602.51	604.3007	956725.0
2026-02-27 09:00:00	QQQ	ETF	604.42	605.955	602.19	604.55	8979399.0
2026-02-27 10:00:00	QQQ	ETF	604.54	607.9	604.23	607.07	11024518.0
2026-02-27 11:00:00	QQQ	ETF	607.08	607.97	605.82	606.71	7283972.0
2026-02-27 12:00:00	QQQ	ETF	606.71	608.32	605.04	606.13	6986236.0
2026-02-27 13:00:00	QQQ	ETF	606.13	606.3698	604.44	605.11	4185752.0
2026-02-27 14:00:00	QQQ	ETF	605.1	606.48	604.42	604.93	3942391.0
2026-02-27 15:00:00	QQQ	ETF	604.895	608.03	604.87	607.45	11930943.0
2026-02-27 16:00:00	QQQ	ETF	607.44	607.5	606.0	606.4101	2647000.0
2026-02-27 17:00:00	QQQ	ETF	606.27	606.8972	606.03	606.26	88827.0
2026-02-27 18:00:00	QQQ	ETF	606.04	606.09	605.24	605.4262	115775.0
2026-02-27 19:00:00	QQQ	ETF	605.43	605.87	605.14	605.38	33052.0
2026-02-27 04:00:00	IWM	ETF	264.36	264.59	264.0	264.1	33252.0
2026-02-27 05:00:00	IWM	ETF	264.04	264.04	263.37	263.83	44304.0
2026-02-27 06:00:00	IWM	ETF	263.85	263.97	263.3	263.35	34189.0
2026-02-27 07:00:00	IWM	ETF	263.43	263.95	262.91	263.03	103353.0
2026-02-27 08:00:00	IWM	ETF	263.15	264.58	261.36	262.43	408601.0
2026-02-27 09:00:00	IWM	ETF	262.39	262.76	259.94	260.09	4904969.0
2026-02-27 10:00:00	IWM	ETF	260.07	261.97	259.82	261.28	3972726.0
2026-02-27 11:00:00	IWM	ETF	261.29	261.94	260.76	260.9	2175105.0
2026-02-27 12:00:00	IWM	ETF	260.9	261.795	260.08	260.555	2612050.0
2026-02-27 13:00:00	IWM	ETF	260.53	260.665	259.84	260.36	1645587.0
2026-02-27 14:00:00	IWM	ETF	260.33	260.77	259.77	259.82	1995740.0
2026-02-27 15:00:00	IWM	ETF	259.81	261.53	259.81	261.43	6543326.0
2026-02-27 16:00:00	IWM	ETF	261.42	261.42	260.1984	260.92	1433800.0
2026-02-27 17:00:00	IWM	ETF	260.81	261.02	260.4	260.5	55429.0
2026-02-27 18:00:00	IWM	ETF	260.48	260.68	260.04	260.36	30501.0
2026-02-27 19:00:00	IWM	ETF	260.26	260.7	260.24	260.35	19596.0
2026-02-27 04:00:00	DIA	ETF	493.22	493.64	492.94	492.95	6447.0
2026-02-27 05:00:00	DIA	ETF	492.93	492.93	492.21	492.36	8679.0

> showing 50 of 29,121 rows — these rows as CSV

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