PREVIEW / etf_1hour / 2025-07-01

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-07-01.parquet
  size:    663 KB
  rows:    25,866

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-07-01 04:00:00	SPY	ETF	617.03	617.46	616.67	617.12	97808.0
2025-07-01 05:00:00	SPY	ETF	617.2	617.21	616.41	616.95	36123.0
2025-07-01 06:00:00	SPY	ETF	617.0	617.08	616.67	616.97	13301.0
2025-07-01 07:00:00	SPY	ETF	616.96	617.14	616.56	616.91	87107.0
2025-07-01 08:00:00	SPY	ETF	616.94	617.51	615.52	616.22	292346.0
2025-07-01 09:00:00	SPY	ETF	616.22	617.74	616.05	617.27	4808477.0
2025-07-01 10:00:00	SPY	ETF	617.23	618.065	616.13	616.5011	8071007.0
2025-07-01 11:00:00	SPY	ETF	616.51	617.4901	615.52	616.94	7399753.0
2025-07-01 12:00:00	SPY	ETF	616.96	618.135	616.71	617.09	5500157.0
2025-07-01 13:00:00	SPY	ETF	617.09	618.83	617.0	618.5681	4496881.0
2025-07-01 14:00:00	SPY	ETF	618.57	618.6993	617.91	617.96	4869564.0
2025-07-01 15:00:00	SPY	ETF	617.95	618.72	616.7	617.56	13916956.0
2025-07-01 16:00:00	SPY	ETF	617.56	617.65	616.859	617.45	2169828.0
2025-07-01 17:00:00	SPY	ETF	617.45	617.6396	617.21	617.39	23564.0
2025-07-01 18:00:00	SPY	ETF	617.39	618.06	617.3	618.0	94040.0
2025-07-01 19:00:00	SPY	ETF	618.04	618.15	617.7684	617.929	69095.0
2025-07-01 04:00:00	QQQ	ETF	550.56	551.05	550.18	550.69	34869.0
2025-07-01 05:00:00	QQQ	ETF	550.76	550.83	550.0	550.46	43333.0
2025-07-01 06:00:00	QQQ	ETF	550.43	550.61	550.28	550.58	27932.0
2025-07-01 07:00:00	QQQ	ETF	550.6	550.79	549.91	550.36	43835.0
2025-07-01 08:00:00	QQQ	ETF	550.6	551.5	548.65	549.54	355935.0
2025-07-01 09:00:00	QQQ	ETF	549.65	550.46	549.14	549.93	3795721.0
2025-07-01 10:00:00	QQQ	ETF	549.76	550.71	546.6	546.92	8155305.0
2025-07-01 11:00:00	QQQ	ETF	546.91	547.63	544.66	546.22	7810399.0
2025-07-01 12:00:00	QQQ	ETF	546.23	548.14	545.58	547.23	3425681.0
2025-07-01 13:00:00	QQQ	ETF	547.24	548.69	547.23	548.205	2383272.0
2025-07-01 14:00:00	QQQ	ETF	548.22	548.49	547.21	547.24	2505594.0
2025-07-01 15:00:00	QQQ	ETF	547.23	548.4	545.92	546.98	8219984.0
2025-07-01 16:00:00	QQQ	ETF	546.99	547.14	546.5	547.0	975030.0
2025-07-01 17:00:00	QQQ	ETF	546.9699	546.97	546.6	546.65	14667.0
2025-07-01 18:00:00	QQQ	ETF	546.69	547.68	546.69	547.6273	59818.0
2025-07-01 19:00:00	QQQ	ETF	547.69	547.82	547.2376	547.36	57734.0
2025-07-01 04:00:00	IWM	ETF	215.59	215.8	215.39	215.58	9504.0
2025-07-01 05:00:00	IWM	ETF	215.54	215.58	215.17	215.28	9531.0
2025-07-01 06:00:00	IWM	ETF	215.26	215.45	214.94	215.13	26590.0
2025-07-01 07:00:00	IWM	ETF	215.15	215.28	214.99	215.18	48227.0
2025-07-01 08:00:00	IWM	ETF	215.1	215.58	214.43	214.62	105210.0
2025-07-01 09:00:00	IWM	ETF	214.65	215.63	214.1499	215.319	2684551.0
2025-07-01 10:00:00	IWM	ETF	215.25	215.965	215.13	215.57	3643104.0
2025-07-01 11:00:00	IWM	ETF	215.57	218.56	215.55	218.5501	6048437.0
2025-07-01 12:00:00	IWM	ETF	218.56	220.525	218.26	218.2699	6321924.0
2025-07-01 13:00:00	IWM	ETF	218.27	219.77	218.085	219.31	3013803.0
2025-07-01 14:00:00	IWM	ETF	219.31	219.35	218.75	218.9	3143467.0
2025-07-01 15:00:00	IWM	ETF	218.9	218.9	217.8	218.03	7102114.0
2025-07-01 16:00:00	IWM	ETF	218.03	218.12	217.85	218.03	1133265.0
2025-07-01 17:00:00	IWM	ETF	218.03	218.2378	217.87	218.02	17657.0
2025-07-01 18:00:00	IWM	ETF	218.02	218.49	218.02	218.49	8968.0
2025-07-01 19:00:00	IWM	ETF	218.47	218.52	218.31	218.47	21861.0
2025-07-01 04:00:00	DIA	ETF	440.24	440.66	440.24	440.5	1668.0
2025-07-01 05:00:00	DIA	ETF	440.5	440.5	440.12	440.21	1400.0

> showing 50 of 25,866 rows — these rows as CSV

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