SELECT MONTHNAME(BLOCK_TIMESTAMP) AS MONTH, TRANSFER_TYPE, COUNT(distinct tx_id) as N_usei_transfers

FROM sei.core.fact_transfers

WHERE BLOCK_TIMESTAMP::DATE >= '2024-01-01'

AND TRANSFER_TYPE = 'SEI'

GROUP BY MONTH(BLOCK_TIMESTAMP), MONTHNAME(BLOCK_TIMESTAMP), transfer_type

ORDER BY MONTH(BLOCK_TIMESTAMP) ASC