borrow 4

yasminborrow 4

Updated 2025-04-29

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)

user_borrows AS (

SELECT

e.ORIGIN_FROM_ADDRESS AS user_address,

t.symbol AS token,

t.price_symbol,

t.decimals,

e.DECODED_LOG:amount/POWER(10, t.decimals) AS borrowed_amount

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'

Last run: 25 days ago

226B

10s

flipside