PREVIEW / etf_1hour / 2025-05-07

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-05-07.parquet
  size:    630 KB
  rows:    24,029

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
2025-05-07 04:00:00	SPY	ETF	562.68	562.68	561.51	562.33	25282.0
2025-05-07 05:00:00	SPY	ETF	562.3	562.51	561.7	562.0	18541.0
2025-05-07 06:00:00	SPY	ETF	561.92	562.57	561.51	562.3	50572.0
2025-05-07 07:00:00	SPY	ETF	562.27	563.02	561.84	562.25	129507.0
2025-05-07 08:00:00	SPY	ETF	562.59	562.9381	560.55	560.87	301991.0
2025-05-07 09:00:00	SPY	ETF	560.85	561.6	559.5202	561.4599	3489020.0
2025-05-07 10:00:00	SPY	ETF	561.46	561.98	559.01	559.45	3568085.0
2025-05-07 11:00:00	SPY	ETF	559.45	560.16	558.38	559.94	3777070.0
2025-05-07 12:00:00	SPY	ETF	559.91	561.37	559.07	561.255	1959674.0
2025-05-07 13:00:00	SPY	ETF	561.24	561.85	558.8	559.27	2776989.0
2025-05-07 14:00:00	SPY	ETF	559.235	562.64	556.04	560.85	7765118.0
2025-05-07 15:00:00	SPY	ETF	560.83	563.82	557.52	561.23	11973377.0
2025-05-07 16:00:00	SPY	ETF	561.23	562.36	560.63	560.99	2963491.0
2025-05-07 17:00:00	SPY	ETF	561.0	561.12	560.77	560.85	135649.0
2025-05-07 18:00:00	SPY	ETF	560.75	561.15	560.13	560.87	100613.0
2025-05-07 19:00:00	SPY	ETF	561.07	561.5284	560.89	561.01	102205.0
2025-05-07 04:00:00	QQQ	ETF	484.89	485.2	483.87	484.73	123876.0
2025-05-07 05:00:00	QQQ	ETF	484.67	484.92	483.91	484.3	40871.0
2025-05-07 06:00:00	QQQ	ETF	484.29	484.77	483.79	484.48	77625.0
2025-05-07 07:00:00	QQQ	ETF	484.5	485.26	484.12	484.44	175298.0
2025-05-07 08:00:00	QQQ	ETF	484.83	485.26	481.049	482.97	503052.0
2025-05-07 09:00:00	QQQ	ETF	482.91	483.1799	481.18	483.0144	2625722.0
2025-05-07 10:00:00	QQQ	ETF	483.04	484.01	480.44	480.7843	2480155.0
2025-05-07 11:00:00	QQQ	ETF	480.79	481.05	479.42	480.87	3262202.0
2025-05-07 12:00:00	QQQ	ETF	480.83	482.1856	479.86	482.04	1603283.0
2025-05-07 13:00:00	QQQ	ETF	482.0342	482.69	479.7972	480.19	1787516.0
2025-05-07 14:00:00	QQQ	ETF	480.1	482.15	476.782	481.73	5373335.0
2025-05-07 15:00:00	QQQ	ETF	481.7	485.8	478.85	483.35	6900233.0
2025-05-07 16:00:00	QQQ	ETF	483.34	484.47	482.5299	483.45	1425652.0
2025-05-07 17:00:00	QQQ	ETF	483.5	483.7	483.04	483.1	75101.0
2025-05-07 18:00:00	QQQ	ETF	483.12	483.41	482.35	483.29	57808.0
2025-05-07 19:00:00	QQQ	ETF	483.28	483.89	483.24	483.37	67173.0
2025-05-07 04:00:00	IWM	ETF	198.41	198.63	198.1	198.63	34805.0
2025-05-07 05:00:00	IWM	ETF	198.61	198.8	198.52	198.64	8198.0
2025-05-07 06:00:00	IWM	ETF	198.63	198.9	198.56	198.82	5716.0
2025-05-07 07:00:00	IWM	ETF	198.85	198.93	198.33	198.56	40118.0
2025-05-07 08:00:00	IWM	ETF	198.53	198.8999	197.98	198.26	134212.0
2025-05-07 09:00:00	IWM	ETF	198.23	198.55	197.52	198.15	2193813.0
2025-05-07 10:00:00	IWM	ETF	198.16	198.22	197.085	197.21	1706079.0
2025-05-07 11:00:00	IWM	ETF	197.19	198.005	196.905	197.755	1282282.0
2025-05-07 12:00:00	IWM	ETF	197.75	198.41	197.42	198.36	952802.0
2025-05-07 13:00:00	IWM	ETF	198.36	198.56	197.085	197.43	1472629.0
2025-05-07 14:00:00	IWM	ETF	197.44	197.92	196.04	197.8	3062617.0
2025-05-07 15:00:00	IWM	ETF	197.76	198.02	196.0728	197.4	3914767.0
2025-05-07 16:00:00	IWM	ETF	197.42	197.73	197.0	197.5	964280.0
2025-05-07 17:00:00	IWM	ETF	197.47	197.53	197.4	197.5	3229.0
2025-05-07 18:00:00	IWM	ETF	197.5	197.7	197.33	197.61	28200.0
2025-05-07 19:00:00	IWM	ETF	197.61	197.72	197.39	197.43	22624.0
2025-05-07 04:00:00	DIA	ETF	410.56	410.56	410.16	410.44	651.0
2025-05-07 05:00:00	DIA	ETF	410.45	410.6	410.43	410.54	1500.0

> showing 50 of 24,029 rows — these rows as CSV

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