with transaction as (
select *
from ethereum.core.ez_eth_transfers
where eth_from_address = '0x78605df79524164911c144801f41e9811b7db73d'), --BitDAO treasury
labels as (
select
address,
address_name as receiving_address
from ethereum.core.dim_labels)
select
block_timestamp::date as day,
case
when labels.receiving_address is null then 'Unknown'
end as receiver,
amount,
amount_usd,
tx_hash
from transaction
left join labels
on transaction.eth_to_address=labels.address