Execution Module¶
The Execution module is the largest module in dbt-cerebro with approximately 208 models. It covers all data produced by the Gnosis Chain execution layer (EVM), including blocks, transactions, logs, traces, contract deployments, native transfers, balance diffs, gas metrics, and DeFi yield tracking.
Data Sources¶
Raw data is sourced from the execution ClickHouse database, which contains:
- blocks -- Block headers with timestamps, gas limits, base fees, and miner/proposer info
- transactions -- All on-chain transactions with input data, gas usage, and receipt status
- logs -- EVM event logs emitted by smart contracts
- traces -- Internal transaction traces (call, create, suicide, reward)
- contracts -- Deployed contract metadata and bytecodes
- native_transfers -- xDAI (native token) transfers extracted from traces
- balance_diffs -- State-level balance changes per block
Model Categories¶
Account
| Model | Layer | Description |
|---|---|---|
int_execution_account_balance_history_daily | Intermediate | Address × date daily portfolio balance aggregate, checkpointed away from |
| fct_execution_account_balance_history_daily ... | ||
int_execution_account_token_movements_in_daily | Intermediate | Inbound leg of token movements (to_address = address) aggregated by |
| (date, token_address, address, counterparty). Spl... | ||
int_execution_account_token_movements_out_daily | Intermediate | Outbound leg of token movements (from_address = address) aggregated by |
| (date, token_address, address, counterparty). ... | ||
fct_execution_account_balance_history_daily | Fact | Daily address-grain portfolio balance history from production token balances. |
fct_execution_account_counterparty_edges_daily | Fact | Daily directed account-counterparty graph edges from production movement and GPay activity facts. |
fct_execution_account_counterparty_edges_latest | Fact | Latest bounded graph edge source for Account Portfolio interactions and relationships. |
fct_execution_account_linked_entities_latest | Fact | Direct entity links for selected and linked-group Account Portfolio navigation. |
fct_execution_account_profile_latest | Fact | Complete latest account profile for the Account Portfolio hero and routing layer. |
fct_execution_account_safes_latest | Fact | One row per current (owner, Safe) pair, enriched with that Safe's threshold, |
| current owner count, version, and deploy... | ||
fct_execution_account_search_index | Fact | Search index for address, Circles, Safe, GPay, Gnosis App, validator, and withdrawal credential lookup. |
fct_execution_account_token_balances_latest | Fact | Latest non-zero token balances by address, optimized for account lookup. |
fct_execution_account_token_movements_daily | Fact | Daily token movement legs by address, counterparty, token, and direction from production whitelisted daily transfers. |
fct_execution_account_transaction_summary_latest | Fact | Latest address-grain activity summary derived from production token movement facts. |
api_execution_account_balance_history_daily | API | Simple API view for Account Portfolio balance history. |
api_execution_account_counterparty_graph | API | Simple API view for Account Portfolio counterparty graph rows. |
api_execution_account_linked_entities_latest | API | Simple API view for direct linked entities. |
api_execution_account_profile_latest | API | Simple API view over the latest Account Portfolio profile fact. |
api_execution_account_recent_transactions | API | Recent production-backed token movement rows for Account Portfolio transaction tables. |
api_execution_account_safes_latest | API | Reverse lookup — given an address, list every Safe it currently owns, |
| enriched with that Safe's threshold, current ow... | ||
api_execution_account_search_index | API | Simple API view over Account Portfolio search index. |
api_execution_account_token_balances_latest | API | Simple API view for latest Account Portfolio token balances. |
api_execution_account_token_movements_daily | API | Simple API view for Account Portfolio token movements. |
api_execution_account_transaction_summary_latest | API | Simple API view for Account Portfolio transaction/activity summary. |
api_execution_account_validators_latest | API | Account-facing validator member view filterable by withdrawal address or credential. |
Address
| Model | Layer | Description |
|---|---|---|
int_execution_address_roles_current | Intermediate | Identity-role pivot: one row per on-chain address with boolean flags |
| for every role it plays across the sectors we tr... | ||
fct_execution_address_resolver | Fact | Per-(address × source) domain resolver rows. The cross-source merge |
| happens at query time inside `api_execution_addre... | ||
api_execution_address_resolver | API | Per-address merge view over fct_execution_address_resolver. Collapses |
| the per-source rows into a single row per add... | ||
api_execution_address_search | API | Lightweight dropdown source for the Account Portfolio tab's global |
| filter. Two columns (address + display_name), `all... |
Balancer
| Model | Layer | Description |
|---|---|---|
stg_pools__balancer_v2_events | Staging | Normalized signed token deltas for Balancer V2 pools, decoded from Vault events |
| (PoolBalanceChanged, PoolBalanceManag... | ||
stg_pools__balancer_v2_pool_registry | Staging | Mapping of Balancer V2 poolId (bytes32) to pool contract address, built from |
| PoolRegistered events emitted once per p... | ||
stg_pools__balancer_v3_events | Staging | -- |
stg_pools__balancer_v3_token_map | Staging | Balancer V3 ERC4626 wrapper → underlying token mapping. Used to resolve wrapped Aave tokens (waGno*) to their underly... |
Blocks
| Model | Layer | Description |
|---|---|---|
int_execution_blocks_clients_version_daily | Intermediate | The model aggregates daily counts of execution blocks grouped by client and version, supporting incremental updates f... |
int_execution_blocks_gas_usage_daily | Intermediate | This model aggregates daily gas usage and limits from execution blocks to monitor gas consumption efficiency over time. |
fct_execution_blocks_clients_daily | Fact | The fct_execution_blocks_clients_daily model aggregates daily execution block counts per client, providing insights i... |
fct_execution_blocks_gas_usage_monthly | Fact | The fct_execution_blocks_gas_usage_monthly model aggregates monthly gas usage and limits for execution blocks to supp... |
api_execution_blocks_clients_cnt_daily | API | The api_execution_blocks_clients_cnt_daily model provides daily aggregated counts of API execution blocks per client,... |
api_execution_blocks_clients_pct_daily | API | The api_execution_blocks_clients_pct_daily model provides daily percentage metrics of API execution blocks per client... |
api_execution_blocks_gas_usage_pct_daily | API | The api_execution_blocks_gas_usage_pct_daily model provides daily insights into the percentage of gas used by API exe... |
api_execution_blocks_gas_usage_pct_monthly | API | This model provides a monthly percentage of gas usage for execution blocks, enabling analysis of gas consumption tren... |
Bridges
| Model | Layer | Description |
|---|---|---|
int_execution_bridges_address_flows_daily | Intermediate | Address-grain bridge flows. Joins whitelisted transfers against the |
| dune labels set filtered on bridge projects to ex... |
Circles
| Model | Layer | Description |
|---|---|---|
int_execution_circles_v2_avatar_metadata | Intermediate | Current parsed IPFS metadata for every Circles v2 avatar. Joins each |
| avatar's latest (avatar, metadata_digest) pair f... | ||
int_execution_circles_v2_avatar_metadata_history | Intermediate | SCD-style historical view of every Circles v2 avatar metadata change. |
| One row per (avatar, metadata_digest) ever anno... | ||
int_execution_circles_v2_avatar_metadata_targets | Intermediate | Deterministic queue of every (avatar, metadata_digest) pair the Circles v2 |
| NameRegistry has ever announced. Built as ... | ||
int_execution_circles_v2_avatars | Intermediate | Circles v2 avatar registration events (Human, Group, Org) normalized for downstream analytics. |
int_execution_circles_v2_backing | Intermediate | Captures Circles backing lifecycle events with decoded participants and metadata for downstream analytics. |
int_execution_circles_v2_balance_cohorts_daily | Intermediate | Daily distribution of CRC holders across balance buckets, aggregated from daily balances. |
int_execution_circles_v2_balance_diffs_daily | Intermediate | Daily aggregated per-account balance deltas derived from unified v2 transfers. One row per (date, account, token_addr... |
int_execution_circles_v2_balances_daily | Intermediate | Daily end-of-day token balances per account for Circles v2 tokens with demurrage adjustment. |
int_execution_circles_v2_group_collateral_balances_daily | Intermediate | Daily end-of-day group collateral balances per token, derived from cumulative collateral diffs. |
int_execution_circles_v2_group_collateral_diffs | Intermediate | Per-group collateral deltas from StandardTreasury lock, burn, and return events. |
int_execution_circles_v2_group_settings_updates | Intermediate | Group configuration changes from BaseGroupFactory, CMGroupDeployer, and BaseGroup runtime events. |
int_execution_circles_v2_hub_transfers | Intermediate | Circles v2 ERC-1155 TransferSingle and TransferBatch events from the Hub, exploded into individual rows. |
int_execution_circles_v2_offer_cycles | Intermediate | ERC20TokenOfferCycle events capturing configuration, creation, deposits, claims, and withdrawals. |
int_execution_circles_v2_payments | Intermediate | Payment events from the PaymentGatewayFactory with decoded payer, payee, and amount. |
int_execution_circles_v2_tokens_supply_daily | Intermediate | Per-token Circles v2 daily supply derived from the zero-address balance in int_execution_circles_v2_balances_daily.... |
int_execution_circles_v2_transfers | Intermediate | Unified Circles v2 transfers combining Hub ERC-1155 and ERC-20 wrapper transfers. Static wrapper amounts are converte... |
int_execution_circles_v2_trust_pair_ranges | Intermediate | -- |
int_execution_circles_v2_trust_updates | Intermediate | Raw trust update events from Circles v2 Trust events, normalized into a common schema. |
int_execution_circles_v2_wrapper_tokens | Intermediate | Reference table mapping Circles V2 ERC-20 wrapper addresses to their on-chain token symbol. Rebuilt daily. Symbol is ... |
int_execution_circles_v2_wrapper_transfers | Intermediate | ERC20 Transfer events for Circles v2 wrapper tokens parsed from raw logs. |
int_execution_circles_v2_wrappers | Intermediate | ERC20 wrapper deployments from the ERC20Lift contract, mapping avatars to their wrapper token addresses. |
fct_execution_circles_v2_active_trusts_daily | Fact | Dense daily time series of network-wide active trust relationships. |
fct_execution_circles_v2_avatar_balances_daily | Fact | Materialized daily avatar token balances with dust filtering (> 0.001 CRC). Derived from int_execution_circles_v2_bal... |
fct_execution_circles_v2_avatar_balances_latest | Fact | Latest per-(avatar, token) CRC balance snapshot with an is_wrapped flag |
| indicating whether the token_address is an ER... | ||
fct_execution_circles_v2_avatar_personal_token_supply_latest | Fact | One-row-per-avatar summary of a Circles v2 avatar's own personal CRC |
| token: total circulating supply, how much is wra... | ||
fct_execution_circles_v2_avatar_token_distribution | Fact | Per-avatar distribution of holders of a Circles v2 personal CRC token |
| (the ERC-1155 token whose token_address equals ... | ||
fct_execution_circles_v2_avatar_tokens_held_count | Fact | Per-avatar count of distinct CRC tokens currently held with a balance |
| above the 0.001 CRC dust threshold (1e15 raw we... | ||
fct_execution_circles_v2_avatar_trusts_daily | Fact | Daily cumulative trust statistics per avatar (trusts given and received). |
fct_execution_circles_v2_avatar_trusts_summary | Fact | Latest per-avatar trust summary: trusts given and trusts received as of |
| the last complete day. Materialised daily fro... | ||
fct_execution_circles_v2_avatars | Fact | Dense daily time series of avatar type counts with cumulative totals. |
fct_execution_circles_v2_inviters_ranking | Fact | Leaderboard of top inviters by number of human avatars invited. |
fct_execution_circles_v2_stats_current | Fact | Current aggregate statistics for Circles v2 (avatar, trust, token, wrapper counts). |
fct_execution_circles_v2_supply_by_holder_type_daily | Fact | Daily CRC supply breakdown by holder type (avatar type or Dune label sector). |
fct_execution_circles_v2_tokens_supply_daily | Fact | Compatibility view over int_execution_circles_v2_tokens_supply_daily. Column-level tests and shape live on the inte... |
fct_execution_circles_v2_total_supply_daily | Fact | Network-wide daily total CRC supply aggregated across all tokens. |
fct_execution_circles_v2_trust_relations_current | Fact | Current active trust relations for Circles v2, derived from trust_pair_ranges. |
fct_execution_circles_v2_trusts_distribution | Fact | Distribution histogram of trust degree (given/received) across avatars. |
api_execution_circles_v2_active_trusts_cnt_latest | API | Latest active trust count with 7-day change percentage. |
api_execution_circles_v2_active_trusts_daily | API | API view of daily active trust count time series. |
api_execution_circles_v2_avatar_balances_daily | API | Daily CRC balance per avatar broken down by token (one row per avatar/date/token). |
api_execution_circles_v2_avatar_balances_latest | API | Latest per-(avatar, token) CRC balance snapshot with an is_wrapped flag |
| indicating whether the token_address is an ER... | ||
api_execution_circles_v2_avatar_metadata | API | Per-avatar identity for Circles v2: on-chain registration metadata |
| (avatar type, on-chain name, inviter, token_id, re... | ||
api_execution_circles_v2_avatar_metadata_history | API | Historical timeline of every Circles v2 avatar metadata change. Thin |
| passthrough over int_execution_circles_v2_avatar... | ||
api_execution_circles_v2_avatar_mint_activity_daily | API | Daily personal-mint activity per Circles v2 avatar. |
A Circles v2 personal mint is a Hub TransferSingle event where f... | | api_execution_circles_v2_avatar_personal_token_supply_latest | API | One-row-per-avatar summary of a Circles v2 avatar's own personal CRC token: total circulating supply, how much is wra... | | api_execution_circles_v2_avatar_search | API | Lightweight (avatar, display_name) lookup used by the dashboard global filter to support searching avatars by display... | | api_execution_circles_v2_avatar_token_distribution | API | Per-avatar distribution of holders of a Circles v2 personal CRC token (the ERC-1155 token whose token_address equals ... | | api_execution_circles_v2_avatar_tokens_held_count | API | Per-avatar count of distinct CRC tokens currently held with a balance above the 0.001 CRC dust threshold (1e15 raw we... | | api_execution_circles_v2_avatar_trust_network | API | Trust-network edge list for the Circles v2 Avatar Trust Network panel.
One row per directed trust edge from the pers... | | api_execution_circles_v2_avatar_trust_relations | API | Current active trust relations pivoted to one row per (avatar, counterparty) pair with direction (outgoing, incoming,... | | api_execution_circles_v2_avatar_trusts_daily | API | Daily cumulative trusts given and received per avatar. | | api_execution_circles_v2_avatar_trusts_summary | API | Latest snapshot of cumulative trusts given and received per avatar. | | api_execution_circles_v2_avatars | API | API view of daily avatar type counts and cumulative totals. | | api_execution_circles_v2_avatars_current | API | API view of current Circles v2 avatar registrations. | | api_execution_circles_v2_groups_cnt_latest | API | Latest count of group avatars and 7-day percentage change. | | api_execution_circles_v2_humans_cnt_latest | API | Latest count of human avatars and 7-day percentage change. | | api_execution_circles_v2_orgs_cnt_latest | API | Latest count of organization avatars and 7-day percentage change. | | api_execution_circles_v2_supply_by_holder_type_daily | API | API view of daily CRC supply breakdown by holder type (avatar type or Dune label sector). | | api_execution_circles_v2_total_supply_daily | API | API view of daily network-wide CRC supply. | | api_execution_circles_v2_trust_relations_current | API | API view of current active Circles v2 trust relations. |
Data
| Model | Layer | Description |
|---|---|---|
fct_crawlers_data_distinct_projects_sectors | Fact | This model identifies unique combinations of projects and sectors from crawler data, supporting analysis of project-s... |
api_crawlers_data_distinct_projects_sectors_totals | API | This view aggregates the total number of distinct projects and sectors crawled, providing a high-level overview of da... |
Deposists
| Model | Layer | Description |
|---|---|---|
int_GBCDeposit_deposists_daily | Intermediate | The int_GBCDeposit_deposists_daily view aggregates daily deposit amounts and withdrawal credentials from GBC deposi... |
Ga
| Model | Layer | Description |
|---|---|---|
fct_mixpanel_ga_gpay_crossdomain_daily | Fact | Daily rollup of Gnosis Pay ↔ Mixpanel matching with role-bucket and |
| activity dimensions. |
Privacy boundary: every cro... | | fct_mixpanel_ga_gpay_users | Fact | Per-user fact joining Mixpanel identified users to Gnosis Pay Safes through the keyed-pseudonym identity bridge.
One... | | api_mixpanel_ga_gpay_crossdomain_daily | API | API view (tier3, internal) for Gnosis App Mixpanel to Gnosis Pay cross-domain daily metrics. |
Gnosis
| Model | Layer | Description |
|---|---|---|
int_execution_gnosis_app_gpay_topups | Intermediate | Gnosis App → Gnosis Pay TopUps. |
A TopUp = a CoW Protocol trade initiated by a GA user whose bought token ends up in ... | | int_execution_gnosis_app_gpay_wallets | Intermediate | Gnosis Pay wallets (Safes) that have been or currently are controlled by a Gnosis App user, via the Safe's Zodiac **D... | | int_execution_gnosis_app_marketplace_offers | Intermediate | Gnosis App marketplace offers — one row per non-excluded PaymentGateway created via Circles v2 PaymentGatewayFactory.... | | int_execution_gnosis_app_marketplace_payments | Intermediate | Gnosis App marketplace payments — one row per PaymentReceived event from Circles v2 PaymentGatewayFactory that satisf... | | int_execution_gnosis_app_swaps | Intermediate | Gnosis App swaps — one row per CoW order pre-signed by a GA user through the Cometh ERC-4337 bundler. Matches the Dun... | | int_execution_gnosis_app_token_offer_claims | Intermediate | Gnosis App token-offer claims — one row per OfferClaimed event emitted by any ERC20TokenOfferCycle where the claim ... | | int_execution_gnosis_app_token_offers | Intermediate | Gnosis App token-offer registry — one row per NextOffer instance emitted by the Circles v2 ERC20TokenOfferCycle con... | | int_execution_gnosis_app_user_activity_daily | Intermediate | Foundation table for all Gnosis App user-activity analytics — one row per (date, address, activity_kind). Every downs... | | int_execution_gnosis_app_user_events | Intermediate | Long-form heuristic event log for Gnosis App user identification.
Six rules, all keyed off the same chokepoint: a Co... | | int_execution_gnosis_app_user_identities | Intermediate | Pseudonymization boundary for the Gnosis App sector.
Every address from the snapshot is hashed via pseudonymize_addr... | | int_execution_gnosis_app_users_current | Intermediate | Snapshot of the Gnosis App sector. One row per address that triggered any heuristic, with derived confidence proxy n... | |fct_execution_gnosis_app_activity_by_action_daily| Fact | Daily activity counts, unique users, and USD by activity_kind. Feeds the Activity tab's stacked bar. | |fct_execution_gnosis_app_activity_by_action_monthly| Fact | Monthly activity-by-action. | |fct_execution_gnosis_app_activity_by_action_weekly| Fact | Weekly activity-by-action. | |fct_execution_gnosis_app_churn_monthly| Fact | Monthly churn & retention segments. Two scopes — 'Any' (any non-onboard activity) and 'Swap' (swap_signed/swap_filled... | |fct_execution_gnosis_app_gpay_topups_by_token_daily| Fact | Daily Gnosis App → Gnosis Pay TopUp activity, derived from int_execution_gnosis_app_gpay_topups. Backing fact for api... | |fct_execution_gnosis_app_gpay_topups_cohort_monthly| Fact | First-TopUp cohort × subsequent-TopUp activity retention. cohort_month = month of user's first TopUp. retention_pct =... | |fct_execution_gnosis_app_gpay_topups_monthly| Fact | Monthly topup counts and USD volume (aggregated across tokens). | |fct_execution_gnosis_app_gpay_topups_weekly| Fact | Weekly topup counts and USD volume (aggregated across tokens). | |fct_execution_gnosis_app_gpay_wallets_daily| Fact | Daily cumulative count of Gnosis Pay wallets controlled by a Gnosis App user, split by onboarding class. Backing fact... | |fct_execution_gnosis_app_marketplace_buys_cumulative_daily| Fact | Cumulative marketplace buys and distinct payers per offer, computed as running window sums over a dense (offer × date... | |fct_execution_gnosis_app_marketplace_buys_daily| Fact | Daily marketplace buys per offer, derived from int_execution_gnosis_app_marketplace_payments. Grain (date, offer_name). | |fct_execution_gnosis_app_marketplace_offers_latest| Fact | Latest per-offer totals — one row per curated offer with lifetime n_buys, distinct payers, and first/last buy timesta... | |fct_execution_gnosis_app_retention_by_action_monthly| Fact | Retention split by activity_kind (swap_filled / topup / marketplace_buy / circles_trust / etc.). Uses the GLOBAL onbo... | |fct_execution_gnosis_app_retention_monthly| Fact | Cohort retention grid. cohort_month = month of user's 'onboard' row (first-ever heuristic hit). activity_month = mont... | |fct_execution_gnosis_app_swaps_by_pair_daily| Fact | Daily swap activity sliced by token pair (sold_symbol → bought_symbol). pair is a pre-joined label for dashboard use;... | |fct_execution_gnosis_app_swaps_by_solver_daily| Fact | Daily swap activity sliced by solver (filled trades only). | |fct_execution_gnosis_app_swaps_daily| Fact | Daily Gnosis App swap activity, derived from int_execution_gnosis_app_swaps. Backing fact for api_execution_gnosis_ap... | |fct_execution_gnosis_app_swaps_monthly| Fact | Monthly swap counts and filled USD volume. | |fct_execution_gnosis_app_swaps_weekly| Fact | Weekly swap counts and filled USD volume (bucket = ISO Mon-start). | |fct_execution_gnosis_app_token_offer_claims_by_offer_daily| Fact | Daily token-offer claims sliced by specific offer (nextOffer address). offer_token_symbol surfaces which token was so... | |fct_execution_gnosis_app_token_offer_claims_cohort_monthly| Fact | First-claim cohort × subsequent-claim activity retention. cohort_month = month of user's first token-offer claim. ret... | |fct_execution_gnosis_app_token_offer_claims_daily| Fact | Daily Gnosis App token-offer claim activity, derived from int_execution_gnosis_app_token_offer_claims. One row per da... | |fct_execution_gnosis_app_token_offer_claims_monthly| Fact | Monthly token-offer claim activity. | |fct_execution_gnosis_app_token_offer_claims_weekly| Fact | Weekly token-offer claim activity. | |fct_execution_gnosis_app_user_profile_latest| Fact | Account-facing Gnosis App profile fact from production current-user and GPay wallet ownership models. | |fct_execution_gnosis_app_users_daily| Fact | Daily user counts. new_users = distinct addresses whose first-ever activity hit was on this date; active_users = dist... | |fct_execution_gnosis_app_users_monthly| Fact | Monthly cohort of users. Returning = active this month AND previous month. Reactivated = active this month, inactive ... | |fct_execution_gnosis_app_users_weekly| Fact | Weekly cohort of users (ISO Mon-start). Returning = active this week AND previous week. Reactivated = active this wee... | |api_execution_gnosis_app_activity_by_action_daily| API | FastAPI view over fct_execution_gnosis_app_activity_by_action_daily. Params: activity_kind, start_date, end_date. | |api_execution_gnosis_app_activity_by_action_monthly| API | FastAPI view over fct_execution_gnosis_app_activity_by_action_monthly. | |api_execution_gnosis_app_activity_by_action_weekly| API | FastAPI view over fct_execution_gnosis_app_activity_by_action_weekly. | |api_execution_gnosis_app_churn_monthly| API | FastAPI view over fct_execution_gnosis_app_churn_monthly. Params: scope, start_month, end_month. | |api_execution_gnosis_app_gpay_topups_by_token_daily| API | FastAPI endpoint view of fct_execution_gnosis_app_gpay_topups_by_token_daily. Supports query params: token_bought_sym... | |api_execution_gnosis_app_gpay_topups_cohort_monthly| API | FastAPI view over fct_execution_gnosis_app_gpay_topups_cohort_monthly. Params: start_month, end_month. | |api_execution_gnosis_app_gpay_topups_monthly| API | FastAPI view over fct_execution_gnosis_app_gpay_topups_monthly. | |api_execution_gnosis_app_gpay_topups_weekly| API | FastAPI view over fct_execution_gnosis_app_gpay_topups_weekly. | |api_execution_gnosis_app_gpay_wallets_daily| API | FastAPI endpoint view of fct_execution_gnosis_app_gpay_wallets_daily. Supports query params: onboarding_class, start_... | |api_execution_gnosis_app_kpi_churn_rate_latest| API | KPI: latest-month 'Any'-scope churn rate. | |api_execution_gnosis_app_kpi_dau_latest| API | KPI: DAU yesterday with pct change vs the day before. | |api_execution_gnosis_app_kpi_gp_wallets_imported| API | KPI: cumulative GP wallets imported (pre-existing GP users who added GA). | |api_execution_gnosis_app_kpi_gp_wallets_latest| API | KPI: count of GP wallets currently GA-owned. | |api_execution_gnosis_app_kpi_gp_wallets_onboarded| API | KPI: cumulative GP wallets onboarded via Gnosis App. | |api_execution_gnosis_app_kpi_marketplace_buys_7d| API | KPI: marketplace buys in the last 7 full days. | |api_execution_gnosis_app_kpi_marketplace_buys_total| API | KPI: lifetime marketplace buys across all curated offers. | |api_execution_gnosis_app_kpi_marketplace_payers_7d| API | KPI: distinct marketplace payers in the last 7 full days. | |api_execution_gnosis_app_kpi_mau_latest| API | KPI: MAU for the latest complete month with pct change vs prior. | |api_execution_gnosis_app_kpi_new_users_7d| API | KPI: new users in the last 7 full days with pct change vs prior 7d. | |api_execution_gnosis_app_kpi_repeat_purchase_rate_latest| API | KPI: share of last-30d active users with ≥2 swap_filled or marketplace_buy events. | |api_execution_gnosis_app_kpi_retention_pct_latest| API | KPI: latest-cohort M1 retention %. | |api_execution_gnosis_app_kpi_swap_volume_7d| API | KPI: filled-swap USD volume in the last 7 full days. | |api_execution_gnosis_app_kpi_swaps_7d| API | KPI: signed swap count in the last 7 full days. | |api_execution_gnosis_app_kpi_token_offer_claimers_7d| API | KPI: distinct token-offer claimers in the last 7 full days. | |api_execution_gnosis_app_kpi_token_offer_claims_7d| API | KPI: token-offer claim count in the last 7 full days with pct change vs prior 7d. | |api_execution_gnosis_app_kpi_token_offer_volume_7d| API | KPI: token-offer received-side USD volume in the last 7 full days. | |api_execution_gnosis_app_kpi_topup_volume_7d| API | KPI: topup USD volume in the last 7 full days. | |api_execution_gnosis_app_kpi_topups_7d| API | KPI: topup count in the last 7 full days. | |api_execution_gnosis_app_kpi_total_users| API | KPI: total distinct GA users to date. Returns (value, change_pct). | |api_execution_gnosis_app_marketplace_buys_cumulative_daily| API | FastAPI endpoint view of fct_execution_gnosis_app_marketplace_buys_cumulative_daily. Supports query params: offer_nam... | |api_execution_gnosis_app_marketplace_buys_daily| API | FastAPI endpoint view of fct_execution_gnosis_app_marketplace_buys_daily. Supports query params: offer_name, start_da... | |api_execution_gnosis_app_marketplace_offers_latest| API | FastAPI endpoint view of fct_execution_gnosis_app_marketplace_offers_latest. Supports query param: offer_name. | |api_execution_gnosis_app_retention_by_action_monthly| API | FastAPI view over fct_execution_gnosis_app_retention_by_action_monthly. Params: activity_kind, start_month, end_month. | |api_execution_gnosis_app_retention_monthly| API | FastAPI view over fct_execution_gnosis_app_retention_monthly. Params: start_month, end_month. | |api_execution_gnosis_app_swaps_by_pair_daily| API | FastAPI view over fct_execution_gnosis_app_swaps_by_pair_daily. Params: pair, start_date, end_date. | |api_execution_gnosis_app_swaps_by_solver_daily| API | FastAPI view over fct_execution_gnosis_app_swaps_by_solver_daily. Params: solver, start_date, end_date. | |api_execution_gnosis_app_swaps_daily| API | FastAPI endpoint view of fct_execution_gnosis_app_swaps_daily. Supports query params: start_date, end_date. | |api_execution_gnosis_app_swaps_monthly| API | FastAPI view over fct_execution_gnosis_app_swaps_monthly. | |api_execution_gnosis_app_swaps_weekly| API | FastAPI view over fct_execution_gnosis_app_swaps_weekly. | |api_execution_gnosis_app_token_offer_claims_by_offer_daily| API | FastAPI view over fct_execution_gnosis_app_token_offer_claims_by_offer_daily. Params: offer_address, cycle_address, o... | |api_execution_gnosis_app_token_offer_claims_cohort_monthly| API | FastAPI view over fct_execution_gnosis_app_token_offer_claims_cohort_monthly. Params: start_month, end_month. | |api_execution_gnosis_app_token_offer_claims_daily| API | FastAPI view over fct_execution_gnosis_app_token_offer_claims_daily. Params: start_date, end_date. | |api_execution_gnosis_app_token_offer_claims_monthly| API | FastAPI view over fct_execution_gnosis_app_token_offer_claims_monthly. Params: start_date, end_date. | |api_execution_gnosis_app_token_offer_claims_weekly| API | FastAPI view over fct_execution_gnosis_app_token_offer_claims_weekly. Params: start_date, end_date. | |api_execution_gnosis_app_user_activity_daily| API | Account-facing Gnosis App activity view. | |api_execution_gnosis_app_user_profile_latest| API | Account-facing Gnosis App profile view from production current-user models. | |api_execution_gnosis_app_users_daily| API | FastAPI view over fct_execution_gnosis_app_users_daily. Params: start_date, end_date. | |api_execution_gnosis_app_users_monthly| API | FastAPI view over fct_execution_gnosis_app_users_monthly. Params: start_month, end_month. | |api_execution_gnosis_app_users_weekly` | API | FastAPI view over fct_execution_gnosis_app_users_weekly. Params: start_date, end_date. |
Gpay
| Model | Layer | Description |
|---|---|---|
int_execution_gpay_activity | Intermediate | Incremental model that captures individual Gnosis Pay wallet transactions including payments, deposits, withdrawals, ... |
int_execution_gpay_activity_daily | Intermediate | Incremental model that aggregates Gnosis Pay wallet activity at the daily level, grouped by wallet, action, direction... |
int_execution_gpay_allowances_current | Intermediate | Current allowance state per Gnosis Pay Safe. |
Replays SetAllowance events from int_execution_gpay_roles_events and ke... | | int_execution_gpay_balances_daily | Intermediate | Incremental model that tracks daily token balances for each Gnosis Pay wallet address, with both native and USD values. | | int_execution_gpay_delay_activity_daily | Intermediate | Daily count of TransactionAdded events per GP Safe — the privacy-respecting "user did something admin-y today" signal... | | int_execution_gpay_delay_events | Intermediate | Decoded events emitted by the Zodiac Delay Module proxies attached to GP Safes. Includes:
DelaySetup — modul... | | int_execution_gpay_roles_events | Intermediate | Decoded events from the Zodiac Roles v2 module proxies attached to GP Safes. Includes the events Gnosis Pay actually ... | | int_execution_gpay_safe_identities | Intermediate | PURPOSE
This model is the privacy boundary for the Gnosis Pay ↔ Mixpanel bridge. It produces a lookup table f... | | int_execution_gpay_safe_modules | Intermediate | Current module topology per Gnosis Pay Safe.
Replays int_execution_safes_module_events filtered to GP Safes, keeps t... | | int_execution_gpay_spend_activity_daily | Intermediate | Daily card-spend activity per GP Safe.
Source: int_execution_gpay_spender_events filtered to event_name='Spend'. The... | | int_execution_gpay_spender_delegates_current | Intermediate | Current spender-delegate set per Gnosis Pay Safe.
Replays AssignRoles events from int_execution_gpay_roles_events wi... | | int_execution_gpay_spender_events | Intermediate | Decoded events from the Gnosis Pay Spender module proxies attached to GP Safes. The Spender is GP's custom final gate... | | int_execution_gpay_wallet_owners | Intermediate | Current owner snapshot for Gnosis Pay Safes. Thin filter over int_execution_safes_current_owners (the generic Safe ow... | | int_execution_gpay_wallets | Intermediate | Gnosis Pay Safes derived from on-chain events. A Safe qualifies if it has emitted SafeSetup (so it exists on-chain) A... | | fct_execution_gpay_actions_by_token_daily | Fact | Daily aggregation of Gnosis Pay activity metrics broken down by action type and token, with cumulative totals. | | fct_execution_gpay_actions_by_token_monthly | Fact | Monthly aggregation of Gnosis Pay activity metrics broken down by action type and token, with cumulative totals. | | fct_execution_gpay_actions_by_token_weekly | Fact | Weekly aggregation of Gnosis Pay activity metrics broken down by action type and token, with cumulative totals. | | fct_execution_gpay_activity_daily | Fact | Daily summary of Gnosis Pay ecosystem activity including active users, payments, volume, and funded wallet counts. | | fct_execution_gpay_activity_monthly | Fact | Monthly summary of Gnosis Pay ecosystem activity including active users, payments, volume, and funded wallet counts. | | fct_execution_gpay_activity_weekly | Fact | Weekly summary of Gnosis Pay ecosystem activity including active users, payments, volume, and funded wallet counts. | | fct_execution_gpay_balance_cohorts_daily | Fact | Daily distribution of Gnosis Pay wallet balances segmented into cohort buckets by token, showing holder counts and va... | | fct_execution_gpay_balances_by_token_daily | Fact | Daily aggregate token balances across all Gnosis Pay wallets, in both native and USD values. | | fct_execution_gpay_cashback_cohort_retention_monthly | Fact | Monthly cohort retention analysis for Gnosis Pay cashback recipients, tracking user counts and retention percentages ... | | fct_execution_gpay_cashback_dist_weekly | Fact | Weekly distribution of Gnosis Pay cashback amounts using percentile statistics. | | fct_execution_gpay_cashback_impact_monthly | Fact | Monthly analysis of cashback impact on Gnosis Pay user segments, comparing payment behavior between cashback and non-... | | fct_execution_gpay_cashback_recipients_weekly | Fact | Weekly count of unique Gnosis Pay cashback recipients. | | fct_execution_gpay_churn_monthly | Fact | Monthly user churn and retention analysis for Gnosis Pay, breaking down users into new, retained, returning, and chur... | | fct_execution_gpay_flows_snapshot | Fact | Snapshot of token flow patterns between Gnosis Pay wallet labels across different time windows. | | fct_execution_gpay_kpi_monthly | Fact | Monthly key performance indicators for Gnosis Pay including MAU, payment volume, deposits, withdrawals, cashback, and... | | fct_execution_gpay_owner_balances_by_token_daily | Fact | Daily aggregate token balances across Gnosis Pay wallet owners (as opposed to wallet addresses), in both native and U... | | fct_execution_gpay_payments_hourly | Fact | Hourly payment counts for Gnosis Pay broken down by token symbol. | | fct_execution_gpay_retention_by_action_monthly | Fact | Monthly cohort retention analysis for Gnosis Pay users broken down by action type, tracking user counts and retention... | | fct_execution_gpay_retention_monthly | Fact | Monthly cohort retention analysis for all Gnosis Pay activity, tracking user counts and retention percentages over time. | | fct_execution_gpay_snapshots | Fact | Summary snapshot metrics for Gnosis Pay across different time windows (All, 7D), providing headline KPIs with percent... | | fct_execution_gpay_user_balances_latest | Fact | Latest Gnosis Pay wallet balances by token for portfolio lookups. | | fct_execution_gpay_user_lifetime_metrics | Fact | Lifetime metrics for each Gnosis Pay wallet, including tenure, activity counts, payment volumes, and cashback totals. | | api_execution_gpay_active_users_7d | API | 7-day active user count with period-over-period change percentage for Gnosis Pay. | | api_execution_gpay_active_users_weekly | API | Weekly time series of Gnosis Pay active user counts. | | api_execution_gpay_activity_by_action_daily | API | Daily Gnosis Pay activity metrics broken down by action type, with counts and volumes. | | api_execution_gpay_activity_by_action_monthly | API | Monthly Gnosis Pay activity metrics broken down by action type, with counts and volumes. | | api_execution_gpay_activity_by_action_weekly | API | Weekly Gnosis Pay activity metrics broken down by action type, with counts and volumes. | | api_execution_gpay_balance_cohorts_holders_daily | API | Daily count of Gnosis Pay wallet holders in each balance cohort bucket by token. | | api_execution_gpay_balance_cohorts_value_daily | API | Daily total value held in each balance cohort bucket by token, in native and USD. | | api_execution_gpay_balances_by_token_daily | API | Daily total Gnosis Pay wallet balances by token in USD. | | api_execution_gpay_balances_native_daily | API | Daily total Gnosis Pay wallet balances by token in native units. | | api_execution_gpay_balances_usd_daily | API | Daily total Gnosis Pay wallet balances by token in USD. | | api_execution_gpay_cashback_7d | API | 7-day cashback summary with unit breakdown and period-over-period change percentage. | | api_execution_gpay_cashback_cohort_retention_monthly | API | Monthly cashback cohort retention heatmap data showing retention and amount percentages across cohorts. | | api_execution_gpay_cashback_cohort_retention_users_monthly | API | Monthly cashback cohort sizes over time, formatted for time series visualization. | | api_execution_gpay_cashback_cumulative | API | Cumulative cashback distributed over time by unit. | | api_execution_gpay_cashback_dist_weekly | API | Weekly cashback distribution percentiles for Gnosis Pay users. | | api_execution_gpay_cashback_impact_monthly | API | Monthly cashback impact analysis comparing payment behavior between user segments. Passes through all columns from th... | | api_execution_gpay_cashback_recipients_7d | API | 7-day unique cashback recipient count with period-over-period change percentage. | | api_execution_gpay_cashback_recipients_total | API | All-time total count of unique Gnosis Pay cashback recipients. | | api_execution_gpay_cashback_recipients_weekly | API | Weekly time series of unique Gnosis Pay cashback recipient counts. | | api_execution_gpay_cashback_total | API | All-time total cashback distributed by unit. | | api_execution_gpay_cashback_weekly | API | Weekly cashback amounts distributed by unit. | | api_execution_gpay_churn_monthly | API | Monthly user churn breakdown for Gnosis Pay showing user segments and rates by activity scope. | | api_execution_gpay_churn_rates_monthly | API | Monthly churn and retention rates for Gnosis Pay by activity scope. | | api_execution_gpay_flows_snapshot | API | Token flow patterns between Gnosis Pay wallet labels for API consumption. | | api_execution_gpay_funded_addresses_daily | API | Daily time series of cumulative funded Gnosis Pay wallet addresses. | | api_execution_gpay_funded_addresses_monthly | API | Monthly time series of cumulative funded Gnosis Pay wallet addresses. | | api_execution_gpay_funded_addresses_weekly | API | Weekly time series of cumulative funded Gnosis Pay wallet addresses. | | api_execution_gpay_gno_balance_daily | API | Daily total GNO token balance across all Gnosis Pay wallets. | | api_execution_gpay_gno_total_balance | API | Current total GNO token balance across all Gnosis Pay wallets. | | api_execution_gpay_kpi_monthly | API | Monthly KPIs for Gnosis Pay, passing through all columns from the fact model. | | api_execution_gpay_owner_balances_by_token_daily | API | Daily total Gnosis Pay owner balances by token in USD. | | api_execution_gpay_owner_total_balance | API | Current total balance across all Gnosis Pay wallet owners in USD. | | api_execution_gpay_payments_7d | API | 7-day payment count with period-over-period change percentage. | | api_execution_gpay_payments_by_token_daily | API | Daily payment counts by token for Gnosis Pay. | | api_execution_gpay_payments_by_token_monthly | API | Monthly payment counts by token for Gnosis Pay. | | api_execution_gpay_payments_by_token_weekly | API | Weekly payment counts by token for Gnosis Pay. | | api_execution_gpay_payments_hourly | API | Hourly payment counts by token for Gnosis Pay. | | api_execution_gpay_retention_by_action_monthly | API | Monthly cohort retention heatmap data for Gnosis Pay broken down by action type. | | api_execution_gpay_retention_by_action_users_monthly | API | Monthly cohort user counts over time by action type, formatted for time series visualization. | | api_execution_gpay_retention_monthly | API | Monthly cohort user counts over time, formatted for time series visualization. | | api_execution_gpay_retention_pct_monthly | API | Monthly cohort retention heatmap data for all Gnosis Pay activity. | | api_execution_gpay_retention_volume_monthly | API | Monthly cohort volume retention over time, formatted for time series visualization. | | api_execution_gpay_total_balance | API | Current total balance across all Gnosis Pay wallets in USD. | | api_execution_gpay_total_funded | API | All-time total count of funded Gnosis Pay wallets (users who made at least one payment). | | api_execution_gpay_total_payments | API | All-time total count of Gnosis Pay payments. | | api_execution_gpay_total_volume | API | All-time total payment volume for Gnosis Pay in USD. | | api_execution_gpay_user_activity | API | Individual transaction-level activity for a specific Gnosis Pay user, filtered by wallet address. | | api_execution_gpay_user_balances_daily | API | Daily token balances for a specific Gnosis Pay user in native and USD values. | | api_execution_gpay_user_balances_latest | API | Simple API view over latest Gnosis Pay wallet balances. | | api_execution_gpay_user_cashback_daily | API | Daily cashback amounts for a specific Gnosis Pay user. | | api_execution_gpay_user_lifetime_metrics | API | Lifetime metrics for a specific Gnosis Pay user, passing through all columns from the fact model. | | api_execution_gpay_user_payments_daily | API | Daily payment amounts by token for a specific Gnosis Pay user. | | api_execution_gpay_user_top_wallets | API | -- | | api_execution_gpay_user_total_cashback | API | All-time total cashback for a specific Gnosis Pay user. | | api_execution_gpay_user_total_payments | API | All-time total payment count for a specific Gnosis Pay user. | | api_execution_gpay_user_total_volume | API | All-time total payment volume for a specific Gnosis Pay user. | | api_execution_gpay_volume_7d | API | 7-day payment volume with period-over-period change percentage. | | api_execution_gpay_volume_payments_by_token_daily | API | Daily payment volume by token in USD for Gnosis Pay. | | api_execution_gpay_volume_payments_by_token_monthly | API | Monthly payment volume by token in USD for Gnosis Pay. | | api_execution_gpay_volume_payments_by_token_weekly | API | Weekly payment volume by token in USD for Gnosis Pay. | | api_execution_gpay_wallet_balance_composition | API | Current balance composition of a Gnosis Pay wallet by token. |
Lending
| Model | Layer | Description |
|---|---|---|
int_execution_lending_aave_balance_cohorts_daily | Intermediate | Daily lender balance cohort distributions per (protocol, reserve) across Aave V3 and SparkLend on Gnosis. Buckets use... |
int_execution_lending_aave_daily | Intermediate | Daily lending metrics per (protocol, reserve) on Gnosis Chain, covering both Aave V3 and SparkLend. Includes supply/b... |
int_execution_lending_aave_diffs_daily | Intermediate | Daily per-user scaled balance deltas for Gnosis lending markets (Aave V3 |
| and SparkLend). Computes scaled deltas from ... | ||
int_execution_lending_aave_user_balances_daily | Intermediate | Daily per-user aToken balances across Gnosis lending markets (Aave V3 and |
| SparkLend). Reads scaled deltas from int_ex... | ||
int_execution_lending_aave_utilization_daily | Intermediate | Daily utilization rate per (protocol, reserve) across Aave V3 and SparkLend. |
| Computes cumulative scaled supply/borrow... | ||
fct_execution_lending_latest | Fact | Lender / borrower counts per (window, protocol, token) plus protocol-scoped |
| 'ALL'-tokens rows and an all-protocols 'A... | ||
fct_execution_lending_top_lenders_latest | Fact | Latest-day snapshot of top lending suppliers with concentration metrics, 7-day balance change, and address labels. On... |
fct_execution_lending_top_lenders_ranked | Fact | Latest-day snapshot of lending suppliers ranked by USD balance within each (protocol, symbol) pair. Top 500 per pair.... |
fct_execution_lending_weekly | Fact | -- |
api_execution_lending_activity_counts_weekly | API | -- |
api_execution_lending_activity_volumes_weekly | API | -- |
api_execution_lending_balance_cohorts_holders_daily | API | Daily lender count by balance cohort per (protocol, token) across Aave V3 and SparkLend. Stacked bar chart data showi... |
api_execution_lending_balance_cohorts_value_daily | API | Daily lender balance cohort values per (protocol, token) across Aave V3 and SparkLend. Stacked bar chart data showing... |
api_execution_lending_borrowers_count_7d | API | -- |
api_execution_lending_daily | API | -- |
api_execution_lending_lenders_count_7d | API | KPI view of currently-active lenders on Gnosis (Aave V3, SparkLend). |
| "Active lenders" is a STOCK measure — unique wal... | ||
api_execution_lending_top_lenders_latest | API | Thin API view over fct_execution_lending_top_lenders_latest. Dashboard applies token and protocol filters as needed. |
api_execution_lending_tvl_by_token_latest | API | Latest lending TVL per reserve token on Gnosis (aggregated across Aave V3 and SparkLend) for pie chart display. Each ... |
Modules
| Model | Layer | Description |
|---|---|---|
contracts_gpay_modules_registry | CONTRACTS | Cross-referenced registry of every Zodiac module proxy that is currently |
| or was ever enabled on a Gnosis Pay Safe. |
T... |
Network
| Model | Layer | Description |
|---|---|---|
fct_execution_network_retention_monthly | Fact | Per-cohort monthly network retention. A cohort is the set of addresses |
| whose first successful transaction landed in a... |
Pools
| Model | Layer | Description |
|---|---|---|
int_execution_pools_balancer_v2_daily | Intermediate | Daily Balancer V2 pool token balances with oracle price enrichment. Built from delta events (PoolBalanceChanged, Swap... |
int_execution_pools_balancer_v3_daily | Intermediate | Daily Balancer V3 pool token balances with oracle price enrichment. |
| Built from delta events (LiquidityAdded, Liquidit... | ||
int_execution_pools_balances_daily | Intermediate | Combined daily pool token balances across all DEX protocols. Thin UNION ALL of the four protocol-level models (Uniswa... |
int_execution_pools_dex_liquidity_events | Intermediate | Individual LP add/remove/collect events across all protocols on Gnosis Chain. One row per (event, token) — not pivote... |
int_execution_pools_dex_trades | Intermediate | DEX swap events enriched with USD prices and transaction context. Source of truth for trade-level analytics with USD ... |
int_execution_pools_dex_trades_raw | Intermediate | Raw DEX swap events across all protocols on Gnosis Chain. One row per swap with token metadata (symbol, decimals, hum... |
int_execution_pools_dex_trades_tx_context | Intermediate | Thin lookup mapping swap transaction hashes to sender (tx_from) and recipient (tx_to). Only contains transactions tha... |
int_execution_pools_fees_daily | Intermediate | Daily accrued pool fees and trading volume at pool x token grain for Uniswap V3, |
| Swapr V3, and Balancer V3 pools, com... | ||
int_execution_pools_il_swap_flows_daily | Intermediate | Daily pool-level base data for LVR computation. Combines swap flows (signed int256 token amounts), fees, TVL, and per... |
int_execution_pools_lps_daily | Intermediate | Daily LP provider activity from Mint and Burn events on Uniswap V3 and Swapr V3 pools. Tracks event counts, daily uni... |
int_execution_pools_metrics_daily | Intermediate | Pool-level daily metrics: TVL, fees, volume, swap count, and 7D trailing fee APR. Aggregates token-level TVL from the... |
int_execution_pools_swapr_v3_daily | Intermediate | Daily Swapr V3 pool token balances with oracle price enrichment. |
| Built from event deltas (Mint, Burn, Swap, Collect, ... | ||
int_execution_pools_uniswap_v3_daily | Intermediate | Daily Uniswap V3 pool token balances with oracle price enrichment. Built from event deltas (Mint, Burn, Swap, Collect... |
fct_execution_pools_daily | Fact | Daily pool-level metrics for top Uniswap V3, Swapr V3, and Balancer V3 pools on |
| Gnosis Chain, including TVL (USD), ac... | ||
fct_execution_pools_il_daily | Fact | Pool-level Loss Versus Rebalancing (LVR) from actual swap flows. LVR measures the cost LPs pay to arbitrageurs — the ... |
fct_execution_pools_lps_latest | Fact | Unique LP provider counts per token over rolling time windows with change_pct vs prior window. Mirrors the lending pa... |
fct_execution_pools_snapshots | Fact | Snapshot KPI table for pool yields. Each row is a (token, metric) pair with the latest value and 7-day percentage cha... |
fct_execution_pools_tvl_token_daily | Fact | Per-token TVL composition within pools with server-side denomination. Three TVL columns are pre-computed: tvl_usd (co... |
api_execution_pools_fee_apr_7d_daily | API | API view for fee APR (7D trailing) time series by token and pool label (Uniswap V3/Swapr V3 only). Uses accrued fees ... |
api_execution_pools_fees_7d | API | -- |
api_execution_pools_fees_usd_daily | API | API view for daily fee revenue (USD) by token and pool, sourced from fct_execution_pools_daily. |
api_execution_pools_lp_activity_daily | API | API view for daily LP activity (Mint/Burn event counts) per pool per token, unpivoted into one row per event type for... |
api_execution_pools_lps_count_7d | API | API view for unique LP provider count over the last 7 days per token. |
api_execution_pools_net_apr_daily | API | API view for net APR (fee APR plus LVR) time series by token and pool label, with fee APR and LVR components. |
api_execution_pools_swap_count_daily | API | API view for daily swap event count by token and pool, sourced from fct_execution_pools_daily. |
api_execution_pools_tvl_by_pool_latest | API | -- |
api_execution_pools_tvl_daily | API | API view for pool TVL (USD) time series by token and pool label. |
api_execution_pools_tvl_latest | API | -- |
api_execution_pools_tvl_token_daily | API | -- |
api_execution_pools_volume_7d | API | API view for 7-day total trading volume per token (snapshot from fct_execution_pools_snapshots). |
api_execution_pools_volume_daily | API | API view for daily trading volume (USD) by token and pool, sourced from fct_execution_pools_daily. |
Registry
| Model | Layer | Description |
|---|---|---|
contracts_safe_registry | CONTRACTS | Registry consumed by decode_logs(contract_address_ref=ref('contracts_safe_registry')). |
| Maps each Safe proxy → the sin... |
Rwa
| Model | Layer | Description |
|---|---|---|
int_execution_rwa_backedfi_prices | Intermediate | The model aggregates daily closing prices for various backed financial instruments from Oracle event data, supporting... |
fct_execution_rwa_backedfi_prices_daily | Fact | The fct_execution_rwa_backedfi_prices_daily view consolidates daily price data for various backed finance instruments... |
api_execution_rwa_backedfi_prices_daily | API | The api_execution_rwa_backedfi_prices_daily model provides daily pricing data for RWA-backed financial instruments to... |
Safe
| Model | Layer | Description |
|---|---|---|
api_execution_safe_details_latest | API | One row per Safe contract with deployment metadata + current-owner-count |
| + current-threshold. Powers the Safe-section... |
Safes
| Model | Layer | Description |
|---|---|---|
int_execution_safes | Intermediate | Gnosis Safe deployments on Gnosis Chain. |
A Safe is deployed by the SafeProxyFactory as a minimal proxy that delegate... | | int_execution_safes_current_owners | Intermediate | Current owner set per Safe.
For each (safe_address, owner) pair, take the latest event by (block_number, log_index).... | | int_execution_safes_module_events | Intermediate | Long-form log of module-state and guard-state mutations on every Safe in contracts_safe_registry.
event_kind ∈ (enab... | | int_execution_safes_owner_events | Intermediate | Long-form ownership-event log for every Safe in contracts_safe_registry.
All ABI decoding is delegated to decode_log... | | api_execution_safes_current_owners | API | Per-Safe owner list (add-only snapshot). One row per (safe, owner) pair where the last observed event for that pair i... |
Savings
| Model | Layer | Description |
|---|---|---|
int_yields_savings_xdai_rate_daily | Intermediate | Canonical daily Savings xDAI vault rate for the Gnosis Savings xDAI vault |
| (0xaf204776c7245bF4147c2612BF6e5972Ee483701... | ||
fct_yields_savings_xdai_apy_daily | Fact | Canonical Savings xDAI APY mart. Long-format output with one row per |
| (date, label) where label ∈ {'Daily','7DMA','30D... |
Sdai
| Model | Layer | Description |
|---|---|---|
int_yields_sdai_rate_daily | Intermediate | Legacy compatibility wrapper over int_yields_savings_xdai_rate_daily. |
| Preserves the historical (date, sdai_conversion... | ||
fct_yields_sdai_apy_daily | Fact | Legacy compatibility wrapper over fct_yields_savings_xdai_apy_daily. |
| Preserves the historical (date, apy, label) shap... |
State
| Model | Layer | Description |
|---|---|---|
int_execution_state_size_full_diff_daily | Intermediate | This model calculates the daily net change in storage size for execution states by aggregating storage diffs, support... |
fct_execution_state_full_size_daily | Fact | The fct_execution_state_full_size_daily model aggregates daily cumulative bytes of execution state data, providing in... |
api_execution_state_full_size_daily | API | The api_execution_state_full_size_daily model provides daily aggregated data on the size of API execution states, fac... |
Storage
| Model | Layer | Description |
|---|---|---|
stg_execution__storage_diffs | Staging | The stg_execution__storage_diffs model captures storage difference events from blockchain execution transactions, ena... |
Swapr
| Model | Layer | Description |
|---|---|---|
stg_pools__swapr_v3_events | Staging | Normalized event deltas for Swapr V3 (Algebra) pools. Same structure as stg_pools__uniswap_v3_events. |
Token
| Model | Layer | Description |
|---|---|---|
int_execution_token_prices_daily | Intermediate | The int_execution_token_prices_daily view consolidates daily price data for various tokens and stablecoins used in ... |
Tokens
| Model | Layer | Description |
|---|---|---|
stg_pools__tokens_meta | Staging | Normalized token metadata from the tokens_whitelist seed. Provides lowercase address, uppercase symbol (nullable via ... |
int_execution_tokens_address_diffs_daily | Intermediate | This model calculates daily net address-level token transfer deltas, capturing inflows and outflows for each address ... |
int_execution_tokens_balance_cohorts_daily | Intermediate | Daily token balance cohort distributions, segmenting holders into balance buckets. |
int_execution_tokens_balances_by_sector_daily | Intermediate | Daily balances aggregated by sector labels for each token. |
int_execution_tokens_balances_daily | Intermediate | Daily token balances per address with USD valuation. Reads native balances from int_execution_tokens_balances_native_... |
int_execution_tokens_balances_native_daily | Intermediate | Daily cumulative native-token balances per address. Holds the heavy running-sum compute; does not include USD pricing... |
int_execution_tokens_supply_holders_daily | Intermediate | Daily supply and holder counts aggregated by token. |
int_execution_tokens_transfers_daily | Intermediate | The int_execution_tokens_transfers_daily model aggregates daily transfer metrics for tokens, providing insights into ... |
fct_execution_tokens_metrics_daily | Fact | -- |
fct_execution_tokens_overview_by_class_latest | Fact | -- |
fct_execution_tokens_supply_by_sector_latest | Fact | -- |
fct_execution_tokens_supply_distribution_latest | Fact | -- |
fct_execution_tokens_top_holders_latest | Fact | Latest-day snapshot of token holders ranked by USD balance, with concentration metrics (pct_of_total, cumulative_pct)... |
fct_execution_tokens_top_holders_ranked | Fact | Latest-day snapshot of token holders ranked by USD balance with pct_of_total, filtered to top 500 per token. No joins... |
api_execution_tokens_active_senders_daily | API | This view provides daily counts of active senders per API token, enabling analysis of token engagement over time. |
api_execution_tokens_balance_cohorts_holders_daily | API | This view provides daily snapshots of token balance cohort distributions among holders, enabling analysis of holder s... |
api_execution_tokens_balance_cohorts_value_daily | API | This view aggregates daily token balance cohort values, segmented by balance buckets, to support analysis of token ho... |
api_execution_tokens_balances_daily | API | -- |
api_execution_tokens_holders_daily | API | The api_execution_tokens_holders_daily model provides daily aggregated data on the number of unique token holders for... |
api_execution_tokens_holders_latest_by_token | API | This model provides the latest snapshot of the number of holders for each API token, aggregated by token symbol, to s... |
api_execution_tokens_overview_latest | API | -- |
api_execution_tokens_supply_by_sector_latest | API | -- |
api_execution_tokens_supply_daily | API | The api_execution_tokens_supply_daily model provides daily aggregated data on the supply of different API tokens, sup... |
api_execution_tokens_supply_distribution_latest | API | -- |
api_execution_tokens_supply_latest_by_token | API | This model provides the latest supply values for each API token based on daily recorded data, enabling tracking of to... |
api_execution_tokens_top_holders_latest | API | Thin API view over fct_execution_tokens_top_holders_latest. Returns all holders ranked by balance, with concentration... |
api_execution_tokens_volume_daily | API | The api_execution_tokens_volume_daily model provides daily aggregated data on the trading volume of different tokens ... |
Transactions
| Model | Layer | Description |
|---|---|---|
int_execution_transactions_by_project_alltime_state | Intermediate | This model aggregates execution transaction data by project and month, providing insights into transaction volume, fe... |
int_execution_transactions_by_project_daily | Intermediate | This model aggregates daily execution transaction data by project, providing insights into transaction volume, user e... |
int_execution_transactions_by_project_hourly_recent | Intermediate | This model aggregates hourly execution transaction data by project for the recent two-day period, providing insights ... |
int_execution_transactions_cumulative_daily | Intermediate | Daily time series of new and cumulative unique active accounts. Derived from the unique addresses table, provides exa... |
int_execution_transactions_daily_active_addresses | Intermediate | Daily active address hashes — one row per unique sender address per active day. Used for memory-efficient windowed ac... |
int_execution_transactions_info_daily | Intermediate | The int_execution_transactions_info_daily model aggregates daily transaction data from the execution layer, providi... |
int_execution_transactions_unique_addresses | Intermediate | Incremental table of every unique transaction sender address hash with the date it was first seen. Used to compute ex... |
fct_execution_transactions_by_project_monthly_top5 | Fact | This model aggregates and ranks execution transactions by project on a monthly basis, highlighting the top 5 projects... |
fct_execution_transactions_by_project_snapshots | Fact | This model aggregates transaction, fee, and active account data by project over various time windows, enabling compar... |
fct_execution_transactions_by_sector_daily | Fact | The fct_execution_transactions_by_sector_daily model aggregates daily execution transaction data by sector to support... |
fct_execution_transactions_by_sector_weekly | Fact | The fct_execution_transactions_by_sector_weekly model aggregates weekly transaction data by sector to support busines... |
fct_execution_transactions_snapshots | Fact | This table provides snapshot metrics of execution transactions, including counts, fees, and active account counts ove... |
api_execution_transactions_7d | API | The api_execution_transactions_7d model provides a snapshot of the total number of API execution transactions and the... |
api_execution_transactions_active_accounts_7d | API | This view provides a snapshot of the number of active accounts involved in API transactions over the last 7 days, ena... |
api_execution_transactions_active_accounts_by_project_monthly_top5 | API | This view aggregates the number of active accounts involved in API execution transactions, focusing on the top 5 proj... |
api_execution_transactions_active_accounts_by_project_ranges_top20 | API | This model identifies the top 20 project ranges with the highest number of active accounts over different time window... |
api_execution_transactions_active_accounts_by_project_total | API | This view provides a snapshot of the total number of active accounts involved in API execution transactions across al... |
api_execution_transactions_active_accounts_by_sector_daily | API | This view provides daily counts of active accounts involved in API transaction initiations, segmented by sector, to m... |
api_execution_transactions_active_accounts_by_sector_hourly | API | This view aggregates the count of active accounts involved in API execution transactions, segmented by sector and hou... |
api_execution_transactions_active_accounts_by_sector_weekly | API | This view provides weekly counts of active accounts involved in API execution transactions, segmented by sector, to s... |
api_execution_transactions_active_accounts_total | API | The api_execution_transactions_active_accounts_total model provides a snapshot of the total number of active accoun... |
api_execution_transactions_by_project_monthly_top5 | API | This view aggregates the top 5 projects by transaction count on a monthly basis, enabling analysis of project activit... |
api_execution_transactions_by_project_ranges_top20 | API | This view aggregates the top 20 API transaction counts per project within specified time ranges, providing insights i... |
api_execution_transactions_by_project_total | API | This view aggregates the total number of API execution transactions across all projects over the entire time period, ... |
api_execution_transactions_by_sector_daily | API | The api_execution_transactions_by_sector_daily model provides daily aggregated counts of API execution transactions c... |
api_execution_transactions_by_sector_hourly | API | This view aggregates the total number of API execution transactions per sector on an hourly basis, providing insights... |
api_execution_transactions_by_sector_weekly | API | The api_execution_transactions_by_sector_weekly model aggregates the number of API execution transactions per sector ... |
api_execution_transactions_cnt_daily | API | The api_execution_transactions_cnt_daily model provides a daily summary of successful API transaction counts categori... |
api_execution_transactions_cnt_total | API | This view aggregates the total number of successful API transactions grouped by transaction type across all time, pro... |
api_execution_transactions_fees_native_7d | API | The api_execution_transactions_fees_native_7d model provides a snapshot of native transaction fees and their percenta... |
api_execution_transactions_fees_native_by_project_monthly_top5 | API | This view aggregates the top 5 projects by native transaction fees on a monthly basis, providing insights into fee di... |
api_execution_transactions_fees_native_by_project_ranges_top20 | API | This view aggregates the top 20 native API transaction fee buckets by project for different time ranges, providing in... |
api_execution_transactions_fees_native_by_project_total | API | This view aggregates total native execution transaction fees per project over the entire available time span, enablin... |
api_execution_transactions_fees_native_by_sector_daily | API | This view aggregates daily native transaction fees by sector, providing insights into sector-specific fee trends over... |
api_execution_transactions_fees_native_by_sector_hourly | API | This view aggregates native transaction fees by sector on an hourly basis, providing insights into fee distribution a... |
api_execution_transactions_fees_native_by_sector_weekly | API | This view aggregates native transaction fees by sector on a weekly basis to support analysis of fee trends across dif... |
api_execution_transactions_fees_native_total | API | The api_execution_transactions_fees_native_total model aggregates total native execution transaction fees over all ... |
api_execution_transactions_gas_share_by_project_daily | API | This view calculates the daily share of gas used by each project in relation to the total gas consumption across all ... |
api_execution_transactions_gas_used_daily | API | This view aggregates daily gas consumption and pricing metrics for successful API transaction executions, facilitatin... |
api_execution_transactions_gas_used_weekly | API | This view aggregates weekly gas usage for successful API transactions, categorized by transaction type, to support pe... |
api_execution_transactions_total | API | The api_execution_transactions_total model provides a consolidated count of API execution transactions over the entir... |
api_execution_transactions_value_daily | API | This view aggregates daily transaction values for API executions on the xDai network, providing insights into transac... |
Transfers
| Model | Layer | Description |
|---|---|---|
int_execution_transfers_whitelisted_daily | Intermediate | The int_execution_transfers_whitelisted_daily model aggregates daily whitelisted token transfer data, including dep... |
Uniswap
| Model | Layer | Description |
|---|---|---|
stg_pools__uniswap_v3_events | Staging | Normalized event deltas for Uniswap V3 pools. Parses Mint, Burn, Swap, Collect, Flash events into signed token deltas... |
V3
| Model | Layer | Description |
|---|---|---|
stg_pools__v3_current_tick | Staging | Latest tick per V3 pool derived from the most recent Swap event. Used to determine whether concentrated-liquidity LP ... |
stg_pools__v3_pool_registry | Staging | Complete registry of Uniswap V3 and Swapr V3 (Algebra) pools on Gnosis Chain. |
| Combines factory creation events (PoolC... |
Yields
| Model | Layer | Description |
|---|---|---|
int_execution_yields_user_activity | Intermediate | Unified yield activity feed combining LP events (Add/Remove Liquidity, Collect Fees) from the pools pipeline and lend... |
int_execution_yields_user_lp_positions | Intermediate | Per-user LP position summary across all DEX protocols. One row per (provider, pool_address, tick_lower, tick_upper). ... |
fct_execution_yields_opportunities_latest | Fact | Combined yield opportunities table for LP pools and lending markets. Ranked by yield for quick comparison. |
fct_execution_yields_overview_snapshot | Fact | -- |
fct_execution_yields_user_fee_collections_daily | Fact | Daily fee collection amounts per user per pool from V3 Collect events. Feeds the fee income chart in the user portfol... |
fct_execution_yields_user_lending_positions_latest | Fact | Current Aave V3 lending positions per user with supply APY from the yields opportunities table. One row per (user, re... |
fct_execution_yields_user_lifetime_metrics | Fact | Per-wallet lifetime KPI metrics for the yields user portfolio. Aggregates across LP positions (fees, active/in-range ... |
api_execution_yields_opportunities_latest | API | -- |
api_execution_yields_overview_lending_best_apy | API | -- |
api_execution_yields_overview_lending_lenders | API | -- |
api_execution_yields_overview_lending_tvl | API | Overview KPI card for total Aave V3 lending TVL with 7-day change percentage. |
api_execution_yields_overview_lp_best_apr | API | -- |
api_execution_yields_overview_lp_tvl | API | -- |
api_execution_yields_overview_sdai_apy | API | -- |
api_execution_yields_overview_sdai_supply | API | -- |
api_execution_yields_user_activity | API | -- |
api_execution_yields_user_fee_collections_daily | API | -- |
api_execution_yields_user_kpis | API | -- |
api_execution_yields_user_lending_balances_daily | API | -- |
api_execution_yields_user_lending_positions | API | -- |
api_execution_yields_user_lp_positions | API | -- |
api_execution_yields_user_top_wallets | API | -- |
Zodiac
| Model | Layer | Description |
|---|---|---|
int_execution_zodiac_module_proxies | Intermediate | Catalogue of every Zodiac module proxy ever deployed on Gnosis Chain. |
Decoded directly from the canonical Zodiac Mod... |
Query Examples¶
Retrieve daily transaction counts for the past 30 days:
SELECT dt, txs, gas_used, success_rate
FROM dbt.api_execution_transactions_daily
WHERE dt >= today() - 30
ORDER BY dt
Check gas price trends:
SELECT dt, avg_gas_price, median_gas_price, p95_gas_price
FROM dbt.api_execution_gas_daily
WHERE dt >= today() - 7
ORDER BY dt