Eman-RazStaking Over Time
Updated 2024-10-28
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
›
⌄
with staking_data as (select block_timestamp, origin_from_address as staker, tx_hash, amount, amount_usd, token_price, 'Blast' as chain
from blast.core.ez_token_transfers
where origin_function_signature='0xa694fc3a'
and origin_to_address='0xcfa9295d69be30d41a43faf71b68cb860d774754'
and contract_address='0x491e6de43b55c8eae702edc263e32339da42f58c'
and from_address=origin_from_address
and to_address=origin_to_address
union all
select block_timestamp, origin_from_address as staker, tx_hash, amount, amount_usd, token_price, 'Ethereum' as chain
from ethereum.core.ez_token_transfers
where origin_function_signature='0xa694fc3a'
and origin_to_address='0x3d374c2e1fe5b228a11ee861e1dc823d18680c54'
and contract_address='0x908ddb096bfb3acb19e2280aad858186ea4935c4'
and from_address=origin_from_address
and to_address=origin_to_address)
select date_trunc('{{Time_Frame}}',block_timestamp) as "Date", chain,
count(distinct staker) as "Staker Count",
count(distinct tx_hash) as "Staking Count", sum(amount) as "Staking Amount ($ESE)",
sum(amount_usd) as "Staking Amount ($USD)"
from staking_data
where block_timestamp::date between '{{Start_Date}}' and '{{End_Date}}'
group by 1,2
order by 1
QueryRunArchived: QueryRun has been archived