adriaparcerisasBendDAO deposit collaterals
    Updated 2022-09-08
    select
    trunc(block_timestamp,'{{granularity}}') as date,
    project_name,
    count(distinct tx_hash) as actions,
    sum(actions) over (partition by project_name order by date) as cum_actions,
    count(distinct nft_from_address) as users,
    sum(users) over (partition by project_name order by date) as cum_users
    from ethereum.core.ez_nft_transfers
    where nft_to_address = '0x3b968d2d299b895a5fcf3bba7a64ad0f566e6f88' and project_name is not null
    and block_timestamp >=CURRENT_DATE-INTERVAL '{{period}}'
    group by 1,2
    order by 1 asc
    Run a query to Download Data