PREVIEW / etf_1hour / 2025-02-27

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-02-27.parquet
  size:    625 KB
  rows:    24,385

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-02-27 04:00:00	SPY	ETF	597.61	597.93	597.11	597.8	32597.0
2025-02-27 05:00:00	SPY	ETF	597.83	598.06	597.5	597.81	9798.0
2025-02-27 06:00:00	SPY	ETF	597.78	598.23	597.78	598.23	31478.0
2025-02-27 07:00:00	SPY	ETF	598.33	598.68	597.87	597.98	451852.0
2025-02-27 08:00:00	SPY	ETF	598.5	598.63	594.79	595.88	1529083.0
2025-02-27 09:00:00	SPY	ETF	595.85	598.02	592.14	592.435	5290820.0
2025-02-27 10:00:00	SPY	ETF	592.43	596.52	590.52	593.432	7200072.0
2025-02-27 11:00:00	SPY	ETF	593.44	596.24	592.28	592.45	2798663.0
2025-02-27 12:00:00	SPY	ETF	592.49	594.475	591.4	593.42	3024566.0
2025-02-27 13:00:00	SPY	ETF	593.44	595.16	593.305	593.71	2357215.0
2025-02-27 14:00:00	SPY	ETF	593.76	593.84	588.34	589.28	5927123.0
2025-02-27 15:00:00	SPY	ETF	589.3	589.35	584.65	585.04	14938660.0
2025-02-27 16:00:00	SPY	ETF	585.045	586.07	584.72	585.5699	3971979.0
2025-02-27 17:00:00	SPY	ETF	585.61	585.66	585.18	585.51	167735.0
2025-02-27 18:00:00	SPY	ETF	585.55	586.25	585.55	586.05	240198.0
2025-02-27 19:00:00	SPY	ETF	586.15	586.25	584.89	584.89	62057.0
2025-02-27 04:00:00	QQQ	ETF	516.77	517.96	516.77	517.69	52524.0
2025-02-27 05:00:00	QQQ	ETF	517.72	518.2	517.4	517.71	43439.0
2025-02-27 06:00:00	QQQ	ETF	517.68	518.21	517.47	518.19	54321.0
2025-02-27 07:00:00	QQQ	ETF	518.17	519.19	518.0	518.42	146581.0
2025-02-27 08:00:00	QQQ	ETF	518.17	519.0988	514.0	517.35	576228.0
2025-02-27 09:00:00	QQQ	ETF	517.22	519.0699	509.77	510.03	5030613.0
2025-02-27 10:00:00	QQQ	ETF	510.03	513.88	507.335	510.3117	9026904.0
2025-02-27 11:00:00	QQQ	ETF	510.36	513.744	509.77	510.0104	2196272.0
2025-02-27 12:00:00	QQQ	ETF	510.06	511.75	508.83	510.78	2112092.0
2025-02-27 13:00:00	QQQ	ETF	510.82	512.6999	510.58	511.1	1688205.0
2025-02-27 14:00:00	QQQ	ETF	511.15	511.23	504.93	505.85	3749198.0
2025-02-27 15:00:00	QQQ	ETF	505.88	506.0	500.05	500.33	10587282.0
2025-02-27 16:00:00	QQQ	ETF	500.33	501.52	499.74	501.07	2920129.0
2025-02-27 17:00:00	QQQ	ETF	500.95	501.2	500.27	501.12	317213.0
2025-02-27 18:00:00	QQQ	ETF	501.12	502.02	501.11	501.87	217337.0
2025-02-27 19:00:00	QQQ	ETF	502.0	502.2301	500.56	500.56	216008.0
2025-02-27 04:00:00	IWM	ETF	217.22	217.46	217.09	217.41	13054.0
2025-02-27 05:00:00	IWM	ETF	217.37	217.37	217.2	217.35	5124.0
2025-02-27 06:00:00	IWM	ETF	217.37	217.87	217.37	217.77	85957.0
2025-02-27 07:00:00	IWM	ETF	217.76	217.77	217.25	217.34	65576.0
2025-02-27 08:00:00	IWM	ETF	217.57	217.7609	215.16	215.3	601321.0
2025-02-27 09:00:00	IWM	ETF	215.25	216.08	214.0	214.12	3094285.0
2025-02-27 10:00:00	IWM	ETF	214.11	216.49	213.43	214.88	3936773.0
2025-02-27 11:00:00	IWM	ETF	214.89	216.095	214.68	214.77	1800584.0
2025-02-27 12:00:00	IWM	ETF	214.79	215.34	214.21	214.63	1874336.0
2025-02-27 13:00:00	IWM	ETF	214.64	215.33	214.62	214.97	1110460.0
2025-02-27 14:00:00	IWM	ETF	214.98	215.04	213.03	213.64	3224904.0
2025-02-27 15:00:00	IWM	ETF	213.65	213.67	212.22	212.4	5274540.0
2025-02-27 16:00:00	IWM	ETF	212.39	212.8	212.25	212.57	1033552.0
2025-02-27 17:00:00	IWM	ETF	212.62	212.62	212.31	212.43	20095.0
2025-02-27 18:00:00	IWM	ETF	212.57	212.8	212.4	212.47	15078.0
2025-02-27 19:00:00	IWM	ETF	212.6	212.6	211.9	211.9	38062.0
2025-02-27 04:00:00	DIA	ETF	435.61	435.69	435.26	435.3	7431.0
2025-02-27 05:00:00	DIA	ETF	435.3	435.3	435.3	435.3	233.0

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

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