PREVIEW / etf_1hour / 2025-06-23

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-06-23.parquet
  size:    668 KB
  rows:    26,190

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-23 04:00:00	SPY	ETF	594.22	596.41	592.55	595.74	80953.0
2025-06-23 05:00:00	SPY	ETF	595.7	596.33	595.31	595.6	54969.0
2025-06-23 06:00:00	SPY	ETF	595.49	596.25	594.59	594.73	121898.0
2025-06-23 07:00:00	SPY	ETF	594.71	594.85	592.81	593.84	459390.0
2025-06-23 08:00:00	SPY	ETF	594.62	596.0404	592.63	595.2199	380572.0
2025-06-23 09:00:00	SPY	ETF	595.16	596.67	593.6	596.65	6021329.0
2025-06-23 10:00:00	SPY	ETF	596.66	598.29	596.42	596.465	7674672.0
2025-06-23 11:00:00	SPY	ETF	596.47	597.66	595.75	595.86	5224580.0
2025-06-23 12:00:00	SPY	ETF	595.86	596.08	591.89	593.58	12170129.0
2025-06-23 13:00:00	SPY	ETF	593.61	599.34	593.19	598.53	10613309.0
2025-06-23 14:00:00	SPY	ETF	598.54	599.13	597.99	598.5086	6253411.0
2025-06-23 15:00:00	SPY	ETF	598.51	600.54	598.41	600.13	12689318.0
2025-06-23 16:00:00	SPY	ETF	600.11	600.3294	599.66	600.13	5571562.0
2025-06-23 17:00:00	SPY	ETF	600.14	600.17	600.02	600.09	61228.0
2025-06-23 18:00:00	SPY	ETF	600.15	602.95	599.9612	602.5892	574548.0
2025-06-23 19:00:00	SPY	ETF	602.6	603.69	602.58	603.3384	288500.0
2025-06-23 04:00:00	QQQ	ETF	527.49	528.52	526.8	527.74	80327.0
2025-06-23 05:00:00	QQQ	ETF	527.71	528.33	527.11	527.19	35944.0
2025-06-23 06:00:00	QQQ	ETF	527.15	528.09	526.32	526.54	58952.0
2025-06-23 07:00:00	QQQ	ETF	526.53	526.72	524.6	525.77	98650.0
2025-06-23 08:00:00	QQQ	ETF	527.54	527.67	524.11	527.16	248710.0
2025-06-23 09:00:00	QQQ	ETF	527.13	528.235	524.16	528.1536	3661013.0
2025-06-23 10:00:00	QQQ	ETF	528.17	530.35	528.17	528.83	5001473.0
2025-06-23 11:00:00	QQQ	ETF	528.85	530.07	528.1	528.45	3039757.0
2025-06-23 12:00:00	QQQ	ETF	528.463	528.61	523.65	526.08	7133755.0
2025-06-23 13:00:00	QQQ	ETF	526.13	531.97	525.67	531.1498	6898550.0
2025-06-23 14:00:00	QQQ	ETF	531.15	531.93	530.43	530.77	3171127.0
2025-06-23 15:00:00	QQQ	ETF	530.76	532.17	530.5	531.7	5264563.0
2025-06-23 16:00:00	QQQ	ETF	531.71	532.0	531.22	531.7	1590344.0
2025-06-23 17:00:00	QQQ	ETF	531.72	531.99	531.63	531.92	36353.0
2025-06-23 18:00:00	QQQ	ETF	531.83	535.12	531.5103	534.83	407190.0
2025-06-23 19:00:00	QQQ	ETF	534.9	536.1	534.82	535.72	314784.0
2025-06-23 04:00:00	IWM	ETF	209.46	209.83	209.31	209.36	26401.0
2025-06-23 05:00:00	IWM	ETF	209.33	209.44	209.05	209.18	40508.0
2025-06-23 06:00:00	IWM	ETF	208.95	209.38	208.7	208.81	59557.0
2025-06-23 07:00:00	IWM	ETF	208.8	208.9	207.94	208.4	79253.0
2025-06-23 08:00:00	IWM	ETF	208.78	209.49	207.98	208.71	139606.0
2025-06-23 09:00:00	IWM	ETF	208.72	209.62	207.6	209.59	2826153.0
2025-06-23 10:00:00	IWM	ETF	209.58	210.71	209.53	209.55	3277838.0
2025-06-23 11:00:00	IWM	ETF	209.56	210.01	209.03	209.05	2234566.0
2025-06-23 12:00:00	IWM	ETF	209.05	209.09	206.81	207.44	4707630.0
2025-06-23 13:00:00	IWM	ETF	207.45	210.25	207.35	210.22	4683878.0
2025-06-23 14:00:00	IWM	ETF	210.23	210.69	210.13	210.66	2674914.0
2025-06-23 15:00:00	IWM	ETF	210.65	211.78	210.615	211.76	6909553.0
2025-06-23 16:00:00	IWM	ETF	211.77	211.77	211.39	211.68	925863.0
2025-06-23 17:00:00	IWM	ETF	211.56	211.7	211.48	211.7	13915.0
2025-06-23 18:00:00	IWM	ETF	211.6	213.01	211.6	212.7701	114983.0
2025-06-23 19:00:00	IWM	ETF	212.79	213.55	212.79	213.25	78740.0
2025-06-23 04:00:00	DIA	ETF	421.7	422.33	421.7	422.33	2504.0
2025-06-23 05:00:00	DIA	ETF	422.37	422.37	422.28	422.28	300.0

> showing 50 of 26,190 rows — these rows as CSV

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