select ADDRESS_NAME,count(1),to_date(BLOCK_TIMESTAMP) from optimism.core.fact_token_transfers inner join optimism.core.dim_labels
on optimism.core.dim_labels.address=CONTRACT_ADDRESS
where to_date(BLOCK_TIMESTAMP) > '2022-06-30' and to_date(BLOCK_TIMESTAMP) <= '2022-07-31'
group by 1,3