eslamis-darkat average current balance4
    Updated 2022-09-29
    select date_trunc('day', b.block_timestamp) as date_day,date_trunc('week', b.block_timestamp) as date_week
    ,date_trunc('month',b.block_timestamp) as date_month,avg(CURRENT_BAL) as average_balance
    from ethereum.core.ez_current_balances join ethereum.core.fact_event_logs b on user_address = origin_from_address
    where symbol = 'ETH' and TOKEN_NAME='Native Ether' and lower(b.contract_address) = lower('0x881D40237659C251811CEC9c364ef91dC08D300C')
    and b.block_timestamp>'2022-01-01'
    GROUP BY 1,2,3



    Run a query to Download Data