PREVIEW / etf_1hour / 2024-04-26

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-04-26.parquet
  size:    524 KB
  rows:    19,350

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
2024-04-26 04:00:00	SPY	ETF	507.33	507.84	506.95	506.97	24929.0
2024-04-26 05:00:00	SPY	ETF	506.91	507.07	506.63	506.97	11015.0
2024-04-26 06:00:00	SPY	ETF	506.86	507.15	506.65	506.85	27224.0
2024-04-26 07:00:00	SPY	ETF	506.92	507.53	506.5	507.2	183035.0
2024-04-26 08:00:00	SPY	ETF	507.09	509.2	506.409	507.19	1178827.0
2024-04-26 09:00:00	SPY	ETF	507.18	508.24	505.7	507.84	6124674.0
2024-04-26 10:00:00	SPY	ETF	507.84	509.01	507.65	508.78	6670695.0
2024-04-26 11:00:00	SPY	ETF	508.8	509.55	507.72	508.625	5584881.0
2024-04-26 12:00:00	SPY	ETF	508.62	509.57	508.16	509.56	3622006.0
2024-04-26 13:00:00	SPY	ETF	509.56	509.88	509.1	509.42	3661021.0
2024-04-26 14:00:00	SPY	ETF	509.425	509.49	508.578	509.4	3823020.0
2024-04-26 15:00:00	SPY	ETF	509.4	509.65	508.16	508.24	10339053.0
2024-04-26 16:00:00	SPY	ETF	508.23	508.6	508.17	508.44	6013990.0
2024-04-26 17:00:00	SPY	ETF	508.6	508.68	508.03	508.28	124337.0
2024-04-26 18:00:00	SPY	ETF	508.28	508.38	508.18	508.38	15601.0
2024-04-26 19:00:00	SPY	ETF	508.44	508.7	508.44	508.69	6958.0
2024-04-26 04:00:00	QQQ	ETF	429.11	429.39	428.43	428.52	126049.0
2024-04-26 05:00:00	QQQ	ETF	428.46	428.59	428.0	428.34	103295.0
2024-04-26 06:00:00	QQQ	ETF	428.4	428.79	428.16	428.31	37924.0
2024-04-26 07:00:00	QQQ	ETF	428.36	429.2	428.36	428.75	129646.0
2024-04-26 08:00:00	QQQ	ETF	429.09	430.5	427.61	428.36	937316.0
2024-04-26 09:00:00	QQQ	ETF	428.41	430.2	426.92	429.82	8299023.0
2024-04-26 10:00:00	QQQ	ETF	429.82	431.535	429.39	431.39	5861210.0
2024-04-26 11:00:00	QQQ	ETF	431.415	432.17	430.47	431.275	3530371.0
2024-04-26 12:00:00	QQQ	ETF	431.28	432.09	430.76	432.09	1793238.0
2024-04-26 13:00:00	QQQ	ETF	432.09	432.55	431.605	431.9501	2460139.0
2024-04-26 14:00:00	QQQ	ETF	431.96	432.03	430.97	431.72	2123470.0
2024-04-26 15:00:00	QQQ	ETF	431.72	432.245	430.98	431.05	5796629.0
2024-04-26 16:00:00	QQQ	ETF	431.04	431.25	430.85	431.02	1741685.0
2024-04-26 17:00:00	QQQ	ETF	431.01	431.19	430.92	431.0	35248.0
2024-04-26 18:00:00	QQQ	ETF	430.95	431.06	430.89	431.02	55109.0
2024-04-26 19:00:00	QQQ	ETF	430.95	431.14	430.95	431.12	14195.0
2024-04-26 04:00:00	IWM	ETF	196.33	196.74	196.33	196.64	17217.0
2024-04-26 05:00:00	IWM	ETF	196.65	196.65	196.3	196.45	15563.0
2024-04-26 06:00:00	IWM	ETF	196.26	196.48	196.17	196.35	5875.0
2024-04-26 07:00:00	IWM	ETF	196.38	196.58	196.28	196.56	37397.0
2024-04-26 08:00:00	IWM	ETF	196.4804	199.06	196.04	197.15	1231005.0
2024-04-26 09:00:00	IWM	ETF	197.17	198.45	196.42	198.34	3031728.0
2024-04-26 10:00:00	IWM	ETF	198.38	198.78	197.8	198.08	3408491.0
2024-04-26 11:00:00	IWM	ETF	198.09	198.42	197.515	198.19	1939282.0
2024-04-26 12:00:00	IWM	ETF	198.2	198.81	198.04	198.81	1276497.0
2024-04-26 13:00:00	IWM	ETF	198.81	198.89	198.465	198.73	1599246.0
2024-04-26 14:00:00	IWM	ETF	198.735	198.79	198.39	198.74	1150119.0
2024-04-26 15:00:00	IWM	ETF	198.74	198.75	198.35	198.4	4130057.0
2024-04-26 16:00:00	IWM	ETF	198.36	198.72	198.36	198.64	1406631.0
2024-04-26 17:00:00	IWM	ETF	198.64	198.69	198.37	198.55	29835.0
2024-04-26 18:00:00	IWM	ETF	198.52	198.63	198.43	198.57	11123.0
2024-04-26 19:00:00	IWM	ETF	198.54	198.63	198.48	198.5	10672.0
2024-04-26 05:00:00	DIA	ETF	381.24	381.45	381.24	381.45	200.0
2024-04-26 06:00:00	DIA	ETF	381.56	381.56	381.56	381.56	200.0

> showing 50 of 19,350 rows — these rows as CSV

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