Afonso_DiazUntitled Query
Updated 2023-02-01
9
1
2
3
4
5
6
7
8
9
›
⌄
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