PREVIEW / etf_1hour / 2025-10-15

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-10-15.parquet
  size:    725 KB
  rows:    27,570

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-10-15 04:00:00	SPY	ETF	665.09	665.75	665.09	665.4	57503.0
2025-10-15 05:00:00	SPY	ETF	665.4	666.74	665.37	666.44	43474.0
2025-10-15 06:00:00	SPY	ETF	666.51	666.79	666.01	666.52	55205.0
2025-10-15 07:00:00	SPY	ETF	666.51	666.72	666.1	666.6	246755.0
2025-10-15 08:00:00	SPY	ETF	666.46	667.7	663.75	667.49	465852.0
2025-10-15 09:00:00	SPY	ETF	667.49	668.58	666.05	668.31	8165452.0
2025-10-15 10:00:00	SPY	ETF	668.34	670.23	668.31	669.02	5755822.0
2025-10-15 11:00:00	SPY	ETF	669.03	669.17	663.915	665.2	6440634.0
2025-10-15 12:00:00	SPY	ETF	665.22	666.4582	663.93	664.0957	4550855.0
2025-10-15 13:00:00	SPY	ETF	664.09	664.51	658.93	664.31	10255668.0
2025-10-15 14:00:00	SPY	ETF	664.32	665.8365	663.45	665.725	4201443.0
2025-10-15 15:00:00	SPY	ETF	665.725	665.825	663.25	665.08	12614988.0
2025-10-15 16:00:00	SPY	ETF	665.09	666.03	664.58	665.03	2914796.0
2025-10-15 17:00:00	SPY	ETF	664.97	665.15	664.88	665.14	95725.0
2025-10-15 18:00:00	SPY	ETF	665.15	666.19	665.15	665.85	90697.0
2025-10-15 19:00:00	SPY	ETF	665.859	665.859	664.74	665.111	36891.0
2025-10-15 04:00:00	QQQ	ETF	601.5	602.42	600.67	602.29	106212.0
2025-10-15 05:00:00	QQQ	ETF	602.28	603.75	602.22	603.31	158924.0
2025-10-15 06:00:00	QQQ	ETF	603.34	603.51	602.77	603.23	103639.0
2025-10-15 07:00:00	QQQ	ETF	603.15	603.26	602.54	603.05	234208.0
2025-10-15 08:00:00	QQQ	ETF	603.06	604.67	597.552	604.49	761560.0
2025-10-15 09:00:00	QQQ	ETF	604.51	604.52	601.51	604.29	4969901.0
2025-10-15 10:00:00	QQQ	ETF	604.33	606.7	604.28	606.34	5498284.0
2025-10-15 11:00:00	QQQ	ETF	606.39	606.5999	601.025	602.43	4749408.0
2025-10-15 12:00:00	QQQ	ETF	602.43	603.8	601.42	601.6413	3105215.0
2025-10-15 13:00:00	QQQ	ETF	601.64	601.92	595.93	601.7199	7301476.0
2025-10-15 14:00:00	QQQ	ETF	601.67	602.99	600.61	602.8401	2463853.0
2025-10-15 15:00:00	QQQ	ETF	602.84	602.9101	600.28	602.16	4217139.0
2025-10-15 16:00:00	QQQ	ETF	602.17	603.07	601.87	602.57	1345244.0
2025-10-15 17:00:00	QQQ	ETF	602.6	602.6	601.79	602.255	101987.0
2025-10-15 18:00:00	QQQ	ETF	602.27	603.7	602.27	603.3712	147322.0
2025-10-15 19:00:00	QQQ	ETF	603.3333	603.401	602.1719	602.55	67320.0
2025-10-15 04:00:00	IWM	ETF	249.45	250.08	249.45	249.83	63990.0
2025-10-15 05:00:00	IWM	ETF	249.82	250.87	249.8	250.82	103484.0
2025-10-15 06:00:00	IWM	ETF	250.8	250.87	250.31	250.75	83396.0
2025-10-15 07:00:00	IWM	ETF	250.7	250.76	250.24	250.39	127043.0
2025-10-15 08:00:00	IWM	ETF	250.66	251.06	248.84	250.6	478997.0
2025-10-15 09:00:00	IWM	ETF	250.61	251.75	250.12	251.6	4230156.0
2025-10-15 10:00:00	IWM	ETF	251.62	252.77	250.885	251.1	4802884.0
2025-10-15 11:00:00	IWM	ETF	251.1	251.129	249.08	249.81	4107264.0
2025-10-15 12:00:00	IWM	ETF	249.84	250.245	248.81	248.95	2488813.0
2025-10-15 13:00:00	IWM	ETF	248.94	249.51	247.06	249.46	4918465.0
2025-10-15 14:00:00	IWM	ETF	249.45	250.05	249.01	250.0199	2211678.0
2025-10-15 15:00:00	IWM	ETF	250.01	250.4	249.69	250.34	5186435.0
2025-10-15 16:00:00	IWM	ETF	250.33	250.77	250.13	250.319	1296540.0
2025-10-15 17:00:00	IWM	ETF	250.36	250.37	250.14	250.3	16991.0
2025-10-15 18:00:00	IWM	ETF	250.29	250.83	250.29	250.58	20746.0
2025-10-15 19:00:00	IWM	ETF	250.65	250.65	250.12	250.33	39563.0
2025-10-15 04:00:00	DIA	ETF	464.35	464.48	464.13	464.13	1500.0
2025-10-15 05:00:00	DIA	ETF	464.18	464.84	464.18	464.76	2800.0

> showing 50 of 27,570 rows — these rows as CSV

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