Moestablecoin borrows on various chains
Updated 2024-12-06
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
›
⌄
-- by pine_moe
-- Metrics : chain date symbol token_contract stable_coin_borrows_token
-- chains : Ethereum, Arb, Base, OP
select
*
from
(
select
'Arbitrum' as chain,
date_trunc(day, BLOCK_TIMESTAMP) as date,
TOKEN_SYMBOL as symbol,
TOKEN_ADDRESS as token_contract,
AMOUNT as stable_coin_borrows_token
from
arbitrum.defi.ez_lending_borrows
where
event_name = 'Borrow'
and TOKEN_ADDRESS in (
'0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9',
-- usdt
'0xaf88d065e77c8cc2239327c5edb3a432268e5831',
-- usdc
'0xff970a61a04b1ca14834a43f5de4533ebddb5cc8',
-- usdc
'0xda10009cbd5d07dd0cecc66161fc93d7c9000da1',
-- dai
'0x5d3a1ff2b6bab83b63cd9ad0787074081a52ef34',
-- usde (ethena)
'0x57f5e098cad7a3d1eed53991d4d66c45c9af7812' -- wusdm
)
and BLOCK_TIMESTAMP >= current_date - 30
union
all
select
'Base' as chain,
date_trunc(day, BLOCK_TIMESTAMP) as date,
QueryRunArchived: QueryRun has been archived