PREVIEW / etf_1hour / 2025-02-05

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-02-05.parquet
  size:    626 KB
  rows:    23,704

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-02-05 04:00:00	SPY	ETF	598.43	599.18	597.7	597.78	35599.0
2025-02-05 05:00:00	SPY	ETF	597.66	598.74	597.66	598.64	12248.0
2025-02-05 06:00:00	SPY	ETF	598.7	599.28	598.7	599.22	17606.0
2025-02-05 07:00:00	SPY	ETF	599.18	599.52	598.79	599.48	78620.0
2025-02-05 08:00:00	SPY	ETF	598.96	600.49	598.36	599.9906	206819.0
2025-02-05 09:00:00	SPY	ETF	600.0	601.09	599.47	600.12	2422759.0
2025-02-05 10:00:00	SPY	ETF	600.12	601.1	598.58	600.585	3470160.0
2025-02-05 11:00:00	SPY	ETF	600.57	602.88	600.135	602.65	3036188.0
2025-02-05 12:00:00	SPY	ETF	602.64	603.17	602.32	602.67	1612517.0
2025-02-05 13:00:00	SPY	ETF	602.675	603.4	602.21	602.93	1135550.0
2025-02-05 14:00:00	SPY	ETF	602.92	603.635	602.88	603.0699	1567806.0
2025-02-05 15:00:00	SPY	ETF	603.07	604.37	602.91	604.17	5011703.0
2025-02-05 16:00:00	SPY	ETF	604.15	604.72	602.0031	604.52	2641164.0
2025-02-05 17:00:00	SPY	ETF	604.57	604.65	604.35	604.45	55831.0
2025-02-05 18:00:00	SPY	ETF	604.45	604.56	604.26	604.5	39595.0
2025-02-05 19:00:00	SPY	ETF	604.54	605.07	604.54	604.74	51115.0
2025-02-05 04:00:00	QQQ	ETF	519.82	520.65	519.01	519.1	75611.0
2025-02-05 05:00:00	QQQ	ETF	518.98	520.1	518.89	520.06	29036.0
2025-02-05 06:00:00	QQQ	ETF	520.03	520.5	520.0	520.42	71753.0
2025-02-05 07:00:00	QQQ	ETF	520.45	520.9	519.88	520.86	96296.0
2025-02-05 08:00:00	QQQ	ETF	520.4	524.077	519.163	521.26	282733.0
2025-02-05 09:00:00	QQQ	ETF	521.28	522.73	520.83	522.1	3125308.0
2025-02-05 10:00:00	QQQ	ETF	522.26	523.25	520.62	522.7648	2654754.0
2025-02-05 11:00:00	QQQ	ETF	522.75	525.81	522.1	525.595	2267434.0
2025-02-05 12:00:00	QQQ	ETF	525.64	526.36	525.0	525.47	1484307.0
2025-02-05 13:00:00	QQQ	ETF	525.515	525.9	524.7	525.63	835188.0
2025-02-05 14:00:00	QQQ	ETF	525.6	526.23	525.445	525.5702	859444.0
2025-02-05 15:00:00	QQQ	ETF	525.56	527.01	525.11	526.85	2505327.0
2025-02-05 16:00:00	QQQ	ETF	526.85	527.63	526.55	527.05	964688.0
2025-02-05 17:00:00	QQQ	ETF	527.2	527.27	526.7	526.7	45625.0
2025-02-05 18:00:00	QQQ	ETF	526.75	527.1407	526.58	527.1	47809.0
2025-02-05 19:00:00	QQQ	ETF	527.1201	527.68	526.96	527.18	72899.0
2025-02-05 04:00:00	IWM	ETF	226.93	227.36	226.76	226.76	15892.0
2025-02-05 05:00:00	IWM	ETF	226.71	227.39	226.71	227.37	6065.0
2025-02-05 06:00:00	IWM	ETF	227.39	227.6	227.29	227.58	14863.0
2025-02-05 07:00:00	IWM	ETF	227.42	227.5	227.18	227.27	87066.0
2025-02-05 08:00:00	IWM	ETF	227.25	227.5	226.8	227.319	152296.0
2025-02-05 09:00:00	IWM	ETF	227.28	228.36	227.19	227.68	1411723.0
2025-02-05 10:00:00	IWM	ETF	227.71	228.6299	226.8893	228.51	2517968.0
2025-02-05 11:00:00	IWM	ETF	228.5	229.12	228.18	229.1	1164455.0
2025-02-05 12:00:00	IWM	ETF	229.09	229.33	228.89	228.99	951488.0
2025-02-05 13:00:00	IWM	ETF	228.99	229.2999	228.732	229.04	701849.0
2025-02-05 14:00:00	IWM	ETF	229.03	229.34	228.95	228.97	962363.0
2025-02-05 15:00:00	IWM	ETF	228.965	229.5	228.805	229.44	2457855.0
2025-02-05 16:00:00	IWM	ETF	229.4	229.8	229.31	229.74	1081445.0
2025-02-05 17:00:00	IWM	ETF	229.73	229.77	229.5505	229.67	11674.0
2025-02-05 18:00:00	IWM	ETF	229.66	229.9189	229.56	229.82	20878.0
2025-02-05 19:00:00	IWM	ETF	229.87	230.17	229.78	229.83	38142.0
2025-02-05 04:00:00	DIA	ETF	444.65	444.92	444.2	444.2	1784.0
2025-02-05 05:00:00	DIA	ETF	444.0	444.82	444.0	444.7	2212.0

> showing 50 of 23,704 rows — these rows as CSV

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