PREVIEW / etf_1hour / 2025-06-25

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-06-25.parquet
  size:    643 KB
  rows:    24,762

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-06-25 04:00:00	SPY	ETF	607.0	607.22	606.65	607.2	25910.0
2025-06-25 05:00:00	SPY	ETF	607.21	607.5	606.88	606.88	16220.0
2025-06-25 06:00:00	SPY	ETF	606.93	607.36	606.63	607.22	35286.0
2025-06-25 07:00:00	SPY	ETF	607.22	608.13	607.03	608.05	83246.0
2025-06-25 08:00:00	SPY	ETF	607.24	608.15	606.87	608.15	196331.0
2025-06-25 09:00:00	SPY	ETF	608.18	608.61	607.45	608.16	6984193.0
2025-06-25 10:00:00	SPY	ETF	608.17	608.41	607.31	607.765	6619525.0
2025-06-25 11:00:00	SPY	ETF	607.76	607.805	606.48	606.89	6138790.0
2025-06-25 12:00:00	SPY	ETF	606.89	607.27	606.42	606.71	3105422.0
2025-06-25 13:00:00	SPY	ETF	606.705	607.14	605.54	606.24	5494517.0
2025-06-25 14:00:00	SPY	ETF	606.27	606.55	606.05	606.42	3288018.0
2025-06-25 15:00:00	SPY	ETF	606.43	607.37	606.37	607.08	10152750.0
2025-06-25 16:00:00	SPY	ETF	607.08	607.15	606.75	606.94	2954329.0
2025-06-25 17:00:00	SPY	ETF	606.97	607.06	606.5	606.65	118727.0
2025-06-25 18:00:00	SPY	ETF	606.65	607.3599	606.65	606.97	170502.0
2025-06-25 19:00:00	SPY	ETF	607.01	607.1	606.3	607.09	188214.0
2025-06-25 04:00:00	QQQ	ETF	540.27	540.5	539.95	540.5	36383.0
2025-06-25 05:00:00	QQQ	ETF	540.49	540.93	540.25	540.31	39480.0
2025-06-25 06:00:00	QQQ	ETF	540.32	541.05	540.07	540.83	52531.0
2025-06-25 07:00:00	QQQ	ETF	540.87	541.9	540.74	541.9	76076.0
2025-06-25 08:00:00	QQQ	ETF	540.83	542.33	539.82	542.33	189846.0
2025-06-25 09:00:00	QQQ	ETF	542.3	543.31	541.81	542.65	6501585.0
2025-06-25 10:00:00	QQQ	ETF	542.66	542.82	541.24	541.885	5257903.0
2025-06-25 11:00:00	QQQ	ETF	541.88	541.93	540.37	540.73	3297338.0
2025-06-25 12:00:00	QQQ	ETF	540.71	541.02	539.9	540.65	2472237.0
2025-06-25 13:00:00	QQQ	ETF	540.65	541.125	539.38	539.9199	3388635.0
2025-06-25 14:00:00	QQQ	ETF	539.93	540.46	539.695	540.0999	2225198.0
2025-06-25 15:00:00	QQQ	ETF	540.11	541.22	540.07	541.17	4360846.0
2025-06-25 16:00:00	QQQ	ETF	541.15	542.1	540.87	541.39	2190011.0
2025-06-25 17:00:00	QQQ	ETF	541.3202	541.71	540.91	540.96	156987.0
2025-06-25 18:00:00	QQQ	ETF	541.05	541.7	540.91	541.17	92087.0
2025-06-25 19:00:00	QQQ	ETF	541.11	541.21	540.57	541.13	51789.0
2025-06-25 04:00:00	IWM	ETF	214.68	214.73	214.34	214.54	16980.0
2025-06-25 05:00:00	IWM	ETF	214.58	214.8	214.45	214.45	6155.0
2025-06-25 06:00:00	IWM	ETF	214.4	214.44	214.22	214.22	20897.0
2025-06-25 07:00:00	IWM	ETF	214.24	214.72	213.93	214.63	70198.0
2025-06-25 08:00:00	IWM	ETF	214.09	214.78	213.99	214.72	98794.0
2025-06-25 09:00:00	IWM	ETF	214.74	214.79	213.1335	213.38	2515567.0
2025-06-25 10:00:00	IWM	ETF	213.37	213.46	212.47	212.7051	3163823.0
2025-06-25 11:00:00	IWM	ETF	212.72	212.86	212.21	212.75	2406690.0
2025-06-25 12:00:00	IWM	ETF	212.74	213.05	212.49	212.53	1871941.0
2025-06-25 13:00:00	IWM	ETF	212.53	212.825	212.15	212.47	2198514.0
2025-06-25 14:00:00	IWM	ETF	212.465	212.81	212.37	212.53	1822298.0
2025-06-25 15:00:00	IWM	ETF	212.53	212.85	211.89	212.03	5423716.0
2025-06-25 16:00:00	IWM	ETF	212.03	212.05	211.64	211.74	1488908.0
2025-06-25 17:00:00	IWM	ETF	211.75	211.96	211.74	211.85	28500.0
2025-06-25 18:00:00	IWM	ETF	211.85	211.99	211.82	211.92	42843.0
2025-06-25 19:00:00	IWM	ETF	211.88	211.95	211.72	211.93	71859.0
2025-06-25 04:00:00	DIA	ETF	431.04	431.04	430.6	430.6	1250.0
2025-06-25 05:00:00	DIA	ETF	431.04	431.05	430.73	430.73	930.0

> showing 50 of 24,762 rows — these rows as CSV

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