PREVIEW / etf_1hour / 2025-07-28

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-07-28.parquet
  size:    670 KB
  rows:    26,001

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-28 04:00:00	SPY	ETF	639.24	639.33	639.02	639.04	56153.0
2025-07-28 05:00:00	SPY	ETF	639.09	639.17	638.66	638.66	21635.0
2025-07-28 06:00:00	SPY	ETF	638.75	638.85	638.02	638.21	48015.0
2025-07-28 07:00:00	SPY	ETF	638.15	638.39	638.08	638.26	98406.0
2025-07-28 08:00:00	SPY	ETF	638.3	640.26	638.01	638.51	387951.0
2025-07-28 09:00:00	SPY	ETF	638.54	638.54	637.08	637.45	5700100.0
2025-07-28 10:00:00	SPY	ETF	637.44	638.04	637.24	637.4353	5485525.0
2025-07-28 11:00:00	SPY	ETF	637.44	637.57	636.33	637.39	4440233.0
2025-07-28 12:00:00	SPY	ETF	637.38	637.65	636.7501	636.885	2957667.0
2025-07-28 13:00:00	SPY	ETF	636.8896	637.145	636.065	636.11	3599703.0
2025-07-28 14:00:00	SPY	ETF	636.1	636.29	635.54	636.08	5392138.0
2025-07-28 15:00:00	SPY	ETF	636.07	637.02	635.69	636.92	8160162.0
2025-07-28 16:00:00	SPY	ETF	636.9	637.15	636.79	637.01	2200171.0
2025-07-28 17:00:00	SPY	ETF	636.94	637.04	636.9	637.04	25475.0
2025-07-28 18:00:00	SPY	ETF	637.0	637.45	637.0	637.43	34440.0
2025-07-28 19:00:00	SPY	ETF	637.45	637.45	637.21	637.38	24368.0
2025-07-28 04:00:00	QQQ	ETF	569.88	569.88	569.19	569.31	62262.0
2025-07-28 05:00:00	QQQ	ETF	569.3	569.41	568.97	569.06	27790.0
2025-07-28 06:00:00	QQQ	ETF	569.04	569.06	568.08	568.3	36257.0
2025-07-28 07:00:00	QQQ	ETF	568.23	568.61	568.2	568.49	39668.0
2025-07-28 08:00:00	QQQ	ETF	568.53	570.38	565.946	568.69	191641.0
2025-07-28 09:00:00	QQQ	ETF	568.73	568.88	567.54	568.86	3770564.0
2025-07-28 10:00:00	QQQ	ETF	568.86	569.04	567.81	568.235	3507804.0
2025-07-28 11:00:00	QQQ	ETF	568.23	568.39	566.87	568.245	2975608.0
2025-07-28 12:00:00	QQQ	ETF	568.25	568.57	567.77	568.04	2045467.0
2025-07-28 13:00:00	QQQ	ETF	568.05	568.1	567.3	567.445	1866360.0
2025-07-28 14:00:00	QQQ	ETF	567.44	567.67	566.96	567.4701	2529774.0
2025-07-28 15:00:00	QQQ	ETF	567.46	568.29	567.18	568.2	4399806.0
2025-07-28 16:00:00	QQQ	ETF	568.2	568.71	568.12	568.61	1452326.0
2025-07-28 17:00:00	QQQ	ETF	568.6	568.68	568.4019	568.45	20628.0
2025-07-28 18:00:00	QQQ	ETF	568.57	569.07	568.56	569.02	47678.0
2025-07-28 19:00:00	QQQ	ETF	569.041	569.08	568.8101	569.07	26326.0
2025-07-28 04:00:00	IWM	ETF	225.9	225.9	224.9	225.75	24801.0
2025-07-28 05:00:00	IWM	ETF	225.74	225.8	225.59	225.65	8450.0
2025-07-28 06:00:00	IWM	ETF	225.64	225.66	225.13	225.32	17181.0
2025-07-28 07:00:00	IWM	ETF	225.28	225.33	224.99	225.3	51774.0
2025-07-28 08:00:00	IWM	ETF	225.26	226.56	225.06	225.88	92419.0
2025-07-28 09:00:00	IWM	ETF	225.91	225.93	223.83	224.02	3546248.0
2025-07-28 10:00:00	IWM	ETF	224.01	224.74	223.89	224.315	2914413.0
2025-07-28 11:00:00	IWM	ETF	224.3	224.38	223.64	224.32	1655341.0
2025-07-28 12:00:00	IWM	ETF	224.305	224.685	224.025	224.15	1450395.0
2025-07-28 13:00:00	IWM	ETF	224.15	224.33	223.73	223.78	1287957.0
2025-07-28 14:00:00	IWM	ETF	223.78	224.13	223.43	224.03	1546134.0
2025-07-28 15:00:00	IWM	ETF	224.03	224.235	223.77	224.16	5114263.0
2025-07-28 16:00:00	IWM	ETF	224.16	224.4	223.94	224.15	1337425.0
2025-07-28 17:00:00	IWM	ETF	223.99	224.11	223.92	223.97	11556.0
2025-07-28 18:00:00	IWM	ETF	224.1	224.29	224.1	224.24	16222.0
2025-07-28 19:00:00	IWM	ETF	224.2	224.22	224.12	224.2	8215.0
2025-07-28 04:00:00	DIA	ETF	450.21	450.21	449.92	449.99	2067.0
2025-07-28 05:00:00	DIA	ETF	449.95	449.97	449.72	449.76	2500.0

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

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