from ethereum.core.ez_token_transfers

where origin_to_address='0xfe5f68cdf736d007f2d70e7f3976458dba9745f3'

and contract_address='0xd8f1460044925d2d5c723c7054cd9247027415b7'

and amount is not null),

tab2 as (select block_timestamp, from_address, to_address, amount

from ethereum.core.ez_token_transfers

where contract_address='0xd8f1460044925d2d5c723c7054cd9247027415b7')

select date_trunc('{{Time_Frame}}',block_timestamp) as "Date", from_address, to_address, amount

from tab1 left join tab2 on tab1.origin_from_address=tab2.from_address),

tab4 as (select ADDRESS, ADDRESS_NAME

from ethereum.core.dim_labels)

select "Date", count(distinct from_address) as "Claimers Count", sum(amount) as "SAIL Volume", case

when address_name='bybit deposit_wallet' then 'Bybit'

when address_name='gate.io deposit_wallet' then 'Gate.io'

end as CEX

from tab3 left join tab4 on tab3.to_address=tab4.address

where address_name='bybit deposit_wallet' or address_name='gate.io deposit_wallet'

group by 1,4

order by 1