PREVIEW / etf_1hour / 2026-04-30

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-04-30.parquet
  size:    717 KB
  rows:    28,682

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-30 04:00:00	SPY	ETF	711.48	711.89	708.2	711.28	156099.0
2026-04-30 05:00:00	SPY	ETF	711.27	713.14	710.64	711.93	86769.0
2026-04-30 06:00:00	SPY	ETF	711.93	713.35	711.93	712.65	129940.0
2026-04-30 07:00:00	SPY	ETF	712.8283	714.66	712.67	714.0512	445313.0
2026-04-30 08:00:00	SPY	ETF	714.1	715.8	711.58	715.07	421384.0
2026-04-30 09:00:00	SPY	ETF	715.02	715.58	710.78	711.27	5441916.0
2026-04-30 10:00:00	SPY	ETF	711.26	714.16	710.445	713.87	6075595.0
2026-04-30 11:00:00	SPY	ETF	713.87	715.07	713.47	714.6	3645107.0
2026-04-30 12:00:00	SPY	ETF	714.6	715.39	713.9	714.3474	2718492.0
2026-04-30 13:00:00	SPY	ETF	714.35	717.16	714.325	717.0601	2772243.0
2026-04-30 14:00:00	SPY	ETF	717.08	718.82	717.03	718.37	4647148.0
2026-04-30 15:00:00	SPY	ETF	718.36	719.79	718.28	718.43	13016447.0
2026-04-30 16:00:00	SPY	ETF	718.42	719.8	718.42	719.28	4666491.0
2026-04-30 17:00:00	SPY	ETF	719.15	720.3	718.2	720.05	607151.0
2026-04-30 18:00:00	SPY	ETF	720.05	720.82	719.3	719.5	220872.0
2026-04-30 19:00:00	SPY	ETF	719.5594	720.25	719.5	719.87	47384.0
2026-04-30 04:00:00	QQQ	ETF	664.0	664.0	658.17	662.38	295828.0
2026-04-30 05:00:00	QQQ	ETF	662.49	664.25	661.67	662.71	134337.0
2026-04-30 06:00:00	QQQ	ETF	662.61	664.07	662.23	662.67	171533.0
2026-04-30 07:00:00	QQQ	ETF	662.61	665.52	662.6	664.26	423739.0
2026-04-30 08:00:00	QQQ	ETF	664.28	666.75	661.074	666.25	419544.0
2026-04-30 09:00:00	QQQ	ETF	666.25	666.619	658.6	659.58	5392505.0
2026-04-30 10:00:00	QQQ	ETF	659.6	662.7	657.56	662.29	5866283.0
2026-04-30 11:00:00	QQQ	ETF	662.32	664.19	661.64	662.965	3196113.0
2026-04-30 12:00:00	QQQ	ETF	662.99	664.1	662.03	662.53	1914791.0
2026-04-30 13:00:00	QQQ	ETF	662.57	666.82	662.55	666.68	3267769.0
2026-04-30 14:00:00	QQQ	ETF	666.71	667.88	666.66	666.8901	3200243.0
2026-04-30 15:00:00	QQQ	ETF	666.89	668.9	666.69	667.6	5318629.0
2026-04-30 16:00:00	QQQ	ETF	667.57	668.52	667.23	668.0	1521771.0
2026-04-30 17:00:00	QQQ	ETF	668.02	669.5	666.9	668.79	438164.0
2026-04-30 18:00:00	QQQ	ETF	668.78	669.17	667.06	667.5	200862.0
2026-04-30 19:00:00	QQQ	ETF	667.64	668.59	667.55	667.8901	80115.0
2026-04-30 04:00:00	IWM	ETF	271.3	272.0	269.89	271.68	55032.0
2026-04-30 05:00:00	IWM	ETF	271.69	272.28	271.29	271.79	21226.0
2026-04-30 06:00:00	IWM	ETF	271.96	272.35	271.55	271.9	59768.0
2026-04-30 07:00:00	IWM	ETF	271.94	272.6	271.8	272.16	171449.0
2026-04-30 08:00:00	IWM	ETF	272.1	272.73	272.0	272.44	196410.0
2026-04-30 09:00:00	IWM	ETF	272.51	273.89	272.2	272.69	3633543.0
2026-04-30 10:00:00	IWM	ETF	272.6897	275.5	272.655	275.3969	2505614.0
2026-04-30 11:00:00	IWM	ETF	275.41	276.2	275.0	276.05	2489606.0
2026-04-30 12:00:00	IWM	ETF	276.07	276.39	275.76	276.27	1414616.0
2026-04-30 13:00:00	IWM	ETF	276.28	277.195	276.25	276.96	1614782.0
2026-04-30 14:00:00	IWM	ETF	276.96	277.68	276.935	277.26	2027592.0
2026-04-30 15:00:00	IWM	ETF	277.25	278.22	277.215	277.92	4791480.0
2026-04-30 16:00:00	IWM	ETF	277.92	278.77	277.91	278.58	1578155.0
2026-04-30 17:00:00	IWM	ETF	278.5	278.5	277.85	278.16	206737.0
2026-04-30 18:00:00	IWM	ETF	278.35	278.6	278.2336	278.35	30978.0
2026-04-30 19:00:00	IWM	ETF	278.37	278.6	278.29	278.39	28930.0
2026-04-30 04:00:00	DIA	ETF	485.5	486.86	485.45	486.83	5861.0
2026-04-30 05:00:00	DIA	ETF	486.81	487.94	486.32	487.77	2782.0

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

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