NuveveCryptoArchived$LQTY Staking vs. Unstaking
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
›
⌄
with staking as (
select
block_timestamp::date as date,
count(distinct tx_hash) as tx_count
from ethereum.core.ez_token_transfers
where to_address = '0x4f9fbb3f1e99b56e0fe2892e623ed36a76fc605d'
and contract_address = '0x6dea81c8171d0ba574754ef6f8b412f2ed88c54d'
and block_timestamp >= current_date - 90
group by date
),
unstaking as (
select
block_timestamp::date as date,
count(distinct tx_hash) as tx_count
from ethereum.core.ez_token_transfers
where from_address = '0x4f9fbb3f1e99b56e0fe2892e623ed36a76fc605d'
and contract_address = '0x6dea81c8171d0ba574754ef6f8b412f2ed88c54d'
and block_timestamp >= current_date - 90
group by date
)
select
staking.date as date,
staking.tx_count as staking,
unstaking.tx_count as unstaking
from staking
inner join unstaking on staking.date = unstaking.date
Run a query to Download Data