PREVIEW / etf_1hour / 2026-03-13

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-03-13.parquet
  size:    718 KB
  rows:    28,382

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-13 04:00:00	SPY	ETF	664.85	665.83	662.7	665.6	189622.0
2026-03-13 05:00:00	SPY	ETF	665.65	667.0	665.65	666.06	74458.0
2026-03-13 06:00:00	SPY	ETF	666.0	668.07	666.0	668.06	98303.0
2026-03-13 07:00:00	SPY	ETF	668.01	669.3	667.75	669.3	387489.0
2026-03-13 08:00:00	SPY	ETF	666.01	671.12	662.77	669.65	933642.0
2026-03-13 09:00:00	SPY	ETF	669.62	672.335	668.89	670.53	9283625.0
2026-03-13 10:00:00	SPY	ETF	670.54	671.25	664.99	665.33	11356578.0
2026-03-13 11:00:00	SPY	ETF	665.34	666.94	663.1	663.38	11840151.0
2026-03-13 12:00:00	SPY	ETF	663.36	665.23	663.135	663.335	8155153.0
2026-03-13 13:00:00	SPY	ETF	663.32	665.08	662.08	662.63	7044293.0
2026-03-13 14:00:00	SPY	ETF	662.64	664.81	662.45	664.18	6428125.0
2026-03-13 15:00:00	SPY	ETF	664.18	664.2	661.36	662.3	13755499.0
2026-03-13 16:00:00	SPY	ETF	662.3	662.41	661.15	661.24	2781768.0
2026-03-13 17:00:00	SPY	ETF	661.35	662.2599	661.29	662.23	133549.0
2026-03-13 18:00:00	SPY	ETF	662.2301	662.88	662.15	662.39	185266.0
2026-03-13 19:00:00	SPY	ETF	662.31	663.1	662.15	663.052	129323.0
2026-03-13 04:00:00	QQQ	ETF	595.12	596.79	593.79	596.54	266597.0
2026-03-13 05:00:00	QQQ	ETF	596.59	598.0	596.5	597.11	174729.0
2026-03-13 06:00:00	QQQ	ETF	596.91	599.17	596.85	599.06	203698.0
2026-03-13 07:00:00	QQQ	ETF	599.04	600.2	598.72	600.15	364611.0
2026-03-13 08:00:00	QQQ	ETF	597.35	601.9	593.75	600.57	913003.0
2026-03-13 09:00:00	QQQ	ETF	600.7	603.5999	598.93	601.69	7293499.0
2026-03-13 10:00:00	QQQ	ETF	601.71	602.6	595.805	595.98	9086124.0
2026-03-13 11:00:00	QQQ	ETF	595.98	597.88	593.58	593.98	8297218.0
2026-03-13 12:00:00	QQQ	ETF	593.96	595.92	593.44	593.68	5346530.0
2026-03-13 13:00:00	QQQ	ETF	593.6878	595.55	592.62	593.13	5340017.0
2026-03-13 14:00:00	QQQ	ETF	593.13	595.5	592.98	594.92	5548905.0
2026-03-13 15:00:00	QQQ	ETF	594.92	594.94	592.57	593.69	8535746.0
2026-03-13 16:00:00	QQQ	ETF	593.69	593.75	592.2008	592.3	1334694.0
2026-03-13 17:00:00	QQQ	ETF	592.4565	592.93	592.3	592.8	54686.0
2026-03-13 18:00:00	QQQ	ETF	592.86	593.6	592.79	593.35	59061.0
2026-03-13 19:00:00	QQQ	ETF	593.4	593.59	593.0	593.44	94064.0
2026-03-13 04:00:00	IWM	ETF	249.28	250.0	245.53	247.12	85295.0
2026-03-13 05:00:00	IWM	ETF	247.19	247.93	247.18	247.73	45059.0
2026-03-13 06:00:00	IWM	ETF	247.91	248.65	247.84	248.16	150940.0
2026-03-13 07:00:00	IWM	ETF	248.62	249.4	248.34	249.32	241053.0
2026-03-13 08:00:00	IWM	ETF	248.92	250.19	245.66	249.34	548527.0
2026-03-13 09:00:00	IWM	ETF	249.34	250.61	248.85	249.34	5385681.0
2026-03-13 10:00:00	IWM	ETF	249.35	249.55	246.11	246.25	6316985.0
2026-03-13 11:00:00	IWM	ETF	246.24	247.35	245.84	246.0	4598482.0
2026-03-13 12:00:00	IWM	ETF	245.99	246.955	245.63	246.05	3989982.0
2026-03-13 13:00:00	IWM	ETF	246.06	246.765	245.535	245.57	3352475.0
2026-03-13 14:00:00	IWM	ETF	245.585	246.9	245.55	246.58	2852106.0
2026-03-13 15:00:00	IWM	ETF	246.585	246.64	245.68	246.56	6514905.0
2026-03-13 16:00:00	IWM	ETF	246.56	246.63	245.93	246.04	1496191.0
2026-03-13 17:00:00	IWM	ETF	246.02	246.5	246.02	246.5	56360.0
2026-03-13 18:00:00	IWM	ETF	246.26	246.6803	246.2	246.42	68224.0
2026-03-13 19:00:00	IWM	ETF	246.511	246.95	246.25	246.9	34330.0
2026-03-13 04:00:00	DIA	ETF	466.41	467.35	465.24	467.35	6554.0
2026-03-13 05:00:00	DIA	ETF	467.37	468.02	467.34	468.02	9750.0

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

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