PREVIEW / etf_1hour / 2025-04-15

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-04-15.parquet
  size:    641 KB
  rows:    24,669

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-04-15 04:00:00	SPY	ETF	539.27	540.86	539.2	540.12	46524.0
2025-04-15 05:00:00	SPY	ETF	539.58	540.67	538.9	539.33	22477.0
2025-04-15 06:00:00	SPY	ETF	539.66	540.32	538.75	539.68	73241.0
2025-04-15 07:00:00	SPY	ETF	539.67	540.0	536.9	537.38	148798.0
2025-04-15 08:00:00	SPY	ETF	539.66	541.0	536.16	538.17	666263.0
2025-04-15 09:00:00	SPY	ETF	538.22	542.9499	538.22	541.48	4545540.0
2025-04-15 10:00:00	SPY	ETF	541.52	543.23	538.14	540.58	7643646.0
2025-04-15 11:00:00	SPY	ETF	540.5801	542.03	539.44	540.9717	3571588.0
2025-04-15 12:00:00	SPY	ETF	541.0	541.62	538.48	539.04	2535949.0
2025-04-15 13:00:00	SPY	ETF	539.01	539.9	537.37	538.2867	3973249.0
2025-04-15 14:00:00	SPY	ETF	538.32	539.21	536.81	538.63	3878497.0
2025-04-15 15:00:00	SPY	ETF	538.63	539.29	537.14	537.72	8126987.0
2025-04-15 16:00:00	SPY	ETF	537.71	538.2899	537.0	537.4	2964574.0
2025-04-15 17:00:00	SPY	ETF	537.35	538.2	535.06	535.19	352964.0
2025-04-15 18:00:00	SPY	ETF	535.15	535.15	532.39	533.91	348522.0
2025-04-15 19:00:00	SPY	ETF	533.9	534.1	532.82	533.58	99562.0
2025-04-15 04:00:00	QQQ	ETF	459.16	459.65	458.16	458.96	70265.0
2025-04-15 05:00:00	QQQ	ETF	458.8	459.53	458.06	458.49	37070.0
2025-04-15 06:00:00	QQQ	ETF	458.27	459.1	457.77	458.49	46517.0
2025-04-15 07:00:00	QQQ	ETF	458.49	458.65	455.83	456.21	124875.0
2025-04-15 08:00:00	QQQ	ETF	458.3	459.81	454.97	457.36	378984.0
2025-04-15 09:00:00	QQQ	ETF	457.37	461.715	457.37	460.5	2821946.0
2025-04-15 10:00:00	QQQ	ETF	460.53	462.38	457.15	459.39	6190257.0
2025-04-15 11:00:00	QQQ	ETF	459.405	461.23	458.57	460.11	2957055.0
2025-04-15 12:00:00	QQQ	ETF	460.13	461.0969	457.63	458.11	2403303.0
2025-04-15 13:00:00	QQQ	ETF	458.07	459.1696	456.73	457.74	2793608.0
2025-04-15 14:00:00	QQQ	ETF	457.74	458.79	456.15	458.39	2124483.0
2025-04-15 15:00:00	QQQ	ETF	458.315	458.93	457.07	457.99	2738196.0
2025-04-15 16:00:00	QQQ	ETF	457.98	458.38	457.29	457.3301	998269.0
2025-04-15 17:00:00	QQQ	ETF	457.52	458.05	453.2582	453.59	288211.0
2025-04-15 18:00:00	QQQ	ETF	453.89	454.01	451.77	452.78	388856.0
2025-04-15 19:00:00	QQQ	ETF	452.72	453.09	451.58	452.31	163244.0
2025-04-15 04:00:00	IWM	ETF	187.0	187.42	186.51	186.75	28833.0
2025-04-15 05:00:00	IWM	ETF	186.61	186.99	186.19	186.44	14036.0
2025-04-15 06:00:00	IWM	ETF	186.53	186.86	186.4	186.66	32683.0
2025-04-15 07:00:00	IWM	ETF	186.73	186.96	185.78	185.98	147231.0
2025-04-15 08:00:00	IWM	ETF	185.89	187.46	184.99	185.58	970453.0
2025-04-15 09:00:00	IWM	ETF	185.71	188.72	185.57	188.08	3148828.0
2025-04-15 10:00:00	IWM	ETF	188.09	189.05	186.74	187.38	4597346.0
2025-04-15 11:00:00	IWM	ETF	187.4	187.92	186.71	187.1	2159986.0
2025-04-15 12:00:00	IWM	ETF	187.1	187.735	186.65	186.81	1673912.0
2025-04-15 13:00:00	IWM	ETF	186.79	187.22	186.14	186.45	2182012.0
2025-04-15 14:00:00	IWM	ETF	186.45	186.835	185.84	186.61	1910266.0
2025-04-15 15:00:00	IWM	ETF	186.6	186.96	186.26	186.74	3415040.0
2025-04-15 16:00:00	IWM	ETF	186.76	186.95	186.4	186.63	1201435.0
2025-04-15 17:00:00	IWM	ETF	186.63	187.0	186.13	186.43	54437.0
2025-04-15 18:00:00	IWM	ETF	186.27	186.27	185.39	185.93	191759.0
2025-04-15 19:00:00	IWM	ETF	185.9	185.96	185.64	185.82	139611.0
2025-04-15 04:00:00	DIA	ETF	405.61	406.25	405.61	405.71	3643.0
2025-04-15 05:00:00	DIA	ETF	405.48	405.48	405.12	405.12	300.0

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

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