Flipside Team⭐️ [parent Query] NEP245 - (TVL Segmentation) Token Mint Volume by Chain & Token
    Updated 9 hours ago
    -- forked from NEP245 - Net Chain Volume, over time @ https://flipsidecrypto.xyz/studio/queries/b93dd1a6-4386-4c6c-80dc-be2ae64d4765

    with source_data AS (
    SELECT
    *
    from
    $query('f7283bcc-2a59-45fe-8173-276bc7031ad0')
    where log_event in ('mt_mint', 'mt_burn')
    )
    select
    symbol,
    blockchain,
    sum(iff(log_event = 'mt_mint', amount_usd, -amount_usd)) as gross_amount_usd,
    sum(iff(log_event = 'mt_mint', token_amount_adj, -token_amount_adj)) as gross_token_amount
    from
    source_data
    group by
    1,
    2
    order by
    1,
    2


    Last run: about 9 hours agoAuto-refreshes every 24 hours
    SYMBOL
    BLOCKCHAIN
    GROSS_AMOUNT_USD
    GROSS_TOKEN_AMOUNT
    1
    AAVEethereum381.4930324232.359398654
    2
    ARBarbitrum3008.5125523974910.865335492
    3
    ARBnear2.756798722.044446862
    4
    AURORAethereum65096.5204153279465.802490785
    5
    AURORAnear105998.612973482567032.90315688
    6
    BLACKDRAGONnear2471.67970078593919244246.0099
    7
    BRETTbase360.2730705384410.624893749
    8
    BRRRnear1209.479045208270105.160357799
    9
    COWgnosis49103.673453463119671.759770474
    10
    DAIethereum99941.03614827199986.4299866
    11
    DOGEnear24782.52792857261705.04612335
    12
    ETHbsc00
    13
    GMXarbitrum490.17051905221.378805874
    14
    GNOgnosis49887.17538274.422
    15
    LINKethereum2078.655736415154.690491533
    16
    MOGethereum359.936221221176970631.109693
    17
    PEPEethereum3832.312534926381439889.075354
    18
    REFnear2964.43732700918390.048769021
    19
    SAFEgnosis51502.52343928785949.074057644
    20
    SHIBethereum1987.530174062103680250.380287
    49
    2KB
    2s