WITH categorized_transactions AS (

SELECT

address,

DATE_TRUNC('month', timestamp) AS stringDay,

CASE

WHEN input_0_value_address = '0x0000000000000000000000000000000000000000' THEN 'Mint'

WHEN input_1_value_address = '0x0000000000000000000000000000000000000000' THEN 'Burn'

WHEN input_0_value_address = '0xD4416b13d2b3a9aBae7AcD5D6C2BbDBE25686401' OR input_1_value_address = '0xD4416b13d2b3a9aBae7AcD5D6C2BbDBE25686401' THEN 'Wrap'

ELSE 'Transfer'

END AS transactionType

FROM evm_events_ethereum_mainnet_v1

WHERE

address IN ('0x57f1887a8bf19b14fc0df6fd9b2acc9af147ea85') -- ENS NFT

AND signature = 'Transfer(address,address,uint256)' -- Signature for transfer

AND timestamp >= '2023-07-01' -- Start date

AND input_0_value_address NOT IN ('0x283Af0B28c62C092C9727F1Ee09c02CA627EB7F5', '0xOtherAddress1', '0xOtherAddress2') -- Exclude Registrar Controller and other addresses

AND input_1_value_address NOT IN ('0x283Af0B28c62C092C9727F1Ee09c02CA627EB7F5', '0xOtherAddress1', '0xOtherAddress2') -- Exclude Registrar Controller and other addresses

stringDay,

transactionType,

COUNT(*) as totalTransactions

FROM categorized_transactions

GROUP BY

stringDay,

transactionType

ORDER BY

stringDay DESC,

transactionType;