PREVIEW / etf_1hour / 2026-04-29

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-04-29.parquet
  size:    693 KB
  rows:    27,964

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-29 04:00:00	SPY	ETF	712.25	713.48	711.35	711.94	69863.0
2026-04-29 05:00:00	SPY	ETF	711.8646	712.4	711.41	711.66	27152.0
2026-04-29 06:00:00	SPY	ETF	711.46	712.75	711.34	712.11	29481.0
2026-04-29 07:00:00	SPY	ETF	712.26	712.64	711.6	712.03	128923.0
2026-04-29 08:00:00	SPY	ETF	712.0	713.0	710.79	711.55	262527.0
2026-04-29 09:00:00	SPY	ETF	711.6	712.0	709.66	710.77	3612856.0
2026-04-29 10:00:00	SPY	ETF	710.755	712.2	710.28	711.44	3134380.0
2026-04-29 11:00:00	SPY	ETF	711.45	711.52	709.21	710.04	4128660.0
2026-04-29 12:00:00	SPY	ETF	710.05	710.73	708.91	709.675	2724737.0
2026-04-29 13:00:00	SPY	ETF	709.69	710.74	709.22	710.61	2518160.0
2026-04-29 14:00:00	SPY	ETF	710.61	710.68	708.37	710.57	5595252.0
2026-04-29 15:00:00	SPY	ETF	710.56	711.62	710.0	711.59	7426791.0
2026-04-29 16:00:00	SPY	ETF	711.62	713.64	707.84	708.75	3813543.0
2026-04-29 17:00:00	SPY	ETF	708.84	711.58	708.67	710.25	660990.0
2026-04-29 18:00:00	SPY	ETF	710.0	714.19	709.5	713.07	444483.0
2026-04-29 19:00:00	SPY	ETF	713.12	713.8	712.56	713.71	565207.0
2026-04-29 04:00:00	QQQ	ETF	659.89	661.19	658.4	659.48	134570.0
2026-04-29 05:00:00	QQQ	ETF	659.3	660.13	659.0	659.25	56719.0
2026-04-29 06:00:00	QQQ	ETF	658.86	660.54	658.75	659.93	73313.0
2026-04-29 07:00:00	QQQ	ETF	659.96	660.45	659.2	659.68	191562.0
2026-04-29 08:00:00	QQQ	ETF	659.59	659.6	658.22	659.02	220149.0
2026-04-29 09:00:00	QQQ	ETF	659.06	659.6299	656.5899	658.9344	3116041.0
2026-04-29 10:00:00	QQQ	ETF	658.92	661.23	657.9	660.91	2852489.0
2026-04-29 11:00:00	QQQ	ETF	660.92	661.07	658.42	659.37	2846826.0
2026-04-29 12:00:00	QQQ	ETF	659.36	660.16	657.281	658.41	2552506.0
2026-04-29 13:00:00	QQQ	ETF	658.455	659.6841	657.69	659.57	1534699.0
2026-04-29 14:00:00	QQQ	ETF	659.6	660.81	657.39	660.69	2897713.0
2026-04-29 15:00:00	QQQ	ETF	660.68	661.72	659.68	661.61	4932068.0
2026-04-29 16:00:00	QQQ	ETF	661.64	663.46	655.75	657.12	2829492.0
2026-04-29 17:00:00	QQQ	ETF	657.2	661.0	657.1	660.45	337466.0
2026-04-29 18:00:00	QQQ	ETF	660.2	665.6	658.67	664.9262	787276.0
2026-04-29 19:00:00	QQQ	ETF	664.91	666.9	664.49	666.87	218072.0
2026-04-29 04:00:00	IWM	ETF	274.5	274.83	273.94	274.07	28668.0
2026-04-29 05:00:00	IWM	ETF	273.9	274.41	273.8	273.85	30363.0
2026-04-29 06:00:00	IWM	ETF	273.86	274.8	273.85	274.59	42984.0
2026-04-29 07:00:00	IWM	ETF	274.66	274.85	274.42	274.49	124532.0
2026-04-29 08:00:00	IWM	ETF	274.58	274.58	273.38	274.1999	217704.0
2026-04-29 09:00:00	IWM	ETF	274.23	274.38	272.51	273.0	2389685.0
2026-04-29 10:00:00	IWM	ETF	273.035	273.51	272.55	272.83	1978927.0
2026-04-29 11:00:00	IWM	ETF	272.82	272.89	271.06	271.52	3474842.0
2026-04-29 12:00:00	IWM	ETF	271.52	271.81	270.85	271.18	2444391.0
2026-04-29 13:00:00	IWM	ETF	271.18	271.81	270.89	271.808	1401360.0
2026-04-29 14:00:00	IWM	ETF	271.87	271.87	270.36	271.47	2623057.0
2026-04-29 15:00:00	IWM	ETF	271.47	272.16	271.13	272.07	3584042.0
2026-04-29 16:00:00	IWM	ETF	272.08	272.5	270.86	271.09	1075108.0
2026-04-29 17:00:00	IWM	ETF	271.14	271.38	270.79	271.0	114037.0
2026-04-29 18:00:00	IWM	ETF	271.0	271.64	270.5504	271.46	231593.0
2026-04-29 19:00:00	IWM	ETF	271.51	271.84	271.43	271.83	29342.0
2026-04-29 04:00:00	DIA	ETF	492.35	492.37	491.34	491.5796	1747.0
2026-04-29 05:00:00	DIA	ETF	491.47	491.69	491.2	491.2	306.0

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

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