PREVIEW / etf_1hour / 2025-01-10

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-01-10.parquet
  size:    640 KB
  rows:    24,770

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-01-10 04:00:00	SPY	ETF	588.11	588.29	587.37	587.79	33133.0
2025-01-10 05:00:00	SPY	ETF	587.78	588.64	587.76	588.51	39955.0
2025-01-10 06:00:00	SPY	ETF	588.43	589.61	588.43	588.61	128214.0
2025-01-10 07:00:00	SPY	ETF	588.57	588.84	587.48	588.82	105344.0
2025-01-10 08:00:00	SPY	ETF	588.8	589.3404	582.44	584.2	1788647.0
2025-01-10 09:00:00	SPY	ETF	583.99	585.96	582.28	582.98	5607828.0
2025-01-10 10:00:00	SPY	ETF	582.39	583.2288	579.15	581.1	10690236.0
2025-01-10 11:00:00	SPY	ETF	581.1	581.37	578.78	579.095	4895420.0
2025-01-10 12:00:00	SPY	ETF	579.12	581.71	578.55	581.56	3525911.0
2025-01-10 13:00:00	SPY	ETF	581.55	584.5	580.98	584.42	3769238.0
2025-01-10 14:00:00	SPY	ETF	584.435	584.46	581.23	582.1	4775015.0
2025-01-10 15:00:00	SPY	ETF	582.09	582.37	579.7	580.51	9962606.0
2025-01-10 16:00:00	SPY	ETF	580.52	580.86	579.75	580.03	3408844.0
2025-01-10 17:00:00	SPY	ETF	580.03	580.1	579.79	579.95	101884.0
2025-01-10 18:00:00	SPY	ETF	579.98	580.03	579.68	579.9	29940.0
2025-01-10 19:00:00	SPY	ETF	579.85	579.94	579.66	579.7817	8728.0
2025-01-10 04:00:00	QQQ	ETF	513.62	513.73	512.85	513.43	32388.0
2025-01-10 05:00:00	QQQ	ETF	513.63	514.56	513.36	514.45	34163.0
2025-01-10 06:00:00	QQQ	ETF	514.55	515.77	514.43	514.43	69622.0
2025-01-10 07:00:00	QQQ	ETF	514.43	514.59	513.06	514.42	112068.0
2025-01-10 08:00:00	QQQ	ETF	514.52	515.656	508.0	509.72	900322.0
2025-01-10 09:00:00	QQQ	ETF	509.59	511.58	507.1504	508.35	4725777.0
2025-01-10 10:00:00	QQQ	ETF	508.26	509.86	503.92	506.68	6613397.0
2025-01-10 11:00:00	QQQ	ETF	506.69	506.89	504.22	504.5	3045333.0
2025-01-10 12:00:00	QQQ	ETF	504.57	507.85	504.2	507.7306	2721887.0
2025-01-10 13:00:00	QQQ	ETF	507.71	511.1	507.07	510.94	2905607.0
2025-01-10 14:00:00	QQQ	ETF	510.9304	511.02	507.9206	508.95	2392021.0
2025-01-10 15:00:00	QQQ	ETF	508.95	509.26	506.45	507.21	4364684.0
2025-01-10 16:00:00	QQQ	ETF	507.22	507.65	506.59	506.759	1485059.0
2025-01-10 17:00:00	QQQ	ETF	506.7	507.19	506.66	506.75	510212.0
2025-01-10 18:00:00	QQQ	ETF	506.75	506.86	506.4659	506.63	27302.0
2025-01-10 19:00:00	QQQ	ETF	506.5976	506.6384	506.44	506.5799	11082.0
2025-01-10 04:00:00	IWM	ETF	220.72	220.75	220.28	220.51	21618.0
2025-01-10 05:00:00	IWM	ETF	220.57	221.11	220.47	221.05	27342.0
2025-01-10 06:00:00	IWM	ETF	221.25	221.61	221.25	221.52	44903.0
2025-01-10 07:00:00	IWM	ETF	221.53	221.71	221.13	221.66	51706.0
2025-01-10 08:00:00	IWM	ETF	221.4306	221.65	216.84	217.6	1435346.0
2025-01-10 09:00:00	IWM	ETF	217.55	218.71	216.9	217.99	4409905.0
2025-01-10 10:00:00	IWM	ETF	217.88	218.1083	215.92	216.82	5249864.0
2025-01-10 11:00:00	IWM	ETF	216.83	216.95	215.75	215.78	2709503.0
2025-01-10 12:00:00	IWM	ETF	215.81	216.7699	215.31	216.7	2430092.0
2025-01-10 13:00:00	IWM	ETF	216.69	217.28	216.36	217.135	2236912.0
2025-01-10 14:00:00	IWM	ETF	217.13	217.37	216.32	217.12	1564620.0
2025-01-10 15:00:00	IWM	ETF	217.11	217.19	216.22	216.88	4485951.0
2025-01-10 16:00:00	IWM	ETF	216.89	216.91	216.26	216.38	1697117.0
2025-01-10 17:00:00	IWM	ETF	216.37	216.48	216.32	216.36	16865.0
2025-01-10 18:00:00	IWM	ETF	216.36	216.39	216.07	216.315	27379.0
2025-01-10 19:00:00	IWM	ETF	216.2013	216.3568	216.07	216.175	5976.0
2025-01-10 04:00:00	DIA	ETF	426.13	426.13	425.24	425.46	4690.0
2025-01-10 05:00:00	DIA	ETF	425.94	425.94	425.94	425.94	100.0

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

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