lido** wstETH Amount Bridged
Updated 2024-06-13
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
›
⌄
⌄
/*
query_2857386
in the ethereum.defi.ez_bridge_activity table there are 8 brgs:
gnosis chain
zksync lite
wormhole
axelar
optimism
polygon zk
base
polygon erc20
*/
SELECT
BLOCK_TIMESTAMP as time
, PLATFORM as brg_name
, BRIDGE_ADDRESS
, TX_HASH
, amount
-- , SUM(AMOUNT) as amount
-- , SUM(AMOUNT) over (partition by platform order by time desc) as cumulatinve_amount
FROM Ethereum.defi.ez_bridge_activity
where TOKEN_SYMBOL = 'wstETH'
-- TOKEN_ADDRESS = lower('0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0')
-- GROUP by 1,2
order by time DESC
limit 100
QueryRunArchived: QueryRun has been archived