PREVIEW / etf_1hour / 2025-04-09

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-04-09.parquet
  size:    708 KB
  rows:    28,104

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-09 04:00:00	SPY	ETF	490.62	499.72	489.22	498.04	442613.0
2025-04-09 05:00:00	SPY	ETF	498.03	499.05	494.55	495.64	150519.0
2025-04-09 06:00:00	SPY	ETF	495.19	498.25	491.99	494.7	492452.0
2025-04-09 07:00:00	SPY	ETF	494.72	494.99	485.28	487.71	2747119.0
2025-04-09 08:00:00	SPY	ETF	492.82	500.0	482.86	491.34	2406705.0
2025-04-09 09:00:00	SPY	ETF	491.42	502.04	491.09	499.85	14548722.0
2025-04-09 10:00:00	SPY	ETF	499.86	503.67	493.0904	493.2084	13692429.0
2025-04-09 11:00:00	SPY	ETF	493.22	499.71	493.05	495.975	8548504.0
2025-04-09 12:00:00	SPY	ETF	495.95	502.58	494.77	501.2	5973269.0
2025-04-09 13:00:00	SPY	ETF	501.25	536.5	497.56	534.87	51743592.0
2025-04-09 14:00:00	SPY	ETF	534.925	539.87	530.59	530.93	23924791.0
2025-04-09 15:00:00	SPY	ETF	530.91	546.33	529.68	543.37	34570984.0
2025-04-09 16:00:00	SPY	ETF	543.48	548.62	541.8	545.82	15804293.0
2025-04-09 17:00:00	SPY	ETF	545.82	546.3	543.52	544.3701	437282.0
2025-04-09 18:00:00	SPY	ETF	544.43	546.231	543.5214	546.2	548666.0
2025-04-09 19:00:00	SPY	ETF	546.29	547.07	545.36	545.9	174734.0
2025-04-09 04:00:00	QQQ	ETF	418.66	420.53	413.67	419.11	355820.0
2025-04-09 05:00:00	QQQ	ETF	419.12	420.05	416.0	416.98	200747.0
2025-04-09 06:00:00	QQQ	ETF	416.75	419.47	413.76	416.44	545266.0
2025-04-09 07:00:00	QQQ	ETF	416.39	416.82	407.39	409.65	1329265.0
2025-04-09 08:00:00	QQQ	ETF	415.23	420.42	404.44	413.59	1642092.0
2025-04-09 09:00:00	QQQ	ETF	413.73	423.97	413.5	421.29	9014582.0
2025-04-09 10:00:00	QQQ	ETF	421.31	424.94	415.74	415.8701	9062653.0
2025-04-09 11:00:00	QQQ	ETF	415.86	421.6	415.6	418.161	5818868.0
2025-04-09 12:00:00	QQQ	ETF	418.18	424.42	417.21	423.26	4753254.0
2025-04-09 13:00:00	QQQ	ETF	423.36	456.27	420.5	455.71	29789981.0
2025-04-09 14:00:00	QQQ	ETF	455.78	461.3291	452.44	453.07	17420744.0
2025-04-09 15:00:00	QQQ	ETF	453.05	467.83	451.73	465.14	20032830.0
2025-04-09 16:00:00	QQQ	ETF	465.12	467.31	464.18	467.3037	7332362.0
2025-04-09 17:00:00	QQQ	ETF	467.0003	468.41	464.39	464.57	331903.0
2025-04-09 18:00:00	QQQ	ETF	464.57	466.93	464.37	466.75	425300.0
2025-04-09 19:00:00	QQQ	ETF	466.76	467.7	465.49	466.06	208090.0
2025-04-09 04:00:00	IWM	ETF	172.5	175.43	172.01	174.37	159782.0
2025-04-09 05:00:00	IWM	ETF	174.52	175.0	173.34	173.67	80549.0
2025-04-09 06:00:00	IWM	ETF	173.52	174.73	172.32	173.19	268337.0
2025-04-09 07:00:00	IWM	ETF	173.03	173.03	169.27	170.15	906991.0
2025-04-09 08:00:00	IWM	ETF	170.2	175.3	168.8	171.83	734665.0
2025-04-09 09:00:00	IWM	ETF	171.75	176.23	171.71	175.25	10896979.0
2025-04-09 10:00:00	IWM	ETF	175.18	176.7	171.8	171.81	8730652.0
2025-04-09 11:00:00	IWM	ETF	171.805	174.05	171.755	172.06	5874880.0
2025-04-09 12:00:00	IWM	ETF	172.12	174.5399	171.74	173.82	4766090.0
2025-04-09 13:00:00	IWM	ETF	173.86	189.67	172.96	189.49	33925760.0
2025-04-09 14:00:00	IWM	ETF	189.5	192.11	186.77	186.83	16080483.0
2025-04-09 15:00:00	IWM	ETF	186.86	191.4199	186.4325	189.78	14438687.0
2025-04-09 16:00:00	IWM	ETF	189.79	191.04	189.39	190.78	4213770.0
2025-04-09 17:00:00	IWM	ETF	190.8384	190.8384	189.6	189.76	41172.0
2025-04-09 18:00:00	IWM	ETF	190.38	191.44	190.08	191.38	74667.0
2025-04-09 19:00:00	IWM	ETF	191.65	191.7	190.72	190.89	77332.0
2025-04-09 04:00:00	DIA	ETF	376.96	376.96	372.98	374.35	5150.0
2025-04-09 05:00:00	DIA	ETF	376.5	376.67	374.25	374.49	4867.0

> showing 50 of 28,104 rows — these rows as CSV

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