SELECT 'ethereum' as blockchain, block_number, block_timestamp, tx_hash, event_index, event_name,

lower(decoded_log['id']) as market_id,

cast(decoded_log['assets'] as BIGINT) as asset_amount,

decoded_log['onBehalf'] as user,

'eth' as chain

FROM ethereum.core.ez_decoded_event_logs

WHERE CONTRACT_ADDRESS = lower('0xBBBBBbbBBb9cC5e90e3b3Af64bdAF62C37EEFFCb')

AND EVENT_NAME in ('SupplyCollateral', 'WithdrawCollateral')

UNION ALL

SELECT 'base' as blockchain, block_number, block_timestamp, tx_hash, event_index, event_name,

lower(decoded_log['id']) as market_id,

cast(decoded_log['assets'] as BIGINT) as asset_amount,

decoded_log['onBehalf'] as user,

'eth' as chain

FROM base.core.ez_decoded_event_logs

WHERE CONTRACT_ADDRESS = lower('0xBBBBBbbBBb9cC5e90e3b3Af64bdAF62C37EEFFCb')

AND EVENT_NAME in ('SupplyCollateral', 'WithdrawCollateral')

),

logs_extended as (

SELECT logs.*,

market_list.collateral_token as pt_collateral_token

FROM logs

JOIN $query('77a9ed37-c3c7-427f-8384-f862f46900a9') market_list

ON logs.blockchain = market_list.blockchain

AND logs.market_id = market_list.id

),

user_market_start_date AS (

SELECT user, blockchain, market_id, pt_collateral_token, date(min(date_trunc('day', BLOCK_TIMESTAMP))) as first_date

FROM logs_extended

GROUP BY 1, 2, 3, 4

),

user_market_daily_delta as (