Execution Module¶

The Execution module is the largest module in dbt-cerebro. 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, tokens, DeFi yield tracking, Gnosis Pay, and Circles.

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

Accounts

Address

Auto

Avatars

Balancer

Blocks

Bridges

Cashback

Cashbacks

Circles

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_backers_cumulative_daily | API | Time-series view of trust-defined EVER-BACKED cumulative backers (ignores revocation); latest day excluded. For the r... | | api_execution_circles_v2_backers_current_daily | API | Time-series of currently-trusted (revocation-aware) backers; latest day excluded. Distinct from api:circles_v2_backer... | | api_execution_circles_v2_backing_depositors_current | API | Snapshot of distinct depositor addresses. | | api_execution_circles_v2_backing_events_daily | API | Time-series of Circles v2 backing-lifecycle events, by stage. | | api_execution_circles_v2_balance_cohorts_daily | API | Daily wealth distribution: distinct CRC holders bucketed by balance tier (0-1 / 1-10 / 10-100 / 100-1k / 1k-10k / 10k... | | api_execution_circles_v2_crc20_prices_daily | API | Public daily price view for CRC20 wrapper tokens, consolidated across all pools. One row per (date, crc20_token) with... | | api_execution_circles_v2_economically_active_avatars_weekly | API | Weekly economically active Circles avatars (ecosystem-wide, circles-first definition) by earning_kind, with the in-ap... | | api_execution_circles_v2_gcrc_cashback_cumulative | API | Cumulative Circles v2 gCRC cashback over time, one row per week: the running total gCRC distributed and the running c... | | api_execution_circles_v2_gcrc_cashback_recipients_ranking | API | Top 100 lifetime recipients of Circles v2 gCRC cashback, ranked by total amount received, enriched with each recipien... | | api_execution_circles_v2_gcrc_cashback_total | API | Lifetime (single-row) Circles v2 gCRC cashback totals for KPI tiles: the cumulative cashback amount distributed and t... | | api_execution_circles_v2_gcrc_cashback_weekly | API | Weekly Circles v2 gCRC cashback distribution: distinct recipient count and total gCRC amount sent from the cashback w... | | api_execution_circles_v2_group_collateral_daily | API | Per-group daily member-CRC collateral (native units). | | api_execution_circles_v2_group_explorer_profile | API | One row per Circles v2 group: identity, on-chain handlers, and snapshot KPIs (members, supply, wrapped %, collateral,... | | api_execution_circles_v2_group_holders | API | Holders of a group's token, resolving both native ERC-1155 and ERC-20 wrapper legs (wrapper mapped back to group via ... | | api_execution_circles_v2_group_member_scores | API | Latest on-chain score per (score-based group, member), from the OffchainScoreBasedMintPolicy PersonalMinted event. On... | | api_execution_circles_v2_group_members | API | Members of a group (trustees on its outgoing trust list) with profile and join date; is_mutual flags reciprocal trust. | | api_execution_circles_v2_group_mints_daily | API | Per-group daily group-token mints vs collateral redemptions (distinct tokens/units, labelled in the kind column). | | api_execution_circles_v2_group_score_distribution | API | Count of members per score bucket, per score-based group. Buckets carry a bucket_rank for stable ordering in charts. | | api_execution_circles_v2_group_search | API | (group_address, display_name) lookup backing the Group Explorer global filter. One row per Circles v2 Group avatar. | | api_execution_circles_v2_group_size_daily | API | Per-group daily member count, from historical trust intervals. | | api_execution_circles_v2_group_size_distribution | API | Histogram of Circles v2 group sizes (members per group). | | api_execution_circles_v2_group_supply_daily | API | Per-group daily token supply, split native ERC-1155 vs ERC-20 wrapper (wrapper level = prefix-sum of wrapper supply d... | | api_execution_circles_v2_group_token_supply_daily | API | Long-format time-series view (one row per (date, label)) over fct_execution_circles_v2_group_token_supply_daily, read... | | api_execution_circles_v2_group_token_supply_top_latest | API | Top 100 Circles v2 groups by personal-token supply (leaderboard view). | | api_execution_circles_v2_groups_cnt_latest | API | Latest count of group avatars and 7-day percentage change. | | api_execution_circles_v2_groups_overview_daily | API | Daily group registrations + collateral activity, with cumulative group total. | | api_execution_circles_v2_hub_events_daily | API | Time-series view over int_execution_circles_v2_hub_events_daily; latest day excluded. | | api_execution_circles_v2_humans_cnt_latest | API | Latest count of human avatars and 7-day percentage change. | | api_execution_circles_v2_invite_funnel_cohort_monthly | API | Invitee cohort by month, with the five-stage mint-cadence funnel (Invited → ≥2 days → ≥7 days → ≥14 days → Active Min... | | api_execution_circles_v2_inviter_farm_quota | API | Inviter InvitationFarm leaderboard (invites claimed + current quota), ordered by invites_claimed. Passthrough over fc... | | api_execution_circles_v2_inviters_ranking | API | Top-N inviters leaderboard ordered by number of human avatars invited. Pre-joins the inviter's display name, preview ... | | api_execution_circles_v2_kpi_active_minters_latest | API | KPI: yesterday's Active Minters count with WoW pct change. | | api_execution_circles_v2_kpi_avg_members_per_group_latest | API | KPI: average and median members per group. | | api_execution_circles_v2_kpi_avg_trusts_per_avatar_latest | API | KPI: average trusts per human avatar = active_trusts / humans. Network-density indicator. | | api_execution_circles_v2_kpi_depositors_in_backers_pct_latest | API | KPI: % of depositors that ended up trusted by the backers group. | | api_execution_circles_v2_kpi_group_token_supply_latest | API | KPI: aggregate group-token supply with 7d change. | | api_execution_circles_v2_kpi_group_wrapped_pct_latest | API | KPI: share of group-token supply held as ERC-20 wrappers, with 7d delta. | | api_execution_circles_v2_kpi_mints_7d | API | KPI: total mints in the last 7 full days with WoW pct change. | | api_execution_circles_v2_kpi_new_backers_7d | API | KPI: backers newly trusted in the last 7 days with WoW change. | | api_execution_circles_v2_kpi_new_groups_7d | API | KPI: groups registered in the last 7 days with WoW change. | | api_execution_circles_v2_kpi_new_trusts_7d | API | KPI: new trusts granted in the last 7 full days with WoW pct change. | | api_execution_circles_v2_kpi_total_backers_latest | API | KPI: backers currently trusted by the backers group (revocation-aware), with 7d change. | | api_execution_circles_v2_kpi_total_depositors_latest | API | KPI: total distinct depositors with 7d-new and WoW change. | | api_execution_circles_v2_kpi_total_supply_latest | API | KPI: latest network-wide CRC supply with 7-day pct change. | | api_execution_circles_v2_minter_cohort_daily | API | Time-series view over fct_execution_circles_v2_minter_cohort_daily; latest day excluded. | | api_execution_circles_v2_mints_daily | API | Time-series view over int_execution_circles_v2_mints_daily; latest day excluded. One row per (date, mint_kind) — mint... | | api_execution_circles_v2_orgs_cnt_latest | API | Latest count of organization avatars and 7-day percentage change. | | api_execution_circles_v2_p2p_velocity_daily | API | Peer-to-peer transfer velocity (mint/burn/wrap/unwrap excluded). | | api_execution_circles_v2_pool_explorer_liquidity_daily | API | Daily count of liquidity events (Mint = 'Add', Burn = 'Remove') per Uniswap V3 Circles pool, deduped on (transaction_... | | api_execution_circles_v2_pool_explorer_liquidity_events | API | Individual liquidity events (Mint mapped to Add, Burn to Remove) for the main Uniswap V3 Circles pools, one row per e... | | api_execution_circles_v2_pool_explorer_swaps | API | Individual recent swaps executed on the main Circles v2 DEX pools, scoped to the curated liquidity pools for the Pool... | | api_execution_circles_v2_pool_explorer_swaps_daily | API | Daily swap activity per main Circles DEX pool tracked in the Pool Explorer: number of swaps, total USD volume, and di... | | api_execution_circles_v2_pool_search | API | Point-in-time (pool_address, display_name) lookup of Circles v2 liquidity pools that backs the Pool Explorer filter d... | | api_execution_circles_v2_pools_daily | API | Daily liquidity/market metrics for the main Circles DEX pools (seed circles_liquidity_pools), one row per (date, pool... | | api_execution_circles_v2_pools_latest | API | One row per main Circles DEX pool: latest TVL plus trailing-7d volume, trades, distinct traders and fees. Backs the L... | | api_execution_circles_v2_pools_reserves_daily | API | Daily USD total value locked (TVL) per main Circles DEX pool, computed as the sum of both token legs' USD value. Back... | | api_execution_circles_v2_pools_reserves_latest | API | Latest per-(pool, token) reserve, token USD price and TVL for the main Circles DEX pools. Emits two rows per pool (on... | | api_execution_circles_v2_pools_reserves_token_daily | API | Daily per-(pool, token) reserve balance and USD valuation for the main Circles DEX pools (Uniswap V3 and Balancer V3)... | | api_execution_circles_v2_pools_traders_daily | API | Daily distinct traders and trade count per main Circles DEX pool. A trader is the swap taker (Swap recipient), fallin... | | api_execution_circles_v2_score_mints_daily | API | Daily score-based mint activity per group: mint count, distinct minters, average member score at mint, and total grou... | | api_execution_circles_v2_stats_current | API | Snapshot of network-level Circles v2 counts (avatars total + by type, active trusts, tokens, wrappers). One row per m... | | 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_transfers_daily | API | Time-series of Circles v2 transfers by category. | | api_execution_circles_v2_trust_relations_current | API | API view of current active Circles v2 trust relations. | | api_execution_circles_v2_trusts_daily | API | Time-series view over int_execution_circles_v2_trusts_daily; latest day excluded. | | api_execution_circles_v2_trusts_distribution | API | Distribution histogram of trust degree (given / received) across avatars. Each row is a (direction, bucket) cell with... | | api_execution_circles_v2_wrapper_share_daily | API | Network wrapped vs unwrapped supply share over time. |

Claims

Coordinator

Cow

Data

Deposists

Dex

Earned

Gnosis

A top-up = a Gnosis Pay "Crypto Deposit" into a GP wallet that is currently GA-owne... | | int_execution_gnosis_app_gpay_txns | Intermediate | Any USER-INITIATED Gnosis Pay card-wallet transaction (Payment = card spend, Crypto Withdrawal, Fiat Off-ramp, Fiat T... | | 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_gt_card_owner | Intermediate | Reusable GP card (Safe) -> Gnosis App account bridge — the UNION of three on-chain signals gated to the envio_ga regi... | | int_execution_gnosis_app_gt_pay_wallets | Intermediate | Guardian-module MEMBERSHIP (netted Enabled-Disabled). GA-ownership is GT-unavailable and stays on the heuristic. is_g... | | int_execution_gnosis_app_gt_user_activity | Intermediate | Canonical per-identity ACTIVITY model (grain = registry UNION avatar). Records every action signal — app-feature (swa... | | int_execution_gnosis_app_gt_user_dim | Intermediate | Ground-truth registered-identity dimension (= dim_circles_identity, ~301k). Registry LEFT JOIN avatar (active spine) ... | | int_execution_gnosis_app_gt_user_identity_bridge | Intermediate | Internal registry address -> pseudonym bridge (shared CEREBRO_PII_SALT). INTERNAL. | | int_execution_gnosis_app_gt_user_reconciliation | Intermediate | Aggregate-only reconciliation snapshot (public). registered (GT registry) vs active (heuristic) containment; cutover ... | | int_execution_gnosis_app_gt_wallet_metrics | Intermediate | Per-wallet analytical rollup (one row per registry-or-avatar identity): lifecycle (tenure/recency/cohort), engagement... | | 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_swap_fees_daily | Intermediate | Daily aggregated CoW protocol fee revenue from Gnosis App swaps. fee_usd is derived from fee_amount (sold-token n... | | int_execution_gnosis_app_swap_fees_monthly | Intermediate | Monthly rollup of swap_fees_daily. | | int_execution_gnosis_app_swap_fees_weekly | Intermediate | Weekly rollup of swap_fees_daily. | | 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_claim_funnel_daily | Intermediate | Daily per-offer token-offer claim conversion. Eligible-pool denominator is the rolling 30-day active GA users (proxy ... | | 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_activity_daily_incl_gpay | Intermediate | The composite Gnosis App activity feed (int_execution_gnosis_app_user_activity_daily) EXTENDED with a gpay_txn acti... | | int_execution_gnosis_app_user_events | Intermediate | Long-form heuristic event log for Gnosis App user identification.

Seven rules, all keyed off the same chokepoint: a ... | | 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_user_identity_bridge | Intermediate | INTERNAL ONLY — holds raw address and user_pseudonym together for every known Gnosis App user. The only place in ... | | int_execution_gnosis_app_user_purchase_freq_30d | Intermediate | Rolling 30-day per-user purchase-event count (swap_filled + marketplace_buy). Full rebuild on every run; size bounded... | | 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... | |int_execution_gnosis_app_weekly_earners| Intermediate | Weekly "economic earners" set for the WEAU metric, scoped to the Gnosis App: addresses that earned >= 1 gCRC cashback... | |int_execution_gnosis_app_weekly_signals| Intermediate | Composite weekly activity for the Gnosis App WAU metric. UNION of Circles v2 active avatars (humans/trusts/mints), fi... | |int_execution_gnosis_app_weekly_signals_in_app| Intermediate | IN-APP-ONLY weekly activity signal — companion to int_execution_gnosis_app_weekly_signals (the ecosystem-wide WAU fee... | |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_gp_card_ga_link_daily| Fact | Daily + cumulative count of Gnosis Pay cards LINKED to a Gnosis App account, split by link_source. Backing fact for a... | |fct_execution_gnosis_app_gp_card_ga_volume_daily| Fact | GA-LINKED Gnosis Pay funding & spend volume, daily, split by link_source. Module-agnostic, correctly-timed successor ... | |fct_execution_gnosis_app_gpay_migration_daily| Fact | Daily Gnosis Pay exploit -> Safe migration recovery time-series (June-2026 incident). One row per calendar date from ... | |fct_execution_gnosis_app_gpay_topups_by_token_daily| Fact | Daily Gnosis App → Gnosis Pay top-up activity, derived from int_execution_gnosis_app_gpay_topups (top-up = a GP "Cryp... | |fct_execution_gnosis_app_gpay_topups_cohort_monthly` | Fact | First-top-up cohort × subsequent-top-up retention.

Top-up definition is owned by int_execution_gnosis_app_gpay_topup... | | fct_execution_gnosis_app_gpay_topups_monthly | Fact | Monthly top-up counts and USD volume (aggregated across tokens). Top-up = a GP Crypto Deposit into a currently-GA-own... | | fct_execution_gnosis_app_gpay_topups_weekly | Fact | Weekly top-up counts and USD volume (aggregated across tokens). Top-up = a GP Crypto Deposit into a currently-GA-owne... | | fct_execution_gnosis_app_gpay_volume_daily | Fact | Gnosis-App-scoped Gnosis Pay funding & spend volume, daily, split by onboarding class. Backing fact table for api_exe... | | 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_gt_active_wallets | Fact | Active-wallet time-series (DAU/WAU/MAU) from real transaction_action.timestamp, scoped to app-engaged wallets. One ta... | | fct_execution_gnosis_app_gt_cashback_nft | Fact | Gnosis Pay cashback NFT-mint program — daily mint series x status. A SEPARATE family from gpay_cashback_* (gCRC trans... | | fct_execution_gnosis_app_gt_investments | Fact | Metri auto-invest accounts by active flag (GT-only; no Gnosis Pay analogue). Owner-keyed. | | fct_execution_gnosis_app_gt_referrals | Fact | Two DISTINCT referral metrics side by side: earned (GA-native paid-reward ledger) and full_invite_graph (every ac... | | fct_execution_gnosis_app_gt_registrations_monthly | Fact | New identity/profile REGISTRATIONS per month (avatar.created_at = account/profile creation; 100% of avatars have a pr... | | fct_execution_gnosis_app_gt_swaps_by_pair | Fact | FILLED swaps by app_scope x token pair. gnosis_app = CURRENT Gnosis App, metri = LEGACY Gnosis App (both roll up to G... | | fct_execution_gnosis_app_gt_swaps_summary | Fact | Swap counts by app_scope x real CoW status enum. app_scope separates the Gnosis App VERSIONS sharing the Circles inde... | | fct_execution_gnosis_app_gt_user_identities_public | Fact | PUBLIC identity boundary — pseudonym-only registry attributes. Join surface to mixpanel/gpay/circles (shared CEREBRO_... | | fct_execution_gnosis_app_gt_wallet_cohort_retention_monthly | Fact | Acquisition-cohort retention: retained wallets / cohort size at month_index N after first activity. Denominator = coh... | | fct_execution_gnosis_app_gt_wallet_metrics_public | Fact | PUBLIC per-wallet rollup — pseudonym-only mirror of int_execution_gnosis_app_gt_wallet_metrics (raw address dropped; ... | | 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 | Cohort retention split by activity_kind (swap_filled / swap_signed / topup / marketplace_buy / token_offer_claim / ci... | | fct_execution_gnosis_app_retention_monthly | Fact | Cohort retention grid for the Gnosis App onboard cohort.

Modeling assumptions: * cohort_month = month of the user'... | | 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_daily_incl_gpay | Fact | "Incl. Gnosis Pay" twin of fct_execution_gnosis_app_users_daily: identical New / Returning / Reactivated / Active log... | | fct_execution_gnosis_app_users_distinct | Fact | One row per Gnosis App on-chain user_pseudonym, with boolean flags indicating which identification heuristic(s) fired... | | 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_monthly_incl_gpay | Fact | "Incl. Gnosis Pay" twin of fct_execution_gnosis_app_users_monthly: identical New / Returning / Reactivated / Active l... | | 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... | | fct_execution_gnosis_app_users_weekly_incl_gpay | Fact | "Incl. Gnosis Pay" twin of fct_execution_gnosis_app_users_weekly — identical New/Returning/Reactivated/Active logic, ... | | fct_execution_gnosis_app_weekly_active_users_circles_ecosystem | Fact | Circles-ecosystem weekly active reach — NOT a Gnosis App growth metric. Distinct addresses active that week across th... | | fct_execution_gnosis_app_weekly_economically_active_users | Fact | Weekly Economically Active Users — intersection of the Gnosis-App-only (in-app) weekly active users and weekly Circle... | | api_execution_gnosis_app_active_users_incl_gpay_daily | API | Gnosis App Daily Active Users (DAU), Gnosis-Pay-inclusive variant over fct_execution_gnosis_app_users_daily_incl_gpay... | | api_execution_gnosis_app_active_users_incl_gpay_monthly | API | Gnosis App Monthly Active Users (MAU), Gnosis-Pay-inclusive variant over fct_execution_gnosis_app_users_monthly_incl_... | | api_execution_gnosis_app_active_users_incl_gpay_weekly | API | Gnosis App Weekly Active Users (WAU), Gnosis-Pay-inclusive variant over fct_execution_gnosis_app_users_weekly_incl_gp... | | 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_circles_ecosystem_weekly_active_users | API | Whole-Circles-network weekly active reach (NOT Gnosis App growth; that is api:gnosis_app_users weekly / api:gnosis_ap... | | api_execution_gnosis_app_gp_card_ga_link_daily | API | Dashboard view of fct_execution_gnosis_app_gp_card_ga_link_daily: daily + cumulative count of GA-linked Gnosis Pay ca... | | api_execution_gnosis_app_gp_card_ga_volume_daily | API | Dashboard view of fct_execution_gnosis_app_gp_card_ga_volume_daily: GA-linked GP-card funding & spend per day by link... | | 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_volume_daily | API | FastAPI endpoint view of fct_execution_gnosis_app_gpay_volume_daily. GA-controlled Gnosis Pay funding (funded_volume_... | | 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_gt_active_wallets | API | Public DAU series (active app-engaged wallets per day). WAU/MAU in the underlying fct. | | api_execution_gnosis_app_gt_referrals | API | Public referral metrics — earned ledger vs full invite graph. | | api_execution_gnosis_app_gt_swaps | API | Public swap counts by scope x CoW status enum. | | api_execution_gnosis_app_gt_user_reconciliation | API | Public reconciliation snapshot — registered (GT registry) vs active (heuristic) containment. | | api_execution_gnosis_app_gt_wallet_cohort_retention | API | Public acquisition-cohort retention matrix (point-in-time; as_of_date). | | api_execution_gnosis_app_gt_wallet_metrics | API | Public per-wallet metric endpoint (pseudonym-only; curated lifecycle/engagement/trust/segment surface). Point-in-time... | | 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_fees_7d | API | KPI: protocol fee revenue (USD) from filled swaps in last 7 full days with WoW pct change. | | 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_kpi_wau_latest | API | KPI: WAU for the latest complete week with pct change vs prior. | | api_execution_gnosis_app_kpi_weekly_active_users_latest | API | KPI: latest complete week's Gnosis App WAU (Lineage A, fct_execution_gnosis_app_users_weekly.active_users — same popu... | | api_execution_gnosis_app_kpi_weekly_economically_active_users_latest | API | KPI: latest complete week's WEAU (non-blacklisted only) with WoW pct change. | | 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_purchase_freq_distribution_latest | API | Distribution histogram of last-30d purchase counts per user (buckets 1/2/3/4-5/6-10/11+). | | 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_swap_fees_daily | API | Daily CoW protocol fee revenue from GA swaps (filled trades, pro-rated to USD). | | api_execution_gnosis_app_swap_fees_monthly | API | Monthly rollup of swap_fees_daily. | | api_execution_gnosis_app_swap_fees_weekly | API | Weekly rollup of swap_fees_daily. | | 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_time_to_first_conversion_cohort_monthly | API | Time from onboard to a user's FIRST event of each conversion kind, bucketed by onboard-month cohort. Long format: one... | | api_execution_gnosis_app_token_offer_claim_funnel_daily | API | Daily per-offer token-offer claim conversion (claims, claimers, USD received, claim_rate_pct). | | 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. | | api_execution_gnosis_app_weekly_active_users | API | Gnosis App Weekly Active Users (WAU) time-series over fct_execution_gnosis_app_users_weekly.active_users (in-app acti... | | api_execution_gnosis_app_weekly_active_users_incl_gpay | API | Gnosis App Weekly Active Users (WAU), Gnosis-Pay-inclusive variant of api_execution_gnosis_app_weekly_active_users: '... | | api_execution_gnosis_app_weekly_economically_active_users | API | Time-series view over fct_execution_gnosis_app_weekly_economically_active_users (latest week excluded). |

Gpay

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_balances_user_daily | Intermediate | User-holdings view over int_execution_gpay_balances_daily that is safe to aggregate across the June 2026 Safe migrati... | | 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_refunds | Intermediate | Exploit-recovery refunds credited to migrated NEW Safes by the distributor wallets in the gpay_refund_distributors se... | | 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_canonical | Intermediate | Canonical resolution for the June 2026 post-exploit Safe migration (gp_migrated_safes seed). One row per OLD Safe wit... | | 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_safe_switchover | Intermediate | One row per June 2026 migrated pair. Refunded (is_lost) pairs are excluded from user holdings from first_refund_at (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_user_identity_bridge | Intermediate | INTERNAL ONLY — GP-side analogue of int_execution_gnosis_app_user_identity_bridge. Holds raw GP addresses (Safe con... | | 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. N... | | 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. User-holdings semantics: reads int_execution_gpay_b... | | fct_execution_gpay_user_lifetime_metrics | Fact | Lifetime metrics for each Gnosis Pay wallet, including tenure, activity counts, payment volumes, and cashback totals. | | fct_execution_gpay_users_distinct | Fact | Deduplicated Gnosis Pay user projection for the semantic layer's cross-sector user-overlap path. One row per user_pse... | | api_execution_gpay_accounts_daily | API | Daily time series of the cumulative number of deployed Gnosis Pay accounts. | | 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_accounts | API | All-time total count of deployed Gnosis Pay accounts (Safes that enabled a Gnosis Pay Zodiac module - Delay / Roles /... | | 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 view of the top 50 Gnosis Pay wallets by lifetime payment volume. One row per wallet_address, selected from fct_e... | | 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. |

Guardian

Interactions

Investment

Known

Lending

Live

Modules

T... | | contracts_zodiac_modules_registry | CONTRACTS | ABI-resolution registry for Zodiac Modifier proxies (Delay + Roles) on Gnosis Chain, chain-wide (NOT GP-scoped).

Mir... |

Network

Ocsdai

Pay

Pools

Prices

Profiles

Registry

Rwa

Safe

Safes

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_module_events_v2 | Intermediate | Validation copy of int_execution_safes_module_events that uses the decode_logs event_name_filter (topic0 pre-filter) ... | | 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

Sdai

Second

Settlements

Solvers

State

Storage

Supply

Swapr

Swaps

Token

Tokens

Trades

Transaction

Transactions

Transfer

Transfers

Uniswap

Users

V3

Wallet

Yields

Zodiac

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

Related Modules¶

• Contracts -- Protocol-specific decoded event data built on top of execution logs
• Bridges -- Bridge flow analytics derived from execution transactions and logs
• ESG -- Energy consumption estimates based on execution block production data