BLOCK_TIMESTAMP::date as Day,

count(distinct TX_HASH) as num_txs,

count(distinct TX_HASH) as num_txs_,

count(distinct FROM_ADDRESS) as num_users,

count(distinct FROM_ADDRESS) as num_users_

from polygon.core.fact_transactions

where BLOCK_TIMESTAMP::date>='2022-07-01' and BLOCK_TIMESTAMP::date<='2022-07-12' and STATUS='SUCCESS'

group by 1

order by 1 asc