Skip to content

Protocol Analytics

This section provides deep dives into the DeFi protocols tracked by the Gnosis Chain analytics platform. While the dbt Model Catalog — Contracts lists all auto-generated decoded models, this section explains how each protocol works, what the decoded data means, and how to query it effectively.

All protocol models use the decode_logs and decode_calls macros to produce a decoded_params column of type Map(String, String). Access individual fields with:

decoded_params['reserve']       -- address of the reserve asset
decoded_params['amount']        -- raw token amount (divide by 10^decimals)
decoded_params['liquidityRate'] -- interest rate in RAY (divide by 1e27)

Lending Protocols

Protocol Contract Address dbt Model Live Since
Agave 0x5E15d5E33d318dCEd84Bfe3F4EACe07909bE6d9c contracts_agave_LendingPool_events 2022-04-19
Aave V3 0xb50201558B00496A145fE76f7424749556E326D8 contracts_aaveV3_PoolInstance_events 2023-10-04
Spark 0x2Dae5307c5E3FD1CF5A72Cb6F698f915860607e0 contracts_spark_Pool_events 2023-09-05

DEX Protocols

Protocol Contract Address dbt Model Live Since
Uniswap V3 Dynamic (whitelist) contracts_UniswapV3_Pool_events 2022-04-22
Balancer V2 0xBA12222222228d8Ba445958a75a0704d566BF2C8 contracts_BalancerV2_Vault_events 2021-01-01
Balancer V3 0xba1333333333a1ba1108e8412f11850a5c319ba9 contracts_BalancerV3_Vault_events 2024-01-01
CoW Protocol 0x9008D19f58AAbD9eD0D60971565AA8510560ab41 (no model yet)
Swapr Dynamic (whitelist) contracts_Swapr_v3_AlgebraPool_events 2022-03-01

Circles Protocol

Protocol Contract Address dbt Model Live Since
Circles V2 0xc12C1E50ABB450d6205Ea2C3Fa861b3B834d13e8 contracts_circles_v2_Hub_events 2024-10-15

Smart Account Protocols

Protocol Discovery Coverage What it tracks
Safe (Gnosis Safe) execution.traces (delegatecall + setup selectors) All Safe versions 0.1.0 → 1.4.1 Every Safe ever deployed on Gnosis Chain, with full owner mutation history (SafeSetup / AddedOwner / RemovedOwner / ChangedThreshold) and module-state events (EnabledModule / DisabledModule / ChangedGuard). The foundation for the GP and Gnosis App stacks.
Gnosis Pay stg_gpay__wallets (Dune labels) + module discovery All GP cardholder Safes Per-Safe module topology (Delay + Roles + Spender), spender delegate assignments, daily-limit allowance state, and Delay-module activity (TransactionAdded). Includes a Mixpanel cardholder bridge using a union of three identity roles (initial owner, delegate, Safe self).

Sectors (heuristic-derived)

Sector Membership source Mixpanel role What it tracks
Gnosis App Six on-chain heuristic rules over Cometh-relayed ERC-4337 transactions (Safe + Circles V2 actions) Check, not source of truth Authoritative on-chain user list for the app.gnosis.io consumer wallet. Mixpanel coverage is reported as a diagnostic, not used as a join filter.

See Also