SELECT

platform,

token_symbol,

SUM(amount_usd) AS protocol_volume

FROM polygon.defi.ez_bridge_activity

WHERE token_symbol IN ('USDT', 'USDC', 'DAI', 'BUSD')

AND block_timestamp BETWEEN '{{start_date}}' AND '{{end_date}}'

GROUP BY platform, token_symbol

), total_volume AS (

SELECT

token_symbol,

SUM(protocol_volume) AS total_volume

FROM protocol_volume

GROUP BY token_symbol

)

SELECT

pv.token_symbol,

SUM(POWER(pv.protocol_volume / tv.total_volume, 2)) AS hhi_index

FROM protocol_volume pv

JOIN total_volume tv

ON pv.token_symbol = tv.token_symbol

GROUP BY pv.token_symbol

HAVING SUM(POWER(pv.protocol_volume / tv.total_volume, 2)) > 0.1;