economic-tan

Updated 2025-01-27

SELECT

SUM(amount_in_usd) AS total_bridged_volume,

COUNT(activity.tx_hash) AS total_transactions,

COUNT(DISTINCT activity.sender) AS unique_users,

COUNT(DISTINCT symbol) AS supported_assets_count,

LISTAGG(DISTINCT symbol, ', ') AS supported_assets_list,

SUM((tx.gas_used * tx.gas_unit_price)/1e8) AS total_bridging_fees

FROM aptos.defi.ez_bridge_activity AS activity

LEFT JOIN aptos.core.fact_transactions AS tx

ON activity.tx_hash = tx.tx_hash

WHERE YEAR(activity.block_timestamp) = 2025

Last run: 3 months ago

	TOTAL_BRIDGED_VOLUME	TOTAL_TRANSACTIONS	UNIQUE_USERS	SUPPORTED_ASSETS_COUNT	SUPPORTED_ASSETS_LIST	TOTAL_BRIDGING_FEES
1	47878014.9669456	19013	4329	31	BSKT, BNB, PYTH, SUI, $WIF, GHC, WAVAX, WGLMR, DAI, STONE, WFTM, BUSD, B...	3.621261

226B

175s

flipside