mucrypto2023-05-28 07:18 PM
    Updated 2023-05-28
    with transaction_outflow as (
    select
    block_timestamp::date as day,
    amount*(-1) as amount,
    amount_usd*(-1) as amount_usd,
    from_address,
    to_address,
    tx_hash,
    'Outflow' as category
    from ethereum.core.ez_token_transfers
    where from_address = '0x78605df79524164911c144801f41e9811b7db73d'
    and contract_address = '0x1a4b46696b2bb4794eb3d4c26f1c55f9170fa4c5'),

    labels_from as (
    select
    address,
    address_name as receiving_address
    from ethereum.core.dim_labels),

    outflow as (select
    day,
    case when labels_from.receiving_address is null then 'Unknown'
    when labels_from.receiving_address = 'alameda research' then 'Alameda Research'
    when labels_from.receiving_address = 'gnosis safe: general contract' then 'Gnosis Safe'
    end as address,
    amount,
    amount_usd,
    tx_hash,
    category
    from transaction_outflow
    left outer join labels_from
    on transaction_outflow.to_address=labels_from.address
    order by amount desc),

    transaction_inflow as (
    select
    Run a query to Download Data