PREVIEW / etf_1hour / 2025-10-09

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-10-09.parquet
  size:    699 KB
  rows:    27,283

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-09 04:00:00	SPY	ETF	673.12	673.28	672.59	672.7	21477.0
2025-10-09 05:00:00	SPY	ETF	672.74	673.34	672.61	673.1	7614.0
2025-10-09 06:00:00	SPY	ETF	673.09	673.23	672.73	673.11	11766.0
2025-10-09 07:00:00	SPY	ETF	673.01	673.58	673.0	673.08	79305.0
2025-10-09 08:00:00	SPY	ETF	673.0197	673.68	672.7	673.4694	114783.0
2025-10-09 09:00:00	SPY	ETF	673.47	673.94	671.57	671.915	7367413.0
2025-10-09 10:00:00	SPY	ETF	671.91	672.24	669.97	671.355	9259183.0
2025-10-09 11:00:00	SPY	ETF	671.35	671.851	669.99	671.308	5683088.0
2025-10-09 12:00:00	SPY	ETF	671.31	671.58	669.65	669.8	3867611.0
2025-10-09 13:00:00	SPY	ETF	669.8	670.38	669.21	670.19	5637896.0
2025-10-09 14:00:00	SPY	ETF	670.185	670.33	669.33	669.9	3683168.0
2025-10-09 15:00:00	SPY	ETF	669.92	671.26	669.825	671.17	11146530.0
2025-10-09 16:00:00	SPY	ETF	671.18	671.31	670.63	671.02	2659704.0
2025-10-09 17:00:00	SPY	ETF	671.02	671.2	670.94	671.11	38966.0
2025-10-09 18:00:00	SPY	ETF	671.05	671.68	671.05	671.59	101581.0
2025-10-09 19:00:00	SPY	ETF	671.59	671.96	671.45	671.96	29613.0
2025-10-09 04:00:00	QQQ	ETF	611.74	611.83	610.66	610.78	109056.0
2025-10-09 05:00:00	QQQ	ETF	610.85	611.71	610.69	611.29	62457.0
2025-10-09 06:00:00	QQQ	ETF	611.29	611.58	610.89	611.25	42872.0
2025-10-09 07:00:00	QQQ	ETF	611.24	611.79	611.11	611.12	66263.0
2025-10-09 08:00:00	QQQ	ETF	611.3	612.36	610.7	611.6	195063.0
2025-10-09 09:00:00	QQQ	ETF	611.61	611.66	609.68	610.29	4606533.0
2025-10-09 10:00:00	QQQ	ETF	610.3	610.53	608.23	609.63	5478026.0
2025-10-09 11:00:00	QQQ	ETF	609.64	610.19	608.34	609.92	3779254.0
2025-10-09 12:00:00	QQQ	ETF	609.93	610.19	608.32	608.5	3193805.0
2025-10-09 13:00:00	QQQ	ETF	608.5	609.18	607.48	608.8	4020625.0
2025-10-09 14:00:00	QQQ	ETF	608.798	609.42	608.02	609.255	2805946.0
2025-10-09 15:00:00	QQQ	ETF	609.26	610.76	609.21	610.7	6055651.0
2025-10-09 16:00:00	QQQ	ETF	610.72	610.82	610.14	610.4676	1022254.0
2025-10-09 17:00:00	QQQ	ETF	610.5	610.58	610.3944	610.56	12318.0
2025-10-09 18:00:00	QQQ	ETF	610.56	611.3	610.56	611.209	102162.0
2025-10-09 19:00:00	QQQ	ETF	611.24	611.63	611.0259	611.5803	77231.0
2025-10-09 04:00:00	IWM	ETF	246.52	246.6	245.92	245.98	41840.0
2025-10-09 05:00:00	IWM	ETF	245.92	246.35	245.92	246.17	17665.0
2025-10-09 06:00:00	IWM	ETF	246.23	246.43	246.22	246.41	17428.0
2025-10-09 07:00:00	IWM	ETF	246.4	246.65	246.33	246.38	34460.0
2025-10-09 08:00:00	IWM	ETF	246.46	246.75	246.12	246.58	81419.0
2025-10-09 09:00:00	IWM	ETF	246.55	247.25	245.5	245.615	3038905.0
2025-10-09 10:00:00	IWM	ETF	245.62	246.01	244.64	245.49	3014324.0
2025-10-09 11:00:00	IWM	ETF	245.49	246.015	245.12	245.92	1856590.0
2025-10-09 12:00:00	IWM	ETF	245.93	246.09	244.71	244.75	1919581.0
2025-10-09 13:00:00	IWM	ETF	244.77	244.95	244.01	244.6335	2259239.0
2025-10-09 14:00:00	IWM	ETF	244.635	244.665	244.095	244.425	1801624.0
2025-10-09 15:00:00	IWM	ETF	244.43	245.45	244.365	245.12	3674350.0
2025-10-09 16:00:00	IWM	ETF	245.13	245.41	245.12	245.33	680039.0
2025-10-09 17:00:00	IWM	ETF	245.26	245.39	245.2	245.33	3318.0
2025-10-09 18:00:00	IWM	ETF	245.37	245.63	245.17	245.63	22501.0
2025-10-09 19:00:00	IWM	ETF	245.61	245.71	245.45	245.71	10770.0
2025-10-09 04:00:00	DIA	ETF	466.16	466.16	465.99	466.06	1200.0
2025-10-09 05:00:00	DIA	ETF	466.04	466.49	466.04	466.42	1136.0

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

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