KeyrockEth Swap Volume
    Updated 2024-06-05
    WITH CTE_1 as (
    SELECT
    TRUNCATE(block_timestamp, 'day') AS day,
    SUM(amount_in_usd) AS stable_stable_amount
    FROM
    ethereum.defi.ez_dex_swaps
    WHERE
    (
    TOKEN_IN IN (
    '0x99d8a9c45b2eca8864373a26d1459e3dff1e17f3', -- MIM
    '0x03ab458634910aad20ef5f1c8ee96f1d6ac54919', -- RAI
    '0x956f47f50a910163d8bf957cf5846d573e7f87ca', -- FEUI
    '0x5f98805a4e8be255a32880fdec7f6728c6568ba0', -- LUSD
    '0x0000000000085d4780b73119b644ae5ecd22b376', -- TUSD
    '0x4fabb145d64652a948d72533023f6e7a623c7c53', -- BUSD
    '0x4c9edd5852cd905f086c759e8383e09bff1e68b3', -- USDe
    '0x6b175474e89094c44da98b954eedeac495271d0f', -- DAI
    '0x853d955acef822db058eb8505911ed77f175b99e', -- FRAX
    '0xdac17f958d2ee523a2206206994597c13d831ec7', -- USDT
    '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48', -- USDC
    '0x83f20f44975d03b1b09e64809b757c47f942beea' -- sDAI
    ,'0x6c3ea9036406852006290770bedfcaba0e23a0e8'--PYUSD
    )
    AND TOKEN_OUT IN (
    '0x99d8a9c45b2eca8864373a26d1459e3dff1e17f3', -- MIM
    '0x03ab458634910aad20ef5f1c8ee96f1d6ac54919', -- RAI
    '0x956f47f50a910163d8bf957cf5846d573e7f87ca', -- FEUI
    '0x5f98805a4e8be255a32880fdec7f6728c6568ba0', -- LUSD
    '0x0000000000085d4780b73119b644ae5ecd22b376', -- TUSD
    '0x4fabb145d64652a948d72533023f6e7a623c7c53', -- BUSD
    '0x4c9edd5852cd905f086c759e8383e09bff1e68b3', -- USDe
    '0x6b175474e89094c44da98b954eedeac495271d0f', -- DAI
    '0x853d955acef822db058eb8505911ed77f175b99e', -- FRAX
    '0xdac17f958d2ee523a2206206994597c13d831ec7', -- USDT
    '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48', -- USDC
    '0x83f20f44975d03b1b09e64809b757c47f942beea' -- sDAI
    QueryRunArchived: QueryRun has been archived