SELECT

block_timestamp,

tx_id

FROM cosmos.core.fact_msg_attributes

WHERE msg_type = 'message'

AND ATTRIBUTE_KEY = 'module'

AND

ATTRIBUTE_VALUE = 'bank'

AND TX_SUCCEEDED

AND block_timestamp :: date >= '2024-01-17'

SELECT

ATTRIBUTE_VALUE as user,

count(DISTINCT b.tx_id) as n_mint

from cosmos.core.fact_msg_attributes a

JOIN all_txns b ON a.tx_id = b.tx_id

WHERE msg_type = 'tx' and ATTRIBUTE_KEY = 'fee_payer'

AND a.block_timestamp :: date >= '2024-01-17'

GROUP BY 1

ORDER BY 2 DESC

LIMIT 1000