freemartianFavorite Chain - ETH Hop Whales
    Updated 2022-06-22
    select
    origin_from_address as user,
    count(distinct origin_from_address) as whale_count,
    sum(event_inputs:amount)/pow(10,18) * avg(price) as volume,
    case
    when event_inputs:chainId = '10' then 'Optimism'
    when event_inputs:chainId = '100' then 'xDAI'
    when event_inputs:chainId = '137' then 'Polygon'
    when event_inputs:chainId = '42161' then 'Arbitrum'
    end as chain
    from ethereum.core.fact_event_logs l
    inner join ethereum.core.fact_hourly_token_prices p on to_char(block_timestamp, 'yyyy-mm-dd HH24:00:00.000 ') = hour
    where origin_to_address = lower('0xb8901acB165ed027E32754E0FFe830802919727f')
    and event_name = 'TransferSentToL2'
    and symbol = 'WETH'
    group by user, chain
    having volume > 1000000
    order by volume DESC

    Run a query to Download Data