DATE_TRUNC('day', block_timestamp) AS date,

SUM(amount_unadj) AS daily_bridge_amount_in_usd,

destination_chain_name,

token_address

aptos.defi.fact_bridge_activity

platform = 'layerzero'

--AND symbol = 'STONE'

--AND token_address = '0x543c5660aa4d496687e2068c11765f04607c4f4b639a83233a9333604fb8ce59::stakestone_ether::StakeStoneEther'

AND token_address = '0x5dee1d4b13fae338a1e1780f9ad2709a010e824388efd169171a26e3ea9029bb::stakestone_bitcoin::StakeStoneBitcoin'

AND destination_chain_name = 'Aptos'

AND source_chain_name = 'Ethereum'

--AND block_timestamp >= '2024-12-01'

GROUP BY

DATE_TRUNC('day', block_timestamp),

destination_chain_name,

-- symbol,

token_address

ORDER BY

date DESC;