mint_burn_liquidity as (

select

'mint' as event_type,

block_timestamp,

contract_address as pool_address,

'0x4200000000000000000000000000000000000006' as token,

'WETH'as symbol,

decoded_log : amount0 / pow(10,18) as amount

from base.core.ez_decoded_event_logs a

where event_name = 'Mint'

and contract_address = '0x5e9bb3d7682a9537db831060176c4247ab80d1ec'

and tx_status = 'SUCCESS'

and block_timestamp::date >= '2024-07-07'

union all

select

'mint' as event_type,

block_timestamp,

contract_address as pool_address,

'0x6b9bb36519538e0c073894e964e90172e1c0b41f' as token,

'WEWE' as symbol,

decoded_log : amount1 / pow(10,18) as amount

from base.core.ez_decoded_event_logs a

where event_name = 'Mint'

and contract_address = '0x5e9bb3d7682a9537db831060176c4247ab80d1ec'

and tx_status = 'SUCCESS'

and block_timestamp::date >= '2024-07-07'

union all

select

'burn' as event_type,

block_timestamp,

contract_address as pool_address,

'0x4200000000000000000000000000000000000006' as token,

'WETH' as symbol,

-1* decoded_log : amount0 / pow(10,18) as amount

from base.core.ez_decoded_event_logs a