Updated 2024-12-12
    with swaps as (
    select
    symbol_in,
    symbol_out,
    tx_hash,
    platform,
    nvl(amount_in_usd, amount_out_usd) as amount_usd,
    block_timestamp,
    origin_from_address as swapper
    from
    blast.defi.ez_dex_swaps
    where
    amount_usd between 0
    and 1e7
    and block_timestamp >= dateadd(day, -30, current_date)
    ),
    final as (
    select
    symbol_in as symbol,
    tx_hash,
    amount_usd,
    swapper
    from
    swaps
    union
    all
    select
    symbol_out as symbol,
    tx_hash,
    amount_usd,
    swapper
    from
    swaps
    )
    select
    symbol,
    Last run: 2 months ago
    SYMBOL
    VOLUME_USD
    AVERAGE_AMOUNT_USD
    1
    WETH870631112.52798.662075567
    2
    USDB731602184.641030.0556626
    3
    BLAST82620182.1272.28565906
    4
    fwWETH39442073.09372.527301397
    5
    weETH28009018.476029.92862648
    6
    fwUSDB24202000.47413.440849875
    7
    USD+18772070.57243.932514294
    8
    fwBLAST15130463.8322.583655978
    9
    YES12241201.71639.593048486
    10
    WBTC10451248.65847.971492901
    10
    357B
    4s