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'

ELSE 'Transfer'

END AS transactionType

FROM evm_events_ethereum_mainnet_v1

WHERE

address IN ('0x049aba7510f45ba5b64ea9e658e342f904db358d') -- Unstoppable NFT

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

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

stringDay,

transactionType,

COUNT(*) as totalTransactions

FROM categorized_transactions

GROUP BY

stringDay,

transactionType

ORDER BY

stringDay DESC,

transactionType;