PREVIEW / etf_1hour / 2026-04-20

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-04-20.parquet
  size:    719 KB
  rows:    28,633

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-20 04:00:00	SPY	ETF	706.56	707.19	705.04	706.98	172322.0
2026-04-20 05:00:00	SPY	ETF	706.89	707.39	706.62	706.87	58561.0
2026-04-20 06:00:00	SPY	ETF	706.88	707.68	706.61	706.66	120226.0
2026-04-20 07:00:00	SPY	ETF	706.65	707.05	706.16	706.92	418931.0
2026-04-20 08:00:00	SPY	ETF	706.9182	708.05	706.66	707.65	251947.0
2026-04-20 09:00:00	SPY	ETF	707.61	709.91	707.51	709.67	4202040.0
2026-04-20 10:00:00	SPY	ETF	709.67	709.72	706.48	707.14	5861865.0
2026-04-20 11:00:00	SPY	ETF	707.155	708.52	706.14	707.5992	4045891.0
2026-04-20 12:00:00	SPY	ETF	707.6	708.1	707.02	707.6399	1890921.0
2026-04-20 13:00:00	SPY	ETF	707.64	708.39	707.26	707.74	1973004.0
2026-04-20 14:00:00	SPY	ETF	707.74	708.61	707.481	708.265	2998262.0
2026-04-20 15:00:00	SPY	ETF	708.27	708.8	707.6	708.69	6779523.0
2026-04-20 16:00:00	SPY	ETF	708.71	709.97	708.46	709.16	2180930.0
2026-04-20 17:00:00	SPY	ETF	709.13	709.3494	708.72	709.17	139287.0
2026-04-20 18:00:00	SPY	ETF	709.18	710.0	709.05	709.76	105467.0
2026-04-20 19:00:00	SPY	ETF	709.71	709.77	709.4026	709.49	38782.0
2026-04-20 04:00:00	QQQ	ETF	644.38	646.14	643.58	645.6	199939.0
2026-04-20 05:00:00	QQQ	ETF	645.55	646.1	645.405	645.59	45699.0
2026-04-20 06:00:00	QQQ	ETF	645.59	646.45	645.47	645.63	63970.0
2026-04-20 07:00:00	QQQ	ETF	645.71	646.24	645.23	645.92	217277.0
2026-04-20 08:00:00	QQQ	ETF	645.97	649.336	645.7301	646.91	324950.0
2026-04-20 09:00:00	QQQ	ETF	646.87	648.76	646.08	647.655	3570532.0
2026-04-20 10:00:00	QQQ	ETF	647.67	647.82	643.58	644.15	4975251.0
2026-04-20 11:00:00	QQQ	ETF	644.16	645.9	642.52	644.67	4722454.0
2026-04-20 12:00:00	QQQ	ETF	644.67	645.66	644.23	645.17	1756765.0
2026-04-20 13:00:00	QQQ	ETF	645.19	646.31	644.75	645.86	1827868.0
2026-04-20 14:00:00	QQQ	ETF	645.9	646.81	645.62	646.43	2557398.0
2026-04-20 15:00:00	QQQ	ETF	646.44	646.95	645.92	646.8	3397870.0
2026-04-20 16:00:00	QQQ	ETF	646.77	648.28	646.44	647.5	1424034.0
2026-04-20 17:00:00	QQQ	ETF	647.38	647.5	646.97	647.32	66261.0
2026-04-20 18:00:00	QQQ	ETF	647.35	648.43	647.15	648.2878	96166.0
2026-04-20 19:00:00	QQQ	ETF	648.2994	648.3	647.89	647.9701	43543.0
2026-04-20 04:00:00	IWM	ETF	273.35	273.84	272.6	273.53	90436.0
2026-04-20 05:00:00	IWM	ETF	273.5	273.73	273.32	273.51	35396.0
2026-04-20 06:00:00	IWM	ETF	273.57	273.87	273.2	273.3	83703.0
2026-04-20 07:00:00	IWM	ETF	273.3	273.63	273.0	273.61	130906.0
2026-04-20 08:00:00	IWM	ETF	273.5	274.06	273.43	273.89	252134.0
2026-04-20 09:00:00	IWM	ETF	273.83	276.205	273.81	276.095	2942758.0
2026-04-20 10:00:00	IWM	ETF	276.08	276.74	275.44	276.15	2837945.0
2026-04-20 11:00:00	IWM	ETF	276.16	277.3007	275.48	277.07	2424917.0
2026-04-20 12:00:00	IWM	ETF	277.08	277.09	276.225	276.4699	1528196.0
2026-04-20 13:00:00	IWM	ETF	276.44	277.035	276.27	276.46	1096034.0
2026-04-20 14:00:00	IWM	ETF	276.48	277.64	276.32	277.59	1805875.0
2026-04-20 15:00:00	IWM	ETF	277.6	277.665	276.99	277.35	3232961.0
2026-04-20 16:00:00	IWM	ETF	277.35	277.8302	277.14	277.59	741184.0
2026-04-20 17:00:00	IWM	ETF	277.58	277.58	277.35	277.41	19913.0
2026-04-20 18:00:00	IWM	ETF	277.55	277.96	277.55	277.7	29506.0
2026-04-20 19:00:00	IWM	ETF	277.7338	277.75	277.6	277.7	13388.0
2026-04-20 04:00:00	DIA	ETF	490.86	491.47	490.54	491.47	2652.0
2026-04-20 05:00:00	DIA	ETF	491.607	491.7	491.6	491.6	615.0

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

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