date_trunc('day', block_timestamp) as day,

symbol,

count(*) as transfers,

count(DISTINCT from_address) as users

FROM optimism.core.fact_token_transfers

LEFT outer JOIN optimism.core.dim_contracts

ON address = contract_address

WHERE to_address in (

SELECT address

FROM optimism.core.dim_labels

WHERE project_name LIKE 'uniswap'

)

GROUP by 1,2