flipside

    Base Earnings #2
    freemartianBase Earnings #2
    Updated 2024-01-29
    -- forked from Base Earnings #1 @ https://flipsidecrypto.xyz/edit/queries/9a95f5b3-8794-48c1-95cc-83bd87d7d49d

    select
    name,
    sum(eth_value) as earning
    from base.core.fact_traces t inner join base.core.dim_contracts l
    on t.from_address = l.address
    where to_address = '0x04de40fc1f4ec28e1f245ed810d45041cc9e59da'
    and tx_status = 'SUCCESS'
    and from_address in ('0xc9cca8e570f81a7476760279b5b19cc1130b7580', '0x05b8ee5658f3ad6c268c08b7a70f2fb4b10cf348')
    group by 1


    Last run: over 1 year agoAuto-refreshes every 3 hours
    NAME
    EARNING
    1
    		DeeKay Motion - New Era ETH452.72
    2
    		DeeKay Motion - New Era BTC262.2
    2
    78B
    18s