select

case

when EVENT_NAME = 'LogSettleTradingFeeAmount' then DECODED_LOG['feeUsd']

when EVENT_NAME = 'LogSettleBorrowingFeeValue' then DECODED_LOG['feeUsd']

when EVENT_NAME = 'LogSettleLiquidationFeeValue' then DECODED_LOG['usd']

end as usd,

case

when EVENT_NAME = 'LogSettleTradingFeeAmount' then 'fees'

when EVENT_NAME = 'LogSettleBorrowingFeeValue' then 'fees'

when EVENT_NAME = 'LogSettleLiquidationFeeValue' then 'fees'

end as type

from blast.core.fact_decoded_event_logs

where CONTRACT_ADDRESS = lower('0x9F1f13eBC178122C3ef6c14FA3A523680563F58b')

and EVENT_NAME in (

'LogSettleTradingFeeAmount',

'LogSettleBorrowingFeeValue',

'LogSettleLiquidationFeeValue'

)

),

hlp_fees as (

select decoded_log['feeUsd'] as usd,

'HlpFees' as type,

from blast.core.fact_decoded_event_logs

where contract_address = lower('0xF0D92907236418Fa8Ee900E384b4c6928f7cADfc')

and event_name in ('CollectAddLiquidityFee', 'CollectRemoveLiquidityFee')

),

all_fees as (

select * from fees_logs

union all

select * from hlp_fees

select sum(usd) / 1e30 as total_fees from all_fees