yasminborrow 3
Updated 2025-04-29
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 token_info AS (
SELECT * FROM (
VALUES ('SolvBTC', 'SOLVBTC', 18),
('BTC.b', 'BTC.B', 8),
('WETH.e', 'WETH.E', 18),
('JOE', 'JOE', 18),
('ggAVAX', 'GGAVAX', 18),
('AVAX', 'AVAX', 18),
('USDC', 'USDC', 6) ) AS tokens(symbol, price_symbol, decimals)),
total_borrows AS (
SELECT
t.symbol AS token,
t.price_symbol,
t.decimals,
SUM(e.DECODED_LOG:amount / POWER(10, t.decimals)) AS total_borrowed_amount,
COUNT(DISTINCT e.TX_HASH) AS transaction_count
FROM avalanche.core.ez_decoded_event_logs e JOIN (
SELECT
tx_hash,
tt.symbol,
m.price_symbol,
m.decimals
FROM avalanche.core.ez_token_transfers tt
JOIN token_info m ON UPPER(tt.symbol) = UPPER(m.symbol)
WHERE tt.symbol IN (SELECT symbol FROM token_info)
UNION ALL
SELECT
tx_hash,
'AVAX' AS symbol,
'AVAX' AS price_symbol,18 AS decimals
FROM avalanche.core.ez_native_transfers
WHERE 'AVAX' IN (SELECT symbol FROM token_info) ) t ON e.TX_HASH = t.TX_HASH
WHERE e.TOPIC_0 = '0xb3707e5831975d143ed0e7dc2a9bcf2871b17fca49b65d15335f9dd8b3e60d89'
AND e.ORIGIN_TO_ADDRESS = '0xc03094c4690f3844ea17ef5272bf6376e0cf2ac6'
AND e.CONTRACT_ADDRESS = '0xf4c542518320f09943c35db6773b2f9feb2f847e'
AND e.EVENT_NAME = 'Borrow'
QueryRunArchived: QueryRun has been archived