PREVIEW / etf_1hour / 2026-04-21

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-04-21.parquet
  size:    712 KB
  rows:    28,594

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-21 04:00:00	SPY	ETF	709.64	710.7	709.54	710.435	38958.0
2026-04-21 05:00:00	SPY	ETF	710.37	710.92	709.89	710.89	62833.0
2026-04-21 06:00:00	SPY	ETF	710.86	711.73	710.81	711.6	111559.0
2026-04-21 07:00:00	SPY	ETF	711.55	712.28	710.8	711.58	363338.0
2026-04-21 08:00:00	SPY	ETF	711.59	711.71	710.1	710.4157	589330.0
2026-04-21 09:00:00	SPY	ETF	710.45	710.865	708.75	710.75	3410238.0
2026-04-21 10:00:00	SPY	ETF	710.77	711.275	707.46	707.59	4839124.0
2026-04-21 11:00:00	SPY	ETF	707.59	708.2	706.04	706.72	5992333.0
2026-04-21 12:00:00	SPY	ETF	706.745	707.885	705.51	705.58	3162089.0
2026-04-21 13:00:00	SPY	ETF	705.58	707.41	703.84	705.795	7911990.0
2026-04-21 14:00:00	SPY	ETF	705.795	706.89	704.71	706.32	4451368.0
2026-04-21 15:00:00	SPY	ETF	706.33	707.87	702.64	704.15	13905774.0
2026-04-21 16:00:00	SPY	ETF	704.15	707.99	703.27	706.3	4206440.0
2026-04-21 17:00:00	SPY	ETF	706.4	706.69	706.22	706.55	70883.0
2026-04-21 18:00:00	SPY	ETF	706.59	707.0	706.35	706.48	69533.0
2026-04-21 19:00:00	SPY	ETF	706.45	707.08	706.37	707.0	325436.0
2026-04-21 04:00:00	QQQ	ETF	648.7	649.5	648.14	649.09	87830.0
2026-04-21 05:00:00	QQQ	ETF	648.87	649.28	648.34	649.13	54398.0
2026-04-21 06:00:00	QQQ	ETF	649.19	650.17	649.04	649.88	115303.0
2026-04-21 07:00:00	QQQ	ETF	649.9	650.59	649.15	649.87	319663.0
2026-04-21 08:00:00	QQQ	ETF	649.93	650.09	648.53	648.7294	362766.0
2026-04-21 09:00:00	QQQ	ETF	648.73	649.09	646.0	649.08	4038041.0
2026-04-21 10:00:00	QQQ	ETF	649.1	650.2	646.49	646.62	4627775.0
2026-04-21 11:00:00	QQQ	ETF	646.63	647.84	644.88	646.51	4236866.0
2026-04-21 12:00:00	QQQ	ETF	646.575	647.74	644.97	645.04	2234299.0
2026-04-21 13:00:00	QQQ	ETF	645.06	647.42	643.365	645.71	3993362.0
2026-04-21 14:00:00	QQQ	ETF	645.7101	646.89	644.78	646.335	2268984.0
2026-04-21 15:00:00	QQQ	ETF	646.34	647.83	642.21	644.3	6355494.0
2026-04-21 16:00:00	QQQ	ETF	644.32	647.99	643.37	646.31	2664283.0
2026-04-21 17:00:00	QQQ	ETF	646.38	646.6	646.19	646.6	84948.0
2026-04-21 18:00:00	QQQ	ETF	646.49	647.06	646.46	646.68	174820.0
2026-04-21 19:00:00	QQQ	ETF	646.66	647.55	646.55	647.49	82729.0
2026-04-21 04:00:00	IWM	ETF	277.47	278.2	277.32	277.81	41819.0
2026-04-21 05:00:00	IWM	ETF	277.79	278.16	277.56	278.12	21745.0
2026-04-21 06:00:00	IWM	ETF	278.07	278.43	278.03	278.39	32761.0
2026-04-21 07:00:00	IWM	ETF	278.34	278.71	277.83	278.38	76472.0
2026-04-21 08:00:00	IWM	ETF	278.41	278.75	277.6	277.94	81118.0
2026-04-21 09:00:00	IWM	ETF	278.03	279.63	277.53	279.02	2262426.0
2026-04-21 10:00:00	IWM	ETF	279.02	279.79	276.69	276.9	2609795.0
2026-04-21 11:00:00	IWM	ETF	276.92	277.47	275.71	276.1	3447446.0
2026-04-21 12:00:00	IWM	ETF	276.19	276.79	275.42	275.4293	1932847.0
2026-04-21 13:00:00	IWM	ETF	275.43	276.31	274.26	275.49	3020703.0
2026-04-21 14:00:00	IWM	ETF	275.48	275.84	274.3	275.5	2253793.0
2026-04-21 15:00:00	IWM	ETF	275.5	276.54	273.76	274.505	6024971.0
2026-04-21 16:00:00	IWM	ETF	274.51	276.8	274.17	275.83	1575257.0
2026-04-21 17:00:00	IWM	ETF	275.99	276.1	275.66	275.99	28662.0
2026-04-21 18:00:00	IWM	ETF	275.93	276.15	275.8	275.8	34045.0
2026-04-21 19:00:00	IWM	ETF	275.8	276.27	275.8	276.27	22869.0
2026-04-21 04:00:00	DIA	ETF	495.0	495.52	494.88	494.88	3334.0
2026-04-21 05:00:00	DIA	ETF	495.21	497.12	495.21	497.01	29340.0

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

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