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 'Transfer'

ELSE 'Other'

END AS transactionType

FROM evm_events_ethereum_mainnet_v1

WHERE

address IN ('0x427b8efee2d6453bb1c59849f164c867e4b2b376') -- BEB 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;