Elprognerd15 - Top 10 tokens with the most of the 'swap from' on Arbitrum copy
    Updated 2023-03-08
    -- forked from 976b9768-0789-4997-9d65-a810d1f7f4ff

    select
    address_name,
    count (distinct tx_hash) as Swap_Count
    from Arbitrum.core.fact_event_logs x join Arbitrum.core.dim_labels y on x.contract_address = y.address
    where origin_to_address = '0xdef171fe48cf0115b1d80b88dc8eab59176fee57' and origin_from_address = event_inputs:from
    and event_name ilike 'transfer'
    and block_timestamp >= CURRENT_DATE - 90
    group by 1
    order by 2 desc
    limit 10


    Run a query to Download Data