flipside

    Distribution of Transferred Stablecoins and Swapped Volume Since November
    0xHaM-dDistribution of Transferred Stablecoins and Swapped Volume Since November
    Updated 2022-12-08
    with swaps as (
    select
    case when SWAP_TO_MINT in ('Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'-- usdt
    ,'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' --usdc
    ,'H5kMHghGUKo4MnGEp4mpAMxveDwnRZ4hXeZMWfp5EzGF' --UXD
    ,'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX'--USDH
    ,'Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS'--pai
    ,'AJ6EVZEePA5HAn58ZRbLCWX3MsK2BKrkT6bJYunuTU71' --nirv
    ,'EjmyN6qEC1Tf1JxiG1ae7UTJhUxSwk1TCWNWqxWV4J6oc'
    ,'9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i' -- 'UST'
    ,'EjmyN6qEC1Tf1JxiG1ae7UTJhUxSwk1TCWNWqxWV4J6o' --dai
    ) THEN SWAP_TO_AMOUNT
    WHEN SWAP_FROM_MINT in ('Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'-- usdt
    ,'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' --usdc
    ,'H5kMHghGUKo4MnGEp4mpAMxveDwnRZ4hXeZMWfp5EzGF' --UXD
    ,'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX'--USDH
    ,'Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS'--pai
    ,'AJ6EVZEePA5HAn58ZRbLCWX3MsK2BKrkT6bJYunuTU71' --nirv
    ,'EjmyN6qEC1Tf1JxiG1ae7UTJhUxSwk1TCWNWqxWV4J6oc'
    ,'9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i' -- 'UST'
    ,'EjmyN6qEC1Tf1JxiG1ae7UTJhUxSwk1TCWNWqxWV4J6o' --dai
    ) THEN SWAP_FROM_AMOUNT end as amount,
    case when SWAP_TO_MINT in ('Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'-- usdt
    ,'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' --usdc
    ,'H5kMHghGUKo4MnGEp4mpAMxveDwnRZ4hXeZMWfp5EzGF' --UXD
    ,'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX'--USDH
    ,'Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS'--pai
    ,'AJ6EVZEePA5HAn58ZRbLCWX3MsK2BKrkT6bJYunuTU71' --nirv
    ,'EjmyN6qEC1Tf1JxiG1ae7UTJhUxSwk1TCWNWqxWV4J6oc'
    ,'9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i' -- 'UST'
    ,'EjmyN6qEC1Tf1JxiG1ae7UTJhUxSwk1TCWNWqxWV4J6o' --dai
    )
    or SWAP_FROM_MINT in ('Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'-- usdt
    ,'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' --usdc
    ,'H5kMHghGUKo4MnGEp4mpAMxveDwnRZ4hXeZMWfp5EzGF' --UXD
    ,'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX'--USDH
    Run a query to Download Data