Afonso_DiazUntitled Query
    Updated 2023-02-01
    select
    count(distinct a.tx_hash) as unstakes_count,
    count(distinct tx_signer) as unstakers_count
    from near.core.fact_receipts a,
    lateral flatten(input => logs) c
    join near.core.fact_transactions b
    where c.value ilike any ('%unstaking%', '%withdrawing%')
    and b.block_timestamp > current_date - 90
    and a.tx_hash = b.tx_hash
    Run a query to Download Data