SELECT symbol, contract_address,
count(DISTINCT tx_hash) as n_txns
FROM optimism.core.fact_token_transfers a
LEFT JOIN optimism.core.dim_contracts b
ON a.contract_address = b.address
WHERE date_trunc('day',block_timestamp) = current_date-1
GROUP BY contract_address,symbol
ORDER BY n_txns DESC
LIMIT 10