0xPrz#2 App.nearcrowd.near
    Updated 2022-09-29
    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