PREVIEW / etf_1hour / 2025-07-21

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-07-21.parquet
  size:    676 KB
  rows:    26,285

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-07-21 04:00:00	SPY	ETF	629.11	629.56	629.05	629.39	45186.0
2025-07-21 05:00:00	SPY	ETF	629.38	629.59	629.3	629.31	34201.0
2025-07-21 06:00:00	SPY	ETF	629.35	629.53	629.0	629.25	37635.0
2025-07-21 07:00:00	SPY	ETF	629.23	629.28	628.99	629.07	126079.0
2025-07-21 08:00:00	SPY	ETF	629.27	629.37	628.2	628.45	141147.0
2025-07-21 09:00:00	SPY	ETF	628.44	630.7	628.17	630.57	4932928.0
2025-07-21 10:00:00	SPY	ETF	630.58	631.39	630.38	631.02	6868722.0
2025-07-21 11:00:00	SPY	ETF	631.025	631.54	630.88	631.1751	4367798.0
2025-07-21 12:00:00	SPY	ETF	631.17	631.32	630.535	631.25	4030193.0
2025-07-21 13:00:00	SPY	ETF	631.25	631.52	631.11	631.17	2866481.0
2025-07-21 14:00:00	SPY	ETF	631.16	631.27	630.32	630.3614	4713755.0
2025-07-21 15:00:00	SPY	ETF	630.37	630.4	628.34	628.76	13939274.0
2025-07-21 16:00:00	SPY	ETF	628.74	629.07	628.5894	629.0	3242480.0
2025-07-21 17:00:00	SPY	ETF	629.01	629.05	628.88	628.92	56939.0
2025-07-21 18:00:00	SPY	ETF	628.91	629.15	628.82	628.92	46164.0
2025-07-21 19:00:00	SPY	ETF	628.93	629.06	628.84	629.06	23416.0
2025-07-21 04:00:00	QQQ	ETF	563.01	563.33	562.77	562.92	35929.0
2025-07-21 05:00:00	QQQ	ETF	562.96	563.13	562.84	562.91	31833.0
2025-07-21 06:00:00	QQQ	ETF	562.9	563.29	562.75	562.93	42193.0
2025-07-21 07:00:00	QQQ	ETF	562.96	562.96	562.56	562.6	63746.0
2025-07-21 08:00:00	QQQ	ETF	562.91	563.11	561.62	561.67	205126.0
2025-07-21 09:00:00	QQQ	ETF	561.65	565.39	561.32	564.91	3935853.0
2025-07-21 10:00:00	QQQ	ETF	564.93	566.06	564.93	565.45	4180354.0
2025-07-21 11:00:00	QQQ	ETF	565.45	565.6299	565.03	565.16	2268054.0
2025-07-21 12:00:00	QQQ	ETF	565.16	565.755	564.535	565.6201	3209219.0
2025-07-21 13:00:00	QQQ	ETF	565.63	566.049	565.62	565.78	1977211.0
2025-07-21 14:00:00	QQQ	ETF	565.77	565.92	565.18	565.27	2531128.0
2025-07-21 15:00:00	QQQ	ETF	565.285	565.32	563.79	564.16	6645974.0
2025-07-21 16:00:00	QQQ	ETF	564.17	564.42	564.05	564.2	1553711.0
2025-07-21 17:00:00	QQQ	ETF	564.26	564.26	563.88	563.94	64213.0
2025-07-21 18:00:00	QQQ	ETF	563.96	564.29	563.95	564.16	53712.0
2025-07-21 19:00:00	QQQ	ETF	564.14	564.31	564.0	564.28	56159.0
2025-07-21 04:00:00	IWM	ETF	223.34	223.91	223.34	223.71	24875.0
2025-07-21 05:00:00	IWM	ETF	223.7	223.74	223.56	223.56	16014.0
2025-07-21 06:00:00	IWM	ETF	223.66	223.67	223.45	223.64	31464.0
2025-07-21 07:00:00	IWM	ETF	223.55	223.93	223.48	223.9	58049.0
2025-07-21 08:00:00	IWM	ETF	223.73	224.0	222.63	223.61	98150.0
2025-07-21 09:00:00	IWM	ETF	223.6	223.965	223.25	223.96	2145619.0
2025-07-21 10:00:00	IWM	ETF	223.96	224.41	223.62	224.27	3458684.0
2025-07-21 11:00:00	IWM	ETF	224.28	224.365	223.61	223.64	2294711.0
2025-07-21 12:00:00	IWM	ETF	223.64	223.725	222.67	222.985	3139774.0
2025-07-21 13:00:00	IWM	ETF	222.99	223.35	222.81	223.005	1619169.0
2025-07-21 14:00:00	IWM	ETF	223.005	223.25	222.325	222.425	2239042.0
2025-07-21 15:00:00	IWM	ETF	222.43	222.46	221.25	221.4505	6697794.0
2025-07-21 16:00:00	IWM	ETF	221.43	221.83	221.43	221.83	609004.0
2025-07-21 17:00:00	IWM	ETF	221.79	221.79	221.639	221.7	18983.0
2025-07-21 18:00:00	IWM	ETF	221.78	222.07	221.75	221.88	29929.0
2025-07-21 19:00:00	IWM	ETF	221.9255	221.95	221.76	221.9	15369.0
2025-07-21 04:00:00	DIA	ETF	444.39	444.56	444.36	444.54	1800.0
2025-07-21 05:00:00	DIA	ETF	444.7	444.7	444.36	444.36	1900.0

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

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