make all materialized views into tables that are indexed using triggers

[moodysalem]

@MentatBot

we have examples of this with the hourly tables

follow the example for the pool states

[mentatbot]

I'm getting to work. See my steps and track my cost here.

• Wake on any new activity.

Pull Requests:

• PR #5

_{I always see new activity while actively working. When paused, I'll only respond when tagged unless this box is checked.}

[mentatbot]

I'll work on converting the materialized views into tables that are indexed using triggers. Looking at the codebase, I can see that we need to convert:

1. pool_states_materialized - Created from pool_states_view
2. oracle_pool_states_materialized - Created from oracle_pool_states_view
3. last_24h_pool_stats_materialized - Created from last_24h_pool_stats_view

I'll follow the example of the per_pool_per_tick_liquidity_incremental_view table which is already using triggers for updates. I'll create the necessary tables and triggers to replace these materialized views, ensuring they're properly indexed and updated when the underlying data changes.