flipside

    Untitled Query
    drone-mostafaUntitled Query
    Updated 2022-08-03
    with NEAR as ( select tx_receiver, min(block_timestamp) as Minimum from near.core.fact_transactions where tx_hash in
    (select tx_hash from near.core.fact_actions_events where action_name = 'DeployContract')

    group by tx_receiver having Minimum > '2022-01-01')

    select tx_receiver as Contract, count(distinct(tx_hash)) as Txn, count(distinct(tx_signer)) as "Unique User"
    from near.core.fact_transactions where tx_receiver in (select tx_receiver from NEAR)
    group by Contract order by "Unique User" desc limit 5
    Run a query to Download Data