PREVIEW / etf_1hour / 2025-07-17

all etf 1-hour files

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

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-17 04:00:00	SPY	ETF	624.4	624.7	624.24	624.69	23107.0
2025-07-17 05:00:00	SPY	ETF	624.59	625.02	624.59	624.64	20425.0
2025-07-17 06:00:00	SPY	ETF	624.68	624.74	624.25	624.3	43748.0
2025-07-17 07:00:00	SPY	ETF	624.3	624.34	623.75	623.87	65077.0
2025-07-17 08:00:00	SPY	ETF	624.01	625.41	623.27	625.34	346031.0
2025-07-17 09:00:00	SPY	ETF	625.34	626.1981	624.18	625.78	5198061.0
2025-07-17 10:00:00	SPY	ETF	625.79	626.23	624.84	625.812	6014130.0
2025-07-17 11:00:00	SPY	ETF	625.815	627.27	625.79	627.2147	5959429.0
2025-07-17 12:00:00	SPY	ETF	627.21	627.51	626.525	626.83	4295178.0
2025-07-17 13:00:00	SPY	ETF	626.83	627.46	626.665	627.4301	3680598.0
2025-07-17 14:00:00	SPY	ETF	627.44	628.14	627.14	627.965	4867861.0
2025-07-17 15:00:00	SPY	ETF	627.97	628.4048	627.65	627.98	14860211.0
2025-07-17 16:00:00	SPY	ETF	627.98	628.32	627.6144	628.0	2527761.0
2025-07-17 17:00:00	SPY	ETF	628.01	628.05	627.8	628.05	54920.0
2025-07-17 18:00:00	SPY	ETF	628.05	628.19	627.77	628.02	50022.0
2025-07-17 19:00:00	SPY	ETF	628.19	628.8502	628.07	628.71	44551.0
2025-07-17 04:00:00	QQQ	ETF	557.62	558.43	557.62	558.23	26946.0
2025-07-17 05:00:00	QQQ	ETF	558.17	558.66	558.17	558.27	12995.0
2025-07-17 06:00:00	QQQ	ETF	558.28	558.38	557.78	557.86	33681.0
2025-07-17 07:00:00	QQQ	ETF	557.81	557.95	557.41	557.74	35666.0
2025-07-17 08:00:00	QQQ	ETF	557.7	559.2	556.38	559.13	268540.0
2025-07-17 09:00:00	QQQ	ETF	559.12	559.42	557.21	559.2	3735921.0
2025-07-17 10:00:00	QQQ	ETF	559.22	560.37	558.39	560.2625	4226244.0
2025-07-17 11:00:00	QQQ	ETF	560.27	561.68	560.245	561.58	3891305.0
2025-07-17 12:00:00	QQQ	ETF	561.58	562.21	561.48	561.775	2957435.0
2025-07-17 13:00:00	QQQ	ETF	561.78	562.235	561.21	562.23	2244878.0
2025-07-17 14:00:00	QQQ	ETF	562.235	562.31	561.3	561.66	3136075.0
2025-07-17 15:00:00	QQQ	ETF	561.67	562.28	561.49	561.8	5658282.0
2025-07-17 16:00:00	QQQ	ETF	561.83	562.21	561.26	561.97	1691336.0
2025-07-17 17:00:00	QQQ	ETF	561.95	561.99	561.65	561.85	45491.0
2025-07-17 18:00:00	QQQ	ETF	561.82	561.84	561.5	561.72	72913.0
2025-07-17 19:00:00	QQQ	ETF	561.8	562.5	561.79	562.37	158646.0
2025-07-17 04:00:00	IWM	ETF	220.64	220.78	220.48	220.74	24829.0
2025-07-17 05:00:00	IWM	ETF	220.75	220.87	220.56	220.64	7803.0
2025-07-17 06:00:00	IWM	ETF	220.56	220.59	220.28	220.46	29657.0
2025-07-17 07:00:00	IWM	ETF	220.34	220.43	219.97	220.12	49117.0
2025-07-17 08:00:00	IWM	ETF	220.08	221.2399	219.98	221.1	166928.0
2025-07-17 09:00:00	IWM	ETF	221.07	223.325	220.71	222.71	3281065.0
2025-07-17 10:00:00	IWM	ETF	222.72	223.7	222.39	222.79	4977528.0
2025-07-17 11:00:00	IWM	ETF	222.795	223.98	222.6435	223.89	3344854.0
2025-07-17 12:00:00	IWM	ETF	223.9	223.91	222.9	223.19	3196948.0
2025-07-17 13:00:00	IWM	ETF	223.18	223.43	222.82	223.36	2288721.0
2025-07-17 14:00:00	IWM	ETF	223.37	223.73	223.09	223.71	2599705.0
2025-07-17 15:00:00	IWM	ETF	223.71	224.2	223.57	223.87	6277842.0
2025-07-17 16:00:00	IWM	ETF	223.92	224.0	223.71	223.9	1891242.0
2025-07-17 17:00:00	IWM	ETF	223.91	223.99	223.625	223.625	5851.0
2025-07-17 18:00:00	IWM	ETF	223.82	224.1385	223.82	224.09	31542.0
2025-07-17 19:00:00	IWM	ETF	224.07	224.48	224.06	224.41	24257.0
2025-07-17 04:00:00	DIA	ETF	442.0	442.15	441.8	442.04	16250.0
2025-07-17 05:00:00	DIA	ETF	442.03	442.42	442.03	442.14	7550.0

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

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