SELECT
CASE
WHEN tx_from = '9DrvZvyWh1HuAoZxvYWMvkf2XCzryCpGgHqrMjyDWpmo'
OR tx_to = '9DrvZvyWh1HuAoZxvYWMvkf2XCzryCpGgHqrMjyDWpmo' THEN 'Kamino Lending'
ELSE 'Others'
END AS CATEGORY,
count(distinct tx_id) as txn_count,
ROUND(sum(amount), 2) as txn_vol
FROM
solana.core.fact_transfers t
WHERE
mint = '2b1kV6DkPAnxd5ixfnxCpjxmKwqjjaYmCZfHsFu24GXo'
AND block_timestamp >= '2024-07-01'
GROUP BY
1