mar1na-catscatscodetx volume by token
    Updated 2022-06-17
    select
    block_timestamp::date as block_date,
    case
    when mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then 'USDC'
    when mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' then 'USDT'
    when mint = '7kbnvuGBxxj8AG9qp8Scn56muWGaRaFqxg1FsRp3PaFT' then 'UXD'
    when mint = 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX' then 'USDH'
    when mint = 'Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS' then 'PAI'
    when mint = 'AJ6EVZEePA5HAn58ZRbLCWX3MsK2BKrkT6bJYunuTU71' then 'NIRV'
    when mint = 'EjmyN6qEC1Tf1JxiG1ae7UTJhUxSwk1TCWNWqxWV4J6o' then 'DAI'
    when mint = 'FR87nWEUxVgerFGhZM8Y4AggKGLnaXswr1Pd8wZ4kZcp' then 'FRAX'
    when mint = '9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i' then 'UST Portal'
    end as token,
    count(distinct tx_id) as n_transactions,
    sum(amount) as total
    from solana.core.fact_transfers
    where mint in (
    'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v', --USDC
    'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB', --USDT
    '7kbnvuGBxxj8AG9qp8Scn56muWGaRaFqxg1FsRp3PaFT', --UXD
    'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX', --USDH
    'Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS', --PAI
    'AJ6EVZEePA5HAn58ZRbLCWX3MsK2BKrkT6bJYunuTU71', --NIRV
    'EjmyN6qEC1Tf1JxiG1ae7UTJhUxSwk1TCWNWqxWV4J6o', --DAI Portal
    'FR87nWEUxVgerFGhZM8Y4AggKGLnaXswr1Pd8wZ4kZcp', --FRAX
    '9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i' --UST Portal
    )
    group by block_date, token