BOB || Competitors DEX Fees

mamad-5XN3k3BOB || Competitors DEX Fees

Updated 2025-04-04

-- forked from BOB || Competitors DEX Volume (Daily) @ https://flipsidecrypto.xyz/studio/queries/68c56f20-0a89-47de-ad8f-6004a35acb87

/*select

from external.defillama.fact_chain_tvl

where chain in ('Bitlayer','Stacks','Merlin','BSquared','BOB')

select

date,

chain,

protocol,

VOLUME

from external.defillama.fact_dex_volume

where chain in ('bitlayer','stacks','merlin','bsquared','bob')

and date >= '2024-01-01'

--group by 1,2

select

chain,

protocol,

sum(FEES) as fee

from external.defillama.fact_protocol_fees_revenue

where chain in ('bitlayer','stacks','merlin','bsquared','bob')

group by 1,2

select

STABLECOIN,

SYMBOL,

CHAINS,

max_by(CIRCULATING,date) as circ,

max(date)

Last run: about 2 months ago

358B