PREVIEW / etf_5min / 2024-01-24

all etf 5-min files

  file:    by_date/etf_5min/2024/2024-01-24.parquet
  size:    2.4 MB
  rows:    113,979

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-01-24 04:00:00	SPY	ETF	486.86	486.9	486.83	486.85	3703.0
2024-01-24 04:05:00	SPY	ETF	486.88	486.89	486.81	486.88	3461.0
2024-01-24 04:10:00	SPY	ETF	486.84	486.91	486.84	486.86	2100.0
2024-01-24 04:15:00	SPY	ETF	486.87	486.88	486.82	486.84	1648.0
2024-01-24 04:20:00	SPY	ETF	486.89	487.06	486.89	487.01	4671.0
2024-01-24 04:25:00	SPY	ETF	486.99	487.07	486.99	487.0	1424.0
2024-01-24 04:30:00	SPY	ETF	486.9	486.99	486.86	486.96	1604.0
2024-01-24 04:35:00	SPY	ETF	486.96	486.96	486.94	486.95	1200.0
2024-01-24 04:40:00	SPY	ETF	487.1	487.1	487.09	487.09	398.0
2024-01-24 04:50:00	SPY	ETF	487.08	487.08	487.08	487.08	127.0
2024-01-24 04:55:00	SPY	ETF	487.11	487.15	487.11	487.15	1348.0
2024-01-24 05:00:00	SPY	ETF	487.15	487.17	487.15	487.17	650.0
2024-01-24 05:05:00	SPY	ETF	487.22	487.26	487.08	487.08	1534.0
2024-01-24 05:10:00	SPY	ETF	487.12	487.12	487.01	487.01	2035.0
2024-01-24 05:15:00	SPY	ETF	487.09	487.09	487.0	487.04	769.0
2024-01-24 05:20:00	SPY	ETF	486.86	486.86	486.85	486.85	989.0
2024-01-24 05:25:00	SPY	ETF	486.81	486.88	486.76	486.88	4679.0
2024-01-24 05:30:00	SPY	ETF	486.94	486.94	486.94	486.94	400.0
2024-01-24 05:35:00	SPY	ETF	486.97	486.97	486.97	486.97	100.0
2024-01-24 05:45:00	SPY	ETF	486.92	486.99	486.92	486.96	25997.0
2024-01-24 05:50:00	SPY	ETF	486.88	486.92	486.88	486.92	204.0
2024-01-24 06:00:00	SPY	ETF	487.07	487.07	487.07	487.07	100.0
2024-01-24 06:05:00	SPY	ETF	487.16	487.2	487.16	487.17	14651.0
2024-01-24 06:15:00	SPY	ETF	487.14	487.14	487.03	487.09	10200.0
2024-01-24 06:20:00	SPY	ETF	487.15	487.15	487.0	487.03	10952.0
2024-01-24 06:25:00	SPY	ETF	487.06	487.08	487.02	487.07	9283.0
2024-01-24 06:35:00	SPY	ETF	487.12	487.12	487.12	487.12	100.0
2024-01-24 06:40:00	SPY	ETF	487.11	487.12	487.11	487.12	315.0
2024-01-24 06:45:00	SPY	ETF	487.04	487.04	487.0	487.03	1774.0
2024-01-24 06:50:00	SPY	ETF	487.04	487.04	487.04	487.04	400.0
2024-01-24 06:55:00	SPY	ETF	487.03	487.03	487.03	487.03	100.0
2024-01-24 07:00:00	SPY	ETF	487.07	487.09	486.81	487.08	16361.0
2024-01-24 07:05:00	SPY	ETF	487.04	487.05	486.92	487.01	14305.0
2024-01-24 07:10:00	SPY	ETF	487.02	487.11	487.0	487.1	16582.0
2024-01-24 07:15:00	SPY	ETF	487.1	487.11	487.02	487.02	5317.0
2024-01-24 07:20:00	SPY	ETF	487.03	487.14	487.03	487.07	18392.0
2024-01-24 07:25:00	SPY	ETF	487.09	487.09	487.0	487.04	4907.0
2024-01-24 07:30:00	SPY	ETF	487.03	487.03	486.97	486.97	1600.0
2024-01-24 07:35:00	SPY	ETF	487.05	487.26	487.04	487.25	7252.0
2024-01-24 07:40:00	SPY	ETF	487.19	487.19	487.11	487.11	10636.0
2024-01-24 07:45:00	SPY	ETF	487.09	487.22	487.09	487.16	10960.0
2024-01-24 07:50:00	SPY	ETF	487.17	487.17	487.12	487.12	10188.0
2024-01-24 07:55:00	SPY	ETF	487.1	487.13	487.08	487.13	11080.0
2024-01-24 08:00:00	SPY	ETF	487.0406	487.42	486.08	487.42	76942.0
2024-01-24 08:05:00	SPY	ETF	487.45	487.68	486.2	487.64	56171.0
2024-01-24 08:10:00	SPY	ETF	487.65	487.8292	487.65	487.72	40215.0
2024-01-24 08:15:00	SPY	ETF	487.76	487.76	487.56	487.7	10839.0
2024-01-24 08:20:00	SPY	ETF	487.69	487.81	487.64	487.78	27733.0
2024-01-24 08:25:00	SPY	ETF	487.76	487.88	487.69	487.87	30698.0
2024-01-24 08:30:00	SPY	ETF	487.85	487.92	487.82	487.84	8976.0

> showing 50 of 113,979 rows — these rows as CSV

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