d.value:"USERS" as users

from (

select livequery.live.udf_api(

'https://flipsidecrypto.xyz/api/v1/queries/c8b851c1-902c-4e8f-b9f4-2216698d5723/data/latest'

):"data" as data

) responses join lateral flatten (input => responses.data) d

),

send as (select

distinct FROM_ADDRESS,

TO_ADDRESS,

tx_hash,

'ETH' as token

from blast.core.ez_native_transfers

where FROM_ADDRESS in (select users from wallets)

and TO_ADDRESS in (select users from wallets)

and TO_ADDRESS <> FROM_ADDRESS

union all

select

distinct FROM_ADDRESS,

TO_ADDRESS,

tx_hash,

SYMBOL as token

from blast.core.ez_token_transfers

where FROM_ADDRESS in (select users from wallets)

and TO_ADDRESS in (select users from wallets)

and TO_ADDRESS <> FROM_ADDRESS

),

total_send as (select