PREVIEW / etf_1hour / 2026-04-06

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-04-06.parquet
  size:    669 KB
  rows:    27,116

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-06 04:00:00	SPY	ETF	656.07	658.61	654.89	658.14	167118.0
2026-04-06 05:00:00	SPY	ETF	658.1501	658.69	657.21	657.3	90059.0
2026-04-06 06:00:00	SPY	ETF	657.39	657.82	655.62	656.74	126616.0
2026-04-06 07:00:00	SPY	ETF	656.74	656.79	656.0	656.35	177998.0
2026-04-06 08:00:00	SPY	ETF	656.36	657.2	655.95	656.58	228009.0
2026-04-06 09:00:00	SPY	ETF	656.68	658.55	655.52	658.53	4294665.0
2026-04-06 10:00:00	SPY	ETF	657.93	659.72	656.03	657.49	6190359.0
2026-04-06 11:00:00	SPY	ETF	657.51	658.04	656.34	657.85	3019208.0
2026-04-06 12:00:00	SPY	ETF	657.868	658.51	656.88	657.93	2395054.0
2026-04-06 13:00:00	SPY	ETF	657.93	658.0	655.52	656.47	3550794.0
2026-04-06 14:00:00	SPY	ETF	656.5	658.65	656.22	658.29	3248296.0
2026-04-06 15:00:00	SPY	ETF	658.32	658.92	657.81	658.87	5728263.0
2026-04-06 16:00:00	SPY	ETF	658.88	659.04	658.3	658.65	1457097.0
2026-04-06 17:00:00	SPY	ETF	658.67	659.09	658.55	658.68	65646.0
2026-04-06 18:00:00	SPY	ETF	658.75	659.49	657.91	657.94	109197.0
2026-04-06 19:00:00	SPY	ETF	658.0	658.55	657.82	657.91	35480.0
2026-04-06 04:00:00	QQQ	ETF	586.95	589.25	584.8	588.68	283033.0
2026-04-06 05:00:00	QQQ	ETF	588.72	589.35	587.79	587.89	102940.0
2026-04-06 06:00:00	QQQ	ETF	587.89	588.42	586.42	587.41	136859.0
2026-04-06 07:00:00	QQQ	ETF	587.4	587.41	586.6	587.17	158049.0
2026-04-06 08:00:00	QQQ	ETF	587.15	587.92	584.542	587.22	243210.0
2026-04-06 09:00:00	QQQ	ETF	587.22	589.67	585.73	589.5501	5285528.0
2026-04-06 10:00:00	QQQ	ETF	589.56	590.61	586.08	587.14	6305614.0
2026-04-06 11:00:00	QQQ	ETF	587.15	587.89	585.81	587.53	3019765.0
2026-04-06 12:00:00	QQQ	ETF	587.555	588.1	586.59	587.21	2347534.0
2026-04-06 13:00:00	QQQ	ETF	587.21	587.79	584.69	586.1	3832466.0
2026-04-06 14:00:00	QQQ	ETF	586.12	588.495	585.7	588.2	2892737.0
2026-04-06 15:00:00	QQQ	ETF	588.2	588.83	587.64	588.52	2956758.0
2026-04-06 16:00:00	QQQ	ETF	588.5	588.63	587.85	588.18	563463.0
2026-04-06 17:00:00	QQQ	ETF	588.2292	588.58	588.0	588.17	45618.0
2026-04-06 18:00:00	QQQ	ETF	588.36	588.97	587.05	587.1461	132995.0
2026-04-06 19:00:00	QQQ	ETF	587.09	587.81	587.01	587.04	87243.0
2026-04-06 04:00:00	IWM	ETF	251.15	252.12	250.17	251.96	170478.0
2026-04-06 05:00:00	IWM	ETF	252.08	252.15	251.24	251.29	39850.0
2026-04-06 06:00:00	IWM	ETF	251.28	251.6	250.59	251.23	146034.0
2026-04-06 07:00:00	IWM	ETF	251.19	251.2192	250.74	251.04	177488.0
2026-04-06 08:00:00	IWM	ETF	251.1	251.73	250.85	251.36	218284.0
2026-04-06 09:00:00	IWM	ETF	251.23	252.3	250.81	251.82	5781088.0
2026-04-06 10:00:00	IWM	ETF	251.5	252.49	250.25	251.6	5640346.0
2026-04-06 11:00:00	IWM	ETF	251.605	252.39	251.36	252.39	2847774.0
2026-04-06 12:00:00	IWM	ETF	252.41	252.6	251.89	252.1	2565858.0
2026-04-06 13:00:00	IWM	ETF	252.1	252.33	250.75	251.785	3924328.0
2026-04-06 14:00:00	IWM	ETF	251.785	253.05	251.562	252.74	2906614.0
2026-04-06 15:00:00	IWM	ETF	252.759	252.785	252.14	252.37	7642656.0
2026-04-06 16:00:00	IWM	ETF	252.36	252.45	252.05	252.16	1377470.0
2026-04-06 17:00:00	IWM	ETF	252.24	252.3	251.99	252.15	31083.0
2026-04-06 18:00:00	IWM	ETF	252.05	252.43	251.61	251.7	32433.0
2026-04-06 19:00:00	IWM	ETF	251.7	251.93	251.6	251.66	26968.0
2026-04-06 04:00:00	DIA	ETF	464.09	465.8	464.09	465.52	3527.0
2026-04-06 05:00:00	DIA	ETF	465.75	465.82	465.03	465.03	1488.0

> showing 50 of 27,116 rows — these rows as CSV

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