PREVIEW / etf_1hour / 2025-06-10

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-06-10.parquet
  size:    634 KB
  rows:    24,526

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-06-10 04:00:00	SPY	ETF	599.83	599.83	598.34	599.45	62178.0
2025-06-10 05:00:00	SPY	ETF	599.46	599.97	599.33	599.81	29246.0
2025-06-10 06:00:00	SPY	ETF	599.76	600.31	599.76	600.15	28459.0
2025-06-10 07:00:00	SPY	ETF	600.17	600.5	599.36	600.5	79800.0
2025-06-10 08:00:00	SPY	ETF	600.0	602.13	597.83	600.48	216282.0
2025-06-10 09:00:00	SPY	ETF	600.49	601.13	600.05	600.57	4181430.0
2025-06-10 10:00:00	SPY	ETF	600.57	601.81	600.51	601.06	5170283.0
2025-06-10 11:00:00	SPY	ETF	601.07	601.49	599.09	601.27	7082269.0
2025-06-10 12:00:00	SPY	ETF	601.26	602.29	601.225	602.17	4311627.0
2025-06-10 13:00:00	SPY	ETF	602.17	602.67	601.27	601.32	4589545.0
2025-06-10 14:00:00	SPY	ETF	601.33	602.89	600.12	602.4009	7557351.0
2025-06-10 15:00:00	SPY	ETF	602.4	603.47	601.61	603.06	12559643.0
2025-06-10 16:00:00	SPY	ETF	603.05	603.08	602.21	602.64	2825657.0
2025-06-10 17:00:00	SPY	ETF	602.63	602.78	602.5	602.5	102786.0
2025-06-10 18:00:00	SPY	ETF	602.57	603.25	602.44	603.14	55416.0
2025-06-10 19:00:00	SPY	ETF	603.05	603.7	601.85	602.7	107273.0
2025-06-10 04:00:00	QQQ	ETF	534.04	534.04	529.41	530.56	43309.0
2025-06-10 05:00:00	QQQ	ETF	530.64	531.25	530.47	531.13	46973.0
2025-06-10 06:00:00	QQQ	ETF	531.24	531.66	531.0	531.23	62064.0
2025-06-10 07:00:00	QQQ	ETF	531.27	531.68	530.4	531.68	57077.0
2025-06-10 08:00:00	QQQ	ETF	531.33	533.5	528.96	531.68	230988.0
2025-06-10 09:00:00	QQQ	ETF	531.62	532.54	530.75	531.68	3809932.0
2025-06-10 10:00:00	QQQ	ETF	531.68	532.44	531.47	531.58	3153998.0
2025-06-10 11:00:00	QQQ	ETF	531.58	532.18	528.89	532.07	5061694.0
2025-06-10 12:00:00	QQQ	ETF	532.07	533.06	532.01	532.8901	3241783.0
2025-06-10 13:00:00	QQQ	ETF	532.91	533.41	531.9	532.02	3423076.0
2025-06-10 14:00:00	QQQ	ETF	532.03	534.31	530.78	533.8509	4222853.0
2025-06-10 15:00:00	QQQ	ETF	533.83	534.9	532.94	534.28	6761519.0
2025-06-10 16:00:00	QQQ	ETF	534.27	534.36	533.6	533.91	773101.0
2025-06-10 17:00:00	QQQ	ETF	533.92	534.03	533.9	533.92	18075.0
2025-06-10 18:00:00	QQQ	ETF	533.86	534.72	533.8	534.451	38188.0
2025-06-10 19:00:00	QQQ	ETF	534.42	535.02	533.07	533.97	121956.0
2025-06-10 04:00:00	IWM	ETF	214.21	214.21	213.02	213.54	14233.0
2025-06-10 05:00:00	IWM	ETF	213.57	213.84	213.57	213.76	7457.0
2025-06-10 06:00:00	IWM	ETF	213.76	214.02	213.76	213.98	21504.0
2025-06-10 07:00:00	IWM	ETF	213.98	214.229	213.78	214.19	44072.0
2025-06-10 08:00:00	IWM	ETF	214.04	214.66	213.12	214.32	113555.0
2025-06-10 09:00:00	IWM	ETF	214.3	214.64	213.98	214.54	2248596.0
2025-06-10 10:00:00	IWM	ETF	214.54	215.43	214.52	214.8	3981254.0
2025-06-10 11:00:00	IWM	ETF	214.8	215.09	214.2	214.7	3153764.0
2025-06-10 12:00:00	IWM	ETF	214.7	214.99	214.55	214.8925	1627270.0
2025-06-10 13:00:00	IWM	ETF	214.89	214.9235	214.22	214.235	2139419.0
2025-06-10 14:00:00	IWM	ETF	214.24	214.62	213.81	214.45	2906377.0
2025-06-10 15:00:00	IWM	ETF	214.45	214.835	214.0	214.51	4272969.0
2025-06-10 16:00:00	IWM	ETF	214.51	214.6	214.3	214.55	957143.0
2025-06-10 17:00:00	IWM	ETF	214.54	214.54	214.3	214.47	21458.0
2025-06-10 18:00:00	IWM	ETF	214.48	215.11	214.48	215.03	27753.0
2025-06-10 19:00:00	IWM	ETF	215.0	215.12	214.51	214.9	31531.0
2025-06-10 04:00:00	DIA	ETF	427.86	428.01	427.46	427.89	1500.0
2025-06-10 05:00:00	DIA	ETF	427.91	427.92	427.91	427.92	430.0

> showing 50 of 24,526 rows — these rows as CSV

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