binhachonSolend - Withdraw lending
Updated 2022-02-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select
block_timestamp,
posttokenbalances[2]:mint::string as token,
posttokenbalances[2]:uiTokenAmount:decimals::float as decimals,
inner_instruction:instructions[2]:parsed:info:amount::float as raw_amount,
raw_amount/pow(10, decimals) as amount,
inner_instruction:instructions[1]:parsed:info:authority::string as address,
inner_instruction:instructions[2]:parsed:info:destination::string as account
from solana.events
where tx_id in ('61KkyGB7inSK8iiBJ2ncbZqAuQ32BeDNEz1HKGvqVaX2cdkuEZ4ui3iU2VRnH6eNMniC6TzzHWFjczv8msXbzWta', '5LmZp4qbGRshABgZk6EzTEFfzQbDKJDftauZZj4HWrGfCrpbqs6aSY5DCtdudgVeAxRNGTMM314SDncDi8FTjdpU', '5xrQezrtVsh6ET7SZe3TzW7uXuzs8Aw5bGnYYt3AhoFXzkiKD6u8WZoPiWVbo8SxAZyrVnpdqDJjHgWr6cA8ACfb')
and instruction:programId::string = 'So1endDq2YkqhipRh3WViPa8hdiSpxWy6z3Z6tMCpAo'
and inner_instruction:instructions[2]:parsed:type::string = 'transfer'
and inner_instruction:instructions[2]:parsed:info:authority::string = 'DdZR6zRFiUt4S5mg7AV1uKB2z1f1WzcNYCaTEEWPAuby' --Solend address
and inner_instruction:instructions[1]:parsed:type::string = 'burn'
Run a query to Download Data