0xPrz#2 App.nearcrowd.near
Updated 2022-09-29Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with contract as ( select tx_hash as tx , block_timestamp as time
from near.core.fact_actions_events
where action_name = 'DeployContract')
,
final as ( select date(time) as date , tx_receiver , count(DISTINCT(tx_hash)) as total_contract ,
sum(total_contract) over (order by date asc) as cum_contract
from near.core.fact_transactions a left outer join contract b on a.tx_hash = b.tx
group by 1,2
)
select tx_receiver , sum(total_contract) as total
from final
group by 1
order by 2 desc
limit 10
Run a query to Download Data