COUNT(TX_HASH) AS total_transactions_last_30_days

FROM

base.core.ez_token_transfers

WHERE

CONTRACT_ADDRESS = '0x532f27101965dd16442e59d40670faf5ebb142e4'

AND BLOCK_TIMESTAMP >= DATEADD(DAY, -30, CURRENT_TIMESTAMP);