SELECT tx_sender as wallet

from terra.core.fact_transactions

WHERE date_Trunc('day',block_timestamp) = current_date - 30

),

tx_fee_per_wallet as (

SELECT tx_sender,

sum(fee) as total_fee

FROM terra.core.fact_transactions

WHERE date_Trunc('day',block_timestamp) > current_date - 30

AND tx_sender IN (SELECT wallet from active_wallets)

GROUP BY tx_sender

)

SELECT avg(total_fee) as avg_fee,

median(total_fee) as median_fee

FROM tx_fee_per_wallet