with big_burns as (

select

block_timestamp::date date

,tx_hash

from bsc.core.ez_token_transfers transfers

--join bsc.core.fact_transactions transactions using (tx_hash)

where 1=1

and block_timestamp > '2023-09-01'

--and STATUS = 'SUCCESS'

and to_address = '0x0000000000000000000000000000000000000000' --effectively burn transactions

and contract_address = '0x033c1c03718ba0f0871bb4dcc38b24f065d585bc' --ION

and amount > '1000'

and from_address in ('0xacbd40b85527c2be2b9b94ca0280d5a775331a68', '0x62680072e0e36ae4c38d9902c67e0167c5cc62fa'

,'0x5b3732d9ab8398533a5cc6c3fc4ea78f39a7261a', '0x2a70cb6bf05360214591405a2322fbffa36c7732'

,'0x225a1672544d4c0e9e0f2906fed3758a4ec631a3')

),

confirming_withdrawal as (

select

tx_hash

,block_timestamp::date as date

,from_address

,case

when to_address in ('0xacbd40b85527c2be2b9b94ca0280d5a775331a68'

,'0x4c33e3301af3e6db43cc1285d9a8fca4a496283e') then 'Treasury'

when to_address in ('0x62680072e0e36ae4c38d9902c67e0167c5cc62fa'

,'0x884c325f559db9f47a4afb7dc86627ddbd2ff5cb'

,'0x2e85f62acfbd35f5b9dbcaf78a3b066b51c221b5') then 'Partnershare'

when to_address = '0x5b3732d9ab8398533a5cc6c3fc4ea78f39a7261a' then 'Platform'

when to_address = '0x2a70cb6bf05360214591405a2322fbffa36c7732' then 'Marketplace 1st half share'

when to_address = '0x225a1672544d4c0e9e0f2906fed3758a4ec631a3' then 'Marketplace 2nd half share'

else to_address

end as Address