select tx_signer as users,

max (block_timestamp::date) as last_day

from flipside_prod_db.mdao_near.transactions

group by users

),

active_users_last_days as (

select users, last_day

from active_users

where last_day > CURRENT_DATE - {{last_day}}

),

raw_transfers_from_active_users as (

select t.block_timestamp,

--t.tx_receiver,

--t.tx_signer as users,

t.txn_hash,

t.deposit / pow (10,24) as amount,

t.transaction_fee / pow (10,24) as fee

from flipside_prod_db.mdao_near.transfers t

inner join active_users_last_days a

on t.tx_signer = a.users

where t.status = 'TRUE'

),

raw_transfers_to_active_users as (

select t.block_timestamp,

--t.tx_receiver as users,

--t.tx_signer,

t.txn_hash,

t.deposit / pow (10,24) as amount,

t.transaction_fee / pow (10,24) as fee

from flipside_prod_db.mdao_near.transfers t

inner join active_users_last_days a

on t.tx_receiver = a.users