datavortexTransactions
    Updated 2025-04-18
    SELECT symbol_in,
    COUNT(DISTINCT tx_hash) AS total_transactions,
    COUNT(DISTINCT origin_from_address) AS total_swappers,
    SUM(amount_in_usd) AS volume_swapped
    FROM polygon.defi.ez_dex_swaps
    WHERE symbol_in IN ('USDT', 'USDC', 'EURS', 'DAI', 'UST', 'BUSD', 'TUSD')
    AND block_timestamp >= '{{ start_date}}'
    AND block_timestamp < '{{end_date}}'
    GROUP BY symbol_in;

    Last run: 22 days ago
    SYMBOL_IN
    TOTAL_TRANSACTIONS
    TOTAL_SWAPPERS
    VOLUME_SWAPPED
    1
    BUSD128776459008.34
    2
    DAI679672316120263296.81
    3
    UST6902104151.98
    4
    USDT533523894201785.51
    5
    USDC900959141572706414630.88
    6
    TUSD52430946130.83
    7
    EURS888344603808.71
    7
    203B
    8s