PREVIEW / etf_1hour / 2025-07-30

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-07-30.parquet
  size:    670 KB
  rows:    25,754

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-30 04:00:00	SPY	ETF	636.04	636.3	635.29	635.77	14890.0
2025-07-30 05:00:00	SPY	ETF	635.78	636.04	635.6	635.98	10437.0
2025-07-30 06:00:00	SPY	ETF	636.05	636.11	635.9	636.11	15790.0
2025-07-30 07:00:00	SPY	ETF	636.16	636.5	636.0	636.21	193872.0
2025-07-30 08:00:00	SPY	ETF	636.12	636.39	635.37	635.86	397419.0
2025-07-30 09:00:00	SPY	ETF	635.83	636.23	635.29	635.735	4374596.0
2025-07-30 10:00:00	SPY	ETF	635.735	636.82	635.39	636.24	4563893.0
2025-07-30 11:00:00	SPY	ETF	636.23	636.36	635.0	636.175	4242555.0
2025-07-30 12:00:00	SPY	ETF	636.16	636.72	635.99	636.46	3394734.0
2025-07-30 13:00:00	SPY	ETF	636.47	636.95	636.115	636.66	2733989.0
2025-07-30 14:00:00	SPY	ETF	636.705	637.68	632.59	632.84	10822957.0
2025-07-30 15:00:00	SPY	ETF	632.83	634.635	631.54	634.49	19489666.0
2025-07-30 16:00:00	SPY	ETF	634.5	638.16	634.09	637.28	3781465.0
2025-07-30 17:00:00	SPY	ETF	637.28	638.68	634.27	638.48	771406.0
2025-07-30 18:00:00	SPY	ETF	638.37	639.18	637.84	638.95	358630.0
2025-07-30 19:00:00	SPY	ETF	638.91	639.3	638.88	638.95	212677.0
2025-07-30 04:00:00	QQQ	ETF	568.44	568.71	567.65	568.05	21608.0
2025-07-30 05:00:00	QQQ	ETF	568.15	568.43	567.9	568.31	19863.0
2025-07-30 06:00:00	QQQ	ETF	568.4	568.65	568.24	568.63	35719.0
2025-07-30 07:00:00	QQQ	ETF	568.67	569.0	568.5	568.68	69934.0
2025-07-30 08:00:00	QQQ	ETF	568.65	568.98	566.835	568.28	261773.0
2025-07-30 09:00:00	QQQ	ETF	568.24	569.11	567.27	568.06	3299999.0
2025-07-30 10:00:00	QQQ	ETF	568.06	569.468	567.67	568.8493	2842695.0
2025-07-30 11:00:00	QQQ	ETF	568.835	569.21	567.875	569.2	2100051.0
2025-07-30 12:00:00	QQQ	ETF	569.195	569.6	568.9	569.3	1392936.0
2025-07-30 13:00:00	QQQ	ETF	569.31	569.705	569.05	569.46	1268260.0
2025-07-30 14:00:00	QQQ	ETF	569.44	570.62	566.07	566.39	7364923.0
2025-07-30 15:00:00	QQQ	ETF	566.36	568.27	565.05	568.1	10308558.0
2025-07-30 16:00:00	QQQ	ETF	568.12	573.05	567.8	572.3101	2800939.0
2025-07-30 17:00:00	QQQ	ETF	572.5	573.68	572.13	573.52	267474.0
2025-07-30 18:00:00	QQQ	ETF	573.59	574.11	573.1	574.08	244162.0
2025-07-30 19:00:00	QQQ	ETF	574.12	574.29	573.91	573.95	94914.0
2025-07-30 04:00:00	IWM	ETF	223.4	223.45	223.14	223.36	15392.0
2025-07-30 05:00:00	IWM	ETF	223.38	223.69	223.32	223.69	13861.0
2025-07-30 06:00:00	IWM	ETF	223.71	223.72	223.44	223.67	13663.0
2025-07-30 07:00:00	IWM	ETF	223.69	223.8	223.421	223.76	71268.0
2025-07-30 08:00:00	IWM	ETF	223.56	223.91	223.09	223.72	201156.0
2025-07-30 09:00:00	IWM	ETF	223.72	223.975	223.27	223.81	2958084.0
2025-07-30 10:00:00	IWM	ETF	223.82	224.47	223.56	224.38	2592362.0
2025-07-30 11:00:00	IWM	ETF	224.37	224.5368	223.585	223.98	2038414.0
2025-07-30 12:00:00	IWM	ETF	223.99	224.78	223.9	224.63	1734192.0
2025-07-30 13:00:00	IWM	ETF	224.63	224.931	224.43	224.59	2152201.0
2025-07-30 14:00:00	IWM	ETF	224.57	224.84	221.65	221.79	9487419.0
2025-07-30 15:00:00	IWM	ETF	221.78	221.91	220.12	221.58	15889165.0
2025-07-30 16:00:00	IWM	ETF	221.59	222.9957	220.05	220.12	2737425.0
2025-07-30 17:00:00	IWM	ETF	220.198	220.463	220.17	220.37	45568.0
2025-07-30 18:00:00	IWM	ETF	220.32	220.43	220.02	220.33	82218.0
2025-07-30 19:00:00	IWM	ETF	220.32	220.5	220.31	220.31	34041.0
2025-07-30 04:00:00	DIA	ETF	446.75	446.75	446.38	446.39	600.0
2025-07-30 05:00:00	DIA	ETF	446.44	446.59	446.44	446.59	400.0

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

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