Build queries on sepolia for v3

[viniabussafi]

With vault contract decoded, we can now start working on building/testing queries on top of it
Disclaimer: still waiting for contracts to show up at data explorer, so these queries are still unfinished

[viniabussafi]

Trades

[viniabussafi]

Pool Balances

[viniabussafi]

Protocol Fees

[viniabussafi]

BPT supply

[viniabussafi]

Transfers BPT

[viniabussafi]

Resubmitted Vault contract for decoding

[viniabussafi]

Pools Registered

[viniabussafi]

Pools Fees

[viniabussafi]

Working on v3_vault_pool_balances to replace the usage of the 'tokens' column, using this snippet:

WITH token_data AS (
SELECT
pool,
ARRAY_AGG(json_extract_scalar(token, '$.token') ORDER BY token_index) AS tokens
FROM (
SELECT
pool,
tokenConfig,
SEQUENCE(1, CARDINALITY(tokenConfig)) AS token_index_array
FROM
balancer_testnet_sepolia.Vault_evt_PoolRegistered
) AS pool_data
CROSS JOIN UNNEST(tokenConfig, token_index_array) AS t(token, token_index)
GROUP BY pool
)

[viniabussafi]

Updated the query for protocol fees using the protocol fee controller: https://dune.com/queries/3850805

[viniabussafi]

v3_vault_pool_balance_changes_per_block