bintuparisTotal Transfer Count and Volume
    Updated 2024-08-17
    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