--from native

select

block_number, block_timestamp, 'avalanche' as chain, tx_hash, origin_from_address as sender, 'AVAX' as from_token, amount as token_from_amount, amount_usd as token_from_amount_usd

from avalanche.core.ez_native_transfers

where block_timestamp::date between '{{Start_Date}}' and '{{End_Date}}'

and ORIGIN_TO_ADDRESS = '0xce16f69375520ab01377ce7b88f5ba8c48f8d666'

and origin_from_address = from_address

union

--from token

select

block_number, block_timestamp, 'avalanche' as chain, tx_hash, origin_from_address as sender, symbol as from_token, amount as token_from_amount, amount_usd as token_from_amount_usd

from avalanche.core.ez_token_transfers

where block_timestamp::date between '{{Start_Date}}' and '{{End_Date}}'

and ORIGIN_TO_ADDRESS = '0xce16f69375520ab01377ce7b88f5ba8c48f8d666'

and origin_from_address = from_address

),

to_avax as (

--to token

select

block_number, block_timestamp, 'avalanche' as chain, tx_hash, to_address as receiver, symbol as to_token, amount as token_to_amount, amount_usd as token_to_amount_usd

from avalanche.core.ez_token_transfers

where block_timestamp::date between '{{Start_Date}}' and '{{End_Date}}'

and origin_from_address = to_address

union

--to native

select

block_number, block_timestamp, 'avalanche' as chain, tx_hash, to_address as receiver, 'AVAX' as to_token, amount as token_to_amount, amount_usd as token_to_amount_usd

from avalanche.core.ez_native_transfers

where block_timestamp::date between '{{Start_Date}}' and '{{End_Date}}'

and origin_from_address = to_address