zakkisyedrsETH Bridgoors and Minters
Updated 2024-06-25
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
31
32
33
34
35
36
›
⌄
-- total rsETH bridged 101265.799509
-- Arb rsETH minted 77650.515801
-- Opt rsETH minted 474.802993
-- Blast rsETH minted 21608.947605
-- Base rsETH minted 1114.932601
---- rseth bridged query
WITH rseth_bridged_from_eth as (
select distinct decoded_log:from as user,
sum(decoded_log:value/1e18) as total_rsETH_bridged,
--count(distinct tx_hash) as tx_count
from ethereum.core.ez_decoded_event_logs
where origin_to_address = lower('0x85d456B2DfF1fd8245387C0BfB64Dfb700e98Ef3')
and contract_address = lower('0xA1290d69c65A6Fe4DF752f95823fae25cB99e5A7')
and event_name = 'Transfer'
and block_timestamp < '2024-05-02'
group by 1
order by 2 desc
),
--- Arbitrum minted rsETH
arb_minted_rseth as (
select distinct to_address as user, sum(amount) as rsETH_minted,
'arbitrum' as blockchain
from arbitrum.core.ez_token_transfers
where contract_address = lower('0x4186BFC76E2E237523CBC30FD220FE055156b41F')
and from_address = '0x0000000000000000000000000000000000000000'
and block_timestamp < '2024-05-02'
group by 1
order by 2 desc
),
QueryRunArchived: QueryRun has been archived