SELECT block_timestamp,t.TX_HASH, gc.SYMBOL

FROM optimism.core.fact_transactions t LEFT JOIN optimism.core.dim_contracts gc ON gc.ADDRESS = t.TO_ADDRESS

WHERE t.BLOCK_TIMESTAMP > CURRENT_DATE - interval '1 month'

-- AND LOWER( SYMBOL) NOT IN ('chainlink','ovm','ovm gas price oracle') --exclude ops ttransactions / focus on consumer transactions

AND TO_ADDRESS != lower('0x420000000000000000000000000000000000000F') --exclude gas price oracle

select RANK() OVER (Order BY COUNT(*) DESC) as ranking, SYMBOL, count(*) from transaction_data

group by SYMBOL