PREVIEW / etf_1hour / 2025-03-14

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-03-14.parquet
  size:    634 KB
  rows:    24,342

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-03-14 04:00:00	SPY	ETF	554.68	556.06	554.23	555.65	28655.0
2025-03-14 05:00:00	SPY	ETF	555.76	556.25	555.59	555.84	29421.0
2025-03-14 06:00:00	SPY	ETF	555.78	556.85	554.88	556.2	56689.0
2025-03-14 07:00:00	SPY	ETF	556.19	556.8	555.42	556.51	212237.0
2025-03-14 08:00:00	SPY	ETF	556.16	557.7	554.35	557.08	405992.0
2025-03-14 09:00:00	SPY	ETF	557.05	559.69	555.8	558.44	5040469.0
2025-03-14 10:00:00	SPY	ETF	557.68	560.2798	555.5	560.2798	6647723.0
2025-03-14 11:00:00	SPY	ETF	560.27	562.43	559.92	562.14	4195103.0
2025-03-14 12:00:00	SPY	ETF	562.14	562.43	560.0201	562.09	3435685.0
2025-03-14 13:00:00	SPY	ETF	562.07	562.8	560.49	560.63	3940684.0
2025-03-14 14:00:00	SPY	ETF	560.64	562.48	560.23	561.76	3562663.0
2025-03-14 15:00:00	SPY	ETF	561.77	563.83	561.37	562.79	9870703.0
2025-03-14 16:00:00	SPY	ETF	562.79	562.81	561.16	561.75	4305283.0
2025-03-14 17:00:00	SPY	ETF	561.9	561.95	561.5401	561.62	54938.0
2025-03-14 18:00:00	SPY	ETF	561.68	561.7	561.42	561.4792	40549.0
2025-03-14 19:00:00	SPY	ETF	561.48	562.18	561.48	562.08	49905.0
2025-03-14 04:00:00	QQQ	ETF	472.01	473.4	471.64	472.84	53902.0
2025-03-14 05:00:00	QQQ	ETF	472.97	473.6	472.87	473.22	37085.0
2025-03-14 06:00:00	QQQ	ETF	473.25	474.22	472.2	473.5	65374.0
2025-03-14 07:00:00	QQQ	ETF	473.55	474.26	472.78	473.98	114355.0
2025-03-14 08:00:00	QQQ	ETF	473.52	475.4	471.5	474.48	432946.0
2025-03-14 09:00:00	QQQ	ETF	474.44	477.51	473.4608	475.74	4684213.0
2025-03-14 10:00:00	QQQ	ETF	475.69	477.3	473.12	477.29	5431474.0
2025-03-14 11:00:00	QQQ	ETF	477.3	479.55	476.83	478.985	3869332.0
2025-03-14 12:00:00	QQQ	ETF	478.985	479.64	477.16	479.19	2202156.0
2025-03-14 13:00:00	QQQ	ETF	479.18	479.67	477.52	477.75	2086565.0
2025-03-14 14:00:00	QQQ	ETF	477.8	479.5431	477.35	478.85	2342268.0
2025-03-14 15:00:00	QQQ	ETF	478.78	480.56	478.28	479.65	5795947.0
2025-03-14 16:00:00	QQQ	ETF	479.66	479.66	478.1	478.7	2435549.0
2025-03-14 17:00:00	QQQ	ETF	478.72	478.75	478.2497	478.6	59518.0
2025-03-14 18:00:00	QQQ	ETF	478.59	478.74	478.55	478.67	13007.0
2025-03-14 19:00:00	QQQ	ETF	478.67	479.2665	478.6	479.18	46196.0
2025-03-14 04:00:00	IWM	ETF	199.57	200.17	199.44	200.01	23552.0
2025-03-14 05:00:00	IWM	ETF	200.08	200.23	199.96	200.09	8839.0
2025-03-14 06:00:00	IWM	ETF	200.08	200.2	199.73	200.04	28324.0
2025-03-14 07:00:00	IWM	ETF	200.0	200.39	199.79	200.04	146458.0
2025-03-14 08:00:00	IWM	ETF	200.06	200.55	199.58	200.35	215650.0
2025-03-14 09:00:00	IWM	ETF	200.29	201.45	199.95	200.92	2955607.0
2025-03-14 10:00:00	IWM	ETF	200.48	201.77	199.34	201.77	4033421.0
2025-03-14 11:00:00	IWM	ETF	201.77	202.81	201.65	202.59	3834174.0
2025-03-14 12:00:00	IWM	ETF	202.58	202.75	201.6499	202.65	2183332.0
2025-03-14 13:00:00	IWM	ETF	202.62	202.81	201.88	201.92	2364029.0
2025-03-14 14:00:00	IWM	ETF	201.93	202.78	201.92	202.44	1406878.0
2025-03-14 15:00:00	IWM	ETF	202.44	203.07	202.11	202.9	4656698.0
2025-03-14 16:00:00	IWM	ETF	202.89	202.9526	202.3	202.33	1388267.0
2025-03-14 17:00:00	IWM	ETF	202.36	202.69	202.33	202.43	13918.0
2025-03-14 18:00:00	IWM	ETF	202.45	202.69	202.45	202.6	3098.0
2025-03-14 19:00:00	IWM	ETF	202.64	202.81	202.5201	202.8	12002.0
2025-03-14 04:00:00	DIA	ETF	410.39	410.99	410.31	410.99	850.0
2025-03-14 05:00:00	DIA	ETF	411.27	411.27	411.11	411.11	300.0

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

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