contract_addresses as (

select *

from community.solana.securitize_buidl_contract_addresses

),

mint_burn_txs as (

select

fact_token_transfers.block_timestamp

, fact_token_transfers.tx_hash

, fact_token_transfers.event_index

, contract_addresses.blockchain

, contract_addresses.contract_address

, case

when fact_token_transfers.from_address = '0x0000000000000000000000000000000000000000'

then fact_token_transfers.raw_amount

else - fact_token_transfers.raw_amount

end / 1e6 as amount

, case

when fact_token_transfers.from_address = '0x0000000000000000000000000000000000000000'

then 'mint'

else 'burn'

end as event

from ethereum.core.fact_token_transfers

inner join contract_addresses

on fact_token_transfers.contract_address = contract_addresses.contract_address

and fact_token_transfers.block_timestamp > contract_addresses.create_date

and contract_addresses.blockchain = 'ethereum'

where (fact_token_transfers.from_address = '0x0000000000000000000000000000000000000000'

or fact_token_transfers.to_address = '0x0000000000000000000000000000000000000000')