PREVIEW / etf_1hour / 2025-04-03

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-04-03.parquet
  size:    672 KB
  rows:    26,466

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-04-03 04:00:00	SPY	ETF	548.0	549.38	547.46	548.88	131864.0
2025-04-03 05:00:00	SPY	ETF	548.92	549.33	546.27	546.54	100850.0
2025-04-03 06:00:00	SPY	ETF	546.6	547.0	544.36	545.44	322237.0
2025-04-03 07:00:00	SPY	ETF	545.53	546.75	544.78	546.0	603837.0
2025-04-03 08:00:00	SPY	ETF	545.35	550.09	543.55	543.68	1313638.0
2025-04-03 09:00:00	SPY	ETF	543.51	547.97	543.188	544.92	12300143.0
2025-04-03 10:00:00	SPY	ETF	544.86	545.22	540.1	540.19	13310384.0
2025-04-03 11:00:00	SPY	ETF	540.2	544.4199	539.58	543.51	9882375.0
2025-04-03 12:00:00	SPY	ETF	543.51	546.36	542.985	543.44	6958501.0
2025-04-03 13:00:00	SPY	ETF	543.46	544.37	541.77	541.85	4868660.0
2025-04-03 14:00:00	SPY	ETF	541.84	542.53	539.9402	541.79	6786883.0
2025-04-03 15:00:00	SPY	ETF	541.77	542.0	536.9	537.64	20929000.0
2025-04-03 16:00:00	SPY	ETF	537.67	538.76	535.65	536.21	8586848.0
2025-04-03 17:00:00	SPY	ETF	536.25	536.73	536.16	536.59	301999.0
2025-04-03 18:00:00	SPY	ETF	536.45	537.19	534.91	536.21	304195.0
2025-04-03 19:00:00	SPY	ETF	536.12	537.0	535.4	536.38	246465.0
2025-04-03 04:00:00	QQQ	ETF	460.46	462.51	460.11	461.96	174302.0
2025-04-03 05:00:00	QQQ	ETF	461.87	462.47	458.76	459.03	130701.0
2025-04-03 06:00:00	QQQ	ETF	459.06	459.29	457.04	458.06	178879.0
2025-04-03 07:00:00	QQQ	ETF	458.1	459.11	457.27	458.04	489430.0
2025-04-03 08:00:00	QQQ	ETF	457.92	462.333	454.55	454.63	1018616.0
2025-04-03 09:00:00	QQQ	ETF	454.53	460.07	454.19	458.07	8856126.0
2025-04-03 10:00:00	QQQ	ETF	457.95	458.4	452.55	452.66	8398440.0
2025-04-03 11:00:00	QQQ	ETF	452.64	456.72	451.5608	455.54	6792443.0
2025-04-03 12:00:00	QQQ	ETF	455.51	457.985	454.88	455.2799	4752145.0
2025-04-03 13:00:00	QQQ	ETF	455.27	456.32	453.77	453.8	3094835.0
2025-04-03 14:00:00	QQQ	ETF	453.76	454.95	452.38	454.6402	3943143.0
2025-04-03 15:00:00	QQQ	ETF	454.63	454.94	450.14	450.68	8745779.0
2025-04-03 16:00:00	QQQ	ETF	450.66	453.9265	449.04	449.86	3073500.0
2025-04-03 17:00:00	QQQ	ETF	449.9	450.6	449.76	450.5	178913.0
2025-04-03 18:00:00	QQQ	ETF	450.5	450.96	448.51	449.83	248675.0
2025-04-03 19:00:00	QQQ	ETF	449.79	450.79	449.14	449.99	187036.0
2025-04-03 04:00:00	IWM	ETF	194.25	195.4	194.25	194.87	122209.0
2025-04-03 05:00:00	IWM	ETF	194.78	194.95	193.56	193.75	31461.0
2025-04-03 06:00:00	IWM	ETF	193.8	194.0	192.81	193.26	59960.0
2025-04-03 07:00:00	IWM	ETF	193.28	193.71	192.6	193.3	347874.0
2025-04-03 08:00:00	IWM	ETF	192.81	194.8	192.25	192.29	544478.0
2025-04-03 09:00:00	IWM	ETF	192.2	195.0599	192.04	192.72	7620326.0
2025-04-03 10:00:00	IWM	ETF	192.7	192.72	189.26	189.3	7810695.0
2025-04-03 11:00:00	IWM	ETF	189.275	191.81	189.2	191.31	4439801.0
2025-04-03 12:00:00	IWM	ETF	191.3	192.55	191.15	191.305	4104861.0
2025-04-03 13:00:00	IWM	ETF	191.32	191.85	190.91	190.92	2244739.0
2025-04-03 14:00:00	IWM	ETF	190.92	191.22	189.92	190.91	3407350.0
2025-04-03 15:00:00	IWM	ETF	190.88	191.195	189.355	189.58	7539665.0
2025-04-03 16:00:00	IWM	ETF	189.58	189.78	188.89	189.19	3073608.0
2025-04-03 17:00:00	IWM	ETF	189.2	189.85	189.05	189.63	109332.0
2025-04-03 18:00:00	IWM	ETF	189.49	189.59	188.75	189.2	48210.0
2025-04-03 19:00:00	IWM	ETF	189.2	189.77	188.94	189.49	38025.0
2025-04-03 04:00:00	DIA	ETF	412.01	412.39	411.71	412.34	18344.0
2025-04-03 05:00:00	DIA	ETF	412.32	412.49	411.22	411.33	17593.0

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

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