PREVIEW / etf_1hour / 2025-06-04

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-06-04.parquet
  size:    624 KB
  rows:    24,060

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-04 04:00:00	SPY	ETF	596.99	597.63	596.84	596.85	25308.0
2025-06-04 05:00:00	SPY	ETF	596.93	597.45	596.83	597.26	8704.0
2025-06-04 06:00:00	SPY	ETF	597.22	597.63	596.92	597.42	28502.0
2025-06-04 07:00:00	SPY	ETF	597.44	597.5	596.92	597.29	48198.0
2025-06-04 08:00:00	SPY	ETF	597.32	597.67	595.46	596.26	505916.0
2025-06-04 09:00:00	SPY	ETF	596.26	597.95	596.1	597.565	5023302.0
2025-06-04 10:00:00	SPY	ETF	597.5	597.77	595.49	597.525	7823377.0
2025-06-04 11:00:00	SPY	ETF	597.54	597.875	596.41	596.88	4422698.0
2025-06-04 12:00:00	SPY	ETF	596.87	596.94	595.7909	596.77	4093155.0
2025-06-04 13:00:00	SPY	ETF	596.77	597.67	596.75	597.57	3406940.0
2025-06-04 14:00:00	SPY	ETF	597.58	597.93	596.84	597.0212	4538006.0
2025-06-04 15:00:00	SPY	ETF	597.03	597.6	595.89	595.9	9633819.0
2025-06-04 16:00:00	SPY	ETF	595.9	596.1	595.65	595.73	2295175.0
2025-06-04 17:00:00	SPY	ETF	595.81	595.89	595.61	595.61	61244.0
2025-06-04 18:00:00	SPY	ETF	595.6	596.13	595.49	595.68	78286.0
2025-06-04 19:00:00	SPY	ETF	595.78	595.84	595.37	595.48	59856.0
2025-06-04 04:00:00	QQQ	ETF	527.85	528.55	527.78	527.78	44393.0
2025-06-04 05:00:00	QQQ	ETF	527.89	528.45	527.86	528.25	26372.0
2025-06-04 06:00:00	QQQ	ETF	528.26	528.87	527.9	528.63	54786.0
2025-06-04 07:00:00	QQQ	ETF	528.59	528.7	528.1	528.54	63771.0
2025-06-04 08:00:00	QQQ	ETF	528.3	528.97	526.31	527.6288	427222.0
2025-06-04 09:00:00	QQQ	ETF	527.64	529.66	527.39	528.61	4217038.0
2025-06-04 10:00:00	QQQ	ETF	528.61	528.94	525.9694	528.88	5588064.0
2025-06-04 11:00:00	QQQ	ETF	528.89	529.43	528.16	528.7	3493461.0
2025-06-04 12:00:00	QQQ	ETF	528.69	528.75	527.5488	528.685	2196664.0
2025-06-04 13:00:00	QQQ	ETF	528.69	529.56	528.66	529.465	2417993.0
2025-06-04 14:00:00	QQQ	ETF	529.47	529.84	529.13	529.38	3709621.0
2025-06-04 15:00:00	QQQ	ETF	529.39	529.75	528.55	528.78	4994610.0
2025-06-04 16:00:00	QQQ	ETF	528.76	528.95	528.41	528.58	1526772.0
2025-06-04 17:00:00	QQQ	ETF	528.5106	528.77	528.45	528.5	61527.0
2025-06-04 18:00:00	QQQ	ETF	528.5	529.07	528.2101	528.6	77627.0
2025-06-04 19:00:00	QQQ	ETF	528.62	528.65	528.3101	528.4	29017.0
2025-06-04 04:00:00	IWM	ETF	210.0	210.29	209.7	209.76	34159.0
2025-06-04 05:00:00	IWM	ETF	209.8	210.05	209.65	209.65	23243.0
2025-06-04 06:00:00	IWM	ETF	209.61	209.87	209.51	209.59	18691.0
2025-06-04 07:00:00	IWM	ETF	209.68	209.76	209.24	209.61	20887.0
2025-06-04 08:00:00	IWM	ETF	209.6	210.0104	208.76	209.01	399001.0
2025-06-04 09:00:00	IWM	ETF	209.02	210.01	208.82	209.3506	3063187.0
2025-06-04 10:00:00	IWM	ETF	209.33	209.335	208.14	208.67	4676844.0
2025-06-04 11:00:00	IWM	ETF	208.66	208.9	208.39	208.5899	2978203.0
2025-06-04 12:00:00	IWM	ETF	208.57	208.795	208.2	208.7262	2367460.0
2025-06-04 13:00:00	IWM	ETF	208.73	209.225	208.73	209.19	1364248.0
2025-06-04 14:00:00	IWM	ETF	209.19	209.3	208.69	208.76	2080552.0
2025-06-04 15:00:00	IWM	ETF	208.76	208.96	208.43	208.44	4260964.0
2025-06-04 16:00:00	IWM	ETF	208.44	208.53	208.3	208.3	575922.0
2025-06-04 17:00:00	IWM	ETF	208.3	208.42	208.28	208.35	5466.0
2025-06-04 18:00:00	IWM	ETF	208.35	208.53	208.22	208.34	21267.0
2025-06-04 19:00:00	IWM	ETF	208.37	208.37	208.17	208.21	39283.0
2025-06-04 04:00:00	DIA	ETF	426.61	426.83	426.61	426.79	4132.0
2025-06-04 05:00:00	DIA	ETF	426.63	426.74	426.63	426.67	695.0

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

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