PREVIEW / etf_1hour / 2025-08-08

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-08-08.parquet
  size:    654 KB
  rows:    25,043

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-08-08 04:00:00	SPY	ETF	633.56	634.08	633.51	633.87	26899.0
2025-08-08 05:00:00	SPY	ETF	633.83	634.32	633.82	634.16	14033.0
2025-08-08 06:00:00	SPY	ETF	634.24	634.48	634.2	634.38	13444.0
2025-08-08 07:00:00	SPY	ETF	634.37	634.73	634.24	634.66	191550.0
2025-08-08 08:00:00	SPY	ETF	634.26	634.74	633.0	633.74	237917.0
2025-08-08 09:00:00	SPY	ETF	633.75	635.9	631.3	635.8492	5632035.0
2025-08-08 10:00:00	SPY	ETF	635.85	637.04	635.7	635.8028	7480978.0
2025-08-08 11:00:00	SPY	ETF	635.81	636.48	634.86	636.36	5404064.0
2025-08-08 12:00:00	SPY	ETF	636.35	637.36	636.28	636.55	4105686.0
2025-08-08 13:00:00	SPY	ETF	636.56	637.33	636.125	637.19	3328375.0
2025-08-08 14:00:00	SPY	ETF	637.228	637.645	636.94	637.26	4257136.0
2025-08-08 15:00:00	SPY	ETF	637.26	637.625	636.05	637.14	10625211.0
2025-08-08 16:00:00	SPY	ETF	637.12	638.3	632.1468	638.22	4457979.0
2025-08-08 17:00:00	SPY	ETF	638.2	638.28	638.01	638.16	51123.0
2025-08-08 18:00:00	SPY	ETF	638.17	638.6	638.17	638.48	104855.0
2025-08-08 19:00:00	SPY	ETF	638.44	638.6	638.3501	638.6	34680.0
2025-08-08 04:00:00	QQQ	ETF	573.0	573.0	570.15	570.78	21127.0
2025-08-08 05:00:00	QQQ	ETF	570.84	571.31	570.73	570.94	11420.0
2025-08-08 06:00:00	QQQ	ETF	571.01	571.25	570.96	571.04	18300.0
2025-08-08 07:00:00	QQQ	ETF	571.09	571.42	570.95	571.27	50737.0
2025-08-08 08:00:00	QQQ	ETF	571.0	571.41	568.814	570.22	234697.0
2025-08-08 09:00:00	QQQ	ETF	570.29	572.98	569.98	572.835	3455463.0
2025-08-08 10:00:00	QQQ	ETF	572.85	574.26	572.43	573.0594	5223081.0
2025-08-08 11:00:00	QQQ	ETF	573.07	573.77	572.11	573.74	3148813.0
2025-08-08 12:00:00	QQQ	ETF	573.74	574.34	573.6	573.64	2228801.0
2025-08-08 13:00:00	QQQ	ETF	573.63	574.275	573.1319	574.2	1935387.0
2025-08-08 14:00:00	QQQ	ETF	574.23	574.77	573.97	574.48	2183352.0
2025-08-08 15:00:00	QQQ	ETF	574.461	574.71	573.67	574.55	5195140.0
2025-08-08 16:00:00	QQQ	ETF	574.56	575.83	574.53	575.8	1839212.0
2025-08-08 17:00:00	QQQ	ETF	575.83	575.92	575.65	575.76	87252.0
2025-08-08 18:00:00	QQQ	ETF	575.76	575.76	575.62	575.7	14660.0
2025-08-08 19:00:00	QQQ	ETF	575.66	575.9955	575.65	575.9955	22594.0
2025-08-08 04:00:00	IWM	ETF	220.75	220.93	220.69	220.8	26520.0
2025-08-08 05:00:00	IWM	ETF	220.74	221.15	220.68	221.12	16824.0
2025-08-08 06:00:00	IWM	ETF	221.2	221.36	221.15	221.23	13032.0
2025-08-08 07:00:00	IWM	ETF	221.23	221.5	221.11	221.45	99818.0
2025-08-08 08:00:00	IWM	ETF	221.23	221.59	220.43	221.1	266973.0
2025-08-08 09:00:00	IWM	ETF	221.12	221.23	220.15	220.48	3680369.0
2025-08-08 10:00:00	IWM	ETF	220.51	221.57	220.47	220.54	4342617.0
2025-08-08 11:00:00	IWM	ETF	220.545	220.645	219.74	220.41	2809659.0
2025-08-08 12:00:00	IWM	ETF	220.41	221.355	220.255	220.33	2229233.0
2025-08-08 13:00:00	IWM	ETF	220.335	220.79	220.09	220.555	1986683.0
2025-08-08 14:00:00	IWM	ETF	220.57	220.79	220.27	220.62	1976967.0
2025-08-08 15:00:00	IWM	ETF	220.61	220.79	219.905	220.34	4771477.0
2025-08-08 16:00:00	IWM	ETF	220.32	221.13	220.3	221.05	734243.0
2025-08-08 17:00:00	IWM	ETF	220.99	221.2	220.74	221.07	24564.0
2025-08-08 18:00:00	IWM	ETF	221.02	221.09	220.92	220.9214	6123.0
2025-08-08 19:00:00	IWM	ETF	220.99	221.1391	220.8	221.04	10838.0
2025-08-08 04:00:00	DIA	ETF	440.41	440.58	440.41	440.58	7258.0
2025-08-08 05:00:00	DIA	ETF	440.43	440.71	440.43	440.71	800.0

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

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