mucryptoETH transfers from/to the treasury of BitDAO
    Updated 2023-05-29
    with transaction_to as (
    select
    block_timestamp::date as day,
    amount,
    amount_usd,
    eth_from_address,
    tx_hash,
    'Inflow' as category
    from ethereum.core.ez_eth_transfers
    where eth_to_address = '0x78605df79524164911c144801f41e9811b7db73d'), --BitDAO treasury

    labels_to as (
    select
    address,
    address_name as sending_address
    from ethereum.core.dim_labels),

    t_to_total as (
    select
    day,
    case when labels_to.sending_address = 'bitdao: launch partner rewards 2' then 'To BitDAO: Launch partner rewards'
    when labels_to.sending_address = 'bitdao: bybit contribution' then 'From Bybit: Contribution'
    when labels_to.sending_address = 'tornadocash 0.1eth' then 'From Tornado Cash'
    when labels_to.sending_address is null then 'From unknown address'
    end as transfer,
    amount,
    amount_usd,
    tx_hash,
    category
    from transaction_to
    left join labels_to
    on transaction_to.eth_from_address=labels_to.address
    order by amount desc),

    transaction_from as (
    select