with mints as (

select

date_trunc('day', block_timestamp) as block_day

, 'Quickswap Matic/MaticX' as lp

, contract_address

, tx_hash

-- , event_name

-- , event_inputs

, sum(event_inputs:amount0::int) / 1e18 as matic_amount

, sum(event_inputs:amount1::int) / 1e18 as maticx_amount

-- , event_inputs:sender::text as sender

from polygon.core.fact_event_logs

where 1=1

and contract_address = '0xb0e69f24982791dd49e316313fd3a791020b8bf7'

-- and tx_hash = '0x7dbd1eeff7f53c9be4a59ef3a67808b5410b1cbef8582b6f6f26839add33ff88'

and event_name = 'Mint'

group by 1,2,3,4

union all

select

date_trunc('day', block_timestamp) as block_day

, 'DystopiaSwap WMatic/MaticX' as lp

, contract_address

, tx_hash

-- , event_name

-- , event_inputs

, sum(event_inputs:amount0::int) / 1e18 as matic_amount

, sum(event_inputs:amount1::int) / 1e18 as maticx_amount

-- , event_inputs:sender::text as sender

from polygon.core.fact_event_logs

where 1=1