with ram as ( select block_timestamp::date as date, count(distinct tx_hash) as total from optimism.core.fact_event_logs where topics[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'

and event_inputs:tokenId is not null group by 1 ), data_all_opt as ( select block_timestamp::date as date, count(distinct tx_hash) as total from optimism.core.fact_transactions where status = 'SUCCESS' group by 1 )

, data_opt as ( select q.date, (q.total/w.total)*100 as rate from ram q join data_all_opt w on q.date = w.date ) , data_raw_arb as ( select block_timestamp::date as date, count(distinct tx_hash) as total

from arbitrum.core.fact_event_logs where topics[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef' and event_inputs:tokenId is not null group by 1 ), data_all_arb as ( select

block_timestamp::date as date, count(distinct tx_hash) as total from arbitrum.core.fact_transactions where status = 'SUCCESS' group by 1 ) , data_arb as ( select q.date, (q.total/w.total)*100 as rate

from data_raw_arb q join data_all_arb w on q.date = w.date ) , data_raw_pol as ( select block_timestamp::date as date, count(distinct tx_hash) as total from polygon.core.fact_event_logs where

topics[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'and event_inputs:tokenId is not null group by 1 ), data_all_pol as ( select block_timestamp::date as date, count(distinct tx_hash) as total

from polygon.core.fact_transactions where status = 'SUCCESS' group by 1 ) , data_pol as ( select q.date, (q.total/w.total)*100 as rate from data_raw_pol q join data_all_pol w on q.date = w.date )

select *, 'Optimism' as chain from data_opt union all select *, 'Arbitrum' as chain from data_arb union all select *, 'Polygon' as chain from data_pol