PREVIEW / etf_1hour / 2025-03-05

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-03-05.parquet
  size:    644 KB
  rows:    25,210

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-05 04:00:00	SPY	ETF	580.7	582.27	579.94	581.9	52050.0
2025-03-05 05:00:00	SPY	ETF	582.0	582.11	580.23	580.23	81911.0
2025-03-05 06:00:00	SPY	ETF	580.2	580.5	577.64	578.9	125317.0
2025-03-05 07:00:00	SPY	ETF	578.89	579.55	577.76	578.17	260388.0
2025-03-05 08:00:00	SPY	ETF	578.15	581.94	576.31	576.77	921671.0
2025-03-05 09:00:00	SPY	ETF	576.77	579.12	575.0	575.81	5692538.0
2025-03-05 10:00:00	SPY	ETF	576.51	579.64	575.4	576.92	6734418.0
2025-03-05 11:00:00	SPY	ETF	576.9	576.91	573.0796	575.89	6169960.0
2025-03-05 12:00:00	SPY	ETF	575.86	580.91	575.77	580.7463	5058312.0
2025-03-05 13:00:00	SPY	ETF	580.75	581.57	577.74	581.465	5867782.0
2025-03-05 14:00:00	SPY	ETF	581.46	584.34	580.83	583.09	6403438.0
2025-03-05 15:00:00	SPY	ETF	583.025	584.88	581.39	583.05	10007050.0
2025-03-05 16:00:00	SPY	ETF	583.04	583.18	580.4099	582.52	3884796.0
2025-03-05 17:00:00	SPY	ETF	582.47	582.68	582.29	582.36	75041.0
2025-03-05 18:00:00	SPY	ETF	582.45	583.26	582.23	582.51	74931.0
2025-03-05 19:00:00	SPY	ETF	582.4	582.9	581.8	581.9	105634.0
2025-03-05 04:00:00	QQQ	ETF	499.3	501.21	498.73	500.8	74227.0
2025-03-05 05:00:00	QQQ	ETF	500.82	500.88	499.11	499.3	66560.0
2025-03-05 06:00:00	QQQ	ETF	499.2	499.51	496.81	497.9	86426.0
2025-03-05 07:00:00	QQQ	ETF	497.96	498.77	497.29	497.78	206671.0
2025-03-05 08:00:00	QQQ	ETF	497.8	500.872	495.92	496.16	531271.0
2025-03-05 09:00:00	QQQ	ETF	496.13	497.22	492.57	493.77	4234445.0
2025-03-05 10:00:00	QQQ	ETF	493.82	498.05	493.3	495.55	4382188.0
2025-03-05 11:00:00	QQQ	ETF	495.47	495.47	491.26	494.2334	4004592.0
2025-03-05 12:00:00	QQQ	ETF	494.205	500.0	494.09	499.888	3866701.0
2025-03-05 13:00:00	QQQ	ETF	499.85	500.53	496.82	500.43	4738011.0
2025-03-05 14:00:00	QQQ	ETF	500.37	503.28	499.62	501.84	3546713.0
2025-03-05 15:00:00	QQQ	ETF	501.82	503.63	500.64	502.1	5375089.0
2025-03-05 16:00:00	QQQ	ETF	502.06	502.12	500.11	500.85	1581622.0
2025-03-05 17:00:00	QQQ	ETF	500.86	501.22	500.81	501.0	63958.0
2025-03-05 18:00:00	QQQ	ETF	500.87	501.659	500.48	500.87	83173.0
2025-03-05 19:00:00	QQQ	ETF	500.77	501.5	500.22	500.41	90407.0
2025-03-05 04:00:00	IWM	ETF	208.81	209.68	208.3	209.41	37737.0
2025-03-05 05:00:00	IWM	ETF	209.55	209.55	208.87	208.99	19850.0
2025-03-05 06:00:00	IWM	ETF	208.88	209.04	207.78	207.99	169533.0
2025-03-05 07:00:00	IWM	ETF	208.04	208.43	207.77	207.85	137920.0
2025-03-05 08:00:00	IWM	ETF	207.98	209.3496	206.48	206.58	725217.0
2025-03-05 09:00:00	IWM	ETF	206.57	207.57	205.67	206.12	3468080.0
2025-03-05 10:00:00	IWM	ETF	206.19	207.8899	206.02	206.75	3535243.0
2025-03-05 11:00:00	IWM	ETF	206.695	206.695	204.82	205.81	3442189.0
2025-03-05 12:00:00	IWM	ETF	205.8	207.33	205.73	207.23	2419227.0
2025-03-05 13:00:00	IWM	ETF	207.23	207.48	205.95	207.44	2936564.0
2025-03-05 14:00:00	IWM	ETF	207.42	208.84	207.27	208.1564	3492706.0
2025-03-05 15:00:00	IWM	ETF	208.13	208.83	207.74	208.53	5296351.0
2025-03-05 16:00:00	IWM	ETF	208.47	208.65	208.18	208.25	1826520.0
2025-03-05 17:00:00	IWM	ETF	208.28	208.55	208.26	208.35	83630.0
2025-03-05 18:00:00	IWM	ETF	208.4	208.71	208.3	208.56	285339.0
2025-03-05 19:00:00	IWM	ETF	208.45	208.69	208.08	208.14	82112.0
2025-03-05 04:00:00	DIA	ETF	427.44	428.44	427.44	428.44	218.0
2025-03-05 05:00:00	DIA	ETF	427.98	427.98	427.91	427.91	214.0

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

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