select

origin_from_address as user, tx_hash, block_timestamp,

sum(event_inputs:amount)/pow(10,18) * avg(price) as volume

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'

and event_inputs:chainId = '137'

and block_timestamp > CURRENT_DATE - 90

group by 1, 2, 3

order by volume DESC

),

next_transactions as (

select ft.tx_hash as tx, from_address, ft.block_timestamp

from polygon.core.fact_transactions ft

inner join eth_bridges e on e.user = ft.from_address

where from_address in (select user from eth_bridges)

and ft.block_timestamp::date = e.block_timestamp::date

and ft.block_timestamp > e.block_timestamp

order by ft.block_timestamp ASC)

select distinct event_name as event, count(tx_hash) as count, origin_to_address, count(distinct origin_from_address) as user,

case

when event_name in ('Swapped', 'Swap', 'TokenSwap', 'DODOSwap') then 'swap'

when event_name = 'Mint' then 'mint'

when event_name = 'Deposit' then 'deposit'

when event_name = 'Withdraw' then 'withdraw'

when event_name = 'Claim' then 'claim'

when event_name in('IncreasedLiquidity', 'AddLiquidity', 'DecreaseLiquidity') then 'liquidityAction'

when event_name = 'VoteCast' then 'vote'

when event_name = 'Borrow' then 'borrow'

when event_name = 'Repay' then 'repay'

when event_name = 'FlashLoan' then 'flashloan'