SELECT COUNT(*) AS total_count

FROM polygon.defi.ez_dex_swaps

WHERE symbol_IN IN ('USDT', 'UST', 'USDC', 'USDD', 'USDA', 'BUSD', 'TUSD', 'DAI', 'FRAX', 'MAI')

and block_timestamp >= '2024-01-01'

),

market_share AS (

SELECT

symbol_IN,

COUNT(*) * 100.0 / (SELECT total_count FROM total_trades) AS market_share

FROM polygon.defi.ez_dex_swaps

WHERE symbol_IN IN ('USDT', 'UST', 'USDC', 'USDD', 'USDA', 'BUSD', 'TUSD', 'DAI', 'FRAX', 'MAI')

and block_timestamp >= '2024-01-01'

GROUP BY symbol_IN

SELECT

swaps.symbol_IN,

COUNT(DISTINCT swaps.tx_hash) AS number_swaps,

SUM(swaps.AMOUNT_IN_USD) AS swap_volume,

AVG(swaps.AMOUNT_IN_USD) AS average_swap_volume,

COUNT(DISTINCT swaps.origin_from_address) AS number_of_traders,

SUM(swaps.AMOUNT_IN_USD) / COUNT(DISTINCT swaps.origin_from_address) AS volume_per_trader,

COUNT(DISTINCT swaps.tx_hash) / COUNT(DISTINCT swaps.origin_from_address) AS swaps_per_trader,

market_share.market_share

FROM polygon.defi.ez_dex_swaps AS swaps

JOIN market_share ON swaps.symbol_IN = market_share.symbol_IN

WHERE swaps.symbol_IN IN ('USDT', 'UST', 'USDC', 'USDD', 'USDA', 'BUSD', 'TUSD', 'DAI', 'FRAX', 'MAI')

GROUP BY swaps.symbol_IN, market_share.market_share;