min(date_trunc('day',block_timestamp)) as borrow_date

from solana.core.fact_events

where instruction:programId = 'So1endDq2YkqhipRh3WViPa8hdiSpxWy6z3Z6tMCpAo'--

-- and tx_id = '61KkyGB7inSK8iiBJ2ncbZqAuQ32BeDNEz1HKGvqVaX2cdkuEZ4ui3iU2VRnH6eNMniC6TzzHWFjczv8msXbzWta'

and inner_instruction:instructions[1]:parsed:info:authority = 'DdZR6zRFiUt4S5mg7AV1uKB2z1f1WzcNYCaTEEWPAuby'

and pretokenbalances[0]:mint = 'So11111111111111111111111111111111111111112'

and inner_instruction:instructions[1]:parsed:info:amount is not null

and succeeded = 'TRUE'

group by 1),

base2 as (select

swap_to_mint,

count(distinct(tx_id)) as tx_counts

from solana.core.fact_swaps a

join base b

on a.swapper = b.borrower

where swap_from_mint = 'So11111111111111111111111111111111111111112'

and succeeded = 'TRUE'

and borrow_date < block_timestamp

group by 1)

select address_name as token_name,

tx_counts as number_of_transactions

from base2 a

join crosschain.address_labels b

on a.swap_to_mint = b.address

order by 2 desc