jeaffbozosSharkyfi - Take Loan
9
1
2
3
4
5
6
7
›
⌄
select date_trunc('day', BLOCK_TIMESTAMP::date) AS day,
count (distinct tx_id) as TX_Count
from solana.core.fact_transactions
where instructions::string LIKE '%SHARKobtfF1bHhxD2eqftjHBdVSCbKo9JtgK71FhELP%'
and LOG_MESSAGES::string LIKE '%Take Loan%'
and BLOCK_TIMESTAMP > CURRENT_DATE - interval '30 days'
GROUP BY 1
Run a query to Download Data