lido**Ethreum Lendings (wstETH)
Updated 2024-06-13
999
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
›
⌄
⌄
-- select
-- distinct PLATFORM as name
-- , PROTOCOL_MARKET as address
-- from ethereum.defi.ez_lending_deposits
-- where TOKEN_SYMBOL = 'wstETH'
/* output:
Compound V3 - 0xa17581a9e3356d9a858b789d68b4d866e593ae94
Spark - 0x12b54025c112aa61face2cdb7118740875a566e9
Strike- 0x1ebfd36223079dc79fefc62260db9e25f3f5e2c7
Aave V3 - 0x0b925ed163218f6662a35e0f0371ac234f9e9371
Silo - 0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0
Fraxlend - 0xb5a46f712f03808ae5c4b885c6f598fa06442684
Radiant - 0x83b3896ec36cb20cfb430fcfe8da23d450dd09b5
*/
with lending_deposits as ( --returns data with gaps, see gaps examples at the end of the request
select
BLOCK_TIMESTAMP as time
, PROTOCOL_MARKET as address
, PLATFORM as name
, AMOUNT as amount
, TX_HASH
from ethereum.defi.ez_lending_deposits
where TOKEN_SYMBOL = 'wstETH'
-- order by 1 DESC
-- limit 100
)
, lending_withdrawals as (
select
BLOCK_TIMESTAMP as time
, PROTOCOL_MARKET as address
, PLATFORM as name
, AMOUNT as amount
QueryRunArchived: QueryRun has been archived