WITH categorized_transactions AS (

SELECT

address,

DATE_TRUNC('day', 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_polygon_mainnet_v1

WHERE

address IN ('0xa9a6a3626993d487d2dbda3173cf58ca1a9d9e9f') -- Unstoppable NFT Polygon

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

stringDay,

transactionType,

COUNT(*) as totalTransactions

FROM categorized_transactions

GROUP BY

stringDay,

transactionType

ORDER BY

stringDay DESC,

transactionType;