Volatility of Bridged Volume

datavortexVolatility of Bridged Volume

Updated 2025-04-18

WITH daily_volume AS (

SELECT

DATE_TRUNC('day', block_timestamp) AS day,

token_symbol,

SUM(amount_usd) AS daily_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 day, token_symbol

)

SELECT

token_symbol,

STDDEV(daily_volume) AS volume_volatility

FROM daily_volume

GROUP BY token_symbol

ORDER BY volume_volatility DESC;

Last run: 17 days ago

77B

flipside