select

block_timestamp,

case when contains(pool_name,'-') then split(pool_name,'-')[0] else pool_name end as pool_name_,

split(pool_name_ ,'.')[0] as chain,

tx_id,

from_address,

from_amount_usd,

to_amount_usd

from thorchain.defi.fact_swaps

where affiliate_address = 'll'

select

date_trunc('{{granularity}}', block_timestamp) as date,

chain,

count(distinct tx_id) as n_txns,

count(DISTINCT from_address) as n_users,

sum(coalesce(from_amount_usd, to_amount_usd)) as volume

from data

where block_timestamp :: date >= '2024-10-18'

group by 1 , 2