DatafiBase - TOP #20 MOST ACTIVE BASE ERC-20 CONTRACTS
    Updated 2023-08-04
    with erc20_transfer as
    (select
    date(block_timestamp) as date,
    -- contract_address,
    count(distinct tx_hash) as no_tx
    from base.core.fact_token_transfers
    group by 1,2)

    select contract_address, sum(no_tx) as no_tx from tmp group by 1 order by 2 desc limit 20

    Run a query to Download Data