select

'THORChain' as protocol,

block_timestamp,

tx_id,

BLOCKCHAIN,

pool_name,

from_address,

NATIVE_TO_ADDRESS,

TO_POOL_ADDRESS,

AFFILIATE_ADDRESS,

AFFILIATE_FEE_BASIS_POINTS,

FROM_ASSET,

to_asset,

from_amount,

to_amount,

from_amount_usd,

to_amount_usd,

SWAP_SLIP_BP,

LIQ_FEE_ASSET_USD,

STREAMING_COUNT,

STREAMING_QUANTITY

from thorchain.defi.fact_swaps

where affiliate_address IN ('eld','ELD')

and tx_id not in (select tx_id from thorchain.defi.fact_refund_events)

union all

select

'Maya' as protocol,

block_timestamp,

tx_id,

BLOCKCHAIN,

pool_name,

from_address,

NATIVE_TO_ADDRESS,

TO_POOL_ADDRESS,

AFFILIATE_ADDRESS,