chainparsertrending-base-tokens
    Updated 2024-09-27
    select
    symbol,
    sum(amount_usd)/1000000000 as volume_billion_usd
    from base.core.ez_token_transfers
    where amount_usd is not null
    and symbol <> 'USDC'
    and symbol <> 'USDT'
    and symbol <> 'DAI'
    and symbol <> 'USD+'
    and block_timestamp >= current_date() - 7
    group by symbol
    order by volume_billion_usd desc
    limit 5
    QueryRunArchived: QueryRun has been archived