count(1) as cnt

from polygon.transactions

where block_timestamp::date >= '2021-06-01' and block_timestamp::date <= '2021-06-30'

group by 1

order by 1 desc