0xaimanStablecoin Dominance : Swap
    Updated 2024-02-15
    SELECT
    -- swaps.block_timestamp as t,
    DATE_TRUNC('month',block_timestamp) as month,
    -- CONCAT(label_from.label, ' --> ', label_to.label) AS swap_direction,

    Case
    when label_from.address = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' then 'USDT'
    when label_from.address = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then 'USDC'
    when label_from.address = '9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i' then 'UST'
    when label_from.address = 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX' then 'USDH'
    when label_from.address = 'EjmyN6qEC1Tf1JxiG1ae7UTJhUxSwk1TCWNWqxWV4J6o' then 'DAI'
    when label_from.address = '88881Hu2jGMfCs9tMu5Rr7Ah7WBNBuXqde4nR5ZmKYYy' then 'SABER'
    when label_from.address = 'E2VmbootbVCBkMNNxKQgCLMS1X3NoGMaYAsufaAsf7M' then 'USDC (Wormhole)'
    when label_from.address = 'Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS' then 'Parrot USD'
    end as SYMBOL,
    COUNT(swapper) as n_unique_address -- ,
    -- -- succeeded,
    -- swapper,
    -- swap_program,
    -- CONCAT(label_from.label, ' --> ', label_to.label) AS swap_direction,
    -- label_from.label as from_token,
    -- swap_from_amount,
    -- label_to.label as to_token,
    -- swap_to_amount
    FROM
    solana.defi.fact_swaps swaps
    left join solana.core.dim_labels label_from on SWAP_FROM_MINT = label_from.address
    left join solana.core.dim_labels label_to on SWAP_to_MINT = label_to.address
    WHERE
    label_from.address in (
    'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v',
    'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB',
    '9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i',
    'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX',
    'Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS',
    'E2VmbootbVCBkMNNxKQgCLMS1X3NoGMaYAsufaAsf7M',
    Last run: about 1 year ago
    MONTH
    SYMBOL
    N_UNIQUE_ADDRESS
    1
    2022-08-01 00:00:00.000SABER422
    2
    2023-09-01 00:00:00.000SABER3
    3
    2024-01-01 00:00:00.000USDH16437
    4
    2022-05-01 00:00:00.000Parrot USD8243
    5
    2022-05-01 00:00:00.000DAI615
    6
    2022-06-01 00:00:00.000USDC (Wormhole)1035
    7
    2023-02-01 00:00:00.000USDC (Wormhole)350
    8
    2022-12-01 00:00:00.000USDC (Wormhole)206
    9
    2023-04-01 00:00:00.000SABER24
    10
    2023-10-01 00:00:00.000USDC839079
    11
    2022-07-01 00:00:00.000USDT309239
    12
    2023-04-01 00:00:00.000USDT199656
    13
    2023-01-01 00:00:00.000USDC1165058
    14
    2022-06-01 00:00:00.000USDT408726
    15
    2022-04-01 00:00:00.000SABER711
    16
    2022-06-01 00:00:00.000Parrot USD11214
    17
    2022-01-01 00:00:00.000USDH60
    18
    2022-09-01 00:00:00.000UST9286
    19
    2022-10-01 00:00:00.000SABER100
    20
    2022-09-01 00:00:00.000DAI60
    ...
    215
    9KB
    188s