PREVIEW / etf_1hour / 2025-06-11

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-06-11.parquet
  size:    627 KB
  rows:    24,746

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-11 04:00:00	SPY	ETF	601.89	602.68	601.8	602.38	98292.0
2025-06-11 05:00:00	SPY	ETF	602.45	602.49	601.81	601.81	20766.0
2025-06-11 06:00:00	SPY	ETF	601.82	602.34	601.73	602.2	61112.0
2025-06-11 07:00:00	SPY	ETF	602.23	602.5	601.13	602.32	82896.0
2025-06-11 08:00:00	SPY	ETF	602.33	606.4	600.99	604.54	2344041.0
2025-06-11 09:00:00	SPY	ETF	604.55	604.78	602.25	603.65	5785113.0
2025-06-11 10:00:00	SPY	ETF	603.66	605.06	603.3	604.7	5143315.0
2025-06-11 11:00:00	SPY	ETF	604.7	604.9879	603.23	603.58	4990589.0
2025-06-11 12:00:00	SPY	ETF	603.59	603.87	601.96	603.42	5911153.0
2025-06-11 13:00:00	SPY	ETF	603.405	604.445	602.36	602.507	4162761.0
2025-06-11 14:00:00	SPY	ETF	602.51	602.78	599.27	600.79	11880411.0
2025-06-11 15:00:00	SPY	ETF	600.82	601.59	599.73	601.4	11838769.0
2025-06-11 16:00:00	SPY	ETF	601.41	602.0	601.08	601.36	1901280.0
2025-06-11 17:00:00	SPY	ETF	601.35	602.9843	600.9	601.0696	224169.0
2025-06-11 18:00:00	SPY	ETF	600.92	601.71	600.21	600.4314	125438.0
2025-06-11 19:00:00	SPY	ETF	600.33	601.01	600.08	600.4895	130631.0
2025-06-11 04:00:00	QQQ	ETF	533.52	534.21	533.3	533.91	36141.0
2025-06-11 05:00:00	QQQ	ETF	533.85	533.92	533.12	533.12	45297.0
2025-06-11 06:00:00	QQQ	ETF	533.22	533.7	532.98	533.44	36906.0
2025-06-11 07:00:00	QQQ	ETF	533.44	533.71	532.37	533.51	63709.0
2025-06-11 08:00:00	QQQ	ETF	533.38	537.5	532.21	535.92	1253910.0
2025-06-11 09:00:00	QQQ	ETF	535.92	536.22	533.19	534.76	4652169.0
2025-06-11 10:00:00	QQQ	ETF	534.78	536.69	534.58	536.56	4603715.0
2025-06-11 11:00:00	QQQ	ETF	536.55	536.78	534.64	535.03	4470402.0
2025-06-11 12:00:00	QQQ	ETF	535.07	535.3393	532.97	534.64	4389368.0
2025-06-11 13:00:00	QQQ	ETF	534.64	535.61	533.02	533.17	3107330.0
2025-06-11 14:00:00	QQQ	ETF	533.14	533.48	530.11	531.8	8289239.0
2025-06-11 15:00:00	QQQ	ETF	531.81	532.55	530.92	532.45	7386475.0
2025-06-11 16:00:00	QQQ	ETF	532.45	532.97	532.05	532.26	993985.0
2025-06-11 17:00:00	QQQ	ETF	532.29	532.41	531.94	531.99	62828.0
2025-06-11 18:00:00	QQQ	ETF	531.93	532.53	531.0	531.18	104250.0
2025-06-11 19:00:00	QQQ	ETF	531.1	531.86	530.84	531.24	194382.0
2025-06-11 04:00:00	IWM	ETF	214.36	214.9	214.35	214.88	34401.0
2025-06-11 05:00:00	IWM	ETF	214.89	214.99	214.43	214.46	8674.0
2025-06-11 06:00:00	IWM	ETF	214.39	214.74	214.39	214.68	6134.0
2025-06-11 07:00:00	IWM	ETF	214.51	214.61	214.14	214.48	48621.0
2025-06-11 08:00:00	IWM	ETF	214.5	217.98	214.13	215.98	1305328.0
2025-06-11 09:00:00	IWM	ETF	216.0	216.29	214.58	215.08	3651018.0
2025-06-11 10:00:00	IWM	ETF	215.05	215.93	214.835	215.64	3400255.0
2025-06-11 11:00:00	IWM	ETF	215.62	215.89	214.965	215.07	2295937.0
2025-06-11 12:00:00	IWM	ETF	215.08	215.22	214.22	214.89	2007067.0
2025-06-11 13:00:00	IWM	ETF	214.89	215.545	214.85	214.92	2084165.0
2025-06-11 14:00:00	IWM	ETF	214.921	215.07	213.3	213.84	4008604.0
2025-06-11 15:00:00	IWM	ETF	213.86	213.99	213.32	213.64	5164006.0
2025-06-11 16:00:00	IWM	ETF	213.63	213.72	213.42	213.54	478319.0
2025-06-11 17:00:00	IWM	ETF	213.47	213.55	212.89	213.2	51780.0
2025-06-11 18:00:00	IWM	ETF	213.28	213.67	213.01	213.08	62334.0
2025-06-11 19:00:00	IWM	ETF	213.11	213.17	212.78	212.84	66873.0
2025-06-11 04:00:00	DIA	ETF	428.7	429.28	428.7	429.28	1250.0
2025-06-11 05:00:00	DIA	ETF	428.94	429.06	428.72	428.72	800.0

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

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