MufasaCount of ETH withdrawn so far over the time
    Updated 2022-06-29
    -- with tx as (
    -- SELECT distinct tx_hash
    -- from ethereum.core.fact_event_logs
    -- where contract_address = '0xae0ee0a63a2ce6baeeffe56e7714fb4efe48d419' and block_timestamp::date>= '2022-05-01'
    -- ) SELECT *
    -- FROM flipside_prod_db.tokenflow_eth.state_diffs
    -- WHERE true and tx_hash IN ( select tx_hash from tx )
    -- and address ='0xae0ee0a63a2ce6baeeffe56e7714fb4efe48d419'

    -- select count(*) as count, sum(amount) as sum from ethereum.core.ez_eth_transfers where eth_from_address = lower('0xae0Ee0A63A2cE6BaeEFFE56e7714FB4EFE48D419')
    -- SELECT *, (curr_value - prev_value) as balance, case when balance > 0 then 'deposit' else 'withdraw' end as eth_deposit_withdraw
    -- FROM flipside_prod_db.tokenflow_eth.state_diffs
    -- WHERE true -- tx_hash IN ( '0x204c58f842801af33c3ab0f33d1dc0a402c99df7ef404beaa08e9ab77d9a6701' )
    -- and address ='0xae0ee0a63a2ce6baeeffe56e7714fb4efe48d419'
    SELECT timestamp::date as date, count(*) as count, (curr_value - prev_value) as balance, case when balance > 0 then 'deposit' else 'withdraw' end as eth_withdraw
    FROM flipside_prod_db.tokenflow_eth.state_diffs
    WHERE true -- tx_hash IN ( '0x204c58f842801af33c3ab0f33d1dc0a402c99df7ef404beaa08e9ab77d9a6701' )
    and eth_withdraw = 'withdraw'
    and address ='0xae0ee0a63a2ce6baeeffe56e7714fb4efe48d419' and date>= '2022-05-01' group by 1, 3, 4 order by count desc



    Run a query to Download Data