mucrypto2023-05-29 11:51 PM
    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)

    select
    day,
    -- case when labels_to.sending_address = 'bitdao: launch partner rewards 2' then 'For BitDAO: Launch partner rewards'
    -- when labels_to.sending_address = 'bitdao: bybit contribution' then 'From Bybit: contribution'
    -- when labels_to.sending_address is null then 'From unknown address'
    -- end as transfer,
    amount,
    labels_to.sending_address,
    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
    Run a query to Download Data