PREVIEW / etf_1hour / 2025-06-12

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-06-12.parquet
  size:    630 KB
  rows:    24,198

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-12 04:00:00	SPY	ETF	598.68	599.88	597.59	599.1	72267.0
2025-06-12 05:00:00	SPY	ETF	599.1	599.76	598.77	598.96	62547.0
2025-06-12 06:00:00	SPY	ETF	598.82	599.24	598.06	598.75	111870.0
2025-06-12 07:00:00	SPY	ETF	598.73	599.0	597.67	597.86	193090.0
2025-06-12 08:00:00	SPY	ETF	600.78	600.78	597.69	599.99	645520.0
2025-06-12 09:00:00	SPY	ETF	600.03	601.3995	599.52	600.7699	4929665.0
2025-06-12 10:00:00	SPY	ETF	600.76	603.13	600.61	602.6413	7056510.0
2025-06-12 11:00:00	SPY	ETF	602.65	603.62	601.54	602.47	7370284.0
2025-06-12 12:00:00	SPY	ETF	602.475	603.42	601.915	602.425	6002221.0
2025-06-12 13:00:00	SPY	ETF	602.45	603.5604	602.37	603.1108	3452163.0
2025-06-12 14:00:00	SPY	ETF	603.11	603.4286	602.42	603.33	4849187.0
2025-06-12 15:00:00	SPY	ETF	603.32	603.72	602.39	603.72	9935172.0
2025-06-12 16:00:00	SPY	ETF	603.7	603.75	602.86	602.94	2323551.0
2025-06-12 17:00:00	SPY	ETF	602.97	603.25	602.83	603.15	117751.0
2025-06-12 18:00:00	SPY	ETF	603.11	603.11	601.92	602.41	116943.0
2025-06-12 19:00:00	SPY	ETF	602.32	602.47	600.12	600.19	126872.0
2025-06-12 04:00:00	QQQ	ETF	529.73	530.45	528.3	530.35	55565.0
2025-06-12 05:00:00	QQQ	ETF	530.33	531.36	530.21	530.6	58361.0
2025-06-12 06:00:00	QQQ	ETF	530.4	530.85	529.51	530.46	101028.0
2025-06-12 07:00:00	QQQ	ETF	530.5	530.53	528.79	528.85	99835.0
2025-06-12 08:00:00	QQQ	ETF	530.94	531.73	528.63	531.39	356547.0
2025-06-12 09:00:00	QQQ	ETF	531.27	532.59	530.84	531.75	2471267.0
2025-06-12 10:00:00	QQQ	ETF	531.75	533.95	531.34	533.5929	3847424.0
2025-06-12 11:00:00	QQQ	ETF	533.6	534.6438	532.3501	533.32	3808459.0
2025-06-12 12:00:00	QQQ	ETF	533.32	534.42	532.83	533.33	3695026.0
2025-06-12 13:00:00	QQQ	ETF	533.36	534.41	533.22	533.66	2263485.0
2025-06-12 14:00:00	QQQ	ETF	533.66	533.98	532.82	533.66	2733522.0
2025-06-12 15:00:00	QQQ	ETF	533.66	534.05	532.6	533.66	3638772.0
2025-06-12 16:00:00	QQQ	ETF	533.68	533.89	532.99	532.99	977377.0
2025-06-12 17:00:00	QQQ	ETF	533.0	533.16	532.95	533.11	83797.0
2025-06-12 18:00:00	QQQ	ETF	533.0	533.0	531.94	532.33	35037.0
2025-06-12 19:00:00	QQQ	ETF	532.2	532.4987	530.04	530.07	97556.0
2025-06-12 04:00:00	IWM	ETF	211.68	212.24	211.19	212.17	53752.0
2025-06-12 05:00:00	IWM	ETF	212.16	212.27	211.81	211.83	35289.0
2025-06-12 06:00:00	IWM	ETF	211.78	212.22	211.72	211.89	110230.0
2025-06-12 07:00:00	IWM	ETF	211.87	211.95	211.2	211.21	74915.0
2025-06-12 08:00:00	IWM	ETF	211.82	212.6	211.1	212.1	205682.0
2025-06-12 09:00:00	IWM	ETF	212.12	212.42	211.63	211.95	3265526.0
2025-06-12 10:00:00	IWM	ETF	211.94	213.265	211.8311	212.81	3240947.0
2025-06-12 11:00:00	IWM	ETF	212.79	213.155	211.93	212.39	2815543.0
2025-06-12 12:00:00	IWM	ETF	212.4	212.78	212.085	212.57	2507146.0
2025-06-12 13:00:00	IWM	ETF	212.57	213.05	212.56	212.89	1613717.0
2025-06-12 14:00:00	IWM	ETF	212.89	213.0899	212.52	212.7711	1463145.0
2025-06-12 15:00:00	IWM	ETF	212.77	212.81	212.31	212.8	3516250.0
2025-06-12 16:00:00	IWM	ETF	212.78	212.84	212.4	212.4	627691.0
2025-06-12 17:00:00	IWM	ETF	212.48	212.59	212.41	212.49	5163.0
2025-06-12 18:00:00	IWM	ETF	212.51	212.51	212.01	212.19	15805.0
2025-06-12 19:00:00	IWM	ETF	212.1	212.22	211.12	211.2	16246.0
2025-06-12 04:00:00	DIA	ETF	427.3	427.49	427.19	427.29	821.0
2025-06-12 05:00:00	DIA	ETF	427.52	427.52	426.97	426.97	2050.0

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

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