PREVIEW / etf_1hour / 2025-06-03

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-06-03.parquet
  size:    634 KB
  rows:    24,653

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-03 04:00:00	SPY	ETF	590.2	590.8	589.01	590.05	60061.0
2025-06-03 05:00:00	SPY	ETF	590.07	590.51	589.9	590.25	13808.0
2025-06-03 06:00:00	SPY	ETF	590.29	591.09	590.0	591.04	65392.0
2025-06-03 07:00:00	SPY	ETF	591.1	592.02	590.92	591.81	112442.0
2025-06-03 08:00:00	SPY	ETF	591.13	592.38	589.34	592.01	329031.0
2025-06-03 09:00:00	SPY	ETF	592.07	593.27	591.84	592.395	4420864.0
2025-06-03 10:00:00	SPY	ETF	592.47	594.41	591.85	594.37	6432081.0
2025-06-03 11:00:00	SPY	ETF	594.37	595.7	594.36	595.64	5669287.0
2025-06-03 12:00:00	SPY	ETF	595.64	596.67	595.24	596.5	4638764.0
2025-06-03 13:00:00	SPY	ETF	596.5	597.08	596.06	596.11	4622102.0
2025-06-03 14:00:00	SPY	ETF	596.12	596.47	594.8001	596.33	6959525.0
2025-06-03 15:00:00	SPY	ETF	596.34	596.51	595.23	596.11	11393890.0
2025-06-03 16:00:00	SPY	ETF	596.11	596.25	595.51	595.94	2415658.0
2025-06-03 17:00:00	SPY	ETF	596.0	596.09	595.82	596.08	39035.0
2025-06-03 18:00:00	SPY	ETF	595.96	596.6001	595.94	596.5	69794.0
2025-06-03 19:00:00	SPY	ETF	596.37	596.5705	596.05	596.3017	54495.0
2025-06-03 04:00:00	QQQ	ETF	521.01	521.25	520.1	521.12	41902.0
2025-06-03 05:00:00	QQQ	ETF	521.19	521.63	520.88	521.27	23512.0
2025-06-03 06:00:00	QQQ	ETF	521.34	522.35	520.97	522.34	73134.0
2025-06-03 07:00:00	QQQ	ETF	522.41	523.31	522.09	523.161	85919.0
2025-06-03 08:00:00	QQQ	ETF	522.29	523.5	520.2	523.32	256122.0
2025-06-03 09:00:00	QQQ	ETF	523.35	525.039	522.69	524.79	3981674.0
2025-06-03 10:00:00	QQQ	ETF	524.75	526.39	523.86	526.355	5011027.0
2025-06-03 11:00:00	QQQ	ETF	526.35	527.0	526.16	526.9101	3848434.0
2025-06-03 12:00:00	QQQ	ETF	526.92	528.45	526.71	528.225	3626468.0
2025-06-03 13:00:00	QQQ	ETF	528.23	528.74	527.7	527.74	3321243.0
2025-06-03 14:00:00	QQQ	ETF	527.75	527.8202	525.77	527.59	4483189.0
2025-06-03 15:00:00	QQQ	ETF	527.6	527.94	526.48	527.42	5534768.0
2025-06-03 16:00:00	QQQ	ETF	527.4	527.43	526.47	527.02	1282935.0
2025-06-03 17:00:00	QQQ	ETF	527.01	527.14	526.7	526.9208	88153.0
2025-06-03 18:00:00	QQQ	ETF	527.08	527.78	527.08	527.53	60552.0
2025-06-03 19:00:00	QQQ	ETF	527.3	527.74	527.15	527.41	48166.0
2025-06-03 04:00:00	IWM	ETF	204.61	204.84	204.12	204.84	35003.0
2025-06-03 05:00:00	IWM	ETF	204.89	205.16	204.79	205.16	20346.0
2025-06-03 06:00:00	IWM	ETF	205.06	205.46	204.82	205.46	14285.0
2025-06-03 07:00:00	IWM	ETF	205.4	206.2	205.39	206.1	61562.0
2025-06-03 08:00:00	IWM	ETF	204.78	206.6	203.94	206.56	176084.0
2025-06-03 09:00:00	IWM	ETF	206.55	206.78	205.55	206.02	3219325.0
2025-06-03 10:00:00	IWM	ETF	206.04	208.25	205.58	208.07	4217579.0
2025-06-03 11:00:00	IWM	ETF	208.07	208.985	208.02	208.97	3059403.0
2025-06-03 12:00:00	IWM	ETF	208.96	209.2	208.77	209.1	2482222.0
2025-06-03 13:00:00	IWM	ETF	209.11	209.605	208.99	209.34	2533176.0
2025-06-03 14:00:00	IWM	ETF	209.3475	209.505	208.73	209.28	3843671.0
2025-06-03 15:00:00	IWM	ETF	209.28	209.335	208.53	209.06	6354692.0
2025-06-03 16:00:00	IWM	ETF	209.03	209.19	208.86	209.15	1342259.0
2025-06-03 17:00:00	IWM	ETF	209.14	209.15	209.03	209.06	508088.0
2025-06-03 18:00:00	IWM	ETF	209.15	209.46	209.13	209.32	8826.0
2025-06-03 19:00:00	IWM	ETF	209.28	209.44	209.23	209.3699	10365.0
2025-06-03 04:00:00	DIA	ETF	421.6	421.98	421.59	421.98	1300.0
2025-06-03 05:00:00	DIA	ETF	421.9	422.27	421.9	422.27	450.0

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

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