adriaparcerisasBendDAO deposit collaterals
Updated 2022-09-08
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
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