PREVIEW / etf_1hour / 2025-09-03

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-09-03.parquet
  size:    675 KB
  rows:    26,028

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-09-03 04:00:00	SPY	ETF	641.97	643.18	641.97	642.89	56064.0
2025-09-03 05:00:00	SPY	ETF	642.99	643.5	642.5	643.27	44889.0
2025-09-03 06:00:00	SPY	ETF	643.35	643.62	643.06	643.5	85015.0
2025-09-03 07:00:00	SPY	ETF	643.47	643.75	642.62	642.7	209563.0
2025-09-03 08:00:00	SPY	ETF	642.76	643.75	640.5	642.39	585615.0
2025-09-03 09:00:00	SPY	ETF	642.39	643.23	641.83	641.94	7091443.0
2025-09-03 10:00:00	SPY	ETF	642.0	644.16	641.59	643.97	7774339.0
2025-09-03 11:00:00	SPY	ETF	643.98	644.21	642.12	642.375	5744689.0
2025-09-03 12:00:00	SPY	ETF	642.37	643.125	641.43	641.82	4303408.0
2025-09-03 13:00:00	SPY	ETF	641.82	642.85	640.625	640.978	4579965.0
2025-09-03 14:00:00	SPY	ETF	640.98	641.29	640.46	640.885	4836632.0
2025-09-03 15:00:00	SPY	ETF	640.88	643.73	640.56	643.64	13183949.0
2025-09-03 16:00:00	SPY	ETF	643.64	644.05	643.56	643.79	3361638.0
2025-09-03 17:00:00	SPY	ETF	643.76	643.79	643.7	643.73	64416.0
2025-09-03 18:00:00	SPY	ETF	643.74	643.74	643.32	643.32	47656.0
2025-09-03 19:00:00	SPY	ETF	643.42	643.709	643.28	643.38	21439.0
2025-09-03 04:00:00	QQQ	ETF	568.13	569.44	567.93	569.18	95906.0
2025-09-03 05:00:00	QQQ	ETF	569.29	569.75	568.71	569.62	39496.0
2025-09-03 06:00:00	QQQ	ETF	569.61	569.84	569.29	569.71	68926.0
2025-09-03 07:00:00	QQQ	ETF	569.69	570.08	568.92	569.1	265259.0
2025-09-03 08:00:00	QQQ	ETF	569.14	570.0403	566.044	569.27	382617.0
2025-09-03 09:00:00	QQQ	ETF	569.27	570.06	567.98	568.28	5497810.0
2025-09-03 10:00:00	QQQ	ETF	568.27	571.695	568.06	571.32	6958242.0
2025-09-03 11:00:00	QQQ	ETF	571.31	571.49	568.78	569.0866	5513097.0
2025-09-03 12:00:00	QQQ	ETF	569.07	570.2436	568.49	568.96	3788020.0
2025-09-03 13:00:00	QQQ	ETF	568.97	570.18	567.43	567.85	4016899.0
2025-09-03 14:00:00	QQQ	ETF	567.86	567.87	566.725	567.3	4229113.0
2025-09-03 15:00:00	QQQ	ETF	567.3	570.07	567.03	569.99	7440186.0
2025-09-03 16:00:00	QQQ	ETF	569.99	570.4164	569.1382	570.01	1757113.0
2025-09-03 17:00:00	QQQ	ETF	570.02	570.15	569.9	569.91	23590.0
2025-09-03 18:00:00	QQQ	ETF	570.01	570.07	569.55	569.5515	79864.0
2025-09-03 19:00:00	QQQ	ETF	569.63	570.0682	569.51	569.65	22953.0
2025-09-03 04:00:00	IWM	ETF	233.02	233.57	233.02	233.46	32697.0
2025-09-03 05:00:00	IWM	ETF	233.51	233.76	233.36	233.62	21587.0
2025-09-03 06:00:00	IWM	ETF	233.68	233.74	233.3	233.61	25085.0
2025-09-03 07:00:00	IWM	ETF	233.63	233.71	233.34	233.4	91709.0
2025-09-03 08:00:00	IWM	ETF	233.57	233.8099	232.2	233.19	343705.0
2025-09-03 09:00:00	IWM	ETF	233.22	235.26	233.1	234.37	3832110.0
2025-09-03 10:00:00	IWM	ETF	234.36	234.8	233.89	234.39	3427037.0
2025-09-03 11:00:00	IWM	ETF	234.385	234.41	233.16	233.31	3690636.0
2025-09-03 12:00:00	IWM	ETF	233.3	233.57	232.97	233.255	2699940.0
2025-09-03 13:00:00	IWM	ETF	233.26	233.6922	232.525	232.675	3320315.0
2025-09-03 14:00:00	IWM	ETF	232.68	233.225	232.46	232.94	2972864.0
2025-09-03 15:00:00	IWM	ETF	232.93	233.91	232.595	233.69	4955011.0
2025-09-03 16:00:00	IWM	ETF	233.67	234.17	233.67	234.08	1112112.0
2025-09-03 17:00:00	IWM	ETF	234.07	234.08	233.82	233.91	13569.0
2025-09-03 18:00:00	IWM	ETF	233.98	233.98	233.73	233.8	47048.0
2025-09-03 19:00:00	IWM	ETF	233.8	234.0	233.76	233.85	9296.0
2025-09-03 04:00:00	DIA	ETF	453.16	453.76	453.16	453.27	3950.0
2025-09-03 05:00:00	DIA	ETF	453.54	453.54	453.5	453.54	350.0

> showing 50 of 26,028 rows — these rows as CSV

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