PREVIEW / etf_1hour / 2026-04-23

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-04-23.parquet
  size:    710 KB
  rows:    28,415

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-23 04:00:00	SPY	ETF	708.7	709.08	706.49	707.58	141219.0
2026-04-23 05:00:00	SPY	ETF	707.38	708.1601	706.89	707.75	42146.0
2026-04-23 06:00:00	SPY	ETF	707.67	708.51	707.19	708.36	61363.0
2026-04-23 07:00:00	SPY	ETF	708.44	710.34	707.75	710.1	323379.0
2026-04-23 08:00:00	SPY	ETF	710.16	711.2	707.9	709.4922	810507.0
2026-04-23 09:00:00	SPY	ETF	709.51	711.285	708.53	710.21	3620304.0
2026-04-23 10:00:00	SPY	ETF	710.19	712.055	709.13	711.71	4930248.0
2026-04-23 11:00:00	SPY	ETF	711.7	712.3598	710.7	711.105	3868370.0
2026-04-23 12:00:00	SPY	ETF	711.105	711.27	710.305	710.87	2403287.0
2026-04-23 13:00:00	SPY	ETF	710.88	711.08	702.2802	706.635	14412466.0
2026-04-23 14:00:00	SPY	ETF	706.67	709.48	706.22	707.1262	6461478.0
2026-04-23 15:00:00	SPY	ETF	707.1325	708.91	706.47	708.44	7560127.0
2026-04-23 16:00:00	SPY	ETF	708.37	708.69	707.11	707.49	2466718.0
2026-04-23 17:00:00	SPY	ETF	707.499	708.66	707.33	708.4	230881.0
2026-04-23 18:00:00	SPY	ETF	708.35	709.04	708.27	708.77	108512.0
2026-04-23 19:00:00	SPY	ETF	708.89	709.56	708.66	709.54	56998.0
2026-04-23 04:00:00	QQQ	ETF	656.2	656.2	650.6	651.44	189860.0
2026-04-23 05:00:00	QQQ	ETF	651.36	652.2	650.6	651.755	122854.0
2026-04-23 06:00:00	QQQ	ETF	651.72	652.8	651.2	652.63	105300.0
2026-04-23 07:00:00	QQQ	ETF	652.7	654.34	651.77	653.86	381508.0
2026-04-23 08:00:00	QQQ	ETF	653.83	655.601	652.17	653.33	464461.0
2026-04-23 09:00:00	QQQ	ETF	653.45	655.62	652.31	653.58	3204794.0
2026-04-23 10:00:00	QQQ	ETF	653.58	655.6998	652.4	655.41	3386635.0
2026-04-23 11:00:00	QQQ	ETF	655.42	656.92	654.65	655.4074	2925537.0
2026-04-23 12:00:00	QQQ	ETF	655.42	656.02	654.12	655.26	1733455.0
2026-04-23 13:00:00	QQQ	ETF	655.28	655.53	645.52	650.28	10279606.0
2026-04-23 14:00:00	QQQ	ETF	650.28	652.74	649.38	649.85	3723990.0
2026-04-23 15:00:00	QQQ	ETF	649.8	651.8499	649.34	651.41	4464219.0
2026-04-23 16:00:00	QQQ	ETF	651.39	652.88	651.04	651.69	1847850.0
2026-04-23 17:00:00	QQQ	ETF	651.9036	653.5	651.78	653.43	310895.0
2026-04-23 18:00:00	QQQ	ETF	653.43	654.48	653.11	654.24	417156.0
2026-04-23 19:00:00	QQQ	ETF	654.3	655.16	654.04	655.16	109033.0
2026-04-23 04:00:00	IWM	ETF	275.1	275.52	274.52	274.63	78924.0
2026-04-23 05:00:00	IWM	ETF	274.59	275.06	274.33	274.76	48484.0
2026-04-23 06:00:00	IWM	ETF	274.75	275.32	274.53	275.2144	127672.0
2026-04-23 07:00:00	IWM	ETF	275.32	276.3	274.85	276.2	346665.0
2026-04-23 08:00:00	IWM	ETF	276.21	277.1	274.87	276.6	815137.0
2026-04-23 09:00:00	IWM	ETF	276.65	277.54	275.99	276.44	2215619.0
2026-04-23 10:00:00	IWM	ETF	276.42	277.87	275.75	277.78	2777829.0
2026-04-23 11:00:00	IWM	ETF	277.76	277.835	276.495	276.77	1181711.0
2026-04-23 12:00:00	IWM	ETF	276.75	276.96	276.35	276.71	966373.0
2026-04-23 13:00:00	IWM	ETF	276.75	276.85	271.95	274.65	7827123.0
2026-04-23 14:00:00	IWM	ETF	274.655	275.8	274.52	274.72	2647364.0
2026-04-23 15:00:00	IWM	ETF	274.71	275.75	274.43	275.54	2889249.0
2026-04-23 16:00:00	IWM	ETF	275.53	275.53	274.68	274.85	1010652.0
2026-04-23 17:00:00	IWM	ETF	274.98	275.58	274.8	275.45	99114.0
2026-04-23 18:00:00	IWM	ETF	275.45	275.45	274.98	275.2	65642.0
2026-04-23 19:00:00	IWM	ETF	275.23	275.55	275.05	275.5455	97698.0
2026-04-23 04:00:00	DIA	ETF	491.3	492.51	491.3	491.94	2939.0
2026-04-23 05:00:00	DIA	ETF	491.45	492.05	491.45	491.96	815.0

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

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