jackguyStablecon Activity on Ethereum 5
    Updated 2023-03-12
    SELECT
    COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS total_origin_from_addresses,
    COUNT(DISTINCT TX_HASH) AS total_transactions,
    SUM(AMOUNT_OUT_USD) AS total_amount_out_usd
    FROM ethereum.core.ez_dex_swaps
    WHERE (SYMBOL_IN IN ('USDC', 'USDT', 'BUSD', 'MIM', 'FRAX', 'DAI', 'USDP', 'TUSD', 'GUSD', 'FEI', 'SUSD')
    OR SYMBOL_OUT IN ('USDC', 'USDT', 'BUSD', 'MIM', 'FRAX', 'DAI', 'USDP', 'TUSD', 'GUSD', 'FEI', 'SUSD'))
    AND YEAR(BLOCK_TIMESTAMP) = 2022
    Run a query to Download Data