PREVIEW / etf_1hour / 2025-07-29

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-07-29.parquet
  size:    658 KB
  rows:    25,460

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-29 04:00:00	SPY	ETF	638.44	638.61	638.1	638.32	45301.0
2025-07-29 05:00:00	SPY	ETF	638.34	638.74	638.3	638.56	33831.0
2025-07-29 06:00:00	SPY	ETF	638.65	638.8	638.57	638.71	25848.0
2025-07-29 07:00:00	SPY	ETF	638.69	638.89	638.239	638.5	85977.0
2025-07-29 08:00:00	SPY	ETF	638.8	638.8683	637.82	638.12	174031.0
2025-07-29 09:00:00	SPY	ETF	638.11	638.67	637.24	637.93	4762589.0
2025-07-29 10:00:00	SPY	ETF	638.0	638.09	636.54	636.74	5878693.0
2025-07-29 11:00:00	SPY	ETF	636.72	637.01	634.69	635.885	7046335.0
2025-07-29 12:00:00	SPY	ETF	635.88	636.225	635.1	636.19	3947443.0
2025-07-29 13:00:00	SPY	ETF	636.19	636.56	634.94	635.61	4958224.0
2025-07-29 14:00:00	SPY	ETF	635.6	635.86	635.135	635.34	3849868.0
2025-07-29 15:00:00	SPY	ETF	635.32	635.61	634.335	635.24	10338406.0
2025-07-29 16:00:00	SPY	ETF	635.225	635.35	634.87	635.01	1940367.0
2025-07-29 17:00:00	SPY	ETF	634.99	635.16	634.95	635.06	167197.0
2025-07-29 18:00:00	SPY	ETF	635.13	635.46	635.06	635.43	132605.0
2025-07-29 19:00:00	SPY	ETF	635.4	635.5702	635.26	635.44	17492.0
2025-07-29 04:00:00	QQQ	ETF	570.59	570.71	570.05	570.44	50549.0
2025-07-29 05:00:00	QQQ	ETF	570.51	571.0	570.44	570.84	33924.0
2025-07-29 06:00:00	QQQ	ETF	570.9	571.07	570.75	570.89	32810.0
2025-07-29 07:00:00	QQQ	ETF	570.91	571.05	570.41	570.93	73817.0
2025-07-29 08:00:00	QQQ	ETF	570.49	571.2	568.566	570.42	188167.0
2025-07-29 09:00:00	QQQ	ETF	570.43	572.11	569.8	570.56	4642048.0
2025-07-29 10:00:00	QQQ	ETF	570.69	570.72	568.82	569.135	4891150.0
2025-07-29 11:00:00	QQQ	ETF	569.11	569.47	566.92	568.51	6324797.0
2025-07-29 12:00:00	QQQ	ETF	568.48	568.72	567.18	568.58	2500003.0
2025-07-29 13:00:00	QQQ	ETF	568.58	568.99	567.49	568.2207	2947201.0
2025-07-29 14:00:00	QQQ	ETF	568.21	568.56	567.675	567.9	1993681.0
2025-07-29 15:00:00	QQQ	ETF	567.89	568.08	566.53	567.33	6183538.0
2025-07-29 16:00:00	QQQ	ETF	567.33	567.8816	567.0	567.24	1261208.0
2025-07-29 17:00:00	QQQ	ETF	567.25	567.48	567.19	567.29	25699.0
2025-07-29 18:00:00	QQQ	ETF	567.28	567.79	567.25	567.71	89509.0
2025-07-29 19:00:00	QQQ	ETF	567.74	567.95	567.57	567.79	43569.0
2025-07-29 04:00:00	IWM	ETF	224.35	224.92	224.35	224.8	14467.0
2025-07-29 05:00:00	IWM	ETF	224.87	225.11	224.83	225.01	15078.0
2025-07-29 06:00:00	IWM	ETF	225.04	225.36	225.04	225.3	22660.0
2025-07-29 07:00:00	IWM	ETF	225.32	225.35	224.94	225.21	29347.0
2025-07-29 08:00:00	IWM	ETF	224.9	225.66	224.48	225.42	129380.0
2025-07-29 09:00:00	IWM	ETF	225.39	225.71	224.28	224.43	3486441.0
2025-07-29 10:00:00	IWM	ETF	224.46	224.78	223.66	223.75	2470941.0
2025-07-29 11:00:00	IWM	ETF	223.74	223.94	222.055	222.83	4618332.0
2025-07-29 12:00:00	IWM	ETF	222.82	223.08	222.36	223.06	2088058.0
2025-07-29 13:00:00	IWM	ETF	223.05	223.48	222.55	222.96	1971259.0
2025-07-29 14:00:00	IWM	ETF	222.96	223.285	222.84	223.23	1653852.0
2025-07-29 15:00:00	IWM	ETF	223.235	223.375	222.36	222.68	4823663.0
2025-07-29 16:00:00	IWM	ETF	222.69	222.95	222.58	222.92	921797.0
2025-07-29 17:00:00	IWM	ETF	222.78	222.86	222.66	222.74	38021.0
2025-07-29 18:00:00	IWM	ETF	222.75	223.0188	222.75	222.88	78915.0
2025-07-29 19:00:00	IWM	ETF	222.96	222.9688	222.78	222.84	18338.0
2025-07-29 04:00:00	DIA	ETF	448.88	449.1	448.88	448.93	3384.0
2025-07-29 05:00:00	DIA	ETF	448.97	449.49	447.91	448.81	67708.0

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

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