flipside

    Each protocol Users
    kingharald-ethEach protocol Users
    Updated 2022-07-27
    select tx:receipt[4]:outcome:executor_id as protocol, count(distinct(tx_signer)) as users_count
    from near.core.fact_transactions
    where block_timestamp >= current_date - interval '1 month'
    and protocol != ''
    and (
    protocol = 'v2.ref-finance.near' OR
    protocol = 'v2.ref-farming.near' OR
    protocol = 'v1.jumbo_exchange.near' OR
    protocol = 'app.nearcrowd.near' OR
    protocol = 'backend.v1.pembrock.near' OR
    protocol = 'operator.meta-pool.near' OR
    protocol = 'v1.orderbook.near' OR
    protocol = 'v1.pembrock.near'
    )
    group by protocol
    Run a query to Download Data