COUNT(*) AS Number_of_contacts,

crosschain.core.dim_contracts

(

symbol LIKE 'USD%'

OR symbol LIKE 'Tether%'

OR symbol LIKE 'DAI'

OR symbol LIKE 'PYUSD'

OR name LIKE 'USD%'

OR name LIKE 'Tether%'

OR name LIKE 'DAI'

OR name LIKE 'Paypal% '

)

AND CREATED_BLOCK_TIMESTAMP >= date_trunc('month', CURRENT_DATE) - INTERVAL '3 months'