Skip to content

Celo (Gnosis Pay) Module

Chainlink

Model Layer Description
contracts_celo_chainlink_feeds_events CONTRACTS Chainlink price-feed AnswerUpdated events on Celo (the 6 aggregators in
seeds/celo_chainlink_feeds.csv), decoded from...

Gpay

Model Layer Description
int_celo_gpay_funder_wallet_daily Intermediate Daily funding-wallet activity at (date, wallet, direction, counterparty_class,
token) grain, folded off int_celo_gpay...
int_celo_gpay_funder_wallet_monthly_presence Intermediate One row per (month, funding wallet): earliest and latest Transfer leg that wallet had
that month, plus leg counts. Th...
int_celo_gpay_funder_wallet_transfers Intermediate All-token ERC-20 Transfer activity touching a GP card FUNDING WALLET on either
side, with the counterparty classified...
int_celo_gpay_funder_wallets Intermediate The card <-> funding-wallet identity spine: one row per EOA that has directly
funded a GP card Safe.

WHY IT EXISTS: ... | | int_celo_gpay_funding_tx_envelopes | Intermediate | One row per inbound ERC-20 transfer onto a GP card Safe, with the funding transaction's envelope attached and a label... | | int_celo_gpay_module_mastercopies | Intermediate | Deterministic mastercopy allowlist: GP Zodiac module proxies created via the canonical ModuleProxyFactory from the Ro... | | int_celo_gpay_roles_modules | Intermediate | GP-specific Zodiac Roles module proxies on Celo, discovered natively from celo_execution.logs: an EnabledModule(int_celo_gpay_safe_events_native | Intermediate | Safe lifecycle events (SafeSetup / AddedOwner / RemovedOwner) for GP card Safes on Celo, decoded through the multicha... | | int_celo_gpay_safe_registry | Intermediate | GP card Safes on Celo, discovered natively: a Safe that emits EnabledModule(\) has been provisioned as... | | int_celo_gpay_safe_transfers_alltoken | Intermediate | Deterministic all-token ERC-20 Transfer activity touching a GP card Safe on either side (int_celo_gpay_safe_registry)... | | int_celo_gpay_wallet_events | Intermediate | Unified, append-only wallet-lifecycle event log (issued_at + add_owner + remove_owner) for GP card Safes, derived NAT... | | fct_celo_gpay_actions_by_token_daily | Fact | Daily volume (native + USD) and count per action x token, with running cumulatives. Actions - Payment, Top-up, Withdr... | | fct_celo_gpay_actions_by_token_monthly | Fact | Monthly rollup of fct_celo_gpay_actions_by_token_daily. Whitelisted tokens only (USDT/USDC in practice — see scope no... | | fct_celo_gpay_actions_by_token_weekly | Fact | Weekly rollup of fct_celo_gpay_actions_by_token_daily. Whitelisted tokens only (USDT/USDC in practice — see scope note). | | fct_celo_gpay_activity_daily | Fact | Daily card-payment activity (active Safes, payment count, USD volume) plus BOTH funnel counts, which are different me... | | fct_celo_gpay_activity_monthly | Fact | Monthly rollup of fct_celo_gpay_activity_daily. Partial current month excluded. Whitelisted tokens only (USDT/USDC in... | | fct_celo_gpay_activity_weekly | Fact | Weekly rollup of fct_celo_gpay_activity_daily. Partial current week excluded. Whitelisted tokens only (USDT/USDC in p... | | fct_celo_gpay_balance_cohorts_daily | Fact | Per-day holder distribution across balance buckets, by token, in USD and native units. Zero/negative balances exclude... | | fct_celo_gpay_balances_by_token_daily | Fact | Total net-flow balance across all Safes, per day per token. Built from the dense per-Safe base. Whitelisted tokens on... | | fct_celo_gpay_balances_safe_daily | Fact | DENSE per-Safe/token/day net-flow balance (Celo analog of Gnosis Chain's int_execution_gpay_balances_user_daily). Den... | | fct_celo_gpay_card_balances_alltoken_daily | Fact | Deterministic ALL-TOKEN running balance per card Safe (net-flow-since- inception, same idiom as fct_celo_gpay_balance... | | fct_celo_gpay_card_funding | Fact | Deterministic funding-relationship per card Safe: which addresses fund it (inbound transfers), per token, plus each f... | | fct_celo_gpay_card_funnel | Fact | One row per card - issuance, first funding, first spend, and the lags between. The atom behind fct_celo_gpay_funnel_c... | | fct_celo_gpay_cardholder_engagement | Fact | One row per Celo GP card, joining the card's own lifecycle to whether the person behind it is still economically aliv... | | fct_celo_gpay_churn_monthly | Fact | Monthly new/retained/returning/churned Safe segmentation and churn/retention rates, for two scopes - Payment (card sp... | | fct_celo_gpay_funnel_cohorts_monthly | Fact | Cards grouped by the month they were ISSUED, with how far each cohort got through issued > funded > activated. Rollup... | | fct_celo_gpay_kpi_monthly | Fact | Monthly KPIs - MAU (and per-action MAU), payment/deposit/withdrawal USD volumes, net flow (deposits minus withdrawals... | | fct_celo_gpay_payments_hourly | Fact | Hourly payment counts by token over the trailing 14 days. Serves the time-of-day distribution panel. Whitelisted toke... | | fct_celo_gpay_retention_by_action_monthly | Fact | Per-action monthly cohort retention. Cohort = month a Safe first performed the action. Actions - Payment, Top-up, Wit... | | fct_celo_gpay_retention_monthly | Fact | Monthly payment-cohort retention (users + USD). Cohort = month of a Safe's first Payment. Whitelisted tokens only (US... | | fct_celo_gpay_settlement_batches | Fact | One row per settlement transaction - how many card charges it swept, how much left the contract, where it went, and w... | | fct_celo_gpay_snapshots | Fact | All-time and trailing-7D headline snapshots per action (Volume/Count/Users), plus TotalBalance and RewardBalance. Fee... | | fct_celo_gpay_wallet_share_of_spend_daily | Fact | Daily split of what cardholders send OUT of their own wallet: how much went to the GP card, and how much went somewhe... | | fct_celo_gpay_wallet_tenure | Fact | One row per GP card funding wallet: how long it had been active on Celo before it funded a card. The acquisition-vs-c... | | api_celo_gpay_activated_addresses_daily | API | Cumulative cards that have ever SPENT, by day. This is the series api_celo_gpay_funded_addresses_daily served before ... | | api_celo_gpay_activated_addresses_monthly | API | Cumulative cards that have ever SPENT, by month. See api_celo_gpay_activated_addresses_daily. | | api_celo_gpay_activated_addresses_weekly | API | Cumulative cards that have ever SPENT, by week. See api_celo_gpay_activated_addresses_daily. | | api_celo_gpay_active_users_7d | API | Trailing-7D distinct paying Safes with WoW change_pct. Counter tile. | | api_celo_gpay_activity_by_action_daily | API | Daily count/USD/native volume per action (Payment, Top-up, Withdrawal, Reversal). | | api_celo_gpay_activity_by_action_monthly | API | Monthly count/USD/native volume per action. | | api_celo_gpay_activity_by_action_weekly | API | Weekly count/USD/native volume per action. | | api_celo_gpay_balance_cohorts_holders_daily | API | Daily holder counts per balance bucket, by token and unit (usd/native). Ends at the complete previous day (dashboard ... | | api_celo_gpay_balance_cohorts_value_daily | API | Daily summed balance (native + USD) per balance bucket, by token and unit. Ends at the complete previous day (dashboa... | | api_celo_gpay_balances_native_daily | API | Daily total net-flow balance (native units) by token. Whitelisted tokens only (USDT/USDC in practice — see scope note... | | api_celo_gpay_balances_usd_daily | API | Daily total net-flow balance (USD) by token. Whitelisted tokens only (USDT/USDC in practice — see scope note). Ends a... | | api_celo_gpay_cardholder_engagement | API | Current card population split by engagement segment: for cards not being used, is the holder still active on Celo at ... | | api_celo_gpay_churn_monthly | API | Monthly new/retained/returning/churned segmentation by scope (Payment, Any). | | api_celo_gpay_churn_rates_monthly | API | Monthly churn and retention rates by scope (Payment, Any). | | api_celo_gpay_first_fund_by_channel | API | Funded cards by first_fund_channel (shape of the card's earliest inbound transfer). Unfunded cards excluded. One row ... | | api_celo_gpay_funded_addresses_daily | API | Cumulative cards that have ever RECEIVED money, by day. RESTATED 2026-08-05: this served a first-PAYMENT count until ... | | api_celo_gpay_funded_addresses_monthly | API | Cumulative cards that have ever RECEIVED money, by month. Restated 2026-08-05 — see api_celo_gpay_funded_addresses_da... | | api_celo_gpay_funded_addresses_weekly | API | Cumulative cards that have ever RECEIVED money, by week. Restated 2026-08-05 — see api_celo_gpay_funded_addresses_daily. | | api_celo_gpay_funding_by_channel | API | Funding relationships by shape channel (cip64_direct_solo / hub / mediated / …). Not a MiniPay identity label. cards ... | | api_celo_gpay_funnel_cohorts_monthly | API | Card funnel by issuance cohort. month is the month the cards were ISSUED, not a month of activity, so the series do... | | api_celo_gpay_kpi_monthly | API | Monthly KPI table (MAU, volumes, net flow, ARPU, repeat rate). Backs the KPI tiles and monthly KPI charts. Whiteliste... | | api_celo_gpay_payments_7d | API | Trailing-7D payment count with WoW change_pct. Counter tile. | | api_celo_gpay_payments_by_token_daily | API | Daily payment count split by token (whitelisted; USDT/USDC in practice). | | api_celo_gpay_payments_by_token_monthly | API | Monthly payment count split by token (whitelisted; USDT/USDC in practice). | | api_celo_gpay_payments_by_token_weekly | API | Weekly payment count split by token (whitelisted; USDT/USDC in practice). | | api_celo_gpay_payments_hourly | API | Hourly payment counts by token over the trailing 14 days. | | api_celo_gpay_retention_by_action_monthly | API | Per-action monthly cohort retention heatmap. | | api_celo_gpay_retention_by_action_users_monthly | API | Per-action monthly cohort retention (absolute users). | | api_celo_gpay_retention_monthly | API | Monthly payment-cohort retention (absolute users) in date/label/value shape. | | api_celo_gpay_retention_pct_monthly | API | Monthly payment-cohort retention heatmap (x/y/retention_pct/value_abs/value_usd). | | api_celo_gpay_retention_volume_monthly | API | Monthly payment-cohort retention by USD volume. | | api_celo_gpay_settlement_cost_monthly | API | What it costs Gnosis Pay to settle Celo card charges, by month. Aggregates fct_celo_gpay_settlement_batches directly ... | | api_celo_gpay_total_activated | API | All-time distinct cards that have ever SPENT (662 on 2026-08-05). Counter tile. This is the value api_celo_gpay_total... | | api_celo_gpay_total_balance | API | Latest-day net-flow USDC+USDT float held across all GP Safes. Counter tile. | | api_celo_gpay_total_funded | API | All-time distinct cards that have ever RECEIVED money (1087 on 2026-08-05). Counter tile. RESTATED 2026-08-05: previo... | | api_celo_gpay_total_payments | API | All-time payment count. Counter tile. | | api_celo_gpay_total_volume | API | All-time card payment volume in USD across whitelisted tokens (USDT + USDC in practice). Counter tile. | | api_celo_gpay_volume_7d | API | Trailing-7D payment volume (USD) with WoW change_pct. Counter tile. | | api_celo_gpay_volume_payments_by_token_daily | API | Daily payment volume (USD) split by token (whitelisted; USDT/USDC in practice). | | api_celo_gpay_volume_payments_by_token_monthly | API | Monthly payment volume (USD) split by token (whitelisted; USDT/USDC in practice). | | api_celo_gpay_volume_payments_by_token_weekly | API | Weekly payment volume (USD) split by token (whitelisted; USDT/USDC in practice). | | api_celo_gpay_wallet_balance_composition | API | Latest-day USD balance composition across whitelisted tokens (USDT/USDC in practice); sub-1% folded into Other. | | api_celo_gpay_wallet_share_of_spend_monthly | API | Monthly share of cardholder stablecoin outflow reaching the GP card vs going elsewhere. value is the RETAIL number ... | | api_celo_gpay_wallet_tenure | API | How long GP card funding wallets had been active on Celo before funding a card, by tenure bucket. Read 'pre_dates_our... | | contracts_celo_gpay_settlement_events | CONTRACTS | Gnosis Pay's own settlement-contract events on Celo, decoded from celo_execution.logs for every address in seeds/celo... |

Sorted

Model Layer Description
int_celo_sorted_oracles_rates Intermediate Tracked Mento SortedOracles rate feeds on Celo, raw-sliced from
celo_execution.logs (MedianUpdated events, values at ...

Token

Model Layer Description
int_celo_token_prices_daily Intermediate Celo daily price hub, native-first (same design as the Gnosis
int_execution_token_prices_daily). Priority 1: native o...