PREVIEW / etf_1hour / 2025-06-13

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-06-13.parquet
  size:    626 KB
  rows:    24,967

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-06-13 04:00:00	SPY	ETF	596.34	597.5	594.48	596.39	221489.0
2025-06-13 05:00:00	SPY	ETF	596.41	597.41	595.86	596.91	142034.0
2025-06-13 06:00:00	SPY	ETF	597.02	597.87	596.4	597.63	196878.0
2025-06-13 07:00:00	SPY	ETF	597.7	598.7	597.5	598.48	651164.0
2025-06-13 08:00:00	SPY	ETF	598.0	599.1	593.79	598.09	596027.0
2025-06-13 09:00:00	SPY	ETF	598.11	600.37	597.25	598.15	7313660.0
2025-06-13 10:00:00	SPY	ETF	598.17	599.42	596.63	599.14	8768519.0
2025-06-13 11:00:00	SPY	ETF	599.14	601.71	598.92	601.25	6281675.0
2025-06-13 12:00:00	SPY	ETF	601.24	601.85	600.285	601.065	4064554.0
2025-06-13 13:00:00	SPY	ETF	601.05	601.17	598.96	599.78	5688132.0
2025-06-13 14:00:00	SPY	ETF	599.8	600.29	595.59	597.21	11894930.0
2025-06-13 15:00:00	SPY	ETF	597.19	597.685	595.48	596.95	16721511.0
2025-06-13 16:00:00	SPY	ETF	596.95	597.7	596.62	596.88	4099848.0
2025-06-13 17:00:00	SPY	ETF	596.76	597.21	596.69	597.0	108163.0
2025-06-13 18:00:00	SPY	ETF	597.01	597.41	597.0	597.3	87676.0
2025-06-13 19:00:00	SPY	ETF	597.34	597.5	597.3018	597.49	69209.0
2025-06-13 04:00:00	QQQ	ETF	526.45	527.24	524.61	525.68	107471.0
2025-06-13 05:00:00	QQQ	ETF	525.69	526.76	525.25	526.31	112173.0
2025-06-13 06:00:00	QQQ	ETF	526.28	527.0	525.64	526.88	117585.0
2025-06-13 07:00:00	QQQ	ETF	526.97	528.17	526.8	527.79	321688.0
2025-06-13 08:00:00	QQQ	ETF	527.18	528.18	523.88	527.13	466848.0
2025-06-13 09:00:00	QQQ	ETF	527.06	530.4	526.4	528.67	4706832.0
2025-06-13 10:00:00	QQQ	ETF	528.88	529.8079	526.14	529.17	6261100.0
2025-06-13 11:00:00	QQQ	ETF	529.17	531.59	529.0	531.37	3906970.0
2025-06-13 12:00:00	QQQ	ETF	531.36	531.87	530.52	531.25	2924955.0
2025-06-13 13:00:00	QQQ	ETF	531.23	531.4	529.35	530.22	3409773.0
2025-06-13 14:00:00	QQQ	ETF	530.26	530.66	525.77	527.3601	7231347.0
2025-06-13 15:00:00	QQQ	ETF	527.35	527.93	525.73	526.94	8598417.0
2025-06-13 16:00:00	QQQ	ETF	526.94	528.5861	526.72	526.99	1390618.0
2025-06-13 17:00:00	QQQ	ETF	526.91	527.149	526.8	526.86	58194.0
2025-06-13 18:00:00	QQQ	ETF	526.8996	526.99	526.3	526.91	14867.0
2025-06-13 19:00:00	QQQ	ETF	526.76	527.03	526.76	526.98	22245.0
2025-06-13 04:00:00	IWM	ETF	209.38	209.64	208.3	209.35	71658.0
2025-06-13 05:00:00	IWM	ETF	209.29	209.63	208.89	209.35	50376.0
2025-06-13 06:00:00	IWM	ETF	209.3	209.5	209.19	209.35	62709.0
2025-06-13 07:00:00	IWM	ETF	209.44	210.18	209.44	210.05	174918.0
2025-06-13 08:00:00	IWM	ETF	206.95	210.25	206.95	209.8	338161.0
2025-06-13 09:00:00	IWM	ETF	209.7	210.92	209.05	209.13	5225857.0
2025-06-13 10:00:00	IWM	ETF	209.18	210.31	209.13	210.29	4504862.0
2025-06-13 11:00:00	IWM	ETF	210.28	211.155	210.17	210.96	3634544.0
2025-06-13 12:00:00	IWM	ETF	210.95	211.44	210.65	211.02	3020097.0
2025-06-13 13:00:00	IWM	ETF	211.0	211.12	210.17	210.335	3875184.0
2025-06-13 14:00:00	IWM	ETF	210.34	210.54	208.52	209.42	7433093.0
2025-06-13 15:00:00	IWM	ETF	209.4	209.52	208.22	208.91	12020533.0
2025-06-13 16:00:00	IWM	ETF	208.89	209.17	208.74	208.81	2847360.0
2025-06-13 17:00:00	IWM	ETF	208.89	209.18	208.8	209.02	26376.0
2025-06-13 18:00:00	IWM	ETF	209.08	209.13	208.83	208.88	28294.0
2025-06-13 19:00:00	IWM	ETF	208.83	209.08	208.76	208.96	17122.0
2025-06-13 04:00:00	DIA	ETF	425.67	426.11	425.4	425.56	12042.0
2025-06-13 05:00:00	DIA	ETF	425.75	425.92	425.4	425.59	3665.0

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

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