faraz-Lvyyy8compare of the beets with top 4 token in the optimism
    Updated 2022-10-19
    select
    b.SYMBOL as name,
    count(TX_HASH) as "number of transaction"
    from optimism.core.fact_token_transfers a
    join optimism.core.dim_contracts b
    on b.ADDRESS = a.CONTRACT_ADDRESS
    where b.SYMBOL='BEETS'
    OR b.SYMBOL='OP'
    or b.SYMBOL='USDC'
    or b.SYMBOL='WETH'
    or b.SYMBOL='USDT'
    GROUP by 1
    order by 2 DESC
    limit 100
    Run a query to Download Data