(select

case

when ATTRIBUTE_VALUE in ('Ethereum') then 10

when ATTRIBUTE_VALUE in ('Avalanche','agoric','assetmantle','aurora','Axelarnet','comdex','cosmoshub','crescent','e-money','evmos','fetch','juno','injective','ki','kujira','osmosis','regen','secret','stargaze',

'terra','terra-2','umee') then 0.5

when ATTRIBUTE_VALUE in ('binance','Fantom','Moonbeam','Polygon','arbitrum','celo') then 1

else null end as bridge_fee,

*

from axelar.core.fact_msg_attributes

where

ATTRIBUTE_KEY='destinationChain'),

ddd as

(select sum(BRIDGE_FEE) as bridge_fee,

date_trunc('day',BLOCK_TIMESTAMP) as date

from bridge_fee

group by 2)

select

sum(bridge_fee) over (order by date) as cumulative_bridge_fee , *

from ddd