SpecterFrom Assest by tx
    Updated 2025-02-18
    SELECT
    symbol_in AS From_assest,
    COUNT(DISTINCT tx_hash) AS transaction_count,
    sum(coalesce(amount_in_usd, amount_out_usd)) as volume_usd,
    FROM blast.defi.ez_dex_swaps
    GROUP BY From_assest
    order by transaction_count desc
    LIMIT 10;


    Last run: 2 months ago
    FROM_ASSEST
    TRANSACTION_COUNT
    VOLUME_USD
    1
    WETH72216669509145454.66
    2
    USDB41225386005646131.4
    3
    BLAST866173453492272.58
    4
    PAC361891158514465.29
    5
    USD+20166467763226.09
    6
    fwWETH198258143735515.07
    7
    ezETH191481913078344.42
    8
    OLE18758852589245.65
    9
    ANDY14643621828487.78
    10
    fwUSDB127056109491945.68
    10
    295B
    4s