Alihastam2023-06-05 01:34 PM
    Updated 2023-06-05

    select
    date_trunc('day',block_timestamp) as date,
    count (distinct tx_hash) as num_tx ,
    count (distinct origin_from_address) as num_users,
    sum (amount) as unstake_amount,
    sum (amount_usd) as unstake_usd
    from ethereum.core.ez_token_transfers
    where FROM_ADDRESS = '0x4da27a545c0c5b758a6ba100e3a049001de870f5'
    and ORIGIN_TO_ADDRESS='0x4da27a545c0c5b758a6ba100e3a049001de870f5'
    and block_timestamp >= CURRENT_DATE-90
    and symbol='AAVE'
    group by 1