SELECT

DISTINCT from_address

FROM

kaia.core.fact_transactions

WHERE

block_timestamp >= DATEADD(MONTH, -1, CURRENT_DATE)

),

dormant_users AS (

SELECT

DISTINCT from_address

FROM

kaia.core.fact_transactions

WHERE

from_address IN (SELECT from_address FROM active_users)

),

token_info AS (

SELECT

address,

decimals

FROM

kaia.core.dim_contracts

),

token_tx AS (

SELECT

from_address,

DATE_TRUNC('day', block_timestamp) AS day,

kaia.core.fact_token_transfers.contract_address,

raw_amount / POWER(10, decimals) AS value

FROM

kaia.core.fact_token_transfers

LEFT JOIN token_info

ON kaia.core.fact_token_transfers.contract_address = token_info.address

WHERE

from_address IN (SELECT from_address FROM dormant_users)

AND kaia.core.fact_token_transfers.contract_address IN (