PREVIEW / etf_1hour / 2025-07-07

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-07-07.parquet
  size:    675 KB
  rows:    26,512

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-07 04:00:00	SPY	ETF	623.38	623.38	620.0	622.63	47495.0
2025-07-07 05:00:00	SPY	ETF	622.5	623.76	622.47	623.76	43668.0
2025-07-07 06:00:00	SPY	ETF	623.68	624.22	623.6	623.62	48976.0
2025-07-07 07:00:00	SPY	ETF	623.6	624.21	623.6	624.19	92281.0
2025-07-07 08:00:00	SPY	ETF	624.14	624.59	622.45	623.43	245076.0
2025-07-07 09:00:00	SPY	ETF	623.43	624.03	622.88	623.6526	4108627.0
2025-07-07 10:00:00	SPY	ETF	623.65	623.795	621.96	622.1599	5389363.0
2025-07-07 11:00:00	SPY	ETF	622.16	622.39	621.18	621.74	4658769.0
2025-07-07 12:00:00	SPY	ETF	621.75	622.29	619.241	619.8006	10750561.0
2025-07-07 13:00:00	SPY	ETF	619.78	621.41	619.56	620.047	6200295.0
2025-07-07 14:00:00	SPY	ETF	620.04	620.3696	617.87	620.16	7540107.0
2025-07-07 15:00:00	SPY	ETF	620.15	621.0	619.375	620.78	13151987.0
2025-07-07 16:00:00	SPY	ETF	620.77	620.81	619.08	619.52	3527888.0
2025-07-07 17:00:00	SPY	ETF	619.53	619.78	618.818	619.45	145032.0
2025-07-07 18:00:00	SPY	ETF	619.45	619.8	618.75	619.4597	104642.0
2025-07-07 19:00:00	SPY	ETF	619.43	620.04	619.38	620.0	53500.0
2025-07-07 04:00:00	QQQ	ETF	553.88	553.99	552.7	552.84	42245.0
2025-07-07 05:00:00	QQQ	ETF	552.67	554.02	552.67	554.02	45361.0
2025-07-07 06:00:00	QQQ	ETF	553.99	554.54	553.9	553.95	38263.0
2025-07-07 07:00:00	QQQ	ETF	553.94	554.5	553.8	554.48	109984.0
2025-07-07 08:00:00	QQQ	ETF	554.41	556.637	552.77	553.73	291277.0
2025-07-07 09:00:00	QQQ	ETF	553.7	554.34	552.49	553.6	3838661.0
2025-07-07 10:00:00	QQQ	ETF	553.59	553.97	552.05	552.335	4010783.0
2025-07-07 11:00:00	QQQ	ETF	552.33	553.33	552.19	553.13	2724374.0
2025-07-07 12:00:00	QQQ	ETF	553.12	553.94	550.8281	551.72	6053896.0
2025-07-07 13:00:00	QQQ	ETF	551.71	553.1	551.16	551.76	3607867.0
2025-07-07 14:00:00	QQQ	ETF	551.745	551.99	549.58	551.87	5015094.0
2025-07-07 15:00:00	QQQ	ETF	551.87	552.23	551.03	552.06	5405211.0
2025-07-07 16:00:00	QQQ	ETF	552.02	552.11	550.59	550.97	1175967.0
2025-07-07 17:00:00	QQQ	ETF	550.99	551.03	550.62	550.81	45858.0
2025-07-07 18:00:00	QQQ	ETF	550.95	551.34	550.35	551.2193	153551.0
2025-07-07 19:00:00	QQQ	ETF	551.19	551.92	551.15	551.8	47514.0
2025-07-07 04:00:00	IWM	ETF	221.71	222.08	221.51	221.76	48025.0
2025-07-07 05:00:00	IWM	ETF	221.81	222.13	221.74	222.1	19739.0
2025-07-07 06:00:00	IWM	ETF	222.12	222.32	221.88	221.92	16983.0
2025-07-07 07:00:00	IWM	ETF	221.89	222.3	221.89	222.15	139988.0
2025-07-07 08:00:00	IWM	ETF	221.91	222.38	221.45	221.62	114638.0
2025-07-07 09:00:00	IWM	ETF	221.66	222.23	221.05	222.2	4030281.0
2025-07-07 10:00:00	IWM	ETF	222.17	222.82	221.03	221.09	5382158.0
2025-07-07 11:00:00	IWM	ETF	221.09	221.31	220.29	220.75	3937850.0
2025-07-07 12:00:00	IWM	ETF	220.75	221.19	219.33	219.525	4107156.0
2025-07-07 13:00:00	IWM	ETF	219.525	220.69	219.48	219.975	3025005.0
2025-07-07 14:00:00	IWM	ETF	219.97	220.08	218.41	219.8832	3111465.0
2025-07-07 15:00:00	IWM	ETF	219.88	219.97	219.27	219.775	5244229.0
2025-07-07 16:00:00	IWM	ETF	219.73	219.79	218.99	219.37	1384219.0
2025-07-07 17:00:00	IWM	ETF	219.36	219.5	219.02	219.3	8051.0
2025-07-07 18:00:00	IWM	ETF	219.29	219.3	218.8	219.11	22068.0
2025-07-07 19:00:00	IWM	ETF	219.1	219.61	219.1	219.6	16626.0
2025-07-07 04:00:00	DIA	ETF	447.0	447.59	447.0	447.53	850.0
2025-07-07 05:00:00	DIA	ETF	448.05	448.08	448.05	448.08	800.0

> showing 50 of 26,512 rows — these rows as CSV

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