SELECT

sum(amount_in_usd) as "total bridged volume",

count(DISTINCT tx_hash) as "total Bridges",

count(DISTINCT sender) as "total users"

FROM

aptos.defi.ez_bridge_activity

WHERE

block_timestamp >=

AND platform = 'layerzero'

),

averages as (

SELECT

"total bridged volume" / NULLIF("total users", 0) as "average bridged volume per user",

"total Bridges" / NULLIF("total users", 0) as "average bridges per user"

FROM

total

),

weekly as (

SELECT

date_trunc('week', block_timestamp) as "timeline",

sum(amount_in_usd) as "weekly bridged volume",

count(DISTINCT tx_hash) as "weekly Bridges",

count(DISTINCT sender) as "weekly users"

FROM

aptos.defi.ez_bridge_activity

WHERE

block_timestamp >= '2024-01-01'

and block_timestamp <= '2024-12-31'

AND platform = 'layerzero'

GROUP BY

"timeline"