payout_txs as (

select

block_timestamp

, tx_from

, tx_to

, amount

, 'Solana' as blockchain

from solana.core.fact_transfers

where mint = 'rndrizKT3MK1iimdxRdWabcF7Zg7AR5T4nud4EkHBof'

and amount > 0

and block_timestamp > '2023-11-25'

and tx_from in (

'7dTswSjBVjfLb6V7Rf2HzDQxFhPH33Ad8nxwG8XjN11z'

, 'rscrKMNxC3sC4fviV5hdJte8aqDfiCyQ1Uw4NPuExQV')

and not tx_to in (

'7CVt936gVDXfKeXdRs5xcWVkrEaYGMTV3HA2K7j4Bqa7'

, 'rscrKMNxC3sC4fviV5hdJte8aqDfiCyQ1Uw4NPuExQV')

),

polygon_payout_txs as (

select

block_timestamp

, fact_token_transfers.from_address as tx_from

, fact_token_transfers.to_address as tx_to

, fact_token_transfers.raw_amount / pow(10, 18) as amount

, 'Polygon' as blockchain

from polygon.core.fact_transactions

inner join polygon.core.fact_token_transfers