mamad-5XN3k3BOB || Competitors DEX Volume (Daily)
    Updated 2025-04-04

    /*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)
    from external.defillama.fact_stablecoin_supply
    group by 1,2,3
    Last run: about 2 months ago
    DATE
    CHAIN
    PROTOCOL
    VOLUME
    1
    2024-11-07 00:00:00.000stacksallbridge classic43633
    2
    2024-10-31 00:00:00.000bobuniswap v37896537
    3
    2024-06-26 00:00:00.000merlinbitgenie amm810529
    4
    2024-08-26 00:00:00.000merlinmerlinswap1343479
    5
    2024-02-25 00:00:00.000stacksallbridge classic0
    6
    2025-01-17 00:00:00.000bitlayermacaron amm87207
    7
    2024-11-06 00:00:00.000merlinmerlinswap1758779
    8
    2024-07-15 00:00:00.000stacksallbridge classic16940
    9
    2024-11-11 00:00:00.000stacksallbridge classic38480
    10
    2024-02-15 00:00:00.000stacksallbridge classic0
    11
    2025-01-18 00:00:00.000bobuniswap v320265921
    12
    2024-10-13 00:00:00.000merlinbitgenie amm4342
    13
    2024-02-20 00:00:00.000stacksallbridge classic19
    14
    2024-06-09 00:00:00.000merlinmerlinswap804145
    15
    2024-06-10 00:00:00.000merlinbitgenie amm2939
    16
    2024-09-19 00:00:00.000bobvelodrome v113052
    17
    2024-04-26 00:00:00.000stacksallbridge classic62659
    18
    2024-08-13 00:00:00.000bsquaredglowswap59755
    19
    2024-05-21 00:00:00.000bsquaredglowswap298962
    20
    2024-08-25 00:00:00.000bitlayermacaron amm640031
    ...
    1878
    106KB
    1s