PREVIEW / etf_1hour / 2026-03-06

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-03-06.parquet
  size:    740 KB
  rows:    29,373

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-06 04:00:00	SPY	ETF	682.01	682.1	678.02	678.62	215436.0
2026-03-06 05:00:00	SPY	ETF	678.71	680.29	678.71	679.65	98797.0
2026-03-06 06:00:00	SPY	ETF	679.61	679.86	677.05	677.6	437370.0
2026-03-06 07:00:00	SPY	ETF	677.54	678.32	676.51	677.005	400752.0
2026-03-06 08:00:00	SPY	ETF	677.07	683.43	672.03	672.69	2880183.0
2026-03-06 09:00:00	SPY	ETF	672.64	674.06	669.76	670.87	12301931.0
2026-03-06 10:00:00	SPY	ETF	670.91	675.915	670.791	674.92	13175586.0
2026-03-06 11:00:00	SPY	ETF	674.96	676.01	673.4	674.97	7904938.0
2026-03-06 12:00:00	SPY	ETF	674.98	675.84	672.03	673.08	6947279.0
2026-03-06 13:00:00	SPY	ETF	673.09	676.11	672.97	674.04	7180707.0
2026-03-06 14:00:00	SPY	ETF	674.07	675.64	673.78	675.01	6653586.0
2026-03-06 15:00:00	SPY	ETF	675.0	675.97	671.14	672.46	21105620.0
2026-03-06 16:00:00	SPY	ETF	672.47	672.72	671.15	672.1	3264645.0
2026-03-06 17:00:00	SPY	ETF	672.1	672.51	671.62	671.8	282447.0
2026-03-06 18:00:00	SPY	ETF	671.79	672.3	671.32	671.6504	166798.0
2026-03-06 19:00:00	SPY	ETF	671.66	671.75	671.3	671.3	34990.0
2026-03-06 04:00:00	QQQ	ETF	610.08	610.45	605.17	605.97	257924.0
2026-03-06 05:00:00	QQQ	ETF	606.14	607.43	606.09	606.75	176303.0
2026-03-06 06:00:00	QQQ	ETF	606.74	607.03	604.0	604.5	327748.0
2026-03-06 07:00:00	QQQ	ETF	604.51	605.1	603.25	604.0	317630.0
2026-03-06 08:00:00	QQQ	ETF	603.91	611.28	598.71	599.3889	1670822.0
2026-03-06 09:00:00	QQQ	ETF	599.21	601.72	598.54	600.47	10082085.0
2026-03-06 10:00:00	QQQ	ETF	600.45	605.34	599.84	604.51	13658059.0
2026-03-06 11:00:00	QQQ	ETF	604.5025	605.88	602.87	605.03	8473588.0
2026-03-06 12:00:00	QQQ	ETF	605.05	606.0	601.73	602.7	7151201.0
2026-03-06 13:00:00	QQQ	ETF	602.71	605.45	602.58	603.08	7120043.0
2026-03-06 14:00:00	QQQ	ETF	603.09	604.37	602.45	603.27	8233726.0
2026-03-06 15:00:00	QQQ	ETF	603.26	604.35	598.33	599.81	14877932.0
2026-03-06 16:00:00	QQQ	ETF	599.86	600.22	598.72	599.7	1762245.0
2026-03-06 17:00:00	QQQ	ETF	599.8	600.15	599.4	599.5532	127206.0
2026-03-06 18:00:00	QQQ	ETF	599.5488	599.81	599.5	599.62	36074.0
2026-03-06 19:00:00	QQQ	ETF	599.51	599.68	598.76	598.8	46281.0
2026-03-06 04:00:00	IWM	ETF	258.11	258.11	255.42	255.69	85158.0
2026-03-06 05:00:00	IWM	ETF	255.86	256.46	255.75	256.25	41739.0
2026-03-06 06:00:00	IWM	ETF	256.23	256.27	254.7	254.77	112543.0
2026-03-06 07:00:00	IWM	ETF	254.91	255.08	254.2	254.54	211119.0
2026-03-06 08:00:00	IWM	ETF	254.8597	258.45	250.78	251.06	1749808.0
2026-03-06 09:00:00	IWM	ETF	251.0	251.77	250.07	250.345	6667265.0
2026-03-06 10:00:00	IWM	ETF	250.35	253.2999	250.32	252.41	6951970.0
2026-03-06 11:00:00	IWM	ETF	252.4	252.91	251.05	251.4	4308017.0
2026-03-06 12:00:00	IWM	ETF	251.41	251.94	249.94	250.5967	4534903.0
2026-03-06 13:00:00	IWM	ETF	250.58	252.28	250.52	251.42	3326781.0
2026-03-06 14:00:00	IWM	ETF	251.41	252.325	251.1	251.79	2936121.0
2026-03-06 15:00:00	IWM	ETF	251.79	252.25	250.08	250.89	7293157.0
2026-03-06 16:00:00	IWM	ETF	250.9	250.9702	250.16	250.79	1097004.0
2026-03-06 17:00:00	IWM	ETF	250.68	250.9	250.46	250.64	71309.0
2026-03-06 18:00:00	IWM	ETF	250.64	250.88	250.4227	250.43	14509.0
2026-03-06 19:00:00	IWM	ETF	250.62	250.64	250.1315	250.1315	10833.0
2026-03-06 04:00:00	DIA	ETF	480.72	480.72	477.93	478.27	27109.0
2026-03-06 05:00:00	DIA	ETF	478.49	479.41	478.49	479.05	9946.0

> showing 50 of 29,373 rows — these rows as CSV

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