SELECT

symbol,

contract_address,

SUM(amount_usd) AS total_volume

FROM

optimism.core.ez_token_transfers

WHERE

amount_usd IS NOT NULL

GROUP BY

symbol, contract_address

ORDER BY

total_volume DESC

LIMIT 15

SELECT

tt.symbol,

SUM(f.tx_fee) AS total_gas_fees_usd

FROM

optimism.core.ez_token_transfers t

JOIN

optimism.core.fact_transactions f

ON

t.tx_hash = f.tx_hash

TopTokens tt

t.contract_address = tt.contract_address

GROUP BY

tt.symbol

ORDER BY

total_gas_fees_usd DESC;