Funding venue distribution - Token Terminal Docs

One row per chain, venue and confidence tier, including the null venue and null confidence row for wallets that resolve to no venue. wallet_share is wallets divided by the chain’s total rows in Funding.

Columns

Column	Type	Description
`chain_id`	STRING	Chain the wallets are on.
`funding_venue_project_id`	STRING	Venue the wallets resolve to. Null for the unresolved row.
`funding_venue_type`	STRING	`cex` or `fiat-ramps`, from Accounts ▸ Registry’s Venues tab. Null for the unresolved row.
`funding_jurisdiction`	STRING	ISO 3166-1 alpha-2 of the venue. Null unless the venue passes the jurisdiction gate.
`funding_confidence`	STRING	`high`, `medium` or `low`. Null for the unresolved row.
`wallets`	INT64	Wallets on this chain at this venue and confidence tier.
`wallet_share`	FLOAT64	`wallets` divided by the chain’s total rows in Funding.
`first_edge_at`	TIMESTAMP	Earliest `funding_first_edge_at` in the group.
`last_edge_at`	TIMESTAMP	Latest `funding_first_edge_at` in the group.

Sample queries

One chain's venue breakdown
Top venues across every chain, at high confidence
Venue name alongside the distribution

The unresolved row has a null funding_venue_project_id, so wallet_share still sums to 1 across every row for the chain.

select
    funding_venue_project_id,
    funding_confidence,
    wallets,
    wallet_share
from `reports_accounts.funding_venue_distribution`
where chain_id = 'ethereum'
order by wallets desc

Summing wallets before ranking avoids letting one chain’s larger wallet count dominate the order.

select
    funding_venue_project_id,
    sum(wallets) as wallets
from `reports_accounts.funding_venue_distribution`
where funding_confidence = 'high'
group by funding_venue_project_id
order by wallets desc
limit 20

funding_venue_project_id joins dimensions.projects for the display name.

select
    projects.name,
    dist.chain_id,
    dist.funding_confidence,
    dist.wallets
from `reports_accounts.funding_venue_distribution` as dist
join `dimensions.projects` as projects
    on dist.funding_venue_project_id = projects.project_id
where dist.chain_id = 'ethereum'
order by dist.wallets desc