SELECT
date_trunc('day', block_timestamp) AS day,
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'
GROUP BY
1,
2
ORDER BY
1,
2