Funding coverage - Token Terminal Docs

One row per chain, over the whole of Funding. resolved_share is wallets_resolved divided by wallets_with_edges.

Columns

Column	Type	Description
`chain_id`	STRING	Chain the wallets are on.
`wallets_with_edges`	INT64	Rows in Funding for this chain.
`wallets_resolved`	INT64	Of those, `funding_venue_project_id` is not null.
`resolved_share`	FLOAT64	`wallets_resolved` divided by `wallets_with_edges`.
`wallets_high`	INT64	Resolved wallets at `high` confidence.
`wallets_medium`	INT64	Resolved wallets at `medium` confidence.
`wallets_low`	INT64	Resolved wallets at `low` confidence.
`wallets_curated_source`	INT64	Resolved wallets whose `funding_venue_source` is `curated`.
`wallets_detected_source`	INT64	Resolved wallets whose `funding_venue_source` is `detected`.
`wallets_with_jurisdiction`	INT64	Resolved wallets with a `funding_jurisdiction`.
`jurisdiction_share`	FLOAT64	`wallets_with_jurisdiction` divided by `wallets_resolved`.
`distinct_venues`	INT64	Distinct `funding_venue_project_id` values on this chain.
`first_edge_at`	TIMESTAMP	Earliest `funding_first_edge_at` on this chain.
`last_edge_at`	TIMESTAMP	Latest `funding_first_edge_at` on this chain.

Sample queries

One chain's coverage
Every chain, ranked by resolved share
Chain name alongside the coverage

resolved_share and jurisdiction_share read together show how much of a chain’s funded wallets resolve to a venue, and how much of that group also resolves to a country.

select
    wallets_with_edges,
    wallets_resolved,
    resolved_share,
    wallets_with_jurisdiction,
    jurisdiction_share
from `reports_accounts.funding_coverage`
where chain_id = 'ethereum'

chain_id joins dimensions.chains for the display name.

select
    chains.name,
    coverage.resolved_share,
    coverage.wallets_high,
    coverage.wallets_medium,
    coverage.wallets_low
from `reports_accounts.funding_coverage` as coverage
join `dimensions.chains` as chains
    using (chain_id)
order by coverage.resolved_share desc