PREVIEW / etf_1hour / 2025-03-04

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-03-04.parquet
  size:    664 KB
  rows:    25,999

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-03-04 04:00:00	SPY	ETF	584.63	585.31	583.76	584.03	37261.0
2025-03-04 05:00:00	SPY	ETF	583.72	584.18	582.8	583.31	44450.0
2025-03-04 06:00:00	SPY	ETF	583.34	583.85	582.75	583.39	27956.0
2025-03-04 07:00:00	SPY	ETF	583.31	583.42	579.86	580.2	297109.0
2025-03-04 08:00:00	SPY	ETF	582.47	586.0	579.03	579.84	789437.0
2025-03-04 09:00:00	SPY	ETF	579.83	581.34	575.59	575.7	8715200.0
2025-03-04 10:00:00	SPY	ETF	575.71	576.21	572.25	574.09	10689493.0
2025-03-04 11:00:00	SPY	ETF	574.1	576.57	572.3	575.985	7188470.0
2025-03-04 12:00:00	SPY	ETF	576.02	578.57	575.33	576.494	6138564.0
2025-03-04 13:00:00	SPY	ETF	576.51	580.83	576.03	580.285	4331360.0
2025-03-04 14:00:00	SPY	ETF	580.26	583.13	580.18	582.89	6305359.0
2025-03-04 15:00:00	SPY	ETF	582.82	585.39	574.69	576.87	19041733.0
2025-03-04 16:00:00	SPY	ETF	576.88	581.81	576.84	580.39	5744729.0
2025-03-04 17:00:00	SPY	ETF	580.31	580.76	579.95	580.75	198046.0
2025-03-04 18:00:00	SPY	ETF	580.75	581.539	580.2	581.24	250534.0
2025-03-04 19:00:00	SPY	ETF	581.25	581.45	579.4	580.43	147825.0
2025-03-04 04:00:00	QQQ	ETF	498.47	499.6	497.8	497.97	65484.0
2025-03-04 05:00:00	QQQ	ETF	497.87	498.39	496.67	497.29	165703.0
2025-03-04 06:00:00	QQQ	ETF	497.0	497.82	496.65	497.42	106212.0
2025-03-04 07:00:00	QQQ	ETF	497.37	497.37	493.41	493.75	380062.0
2025-03-04 08:00:00	QQQ	ETF	496.52	500.12	492.24	493.7	976243.0
2025-03-04 09:00:00	QQQ	ETF	493.74	496.32	491.46	491.5594	7534746.0
2025-03-04 10:00:00	QQQ	ETF	491.55	492.24	487.735	490.6862	9248978.0
2025-03-04 11:00:00	QQQ	ETF	490.69	494.07	488.52	493.15	5062528.0
2025-03-04 12:00:00	QQQ	ETF	493.158	496.42	492.35	494.0766	4604867.0
2025-03-04 13:00:00	QQQ	ETF	494.08	498.59	493.48	498.06	3944252.0
2025-03-04 14:00:00	QQQ	ETF	498.05	501.22	497.99	500.955	4129165.0
2025-03-04 15:00:00	QQQ	ETF	500.92	503.74	493.75	495.52	9493097.0
2025-03-04 16:00:00	QQQ	ETF	495.51	500.27	495.3	498.97	3075306.0
2025-03-04 17:00:00	QQQ	ETF	499.0	499.41	498.6	499.35	110989.0
2025-03-04 18:00:00	QQQ	ETF	499.2	500.35	498.92	499.9	197565.0
2025-03-04 19:00:00	QQQ	ETF	499.84	500.16	497.83	498.84	147042.0
2025-03-04 04:00:00	IWM	ETF	209.18	209.18	208.05	208.3	48822.0
2025-03-04 05:00:00	IWM	ETF	207.89	208.27	207.5	207.83	17540.0
2025-03-04 06:00:00	IWM	ETF	207.83	208.14	207.65	207.84	24433.0
2025-03-04 07:00:00	IWM	ETF	207.79	207.99	206.83	206.9	453256.0
2025-03-04 08:00:00	IWM	ETF	207.44	209.39	205.8	206.12	479150.0
2025-03-04 09:00:00	IWM	ETF	206.05	206.73	204.21	204.27	5353512.0
2025-03-04 10:00:00	IWM	ETF	204.27	204.95	203.32	203.94	7665069.0
2025-03-04 11:00:00	IWM	ETF	203.95	205.26	203.19	205.13	4113333.0
2025-03-04 12:00:00	IWM	ETF	205.13	206.5	204.59	205.6	4285078.0
2025-03-04 13:00:00	IWM	ETF	205.61	207.98	205.555	207.79	3554731.0
2025-03-04 14:00:00	IWM	ETF	207.76	208.8399	207.731	208.75	3383172.0
2025-03-04 15:00:00	IWM	ETF	208.74	209.77	206.21	206.43	8868067.0
2025-03-04 16:00:00	IWM	ETF	206.42	208.8	206.42	208.41	1975473.0
2025-03-04 17:00:00	IWM	ETF	208.39	208.66	208.11	208.62	59361.0
2025-03-04 18:00:00	IWM	ETF	208.53	208.93	208.17	208.79	45551.0
2025-03-04 19:00:00	IWM	ETF	208.82	209.03	208.25	208.8	64917.0
2025-03-04 04:00:00	DIA	ETF	432.75	432.75	431.89	432.59	2144.0
2025-03-04 05:00:00	DIA	ETF	431.58	432.15	431.4	432.1	4437.0

> showing 50 of 25,999 rows — these rows as CSV

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