from terra.core.fact_transactions

where block_timestamp >= current_date - 180

group by 1

having active_day > 14

,

swap as ( select block_timestamp, tx_id, trader as user

from terra.core.ez_swaps

where trader in (select tx_sender from transactions))

,

vote as ( select block_timestamp, tx_id, voter as user

from terra.core.fact_governance_votes

where voter in (select tx_sender from transactions))

,

lp as ( select block_timestamp, tx_id, LIQUIDITY_PROVIDER_ADDRESS as user

from terra.core.fact_lp_actions

where LIQUIDITY_PROVIDER_ADDRESS in (select tx_sender from transactions))

,

transfers as ( select block_timestamp, tx_id, sender as user

from terra.core.ez_transfers

where sender in (select tx_sender from transactions))

,

nft_sales as ( select block_timestamp, tx_id, purchaser as user

from terra.core.fact_nft_sales

where purchaser in (select tx_sender from transactions))

,

nft_mint as ( select block_timestamp , tx_id, minter as user

from terra.core.fact_nft_mints

where minter in (select tx_sender from transactions))

,

staking as ( select block_timestamp, tx_id, delegator_address as user

from terra.core.ez_staking

where delegator_address in (select tx_sender from transactions))

,

final as ( select 'Swap' as type, date(block_timestamp) as date, user, count(DISTINCT(tx_id)) as total_tx, count(DISTINCT(user)) as total_user,