itsxenuxCommon wallet activities and the most common platforms
    Updated 2022-06-24
    with users as (
    select distinct origin_from_address as wallet_address
    from ethereum.core.ez_token_transfers
    where origin_to_address = '0x881d40237659c251811cec9c364ef91dc08d300c'
    and amount_usd > 0)

    select top 20 b.label, count(distinct tx_hash) as total
    from ethereum.core.fact_event_logs a join ethereum.core.dim_labels b
    on a.contract_address = b.address
    where a.origin_from_address in (select wallet_address from users)
    group by b.label
    order by total desc
    Run a query to Download Data