block_timestamp::date as day,

count(distinct tx_id) as txns_count,

count(distinct (iff(transfer_type = 'IBC_TRANSFER_IN', tx_id, null))) as inflow_txns_count,

count(distinct (iff(transfer_type = 'IBC_TRANSFER_OUT', tx_id, null))) as outflow_txns_count,

count(distinct sender) as senders_count,

count(distinct receiver) as receivers_count,

txns_count / senders_count as txns_per_user

from osmosis.core.fact_transfers

where tx_succeeded = 1

and block_timestamp > current_date - 90

group by 1

avg(txns_count) as average_txns_count,

avg(senders_count) as average_senders_count,

avg(receivers_count) as average_receivers_count

from t