PREVIEW / etf_1hour / 2025-10-22

all etf 1-hour files

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

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-22 04:00:00	SPY	ETF	671.72	672.31	671.34	671.7	17533.0
2025-10-22 05:00:00	SPY	ETF	671.67	671.94	671.14	671.94	9696.0
2025-10-22 06:00:00	SPY	ETF	671.96	672.32	671.78	671.9	12137.0
2025-10-22 07:00:00	SPY	ETF	671.9	672.0	670.71	671.05	151222.0
2025-10-22 08:00:00	SPY	ETF	672.19	672.84	670.83	671.97	245890.0
2025-10-22 09:00:00	SPY	ETF	671.98	672.27	670.45	671.27	4175636.0
2025-10-22 10:00:00	SPY	ETF	671.25	671.61	668.09	670.07	8245123.0
2025-10-22 11:00:00	SPY	ETF	670.07	670.41	667.39	669.01	6650200.0
2025-10-22 12:00:00	SPY	ETF	669.0	669.2	664.01	667.35	10552257.0
2025-10-22 13:00:00	SPY	ETF	667.3	667.65	663.3	664.74	6716265.0
2025-10-22 14:00:00	SPY	ETF	664.75	666.56	663.76	666.49	5757673.0
2025-10-22 15:00:00	SPY	ETF	666.46	668.36	665.54	667.79	12160180.0
2025-10-22 16:00:00	SPY	ETF	667.81	668.52	667.25	667.84	3333189.0
2025-10-22 17:00:00	SPY	ETF	667.74	667.84	667.35	667.5	69705.0
2025-10-22 18:00:00	SPY	ETF	667.49	668.0	667.08	667.8	96561.0
2025-10-22 19:00:00	SPY	ETF	667.769	668.0801	666.78	666.8096	58623.0
2025-10-22 04:00:00	QQQ	ETF	611.6	611.7	610.54	610.89	110889.0
2025-10-22 05:00:00	QQQ	ETF	610.86	611.04	610.06	611.0	111807.0
2025-10-22 06:00:00	QQQ	ETF	610.99	612.0	610.56	611.31	102552.0
2025-10-22 07:00:00	QQQ	ETF	611.31	611.43	609.499	609.89	154214.0
2025-10-22 08:00:00	QQQ	ETF	611.41	612.55	609.5	610.73	334987.0
2025-10-22 09:00:00	QQQ	ETF	610.76	611.41	608.6302	610.645	3943101.0
2025-10-22 10:00:00	QQQ	ETF	610.64	611.19	605.63	608.598	7739198.0
2025-10-22 11:00:00	QQQ	ETF	608.6	609.02	604.495	606.82	5342251.0
2025-10-22 12:00:00	QQQ	ETF	606.87	607.07	601.26	604.26	5868197.0
2025-10-22 13:00:00	QQQ	ETF	604.26	604.67	599.74	601.3899	5550752.0
2025-10-22 14:00:00	QQQ	ETF	601.39	603.5	600.29	603.45	4395412.0
2025-10-22 15:00:00	QQQ	ETF	603.42	605.84	602.64	605.38	5382398.0
2025-10-22 16:00:00	QQQ	ETF	605.4	606.27	605.0	605.35	1568272.0
2025-10-22 17:00:00	QQQ	ETF	605.29	605.3491	604.21	604.36	151381.0
2025-10-22 18:00:00	QQQ	ETF	604.4	605.83	604.4	605.5404	207438.0
2025-10-22 19:00:00	QQQ	ETF	605.45	605.9	604.24	604.3072	94675.0
2025-10-22 04:00:00	IWM	ETF	247.17	247.23	246.62	246.75	57711.0
2025-10-22 05:00:00	IWM	ETF	246.74	246.77	246.22	246.54	45556.0
2025-10-22 06:00:00	IWM	ETF	246.53	246.55	246.23	246.3	28607.0
2025-10-22 07:00:00	IWM	ETF	246.33	246.33	245.67	245.68	58018.0
2025-10-22 08:00:00	IWM	ETF	245.69	247.42	245.69	246.13	141228.0
2025-10-22 09:00:00	IWM	ETF	246.17	246.86	245.55	246.14	2671285.0
2025-10-22 10:00:00	IWM	ETF	246.13	246.19	243.32	244.325	5504653.0
2025-10-22 11:00:00	IWM	ETF	244.34	244.58	243.07	243.7	4437220.0
2025-10-22 12:00:00	IWM	ETF	243.7	243.8	240.88	242.61	6372122.0
2025-10-22 13:00:00	IWM	ETF	242.58	242.95	240.765	241.2	3747321.0
2025-10-22 14:00:00	IWM	ETF	241.2	242.64	240.89	242.61	3345103.0
2025-10-22 15:00:00	IWM	ETF	242.6	243.86	242.08	243.36	7116336.0
2025-10-22 16:00:00	IWM	ETF	243.34	243.62	243.1	243.49	1113108.0
2025-10-22 17:00:00	IWM	ETF	243.4	243.55	243.27	243.37	15061.0
2025-10-22 18:00:00	IWM	ETF	243.39	243.62	243.37	243.52	26515.0
2025-10-22 19:00:00	IWM	ETF	243.49	243.67	242.98	243.01	27390.0
2025-10-22 04:00:00	DIA	ETF	469.36	469.36	469.13	469.25	1300.0
2025-10-22 05:00:00	DIA	ETF	468.98	469.38	468.98	469.37	700.0

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

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