PREVIEW / etf_1hour / 2026-04-27

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-04-27.parquet
  size:    694 KB
  rows:    28,126

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-04-27 04:00:00	SPY	ETF	713.87	715.04	712.72	713.5	113747.0
2026-04-27 05:00:00	SPY	ETF	713.5	713.7	713.37	713.47	16442.0
2026-04-27 06:00:00	SPY	ETF	713.52	714.09	713.3	713.99	30388.0
2026-04-27 07:00:00	SPY	ETF	713.95	714.43	713.941	714.3	231135.0
2026-04-27 08:00:00	SPY	ETF	714.28	714.33	713.1	713.4	220910.0
2026-04-27 09:00:00	SPY	ETF	713.43	714.4093	712.6	714.085	4829934.0
2026-04-27 10:00:00	SPY	ETF	714.09	714.45	713.072	713.62	3748354.0
2026-04-27 11:00:00	SPY	ETF	713.66	713.8	712.295	713.4	2611816.0
2026-04-27 12:00:00	SPY	ETF	713.41	714.31	713.18	714.13	2302599.0
2026-04-27 13:00:00	SPY	ETF	714.12	715.21	713.88	714.8799	2579941.0
2026-04-27 14:00:00	SPY	ETF	714.85	715.24	714.72	714.875	2444271.0
2026-04-27 15:00:00	SPY	ETF	714.87	715.63	714.71	715.15	5817414.0
2026-04-27 16:00:00	SPY	ETF	715.16	715.25	714.39	715.03	1748648.0
2026-04-27 17:00:00	SPY	ETF	715.0	715.17	714.9	715.0586	47004.0
2026-04-27 18:00:00	SPY	ETF	715.06	716.48	715.06	716.1364	92585.0
2026-04-27 19:00:00	SPY	ETF	716.19	716.4696	716.0	716.26	38303.0
2026-04-27 04:00:00	QQQ	ETF	664.32	666.55	662.94	664.19	219195.0
2026-04-27 05:00:00	QQQ	ETF	664.19	664.81	664.08	664.52	91128.0
2026-04-27 06:00:00	QQQ	ETF	664.57	665.195	664.2	665.02	100743.0
2026-04-27 07:00:00	QQQ	ETF	665.0	665.6	664.98	665.2	172009.0
2026-04-27 08:00:00	QQQ	ETF	665.15	665.22	662.95	663.61	346108.0
2026-04-27 09:00:00	QQQ	ETF	663.5608	663.98	660.69	663.2	4839131.0
2026-04-27 10:00:00	QQQ	ETF	663.2	663.41	661.27	662.38	4717199.0
2026-04-27 11:00:00	QQQ	ETF	662.39	662.73	660.94	662.34	2498314.0
2026-04-27 12:00:00	QQQ	ETF	662.39	663.33	661.9	662.94	1822158.0
2026-04-27 13:00:00	QQQ	ETF	662.935	664.1225	662.65	663.86	2163307.0
2026-04-27 14:00:00	QQQ	ETF	663.84	664.375	662.96	663.19	1664016.0
2026-04-27 15:00:00	QQQ	ETF	663.17	664.43	662.93	664.28	2928059.0
2026-04-27 16:00:00	QQQ	ETF	664.29	664.29	662.012	663.7046	1259074.0
2026-04-27 17:00:00	QQQ	ETF	663.88	664.23	663.71	663.89	23139.0
2026-04-27 18:00:00	QQQ	ETF	663.77	665.56	663.75	665.22	152270.0
2026-04-27 19:00:00	QQQ	ETF	665.27	665.68	665.01	665.31	43043.0
2026-04-27 04:00:00	IWM	ETF	276.38	276.97	276.09	276.65	57446.0
2026-04-27 05:00:00	IWM	ETF	276.71	276.79	276.57	276.76	9232.0
2026-04-27 06:00:00	IWM	ETF	276.7	277.05	276.56	276.99	9571.0
2026-04-27 07:00:00	IWM	ETF	277.0	277.18	276.8109	277.07	71106.0
2026-04-27 08:00:00	IWM	ETF	277.1	277.22	276.4844	276.4844	161464.0
2026-04-27 09:00:00	IWM	ETF	276.52	278.24	276.25	277.32	3113844.0
2026-04-27 10:00:00	IWM	ETF	277.3	277.61	276.57	276.98	1985612.0
2026-04-27 11:00:00	IWM	ETF	277.0	277.1	276.26	276.85	913087.0
2026-04-27 12:00:00	IWM	ETF	276.87	277.05	276.55	276.69	652524.0
2026-04-27 13:00:00	IWM	ETF	276.695	277.19	276.43	276.64	948564.0
2026-04-27 14:00:00	IWM	ETF	276.605	276.95	276.56	276.755	1036909.0
2026-04-27 15:00:00	IWM	ETF	276.74	277.16	276.7	277.11	2244144.0
2026-04-27 16:00:00	IWM	ETF	277.1	277.2235	276.805	277.2235	896693.0
2026-04-27 17:00:00	IWM	ETF	277.11	277.19	277.01	277.01	8138.0
2026-04-27 18:00:00	IWM	ETF	277.13	277.75	277.01	277.59	56358.0
2026-04-27 19:00:00	IWM	ETF	277.61	277.74	277.54	277.711	8764.0
2026-04-27 04:00:00	DIA	ETF	491.5	491.85	491.2	491.65	697.0
2026-04-27 05:00:00	DIA	ETF	491.75	491.78	491.62	491.65	633.0

> showing 50 of 28,126 rows — these rows as CSV

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