Yousefi_1994Unstaking floor tokens
Updated 2022-07-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
block_timestamp::date as days,
count(distinct tx_hash) as number_of_unstake,
sum((tx_json:receipt:logs[1]:decoded:inputs:value::float)/1e9) as unstake_amount,
sum(unstake_amount) over (order by days) as cumulative_unstake_amount
from ethereum.core.fact_transactions
where origin_function_signature = '0x990966d5'
and to_address = '0x759c6de5bca9ade8a1a2719a31553c4b7de02539'
and status = 'SUCCESS'
and block_timestamp::date >= current_date - 90
group by days
order by days
Run a query to Download Data