PREVIEW / etf_1hour / 2026-05-01

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-05-01.parquet
  size:    707 KB
  rows:    28,025

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-05-01 04:00:00	SPY	ETF	720.36	720.92	719.61	719.88	43512.0
2026-05-01 05:00:00	SPY	ETF	719.79	720.24	719.55	720.16	12470.0
2026-05-01 06:00:00	SPY	ETF	720.2	720.29	719.72	720.22	10223.0
2026-05-01 07:00:00	SPY	ETF	720.24	720.49	719.7503	720.4403	75136.0
2026-05-01 08:00:00	SPY	ETF	720.55	721.99	720.26	720.7	396750.0
2026-05-01 09:00:00	SPY	ETF	720.65	724.24	720.61	724.175	4937986.0
2026-05-01 10:00:00	SPY	ETF	724.19	724.87	722.3	722.72	5325851.0
2026-05-01 11:00:00	SPY	ETF	722.73	724.38	722.04	723.385	3788489.0
2026-05-01 12:00:00	SPY	ETF	723.36	723.61	721.49	721.89	4019518.0
2026-05-01 13:00:00	SPY	ETF	721.89	723.22	721.86	722.8	2712994.0
2026-05-01 14:00:00	SPY	ETF	722.79	722.92	720.78	721.17	3280299.0
2026-05-01 15:00:00	SPY	ETF	721.17	722.59	720.47	720.67	6492588.0
2026-05-01 16:00:00	SPY	ETF	720.655	720.75	718.97	719.74	2220483.0
2026-05-01 17:00:00	SPY	ETF	719.73	720.24	719.73	720.23	88287.0
2026-05-01 18:00:00	SPY	ETF	720.24	720.65	719.99	720.19	216818.0
2026-05-01 19:00:00	SPY	ETF	720.1805	720.21	719.99	720.0	21423.0
2026-05-01 04:00:00	QQQ	ETF	668.35	669.35	667.3	667.54	126850.0
2026-05-01 05:00:00	QQQ	ETF	667.5245	667.76	667.08	667.69	37429.0
2026-05-01 06:00:00	QQQ	ETF	667.7	667.93	666.62	667.67	91880.0
2026-05-01 07:00:00	QQQ	ETF	667.6899	667.76	666.92	667.5	108647.0
2026-05-01 08:00:00	QQQ	ETF	667.51	669.0	667.1	667.77	343879.0
2026-05-01 09:00:00	QQQ	ETF	667.79	674.96	667.79	674.96	5239110.0
2026-05-01 10:00:00	QQQ	ETF	674.98	675.76	672.01	673.53	6228242.0
2026-05-01 11:00:00	QQQ	ETF	673.57	675.97	672.47	675.36	4240478.0
2026-05-01 12:00:00	QQQ	ETF	675.35	675.61	673.33	673.935	2928036.0
2026-05-01 13:00:00	QQQ	ETF	673.925	675.53	673.89	675.22	1855816.0
2026-05-01 14:00:00	QQQ	ETF	675.22	675.39	673.0901	673.76	2316778.0
2026-05-01 15:00:00	QQQ	ETF	673.7708	675.66	673.661	674.16	4765924.0
2026-05-01 16:00:00	QQQ	ETF	674.09	674.19	672.15	672.94	1504431.0
2026-05-01 17:00:00	QQQ	ETF	672.99	674.01	672.98	673.82	123056.0
2026-05-01 18:00:00	QQQ	ETF	673.83	673.9513	673.57	673.73	29222.0
2026-05-01 19:00:00	QQQ	ETF	673.74	673.89	673.5	673.5501	39971.0
2026-05-01 04:00:00	IWM	ETF	278.2	278.38	277.7	277.85	56333.0
2026-05-01 05:00:00	IWM	ETF	277.82	277.87	277.71	277.75	21630.0
2026-05-01 06:00:00	IWM	ETF	277.77	277.88	277.46	277.86	41429.0
2026-05-01 07:00:00	IWM	ETF	277.87	277.99	277.63	277.9638	36290.0
2026-05-01 08:00:00	IWM	ETF	278.1	279.12	277.98	278.23	224751.0
2026-05-01 09:00:00	IWM	ETF	278.26	278.8	276.57	278.285	5970789.0
2026-05-01 10:00:00	IWM	ETF	278.31	279.52	278.02	278.11	4024839.0
2026-05-01 11:00:00	IWM	ETF	278.125	279.36	277.845	278.87	3145684.0
2026-05-01 12:00:00	IWM	ETF	278.87	279.24	278.24	278.675	2088399.0
2026-05-01 13:00:00	IWM	ETF	278.66	279.69	278.635	279.5202	1647927.0
2026-05-01 14:00:00	IWM	ETF	279.525	279.605	278.93	278.99	1978441.0
2026-05-01 15:00:00	IWM	ETF	278.985	279.81	278.92	279.3	3542089.0
2026-05-01 16:00:00	IWM	ETF	279.3	279.31	278.45	278.71	730099.0
2026-05-01 17:00:00	IWM	ETF	278.76	278.94	278.52	278.94	18057.0
2026-05-01 18:00:00	IWM	ETF	278.93	278.98	278.81	278.98	4548.0
2026-05-01 19:00:00	IWM	ETF	278.98	279.18	278.88	278.88	4203.0
2026-05-01 04:00:00	DIA	ETF	497.56	497.56	497.25	497.38	2670.0
2026-05-01 05:00:00	DIA	ETF	497.4	497.91	497.4	497.91	520.0

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

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