Celo API Endpoints¶

44 endpoints across 33 resources. Generated from the dbt manifest — edits inside this block will be overwritten. Regenerate with python scripts/update_docs.py --only api.

celo_gpay_activated_addresses¶

Cumulative cards that have ever SPENT, by day. This is the series api_celo_gpay_funded_addresses_daily served before the 2026-08-05 restatement, exposed here under its true name. Always <= the funded series.

Path	Methods	Tier	Filters	Pagination	Sort
`/v1/celo/celo_gpay_activated_addresses/daily`	GET	tier1	--	--	--
`/v1/celo/celo_gpay_activated_addresses/weekly`	GET	tier1	--	--	--
`/v1/celo/celo_gpay_activated_addresses/monthly`	GET	tier1	--	--	--

GET /v1/celo/celo_gpay_activated_addresses/daily

Cumulative cards that have ever SPENT, by day. This is the series api_celo_gpay_funded_addresses_daily served before the 2026-08-05 restatement, exposed here under its true name. Always <= the funded series.

Model: api_celo_gpay_activated_addresses_daily — table dbt.api_celo_gpay_activated_addresses_daily

Legacy endpoint — GET only, no query parameters, returns the full table.

Columns

Column	Type	Description
`date`	`Date`	The calendar date.
`value`	`UInt64`	Cumulative cards that have ever settled a payment.

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_activated_addresses/daily" \
  -H "X-API-Key: YOUR_API_KEY"

GET /v1/celo/celo_gpay_activated_addresses/weekly

Cumulative cards that have ever SPENT, by week. See api_celo_gpay_activated_addresses_daily.

Model: api_celo_gpay_activated_addresses_weekly — table dbt.api_celo_gpay_activated_addresses_weekly

Legacy endpoint — GET only, no query parameters, returns the full table.

Columns

Column	Type	Description
`date`	`Date`	The first day of the ISO week.
`value`	`UInt64`	Cumulative cards that have ever settled a payment.

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_activated_addresses/weekly" \
  -H "X-API-Key: YOUR_API_KEY"

GET /v1/celo/celo_gpay_activated_addresses/monthly

Cumulative cards that have ever SPENT, by month. See api_celo_gpay_activated_addresses_daily.

Model: api_celo_gpay_activated_addresses_monthly — table dbt.api_celo_gpay_activated_addresses_monthly

Legacy endpoint — GET only, no query parameters, returns the full table.

Columns

Column	Type	Description
`date`	`Date`	The first day of the month.
`value`	`UInt64`	Cumulative cards that have ever settled a payment.

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_activated_addresses/monthly" \
  -H "X-API-Key: YOUR_API_KEY"

celo_gpay_active_users¶

Trailing-7D distinct paying Safes with WoW change_pct. Counter tile.

Path	Methods	Tier	Filters	Pagination	Sort
`/v1/celo/celo_gpay_active_users/last_7d`	GET	tier3	--	--	--

GET /v1/celo/celo_gpay_active_users/last_7d

Trailing-7D distinct paying Safes with WoW change_pct. Counter tile.

Model: api_celo_gpay_active_users_7d — table dbt.api_celo_gpay_active_users_7d

Legacy endpoint — GET only, no query parameters, returns the full table.

Columns

Column	Type	Description
`value`	`Nullable(Float64)`	The number of active users in the last 7 days.
`change_pct`	`Nullable(Float64)`	The percentage change compared to the previous 7-day period.
`as_of_date`	`Nullable(Date)`	Date the snapshot is computed as of (max date in the underlying data).

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_active_users/last_7d" \
  -H "X-API-Key: YOUR_API_KEY"

celo_gpay_activity_by_action¶

Daily count/USD/native volume per action (Payment, Top-up, Withdrawal, Reversal).

Path	Methods	Tier	Filters	Pagination	Sort
`/v1/celo/celo_gpay_activity_by_action/daily`	GET	tier3	`action`, `start_date`, `end_date`	--	date DESC
`/v1/celo/celo_gpay_activity_by_action/weekly`	GET	tier3	`action`, `start_date`, `end_date`	--	week DESC
`/v1/celo/celo_gpay_activity_by_action/monthly`	GET	tier3	`action`, `start_date`, `end_date`	--	month DESC

GET /v1/celo/celo_gpay_activity_by_action/daily

Daily count/USD/native volume per action (Payment, Top-up, Withdrawal, Reversal).

Model: api_celo_gpay_activity_by_action_daily — table dbt.api_celo_gpay_activity_by_action_daily

Declared filters

Parameter	Operator	Column	Type	Notes
`action`	`=`	`action`	string	Action type (Payment, Top-up, Withdrawal, Reversal)
`start_date`	`>=`	`date`	date	Inclusive start date
`end_date`	`<=`	`date`	date	Inclusive end date

Filter policy: Unfiltered requests allowed.

Pagination: none (full result set, bare JSON array)

Sort: date DESC

Columns

Column	Type	Description
`date`	`Date`	The calendar date.
`action`	`Nullable(String)`	The activity type (e.g., Payment, Deposit, Withdrawal, Cashback).
`activity_count`	`UInt64`	The number of transactions for this action on this date.
`volume_usd`	`Nullable(Float64)`	The total USD volume for this action on this date.
`volume_native`	`Float64`	The total native token volume for this action on this date.

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_activity_by_action/daily?start_date=2026-01-01" \
  -H "X-API-Key: YOUR_API_KEY"

GET /v1/celo/celo_gpay_activity_by_action/weekly

Weekly count/USD/native volume per action.

Model: api_celo_gpay_activity_by_action_weekly — table dbt.api_celo_gpay_activity_by_action_weekly

Declared filters

Parameter	Operator	Column	Type	Notes
`action`	`=`	`action`	string	Action type (Payment, Top-up, Withdrawal, Reversal)
`start_date`	`>=`	`week`	date	Inclusive start date
`end_date`	`<=`	`week`	date	Inclusive end date

Filter policy: Unfiltered requests allowed.

Pagination: none (full result set, bare JSON array)

Sort: week DESC

Columns

Column	Type	Description
`week`	`Date`	The first day of the ISO week.
`action`	`Nullable(String)`	The activity type (e.g., Payment, Deposit, Withdrawal, Cashback).
`activity_count`	`UInt64`	The number of transactions for this action in this week.
`volume_usd`	`Nullable(Float64)`	The total USD volume for this action in this week.
`volume_native`	`Float64`	The total native token volume for this action in this week.

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_activity_by_action/weekly?start_date=2026-01-01" \
  -H "X-API-Key: YOUR_API_KEY"

GET /v1/celo/celo_gpay_activity_by_action/monthly

Monthly count/USD/native volume per action.

Model: api_celo_gpay_activity_by_action_monthly — table dbt.api_celo_gpay_activity_by_action_monthly

Declared filters

Parameter	Operator	Column	Type	Notes
`action`	`=`	`action`	string	Action type (Payment, Top-up, Withdrawal, Reversal)
`start_date`	`>=`	`month`	date	Inclusive start date
`end_date`	`<=`	`month`	date	Inclusive end date

Filter policy: Unfiltered requests allowed.

Pagination: none (full result set, bare JSON array)

Sort: month DESC

Columns

Column	Type	Description
`month`	`Date`	The first day of the month.
`action`	`Nullable(String)`	The activity type (e.g., Payment, Deposit, Withdrawal, Cashback).
`activity_count`	`UInt64`	The number of transactions for this action in this month.
`volume_usd`	`Nullable(Float64)`	The total USD volume for this action in this month.
`volume_native`	`Float64`	The total native token volume for this action in this month.

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_activity_by_action/monthly?start_date=2026-01-01" \
  -H "X-API-Key: YOUR_API_KEY"

celo_gpay_balance_cohorts_holders¶

Daily holder counts per balance bucket, by token and unit (usd/native). Ends at the complete previous day (dashboard convention); the current day's rows exist upstream in the fct.

Path	Methods	Tier	Filters	Pagination	Sort
`/v1/celo/celo_gpay_balance_cohorts_holders/daily`	GET	tier3	`token`, `start_date`, `end_date`	--	date DESC

GET /v1/celo/celo_gpay_balance_cohorts_holders/daily

Daily holder counts per balance bucket, by token and unit (usd/native). Ends at the complete previous day (dashboard convention); the current day's rows exist upstream in the fct.

Model: api_celo_gpay_balance_cohorts_holders_daily — table dbt.api_celo_gpay_balance_cohorts_holders_daily

Declared filters

Parameter	Operator	Column	Type	Notes
`token`	`=`	`token`	string	Token symbol
`start_date`	`>=`	`date`	date	Inclusive start date
`end_date`	`<=`	`date`	date	Inclusive end date

Filter policy: Unfiltered requests allowed.

Pagination: none (full result set, bare JSON array)

Sort: date DESC

Columns

Column	Type	Description
`date`	`Nullable(Date)`	The calendar date of the balance snapshot.
`token`	`LowCardinality(String)`	The token symbol.
`cohort_unit`	`String`	The unit used for cohort bucketing (e.g., USD, native).
`label`	`String`	The balance range bucket label.
`value`	`UInt64`	The number of holders in this cohort bucket.

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_balance_cohorts_holders/daily?start_date=2026-01-01" \
  -H "X-API-Key: YOUR_API_KEY"

celo_gpay_balance_cohorts_value¶

Daily summed balance (native + USD) per balance bucket, by token and unit. Ends at the complete previous day (dashboard convention); the current day's rows exist upstream in the fct.

Path	Methods	Tier	Filters	Pagination	Sort
`/v1/celo/celo_gpay_balance_cohorts_value/daily`	GET	tier3	`token`, `start_date`, `end_date`	--	date DESC

GET /v1/celo/celo_gpay_balance_cohorts_value/daily

Daily summed balance (native + USD) per balance bucket, by token and unit. Ends at the complete previous day (dashboard convention); the current day's rows exist upstream in the fct.

Model: api_celo_gpay_balance_cohorts_value_daily — table dbt.api_celo_gpay_balance_cohorts_value_daily

Declared filters

Parameter	Operator	Column	Type	Notes
`token`	`=`	`token`	string	Token symbol
`start_date`	`>=`	`date`	date	Inclusive start date
`end_date`	`<=`	`date`	date	Inclusive end date

Filter policy: Unfiltered requests allowed.

Pagination: none (full result set, bare JSON array)

Sort: date DESC

Columns

Column	Type	Description
`date`	`Nullable(Date)`	The calendar date of the balance snapshot.
`token`	`LowCardinality(String)`	The token symbol.
`cohort_unit`	`String`	The unit used for cohort bucketing.
`label`	`String`	The balance range bucket label.
`value_native`	`Float64`	The total native token value in this bucket.
`value_usd`	`Float64`	The total USD value in this bucket.

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_balance_cohorts_value/daily?start_date=2026-01-01" \
  -H "X-API-Key: YOUR_API_KEY"

celo_gpay_balances_native¶

Daily total net-flow balance (native units) by token. Whitelisted tokens only (USDT/USDC in practice — see scope note). Ends at the complete previous day (dashboard convention); the current day's row exists upstream in the fct.

Path	Methods	Tier	Filters	Pagination	Sort
`/v1/celo/celo_gpay_balances_native/daily`	GET	tier3	`token`, `start_date`, `end_date`	--	date DESC

GET /v1/celo/celo_gpay_balances_native/daily

Daily total net-flow balance (native units) by token. Whitelisted tokens only (USDT/USDC in practice — see scope note). Ends at the complete previous day (dashboard convention); the current day's row exists upstream in the fct.

Model: api_celo_gpay_balances_native_daily — table dbt.api_celo_gpay_balances_native_daily

Declared filters

Parameter	Operator	Column	Type	Notes
`token`	`=`	`label`	string	Token symbol
`start_date`	`>=`	`date`	date	Inclusive start date
`end_date`	`<=`	`date`	date	Inclusive end date

Filter policy: Unfiltered requests allowed.

Pagination: none (full result set, bare JSON array)

Sort: date DESC

Columns

Column	Type	Description
`date`	`Nullable(Date)`	The calendar date of the balance snapshot.
`label`	`LowCardinality(String)`	The token symbol.
`value`	`Float64`	The total balance in native token units.

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_balances_native/daily?start_date=2026-01-01" \
  -H "X-API-Key: YOUR_API_KEY"

celo_gpay_balances_usd¶

Daily total net-flow balance (USD) by token. Whitelisted tokens only (USDT/USDC in practice — see scope note). Ends at the complete previous day (dashboard convention); the current day's row exists upstream in the fct.

Path	Methods	Tier	Filters	Pagination	Sort
`/v1/celo/celo_gpay_balances_usd/daily`	GET	tier3	`token`, `start_date`, `end_date`	--	date DESC

GET /v1/celo/celo_gpay_balances_usd/daily

Daily total net-flow balance (USD) by token. Whitelisted tokens only (USDT/USDC in practice — see scope note). Ends at the complete previous day (dashboard convention); the current day's row exists upstream in the fct.

Model: api_celo_gpay_balances_usd_daily — table dbt.api_celo_gpay_balances_usd_daily

Declared filters

Parameter	Operator	Column	Type	Notes
`token`	`=`	`label`	string	Token symbol
`start_date`	`>=`	`date`	date	Inclusive start date
`end_date`	`<=`	`date`	date	Inclusive end date

Filter policy: Unfiltered requests allowed.

Pagination: none (full result set, bare JSON array)

Sort: date DESC

Columns

Column	Type	Description
`date`	`Nullable(Date)`	The calendar date of the balance snapshot.
`label`	`LowCardinality(String)`	The token symbol.
`value`	`Float64`	The total balance in USD for this token.

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_balances_usd/daily?start_date=2026-01-01" \
  -H "X-API-Key: YOUR_API_KEY"

celo_gpay_cardholder_engagement¶

Current card population split by engagement segment: for cards not being used, is the holder still active on Celo at all? See fct_celo_gpay_cardholder_engagement for horizon clipping and for why '__wallet_unmapped' is a coverage limit rather than an observation of absence.

Path	Methods	Tier	Filters	Pagination	Sort
`/v1/celo/celo_gpay_cardholder_engagement/latest`	GET	tier1	--	--	--

GET /v1/celo/celo_gpay_cardholder_engagement/latest

Current card population split by engagement segment: for cards not being used, is the holder still active on Celo at all? See fct_celo_gpay_cardholder_engagement for horizon clipping and for why '__wallet_unmapped' is a coverage limit rather than an observation of absence.

Model: api_celo_gpay_cardholder_engagement — table dbt.api_celo_gpay_cardholder_engagement

Legacy endpoint — GET only, no query parameters, returns the full table.

Columns

Column	Type	Description
`label`	`String`	engagement_segment from fct_celo_gpay_cardholder_engagement.
`value`	`UInt64`	Cards in this segment.
`wallet_out_usd_retail`	`Float64`	Summed 30-day wallet outflow under $1,000 per transfer - the size of the prize for the reactivation segments.
`wallet_out_usd_total`	`Float64`	Same window, all transfer sizes. Published alongside the retail figure because the two diverge by an order of magnitude.
`as_of_date`	`Date`	The horizon the segmentation is computed as of.

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_cardholder_engagement/latest" \
  -H "X-API-Key: YOUR_API_KEY"

celo_gpay_churn¶

Monthly new/retained/returning/churned segmentation by scope (Payment, Any).

Path	Methods	Tier	Filters	Pagination	Sort
`/v1/celo/celo_gpay_churn/monthly`	GET	tier3	`scope`, `start_date`, `end_date`	--	month DESC

GET /v1/celo/celo_gpay_churn/monthly

Monthly new/retained/returning/churned segmentation by scope (Payment, Any).

Model: api_celo_gpay_churn_monthly — table dbt.api_celo_gpay_churn_monthly

Declared filters

Parameter	Operator	Column	Type	Notes
`scope`	`=`	`scope`	string	Churn scope
`start_date`	`>=`	`month`	date	Inclusive start month
`end_date`	`<=`	`month`	date	Inclusive end month

Filter policy: Unfiltered requests allowed.

Pagination: none (full result set, bare JSON array)

Sort: month DESC

Columns

Column	Type	Description
`scope`	`String`	The activity scope for churn calculation (e.g., all, payment).
`month`	`String`	The first day of the month.
`new_users`	`UInt64`	Users active for the first time this month.
`retained_users`	`UInt64`	Users active in both this and the previous month.
`returning_users`	`UInt64`	Users returning after a period of inactivity.
`churned_users`	`UInt64`	Users active last month but not this month.
`total_active`	`UInt64`	Total active users this month.
`churn_rate`	`Float64`	The percentage of last month's users who churned.
`retention_rate`	`Float64`	The percentage of last month's users who were retained.

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_churn/monthly?start_date=2026-01-01" \
  -H "X-API-Key: YOUR_API_KEY"

celo_gpay_churn_rates¶

Monthly churn and retention rates by scope (Payment, Any).

Path	Methods	Tier	Filters	Pagination	Sort
`/v1/celo/celo_gpay_churn_rates/monthly`	GET	tier3	`scope`, `start_date`, `end_date`	--	month DESC

GET /v1/celo/celo_gpay_churn_rates/monthly

Monthly churn and retention rates by scope (Payment, Any).

Model: api_celo_gpay_churn_rates_monthly — table dbt.api_celo_gpay_churn_rates_monthly

Declared filters

Parameter	Operator	Column	Type	Notes
`scope`	`=`	`scope`	string	Churn scope
`start_date`	`>=`	`month`	date	Inclusive start month
`end_date`	`<=`	`month`	date	Inclusive end month

Filter policy: Unfiltered requests allowed.

Pagination: none (full result set, bare JSON array)

Sort: month DESC

Columns

Column	Type	Description
`scope`	`String`	The activity scope (e.g., all, payment).
`month`	`String`	The first day of the month.
`churn_rate`	`Float64`	The churn rate for the month.
`retention_rate`	`Float64`	The retention rate for the month.

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_churn_rates/monthly?start_date=2026-01-01" \
  -H "X-API-Key: YOUR_API_KEY"

celo_gpay_first_fund_by_channel¶

Funded cards by first_fund_channel (shape of the card's earliest inbound transfer). Unfunded cards excluded. One row per card, unlike funding_by_channel which is per relationship.

Path	Methods	Tier	Filters	Pagination	Sort
`/v1/celo/celo_gpay_first_fund_by_channel/latest`	GET	tier1	--	--	--

GET /v1/celo/celo_gpay_first_fund_by_channel/latest

Funded cards by first_fund_channel (shape of the card's earliest inbound transfer). Unfunded cards excluded. One row per card, unlike funding_by_channel which is per relationship.

Model: api_celo_gpay_first_fund_by_channel — table dbt.api_celo_gpay_first_fund_by_channel

Legacy endpoint — GET only, no query parameters, returns the full table.

Columns

Column	Type	Description
`label`	`String`	first_fund_channel from fct_celo_gpay_card_funnel.
`value`	`UInt64`	Distinct funded cards whose first fund used this channel.
`as_of_date`	`Nullable(Date)`	The funnel's observation horizon (observed_through), as a single scalar across all channels (not a per-channel max).

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_first_fund_by_channel/latest" \
  -H "X-API-Key: YOUR_API_KEY"

celo_gpay_funded_addresses¶

Cumulative cards that have ever RECEIVED money, by day. RESTATED 2026-08-05: this served a first-PAYMENT count until then — activation under the funded label, reading 654 against a true 1075. The old series is api_celo_gpay_activated_addresses_daily.

Path	Methods	Tier	Filters	Pagination	Sort
`/v1/celo/celo_gpay_funded_addresses/daily`	GET	tier3	--	--	--
`/v1/celo/celo_gpay_funded_addresses/weekly`	GET	tier3	--	--	--
`/v1/celo/celo_gpay_funded_addresses/monthly`	GET	tier3	--	--	--

GET /v1/celo/celo_gpay_funded_addresses/daily

Cumulative cards that have ever RECEIVED money, by day. RESTATED 2026-08-05: this served a first-PAYMENT count until then — activation under the funded label, reading 654 against a true 1075. The old series is api_celo_gpay_activated_addresses_daily.

Model: api_celo_gpay_funded_addresses_daily — table dbt.api_celo_gpay_funded_addresses_daily

Legacy endpoint — GET only, no query parameters, returns the full table.

Columns

Column	Type	Description
`date`	`Date`	The calendar date.
`value`	`UInt64`	Cumulative cards that have ever received an inbound transfer.

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_funded_addresses/daily" \
  -H "X-API-Key: YOUR_API_KEY"

GET /v1/celo/celo_gpay_funded_addresses/weekly

Cumulative cards that have ever RECEIVED money, by week. Restated 2026-08-05 — see api_celo_gpay_funded_addresses_daily.

Model: api_celo_gpay_funded_addresses_weekly — table dbt.api_celo_gpay_funded_addresses_weekly

Legacy endpoint — GET only, no query parameters, returns the full table.

Columns

Column	Type	Description
`date`	`Date`	The first day of the ISO week.
`value`	`UInt64`	Cumulative cards that have ever received an inbound transfer.

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_funded_addresses/weekly" \
  -H "X-API-Key: YOUR_API_KEY"

GET /v1/celo/celo_gpay_funded_addresses/monthly

Cumulative cards that have ever RECEIVED money, by month. Restated 2026-08-05 — see api_celo_gpay_funded_addresses_daily.

Model: api_celo_gpay_funded_addresses_monthly — table dbt.api_celo_gpay_funded_addresses_monthly

Legacy endpoint — GET only, no query parameters, returns the full table.

Columns

Column	Type	Description
`date`	`Date`	The first day of the month.
`value`	`UInt64`	Cumulative cards that have ever received an inbound transfer.

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_funded_addresses/monthly" \
  -H "X-API-Key: YOUR_API_KEY"

celo_gpay_funding_by_channel¶

Funding relationships by shape channel (cip64_direct_solo / hub / mediated / …). Not a MiniPay identity label. cards = distinct Safes, relationships = (safe, funder, token) rows, amount = summed known-decimal native amount.

Path	Methods	Tier	Filters	Pagination	Sort
`/v1/celo/celo_gpay_funding_by_channel/latest`	GET	tier1	--	--	--

GET /v1/celo/celo_gpay_funding_by_channel/latest

Funding relationships by shape channel (cip64_direct_solo / hub / mediated / …). Not a MiniPay identity label. cards = distinct Safes, relationships = (safe, funder, token) rows, amount = summed known-decimal native amount.

Model: api_celo_gpay_funding_by_channel — table dbt.api_celo_gpay_funding_by_channel

Legacy endpoint — GET only, no query parameters, returns the full table.

Columns

Column	Type	Description
`label`	`String`	funding_channel value from fct_celo_gpay_card_funding.
`cards`	`UInt64`	Distinct card Safes in this channel.
`relationships`	`UInt64`	Distinct (safe, funder, token) funding relationships.
`amount`	`Float64`	Sum of total_amount where known (USDT/USDC); NULL amounts skipped.
`as_of_date`	`Nullable(Date)`	Latest funding date this model has observed, as a single scalar across all channels (not a per-channel max).

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_funding_by_channel/latest" \
  -H "X-API-Key: YOUR_API_KEY"

celo_gpay_funnel_cohorts¶

Card funnel by issuance cohort. month is the month the cards were ISSUED, not a month of activity, so the series does not read left-to-right as a timeline - each row describes what one group of cards went on to do. Plot the windowed rates. funded_ever/activated_ever slope down toward the presen...

Path	Methods	Tier	Filters	Pagination	Sort
`/v1/celo/celo_gpay_funnel_cohorts/monthly`	GET	tier1	`start_date`, `end_date`	--	month DESC

GET /v1/celo/celo_gpay_funnel_cohorts/monthly

Card funnel by issuance cohort. month is the month the cards were ISSUED, not a month of activity, so the series does not read left-to-right as a timeline - each row describes what one group of cards went on to do. Plot the windowed rates. funded_ever/activated_ever slope down toward the presen...

Model: api_celo_gpay_funnel_cohorts_monthly — table dbt.api_celo_gpay_funnel_cohorts_monthly

Declared filters

Parameter	Operator	Column	Type	Notes
`start_date`	`>=`	`month`	date	Inclusive start of issuance cohort month
`end_date`	`<=`	`month`	date	Inclusive end of issuance cohort month

Filter policy: Unfiltered requests allowed.

Pagination: none (full result set, bare JSON array)

Sort: month DESC

Columns

Column	Type	Description
`month`	`String`	Issuance cohort month, as a string date.
`cards_issued`	`UInt64`	Cards issued in the cohort month.
`funded_ever`	`UInt64`	Cards funded at any point since issuance. Not comparable across rows.
`activated_ever`	`UInt64`	Cards that spent at any point since issuance. Not comparable across rows.
`funded_rate_7d`	`Nullable(Float64)`	Share of cards funded within 7 days of issuance, among those old enough to judge.
`funded_rate_30d`	`Nullable(Float64)`	Share of cards funded within 30 days of issuance, among those old enough to judge.
`activated_rate_7d`	`Nullable(Float64)`	Share of cards that spent within 7 days of issuance.
`activated_rate_30d`	`Nullable(Float64)`	Share of cards that spent within 30 days of issuance.
`spend_rate_of_funded_30d`	`Nullable(Float64)`	Share of 30-day-funded cards that went on to spend - the second leg of the funnel.
`median_days_issue_to_fund`	`Int32`	Median days from issuance to funding, among funded cards.
`median_days_fund_to_spend`	`Int32`	Median days from funding to first spend, among cards that did both.
`cohort_complete_7d`	`Bool`	Every card in the row has had 7 days of observation; the 7-day rates are final.
`cohort_complete_30d`	`Bool`	Every card in the row has had 30 days of observation; the 30-day rates are final.

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_funnel_cohorts/monthly?start_date=2026-01-01" \
  -H "X-API-Key: YOUR_API_KEY"

celo_gpay_kpi¶

Monthly KPI table (MAU, volumes, net flow, ARPU, repeat rate). Backs the KPI tiles and monthly KPI charts. Whitelisted tokens only (USDT/USDC in practice — see scope note).

Path	Methods	Tier	Filters	Pagination	Sort
`/v1/celo/celo_gpay_kpi/monthly`	GET	tier3	--	--	--

GET /v1/celo/celo_gpay_kpi/monthly

Monthly KPI table (MAU, volumes, net flow, ARPU, repeat rate). Backs the KPI tiles and monthly KPI charts. Whitelisted tokens only (USDT/USDC in practice — see scope note).

Model: api_celo_gpay_kpi_monthly — table dbt.api_celo_gpay_kpi_monthly

Legacy endpoint — GET only, no query parameters, returns the full table.

Columns

Column	Type	Description
`month`	`Date`	The first day of the month.
`mau`	`UInt64`	Monthly active users across all activity types.
`payment_mau`	`UInt64`	Monthly active users who made payments.
`deposit_mau`	`UInt64`	Monthly active users who made deposits.
`withdrawal_mau`	`UInt64`	Monthly active users who made withdrawals.
`total_payment_volume_usd`	`Float64`	Total payment volume in USD for the month. 0, never NULL, when no payments occurred.
`total_payment_count`	`UInt64`	Total number of payments in the month.
`total_deposit_volume_usd`	`Float64`	Total deposit volume in USD for the month. 0, never NULL, when none occurred.
`total_withdrawal_volume_usd`	`Float64`	Total withdrawal volume in USD for the month. 0, never NULL, when none occurred.
`net_flow_usd`	`Float64`	Net flow (deposits minus withdrawals) in USD for the month. Components are coalesced to 0 upstream, so a month missing one action no longer reads NULL.
`reversal_total_usd`	`Float64`	Total reversal value in USD for the month. Currently 0 in every month — GP has never issued a Reversal on Celo. 0 means "none happened", not "not tracked".
`arpu`	`Float64`	Average revenue per user in USD.
`avg_tx_per_user`	`Float64`	Average number of transactions per active user.
`repeat_purchase_rate`	`Float64`	Percentage of users who made more than one payment.

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_kpi/monthly" \
  -H "X-API-Key: YOUR_API_KEY"

celo_gpay_payments¶

Trailing-7D payment count with WoW change_pct. Counter tile.

Path	Methods	Tier	Filters	Pagination	Sort
`/v1/celo/celo_gpay_payments/last_7d`	GET	tier3	--	--	--
`/v1/celo/celo_gpay_payments/hourly`	GET	tier3	`token`, `start_date`, `end_date`	--	date DESC

GET /v1/celo/celo_gpay_payments/last_7d

Trailing-7D payment count with WoW change_pct. Counter tile.

Model: api_celo_gpay_payments_7d — table dbt.api_celo_gpay_payments_7d

Legacy endpoint — GET only, no query parameters, returns the full table.

Columns

Column	Type	Description
`value`	`Nullable(Float64)`	The total number of payments in the last 7 days.
`change_pct`	`Nullable(Float64)`	The percentage change compared to the previous 7-day period.
`as_of_date`	`Nullable(Date)`	Date the snapshot is computed as of (max date in the underlying data).

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_payments/last_7d" \
  -H "X-API-Key: YOUR_API_KEY"

GET /v1/celo/celo_gpay_payments/hourly

Hourly payment counts by token over the trailing 14 days.

Model: api_celo_gpay_payments_hourly — table dbt.api_celo_gpay_payments_hourly

Declared filters

Parameter	Operator	Column	Type	Notes
`token`	`=`	`label`	string	Token symbol
`start_date`	`>=`	`date`	date	Inclusive start date
`end_date`	`<=`	`date`	date	Inclusive end date

Filter policy: Unfiltered requests allowed.

Pagination: none (full result set, bare JSON array)

Sort: date DESC

Columns

Column	Type	Description
`date`	`DateTime`	The hour timestamp of the payment activity.
`label`	`String`	The token symbol.
`value`	`UInt64`	The number of payments in this hour for this token.

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_payments/hourly?start_date=2026-01-01" \
  -H "X-API-Key: YOUR_API_KEY"

celo_gpay_payments_by_token¶

Daily payment count split by token (whitelisted; USDT/USDC in practice).

Path	Methods	Tier	Filters	Pagination	Sort
`/v1/celo/celo_gpay_payments_by_token/daily`	GET	tier3	`token`, `start_date`, `end_date`	--	date DESC
`/v1/celo/celo_gpay_payments_by_token/weekly`	GET	tier3	`token`, `start_date`, `end_date`	--	date DESC
`/v1/celo/celo_gpay_payments_by_token/monthly`	GET	tier3	`token`, `start_date`, `end_date`	--	date DESC

GET /v1/celo/celo_gpay_payments_by_token/daily

Daily payment count split by token (whitelisted; USDT/USDC in practice).

Model: api_celo_gpay_payments_by_token_daily — table dbt.api_celo_gpay_payments_by_token_daily

Declared filters

Parameter	Operator	Column	Type	Notes
`token`	`=`	`label`	string	Token symbol
`start_date`	`>=`	`date`	date	Inclusive start date
`end_date`	`<=`	`date`	date	Inclusive end date

Filter policy: Unfiltered requests allowed.

Pagination: none (full result set, bare JSON array)

Sort: date DESC

Columns

Column	Type	Description
`date`	`Date`	The calendar date.
`label`	`LowCardinality(String)`	The token symbol.
`value`	`UInt64`	The number of payments for this token on this date.

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_payments_by_token/daily?start_date=2026-01-01" \
  -H "X-API-Key: YOUR_API_KEY"

GET /v1/celo/celo_gpay_payments_by_token/weekly

Weekly payment count split by token (whitelisted; USDT/USDC in practice).

Model: api_celo_gpay_payments_by_token_weekly — table dbt.api_celo_gpay_payments_by_token_weekly

Declared filters

Parameter	Operator	Column	Type	Notes
`token`	`=`	`label`	string	Token symbol
`start_date`	`>=`	`date`	date	Inclusive start date
`end_date`	`<=`	`date`	date	Inclusive end date

Filter policy: Unfiltered requests allowed.

Pagination: none (full result set, bare JSON array)

Sort: date DESC

Columns

Column	Type	Description
`date`	`Date`	The first day of the ISO week.
`label`	`LowCardinality(String)`	The token symbol.
`value`	`UInt64`	The number of payments for this token in this week.

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_payments_by_token/weekly?start_date=2026-01-01" \
  -H "X-API-Key: YOUR_API_KEY"

GET /v1/celo/celo_gpay_payments_by_token/monthly

Monthly payment count split by token (whitelisted; USDT/USDC in practice).

Model: api_celo_gpay_payments_by_token_monthly — table dbt.api_celo_gpay_payments_by_token_monthly

Declared filters

Parameter	Operator	Column	Type	Notes
`token`	`=`	`label`	string	Token symbol
`start_date`	`>=`	`date`	date	Inclusive start date
`end_date`	`<=`	`date`	date	Inclusive end date

Filter policy: Unfiltered requests allowed.

Pagination: none (full result set, bare JSON array)

Sort: date DESC

Columns

Column	Type	Description
`date`	`Date`	The first day of the month.
`label`	`LowCardinality(String)`	The token symbol.
`value`	`UInt64`	The number of payments for this token in this month.

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_payments_by_token/monthly?start_date=2026-01-01" \
  -H "X-API-Key: YOUR_API_KEY"

celo_gpay_retention¶

Monthly payment-cohort retention (absolute users) in date/label/value shape.

Path	Methods	Tier	Filters	Pagination	Sort
`/v1/celo/celo_gpay_retention/monthly`	GET	tier3	--	--	--

GET /v1/celo/celo_gpay_retention/monthly

Monthly payment-cohort retention (absolute users) in date/label/value shape.

Model: api_celo_gpay_retention_monthly — table dbt.api_celo_gpay_retention_monthly

Legacy endpoint — GET only, no query parameters, returns the full table.

Columns

Column	Type	Description
`date`	`String`	The activity month.
`label`	`String`	The cohort month label.
`value`	`UInt64`	The number of active users from this cohort.

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_retention/monthly" \
  -H "X-API-Key: YOUR_API_KEY"

celo_gpay_retention_by_action¶

Per-action monthly cohort retention heatmap.

Path	Methods	Tier	Filters	Pagination	Sort
`/v1/celo/celo_gpay_retention_by_action/monthly`	GET	tier3	`action`	--	--

GET /v1/celo/celo_gpay_retention_by_action/monthly

Per-action monthly cohort retention heatmap.

Model: api_celo_gpay_retention_by_action_monthly — table dbt.api_celo_gpay_retention_by_action_monthly

Declared filters

Parameter	Operator	Column	Type	Notes
`action`	`=`	`action`	string	Action type

Filter policy: Unfiltered requests allowed.

Pagination: none (full result set, bare JSON array)

Columns

Column	Type	Description
`x`	`String`	The activity month (x-axis of the heatmap).
`y`	`String`	The cohort month (y-axis of the heatmap).
`action`	`Nullable(String)`	The activity type (e.g., Payment, Deposit, Withdrawal).
`retention_pct`	`Float64`	The user retention percentage.
`value_abs`	`UInt64`	The absolute number of retained users.
`amount_retention_pct`	`Nullable(Float64)`	The amount retention percentage.
`value_usd`	`Nullable(Float64)`	The total USD amount for the cohort in this month.

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_retention_by_action/monthly?action=VALUE" \
  -H "X-API-Key: YOUR_API_KEY"

celo_gpay_retention_by_action_users¶

Per-action monthly cohort retention (absolute users).

Path	Methods	Tier	Filters	Pagination	Sort
`/v1/celo/celo_gpay_retention_by_action_users/monthly`	GET	tier3	`action`	--	--

GET /v1/celo/celo_gpay_retention_by_action_users/monthly

Per-action monthly cohort retention (absolute users).

Model: api_celo_gpay_retention_by_action_users_monthly — table dbt.api_celo_gpay_retention_by_action_users_monthly

Declared filters

Parameter	Operator	Column	Type	Notes
`action`	`=`	`action`	string	Action type

Filter policy: Unfiltered requests allowed.

Pagination: none (full result set, bare JSON array)

Columns

Column	Type	Description
`action`	`Nullable(String)`	The activity type (e.g., Payment, Deposit, Withdrawal).
`date`	`String`	The activity month.
`label`	`String`	The cohort month label.
`value`	`UInt64`	The number of active users from this cohort.

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_retention_by_action_users/monthly?action=VALUE" \
  -H "X-API-Key: YOUR_API_KEY"

celo_gpay_retention_pct¶

Monthly payment-cohort retention heatmap (x/y/retention_pct/value_abs/value_usd).

Path	Methods	Tier	Filters	Pagination	Sort
`/v1/celo/celo_gpay_retention_pct/monthly`	GET	tier3	--	--	--

GET /v1/celo/celo_gpay_retention_pct/monthly

Monthly payment-cohort retention heatmap (x/y/retention_pct/value_abs/value_usd).

Model: api_celo_gpay_retention_pct_monthly — table dbt.api_celo_gpay_retention_pct_monthly

Legacy endpoint — GET only, no query parameters, returns the full table.

Columns

Column	Type	Description
`x`	`String`	The activity month (x-axis of the heatmap).
`y`	`String`	The cohort month (y-axis of the heatmap).
`retention_pct`	`Float64`	The user retention percentage.
`value_abs`	`UInt64`	The absolute number of retained users.
`amount_retention_pct`	`Nullable(Float64)`	The amount retention percentage.
`value_usd`	`Nullable(Float64)`	The total USD amount for the cohort in this month.

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_retention_pct/monthly" \
  -H "X-API-Key: YOUR_API_KEY"

celo_gpay_retention_volume¶

Monthly payment-cohort retention by USD volume.

Path	Methods	Tier	Filters	Pagination	Sort
`/v1/celo/celo_gpay_retention_volume/monthly`	GET	tier3	--	--	--

GET /v1/celo/celo_gpay_retention_volume/monthly

Monthly payment-cohort retention by USD volume.

Model: api_celo_gpay_retention_volume_monthly — table dbt.api_celo_gpay_retention_volume_monthly

Legacy endpoint — GET only, no query parameters, returns the full table.

Columns

Column	Type	Description
`date`	`String`	The activity month.
`label`	`String`	The cohort month label.
`value`	`Nullable(Float64)`	The total USD volume for this cohort in this month.

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_retention_volume/monthly" \
  -H "X-API-Key: YOUR_API_KEY"

celo_gpay_settlement_cost¶

What it costs Gnosis Pay to settle Celo card charges, by month. Aggregates fct_celo_gpay_settlement_batches directly - the source is a few hundred rows, so a separate monthly fact would cost more to maintain than it saves. The headline is fee_usd_per_charge, which has fallen from 0.205 in March t...

Path	Methods	Tier	Filters	Pagination	Sort
`/v1/celo/celo_gpay_settlement_cost/monthly`	GET	tier1	`start_date`, `end_date`	--	month DESC

GET /v1/celo/celo_gpay_settlement_cost/monthly

What it costs Gnosis Pay to settle Celo card charges, by month. Aggregates fct_celo_gpay_settlement_batches directly - the source is a few hundred rows, so a separate monthly fact would cost more to maintain than it saves. The headline is fee_usd_per_charge, which has fallen from 0.205 in March t...

Model: api_celo_gpay_settlement_cost_monthly — table dbt.api_celo_gpay_settlement_cost_monthly

Declared filters

Parameter	Operator	Column	Type	Notes
`start_date`	`>=`	`month`	date	Inclusive start month
`end_date`	`<=`	`month`	date	Inclusive end month

Filter policy: Unfiltered requests allowed.

Pagination: none (full result set, bare JSON array)

Sort: month DESC

Columns

Column	Type	Description
`month`	`String`	Calendar month, as a string date.
`batches`	`UInt64`	Settlement transactions in the month.
`charges`	`UInt64`	Card charges swept in the month.
`failed_charges`	`UInt64`	Pulls that failed. 7 ever, none since June 2026.
`settled_usd`	`Float64`	Value settled out of the contracts, in USD.
`fee_celo`	`Float64`	CELO spent on LayerZero bridge hops.
`fee_usd`	`Float64`	Bridge fees priced in USD at each batch date.
`fee_usd_per_charge`	`Nullable(Float64)`	Bridge cost per card charge settled - the unit economics figure.
`fee_bps_of_volume`	`Nullable(Float64)`	Bridge cost as basis points of settled volume. 3.03 bps all-time, 1.19 in August.
`charges_per_batch`	`Nullable(Float64)`	Mean batch size. The driver of the per-charge cost.

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_settlement_cost/monthly?start_date=2026-01-01" \
  -H "X-API-Key: YOUR_API_KEY"

celo_gpay_total_activated¶

All-time distinct cards that have ever SPENT (662 on 2026-08-05). Counter tile. This is the value api_celo_gpay_total_funded served before the 2026-08-05 restatement, kept under its true name. Always <= total_funded.

Path	Methods	Tier	Filters	Pagination	Sort
`/v1/celo/celo_gpay_total_activated/all_time`	GET	tier0	--	--	--

GET /v1/celo/celo_gpay_total_activated/all_time

All-time distinct cards that have ever SPENT (662 on 2026-08-05). Counter tile. This is the value api_celo_gpay_total_funded served before the 2026-08-05 restatement, kept under its true name. Always <= total_funded.

Model: api_celo_gpay_total_activated — table dbt.api_celo_gpay_total_activated

Legacy endpoint — GET only, no query parameters, returns the full table.

Columns

Column	Type	Description
`value`	`Nullable(Float64)`	Distinct cards that have ever settled a payment.
`as_of_date`	`Nullable(Date)`	Date the snapshot is computed as of (max date in the underlying data).

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_total_activated/all_time"

celo_gpay_total_balance¶

Latest-day net-flow USDC+USDT float held across all GP Safes. Counter tile.

Path	Methods	Tier	Filters	Pagination	Sort
`/v1/celo/celo_gpay_total_balance/all_time`	GET	tier3	--	--	--

GET /v1/celo/celo_gpay_total_balance/all_time

Latest-day net-flow USDC+USDT float held across all GP Safes. Counter tile.

Model: api_celo_gpay_total_balance — table dbt.api_celo_gpay_total_balance

Legacy endpoint — GET only, no query parameters, returns the full table.

Columns

Column	Type	Description
`value`	`Nullable(Float64)`	The total balance in USD.
`as_of_date`	`Nullable(Date)`	Date the snapshot is computed as of (max date in the underlying data).

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_total_balance/all_time" \
  -H "X-API-Key: YOUR_API_KEY"

celo_gpay_total_funded¶

All-time distinct cards that have ever RECEIVED money (1087 on 2026-08-05). Counter tile. RESTATED 2026-08-05: previously served the PaymentUsers snapshot, i.e. cards that had ever SPENT, so it read 662 under the funded label. The old value lives on as api_celo_gpay_total_activated.

Path	Methods	Tier	Filters	Pagination	Sort
`/v1/celo/celo_gpay_total_funded/all_time`	GET	tier3	--	--	--

GET /v1/celo/celo_gpay_total_funded/all_time

All-time distinct cards that have ever RECEIVED money (1087 on 2026-08-05). Counter tile. RESTATED 2026-08-05: previously served the PaymentUsers snapshot, i.e. cards that had ever SPENT, so it read 662 under the funded label. The old value lives on as api_celo_gpay_total_activated.

Model: api_celo_gpay_total_funded — table dbt.api_celo_gpay_total_funded

Legacy endpoint — GET only, no query parameters, returns the full table.

Columns

Column	Type	Description
`value`	`Nullable(Float64)`	Distinct cards that have ever received an inbound transfer.
`as_of_date`	`Nullable(Date)`	Date the snapshot is computed as of (max date in the underlying data).

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_total_funded/all_time" \
  -H "X-API-Key: YOUR_API_KEY"

celo_gpay_total_payments¶

All-time payment count. Counter tile.

Path	Methods	Tier	Filters	Pagination	Sort
`/v1/celo/celo_gpay_total_payments/all_time`	GET	tier3	--	--	--

GET /v1/celo/celo_gpay_total_payments/all_time

All-time payment count. Counter tile.

Model: api_celo_gpay_total_payments — table dbt.api_celo_gpay_total_payments

Legacy endpoint — GET only, no query parameters, returns the full table.

Columns

Column	Type	Description
`value`	`Nullable(Float64)`	The total number of payments.
`as_of_date`	`Nullable(Date)`	Date the snapshot is computed as of (max date in the underlying data).

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_total_payments/all_time" \
  -H "X-API-Key: YOUR_API_KEY"

celo_gpay_total_volume¶

All-time card payment volume in USD across whitelisted tokens (USDT + USDC in practice). Counter tile.

Path	Methods	Tier	Filters	Pagination	Sort
`/v1/celo/celo_gpay_total_volume/all_time`	GET	tier3	--	--	--

GET /v1/celo/celo_gpay_total_volume/all_time

All-time card payment volume in USD across whitelisted tokens (USDT + USDC in practice). Counter tile.

Model: api_celo_gpay_total_volume — table dbt.api_celo_gpay_total_volume

Legacy endpoint — GET only, no query parameters, returns the full table.

Columns

Column	Type	Description
`value`	`Nullable(Float64)`	The total payment volume in USD.
`as_of_date`	`Nullable(Date)`	Date the snapshot is computed as of (max date in the underlying data).

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_total_volume/all_time" \
  -H "X-API-Key: YOUR_API_KEY"

celo_gpay_volume¶

Trailing-7D payment volume (USD) with WoW change_pct. Counter tile.

Path	Methods	Tier	Filters	Pagination	Sort
`/v1/celo/celo_gpay_volume/last_7d`	GET	tier3	--	--	--

GET /v1/celo/celo_gpay_volume/last_7d

Trailing-7D payment volume (USD) with WoW change_pct. Counter tile.

Model: api_celo_gpay_volume_7d — table dbt.api_celo_gpay_volume_7d

Legacy endpoint — GET only, no query parameters, returns the full table.

Columns

Column	Type	Description
`value`	`Nullable(Float64)`	The total payment volume in USD in the last 7 days.
`change_pct`	`Nullable(Float64)`	The percentage change compared to the previous 7-day period.
`as_of_date`	`Nullable(Date)`	Date the snapshot is computed as of (max date in the underlying data).

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_volume/last_7d" \
  -H "X-API-Key: YOUR_API_KEY"

celo_gpay_volume_payments_by_token¶

Daily payment volume (USD) split by token (whitelisted; USDT/USDC in practice).

Path	Methods	Tier	Filters	Pagination	Sort
`/v1/celo/celo_gpay_volume_payments_by_token/daily`	GET	tier3	`token`, `start_date`, `end_date`	--	date DESC
`/v1/celo/celo_gpay_volume_payments_by_token/weekly`	GET	tier3	`token`, `start_date`, `end_date`	--	date DESC
`/v1/celo/celo_gpay_volume_payments_by_token/monthly`	GET	tier3	`token`, `start_date`, `end_date`	--	date DESC

GET /v1/celo/celo_gpay_volume_payments_by_token/daily

Daily payment volume (USD) split by token (whitelisted; USDT/USDC in practice).

Model: api_celo_gpay_volume_payments_by_token_daily — table dbt.api_celo_gpay_volume_payments_by_token_daily

Declared filters

Parameter	Operator	Column	Type	Notes
`token`	`=`	`label`	string	Token symbol
`start_date`	`>=`	`date`	date	Inclusive start date
`end_date`	`<=`	`date`	date	Inclusive end date

Filter policy: Unfiltered requests allowed.

Pagination: none (full result set, bare JSON array)

Sort: date DESC

Columns

Column	Type	Description
`date`	`Date`	The calendar date.
`label`	`LowCardinality(String)`	The token symbol.
`value`	`Nullable(Float64)`	The payment volume in USD for this token on this date.

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_volume_payments_by_token/daily?start_date=2026-01-01" \
  -H "X-API-Key: YOUR_API_KEY"

GET /v1/celo/celo_gpay_volume_payments_by_token/weekly

Weekly payment volume (USD) split by token (whitelisted; USDT/USDC in practice).

Model: api_celo_gpay_volume_payments_by_token_weekly — table dbt.api_celo_gpay_volume_payments_by_token_weekly

Declared filters

Parameter	Operator	Column	Type	Notes
`token`	`=`	`label`	string	Token symbol
`start_date`	`>=`	`date`	date	Inclusive start date
`end_date`	`<=`	`date`	date	Inclusive end date

Filter policy: Unfiltered requests allowed.

Pagination: none (full result set, bare JSON array)

Sort: date DESC

Columns

Column	Type	Description
`date`	`Date`	The first day of the ISO week.
`label`	`LowCardinality(String)`	The token symbol.
`value`	`Nullable(Float64)`	The payment volume in USD for this token in this week.

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_volume_payments_by_token/weekly?start_date=2026-01-01" \
  -H "X-API-Key: YOUR_API_KEY"

GET /v1/celo/celo_gpay_volume_payments_by_token/monthly

Monthly payment volume (USD) split by token (whitelisted; USDT/USDC in practice).

Model: api_celo_gpay_volume_payments_by_token_monthly — table dbt.api_celo_gpay_volume_payments_by_token_monthly

Declared filters

Parameter	Operator	Column	Type	Notes
`token`	`=`	`label`	string	Token symbol
`start_date`	`>=`	`date`	date	Inclusive start date
`end_date`	`<=`	`date`	date	Inclusive end date

Filter policy: Unfiltered requests allowed.

Pagination: none (full result set, bare JSON array)

Sort: date DESC

Columns

Column	Type	Description
`date`	`Date`	The first day of the month.
`label`	`LowCardinality(String)`	The token symbol.
`value`	`Nullable(Float64)`	The payment volume in USD for this token in this month.

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_volume_payments_by_token/monthly?start_date=2026-01-01" \
  -H "X-API-Key: YOUR_API_KEY"

celo_gpay_wallet_balance_composition¶

Latest-day USD balance composition across whitelisted tokens (USDT/USDC in practice); sub-1% folded into Other.

Path	Methods	Tier	Filters	Pagination	Sort
`/v1/celo/celo_gpay_wallet_balance_composition/latest`	GET	tier3	--	--	--

GET /v1/celo/celo_gpay_wallet_balance_composition/latest

Latest-day USD balance composition across whitelisted tokens (USDT/USDC in practice); sub-1% folded into Other.

Model: api_celo_gpay_wallet_balance_composition — table dbt.api_celo_gpay_wallet_balance_composition

Legacy endpoint — GET only, no query parameters, returns the full table.

Columns

Column	Type	Description
`name`	`String`	The token symbol or name.
`value`	`Float64`	The balance amount in USD.
`as_of_date`	`Nullable(Date)`	Date the snapshot is computed as of (max date in the underlying data).

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_wallet_balance_composition/latest" \
  -H "X-API-Key: YOUR_API_KEY"

celo_gpay_wallet_share_of_spend¶

Monthly share of cardholder stablecoin outflow reaching the GP card vs going elsewhere. value is the RETAIL number (transfers under $1,000); value_all is raw flow including large treasury-scale movements that a handful of addresses dominate. Read fct_celo_gpay_wallet_share_of_spend_daily before...

Path	Methods	Tier	Filters	Pagination	Sort
`/v1/celo/celo_gpay_wallet_share_of_spend/monthly`	GET	tier1	`destination`, `start_date`, `end_date`	--	date DESC

GET /v1/celo/celo_gpay_wallet_share_of_spend/monthly

Monthly share of cardholder stablecoin outflow reaching the GP card vs going elsewhere. value is the RETAIL number (transfers under $1,000); value_all is raw flow including large treasury-scale movements that a handful of addresses dominate. Read fct_celo_gpay_wallet_share_of_spend_daily before...

Model: api_celo_gpay_wallet_share_of_spend_monthly — table dbt.api_celo_gpay_wallet_share_of_spend_monthly

Declared filters

Parameter	Operator	Column	Type	Notes
`destination`	`=`	`label`	string	to_card or to_elsewhere
`start_date`	`>=`	`date`	date	Inclusive start date
`end_date`	`<=`	`date`	date	Inclusive end date

Filter policy: Unfiltered requests allowed.

Pagination: none (full result set, bare JSON array)

Sort: date DESC

Columns

Column	Type	Description
`date`	`Date`	Month start.
`label`	`String`	to_card or to_elsewhere.
`value`	`Float64`	Retail outflow (transfers under $1,000) in USD.
`value_all`	`Float64`	All outflow in USD, large transfers included.
`transfers`	`UInt64`	Outbound transfer count.
`peak_daily_wallets`	`UInt64`	Highest single-day distinct sending wallets in the month. Not a monthly unique count - daily figures cannot be summed or maxed into one.

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_wallet_share_of_spend/monthly?start_date=2026-01-01" \
  -H "X-API-Key: YOUR_API_KEY"

celo_gpay_wallet_tenure¶

How long GP card funding wallets had been active on Celo before funding a card, by tenure bucket. Read 'pre_dates_our_window' as "at least this long, unknown how much longer" - those wallets were already transacting when coverage opens at the L2 migration, so their true tenure is unmeasurable her...

Path	Methods	Tier	Filters	Pagination	Sort
`/v1/celo/celo_gpay_wallet_tenure/latest`	GET	tier1	--	--	--

GET /v1/celo/celo_gpay_wallet_tenure/latest

How long GP card funding wallets had been active on Celo before funding a card, by tenure bucket. Read 'pre_dates_our_window' as "at least this long, unknown how much longer" - those wallets were already transacting when coverage opens at the L2 migration, so their true tenure is unmeasurable her...

Model: api_celo_gpay_wallet_tenure — table dbt.api_celo_gpay_wallet_tenure

Legacy endpoint — GET only, no query parameters, returns the full table.

Columns

Column	Type	Description
`label`	`String`	tenure_bucket from fct_celo_gpay_wallet_tenure.
`value`	`UInt64`	Funding wallets in this bucket.
`median_days_before_funding`	`Nullable(Float64)`	Median days on chain before first funding. Exact for uncensored buckets; a lower bound inside 'pre_dates_our_window'.
`as_of_date`	`Nullable(Date)`	Latest first-funding date covered, as a single scalar across buckets.

Example

curl "https://api.analytics.gnosis.io/v1/celo/celo_gpay_wallet_tenure/latest" \
  -H "X-API-Key: YOUR_API_KEY"