-- get user who had a deposit transaction before (not necessary currently staked)

select

block_timestamp,

symbol,

contract_address,

--sum(amount) as total_staked,

origin_from_address

from

avalanche.core.ez_token_transfers

where

to_address = '0xb22c6d1c2897b950fc1040913c0d84d788f24df2'

union all

select

block_timestamp,

'KINGSHIT' as symbol,

contract_address,

--sum(decoded_log:amount)*pow(10,-18) as total_staked,

origin_from_address

from

avalanche.core.ez_decoded_event_logs

where

contract_address=lower('0x05b0def5c00ba371683d7035934bcf82b737c364')

and event_name='ERC20Transfer'

and decoded_log:to='0xb22c6d1c2897b950fc1040913c0d84d788f24df2'

),

user_deposit as (

origin_from_address,

count(distinct contract_address) as pool_deposited,

min(date(block_timestamp)) as first_deposit

from

memecoin_deposit

group by