(select address,

symbol,

name

from ink.core.dim_contracts),

ink_wallet as

(select

user_add

(select date(block_timestamp) as datetime,

date_trunc('week',block_timestamp) as week_date,

date_trunc('month',block_timestamp) as month_date,

tx_hash,

tx_fee,

to_address as user_add,

from_address as contract_add

from ink.core.fact_transactions

where from_address in (select address from contract)

union all

select date(block_timestamp) as datetime,

date_trunc('week',block_timestamp) as week_date,

date_trunc('month',block_timestamp) as month_date,

tx_hash,

tx_fee,

from_address as user_add,

to_address as contract_add

from ink.core.fact_transactions

where to_address in (select address from contract)))

select sum(total_buy) as total_vol,

chain

(select *,

'Base' as chain

from