mucryptoETH transfer out of the treasury of BitDAO
    Updated 2023-06-01
    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
    Run a query to Download Data