PREVIEW / etf_1hour / 2025-10-06

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-10-06.parquet
  size:    730 KB
  rows:    28,103

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-06 04:00:00	SPY	ETF	670.66	671.24	669.72	671.09	35269.0
2025-10-06 05:00:00	SPY	ETF	671.04	671.65	670.98	671.6	21805.0
2025-10-06 06:00:00	SPY	ETF	671.65	672.57	671.42	671.74	54573.0
2025-10-06 07:00:00	SPY	ETF	671.7	671.72	670.95	671.55	190841.0
2025-10-06 08:00:00	SPY	ETF	671.57	672.14	670.15	671.0681	345357.0
2025-10-06 09:00:00	SPY	ETF	671.02	671.8	669.89	670.015	7306082.0
2025-10-06 10:00:00	SPY	ETF	670.01	670.855	669.455	670.76	6567512.0
2025-10-06 11:00:00	SPY	ETF	670.77	671.925	670.7101	671.81	4261291.0
2025-10-06 12:00:00	SPY	ETF	671.8	671.885	671.2917	671.72	2873835.0
2025-10-06 13:00:00	SPY	ETF	671.715	672.35	671.33	672.27	3837247.0
2025-10-06 14:00:00	SPY	ETF	672.27	672.51	672.0001	672.11	3933888.0
2025-10-06 15:00:00	SPY	ETF	672.1101	672.15	671.54	671.59	8526952.0
2025-10-06 16:00:00	SPY	ETF	671.59	671.86	671.4	671.78	1829218.0
2025-10-06 17:00:00	SPY	ETF	671.85	671.85	671.64	671.7	28715.0
2025-10-06 18:00:00	SPY	ETF	671.7	671.99	670.54	670.6499	69413.0
2025-10-06 19:00:00	SPY	ETF	670.64	670.91	670.4874	670.68	58057.0
2025-10-06 04:00:00	QQQ	ETF	604.5	606.1	604.5	605.91	73820.0
2025-10-06 05:00:00	QQQ	ETF	605.91	606.67	605.85	606.57	70318.0
2025-10-06 06:00:00	QQQ	ETF	606.52	607.74	606.33	607.43	91863.0
2025-10-06 07:00:00	QQQ	ETF	607.44	607.75	606.4	607.73	174321.0
2025-10-06 08:00:00	QQQ	ETF	607.1	609.06	604.44	607.88	436512.0
2025-10-06 09:00:00	QQQ	ETF	607.84	608.6103	606.09	607.03	5197838.0
2025-10-06 10:00:00	QQQ	ETF	607.03	607.73	605.97	606.9793	4387076.0
2025-10-06 11:00:00	QQQ	ETF	606.97	608.495	606.76	608.305	2982287.0
2025-10-06 12:00:00	QQQ	ETF	608.3	608.385	607.7099	608.18	2338499.0
2025-10-06 13:00:00	QQQ	ETF	608.17	608.87	607.71	608.78	3038147.0
2025-10-06 14:00:00	QQQ	ETF	608.772	609.36	608.56	609.02	2559621.0
2025-10-06 15:00:00	QQQ	ETF	609.015	609.04	607.62	607.71	7142698.0
2025-10-06 16:00:00	QQQ	ETF	607.72	607.9351	607.47	607.69	1776414.0
2025-10-06 17:00:00	QQQ	ETF	607.7698	607.99	607.61	607.87	21068.0
2025-10-06 18:00:00	QQQ	ETF	607.78	608.0	606.63	606.68	110190.0
2025-10-06 19:00:00	QQQ	ETF	606.7	607.0	606.519	606.77	110141.0
2025-10-06 04:00:00	IWM	ETF	246.36	246.74	246.36	246.58	41953.0
2025-10-06 05:00:00	IWM	ETF	246.57	246.98	246.55	246.96	22404.0
2025-10-06 06:00:00	IWM	ETF	246.95	247.28	246.71	247.16	30260.0
2025-10-06 07:00:00	IWM	ETF	247.16	247.42	247.0	247.42	28532.0
2025-10-06 08:00:00	IWM	ETF	247.4	247.72	246.05	247.45	248157.0
2025-10-06 09:00:00	IWM	ETF	247.41	248.21	246.465	246.62	4084847.0
2025-10-06 10:00:00	IWM	ETF	246.62	248.03	246.065	247.71	3557126.0
2025-10-06 11:00:00	IWM	ETF	247.715	248.475	247.67	247.895	2188081.0
2025-10-06 12:00:00	IWM	ETF	247.895	248.135	247.44	247.76	1942888.0
2025-10-06 13:00:00	IWM	ETF	247.75	248.025	247.445	247.84	2003720.0
2025-10-06 14:00:00	IWM	ETF	247.82	247.94	247.05	247.28	2376707.0
2025-10-06 15:00:00	IWM	ETF	247.27	247.29	246.7	246.8	4755437.0
2025-10-06 16:00:00	IWM	ETF	246.81	247.03	246.64	247.01	777801.0
2025-10-06 17:00:00	IWM	ETF	247.03	247.3275	246.93	247.13	26923.0
2025-10-06 18:00:00	IWM	ETF	247.03	247.1	246.25	246.25	31644.0
2025-10-06 19:00:00	IWM	ETF	246.27	246.43	246.24	246.24	26385.0
2025-10-06 04:00:00	DIA	ETF	468.27	468.27	467.99	468.02	6300.0
2025-10-06 05:00:00	DIA	ETF	468.05	468.41	468.05	468.41	800.0

> showing 50 of 28,103 rows — these rows as CSV

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