PREVIEW / etf_1hour / 2026-03-18

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-03-18.parquet
  size:    635 KB
  rows:    24,846

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-03-18 04:00:00	SPY	ETF	673.5	674.63	673.5	674.18	38839.0
2026-03-18 05:00:00	SPY	ETF	674.3	674.54	673.89	674.23	23203.0
2026-03-18 06:00:00	SPY	ETF	674.18	674.7	673.86	673.86	46701.0
2026-03-18 07:00:00	SPY	ETF	673.89	674.25	672.39	672.86	441289.0
2026-03-18 08:00:00	SPY	ETF	674.38	674.93	667.06	667.3896	2457437.0
2026-03-18 09:00:00	SPY	ETF	667.42	669.72	666.9	669.28	7436397.0
2026-03-18 10:00:00	SPY	ETF	669.28	669.41	665.66	667.14	8477424.0
2026-03-18 11:00:00	SPY	ETF	667.13	668.0	666.4	667.04	5622506.0
2026-03-18 12:00:00	SPY	ETF	667.03	667.58	665.83	666.55	3965469.0
2026-03-18 13:00:00	SPY	ETF	666.54	666.87	665.29	666.72	5310363.0
2026-03-18 14:00:00	SPY	ETF	666.71	667.44	663.32	663.41	10001957.0
2026-03-18 15:00:00	SPY	ETF	663.4	664.72	661.19	661.51	18925764.0
2026-03-18 16:00:00	SPY	ETF	661.54	661.9	659.37	660.27	6434392.0
2026-03-18 17:00:00	SPY	ETF	660.31	661.47	660.2641	661.2	401952.0
2026-03-18 18:00:00	SPY	ETF	661.2	661.2	659.63	660.26	219225.0
2026-03-18 19:00:00	SPY	ETF	660.21	661.4	660.19	660.9114	178297.0
2026-03-18 04:00:00	QQQ	ETF	607.47	607.64	606.02	607.35	125132.0
2026-03-18 05:00:00	QQQ	ETF	607.3	607.78	607.03	607.31	58142.0
2026-03-18 06:00:00	QQQ	ETF	607.31	607.96	607.07	607.1	75277.0
2026-03-18 07:00:00	QQQ	ETF	607.08	607.43	605.6	605.91	209181.0
2026-03-18 08:00:00	QQQ	ETF	607.61	608.22	600.1	600.3241	1747056.0
2026-03-18 09:00:00	QQQ	ETF	600.41	603.16	599.96	602.4799	5882021.0
2026-03-18 10:00:00	QQQ	ETF	602.45	602.79	598.71	600.4	7144646.0
2026-03-18 11:00:00	QQQ	ETF	600.41	601.55	599.87	600.78	5717125.0
2026-03-18 12:00:00	QQQ	ETF	600.77	601.07	599.14	599.48	3683113.0
2026-03-18 13:00:00	QQQ	ETF	599.45	600.39	598.3	600.26	3665261.0
2026-03-18 14:00:00	QQQ	ETF	600.23	601.17	597.0	597.05	4752736.0
2026-03-18 15:00:00	QQQ	ETF	597.04	598.45	594.56	594.78	8983413.0
2026-03-18 16:00:00	QQQ	ETF	594.78	595.92	592.74	593.76	2364074.0
2026-03-18 17:00:00	QQQ	ETF	593.84	595.06	593.68	594.47	253378.0
2026-03-18 18:00:00	QQQ	ETF	594.47	594.47	592.75	593.48	230348.0
2026-03-18 19:00:00	QQQ	ETF	593.5	594.63	593.34	594.19	167215.0
2026-03-18 04:00:00	IWM	ETF	252.25	252.59	252.13	252.32	25287.0
2026-03-18 05:00:00	IWM	ETF	252.38	252.47	252.1	252.26	12644.0
2026-03-18 06:00:00	IWM	ETF	252.23	252.53	251.85	251.95	77453.0
2026-03-18 07:00:00	IWM	ETF	251.94	252.03	250.92	251.17	280774.0
2026-03-18 08:00:00	IWM	ETF	251.85	252.77	247.59	247.76	841919.0
2026-03-18 09:00:00	IWM	ETF	247.82	249.04	247.42	249.04	5009144.0
2026-03-18 10:00:00	IWM	ETF	249.04	249.12	247.12	248.19	3448617.0
2026-03-18 11:00:00	IWM	ETF	248.22	248.71	247.48	247.69	2468195.0
2026-03-18 12:00:00	IWM	ETF	247.67	248.72	247.4	248.4	1819457.0
2026-03-18 13:00:00	IWM	ETF	248.39	249.0	248.02	248.92	1718131.0
2026-03-18 14:00:00	IWM	ETF	249.02	249.23	246.49	246.59	4089592.0
2026-03-18 15:00:00	IWM	ETF	246.59	247.46	245.88	246.04	5223004.0
2026-03-18 16:00:00	IWM	ETF	246.02	248.35	244.95	245.26	1289148.0
2026-03-18 17:00:00	IWM	ETF	245.38	245.95	245.28	245.94	73086.0
2026-03-18 18:00:00	IWM	ETF	245.85	245.99	244.91	245.13	90738.0
2026-03-18 19:00:00	IWM	ETF	245.13	245.93	245.13	245.5	160865.0
2026-03-18 04:00:00	DIA	ETF	473.32	473.72	473.28	473.58	8695.0
2026-03-18 05:00:00	DIA	ETF	473.42	473.42	473.39	473.39	380.0

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

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