SELECT

SOURCE_ADDRESS,

DESTINATION_CHAIN,

SUM(AMOUNT_USD) AS total_whale_transfer,

COUNT(*) AS transfer_count

FROM near.defi.ez_bridge_activity

WHERE AMOUNT_USD > (SELECT PERCENTILE_CONT(0.95) WITHIN GROUP (ORDER BY AMOUNT_USD) FROM near.defi.ez_bridge_activity)

AND BLOCK_TIMESTAMP >= '2024-11-09'

GROUP BY

SOURCE_ADDRESS,

DESTINATION_CHAIN

SELECT

SOURCE_ADDRESS,

DESTINATION_CHAIN,

total_whale_transfer,

transfer_count,

total_whale_transfer / transfer_count AS avg_whale_transfer

FROM whale_transfers

ORDER BY total_whale_transfer DESC

LIMIT 50;