SYMBOL | Amount Borrowed | PRICE | Amount Borrowed ($) | |
---|---|---|---|---|
1 | DAI | 47717.992665196 | 1.001 | 47765.710657861 |
2 | AERO | 45319.824542288 | 1.06909872 | 48451.366386946 |
3 | EURC | 294135.85628 | 1.04 | 305901.2905312 |
4 | USDC | 26736066.608799 | 0.999999 | 26736039.8727323 |
5 | WETH | 1406.572618295 | 3259.84 | 4585201.68402174 |
Abbas_ra21Borrows Table
Updated 2025-01-21
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
›
⌄
with prices AS (
select
SYMBOL,
PRICE,
rank() over (
partition by SYMBOL
order by
HOUR desc
) AS rank
from
base.price.ez_prices_hourly
where
TOKEN_ADDRESS in (
select
DISTINCT TOKEN_ADDRESS
from
base.defi.ez_lending_borrows
) qualify rank = 1
),
main AS (
select
SYMBOL,
sum(AMT) AS "Amount Borrowed"
from
(
select
TOKEN_SYMBOL AS SYMBOL,
sum(AMOUNT) AS AMT
from
base.defi.ez_lending_borrows
where
PLATFORM = 'Seamless'
group by
1
union
ALL
Last run: about 1 month agoAuto-refreshes every 24 hours
5
241B
12s