FROM optimism.core.fact_event_logs

WHERE ORIGIN_TO_ADDRESS = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de'

AND TOPICS[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'

AND BLOCK_TIMESTAMP > '2022-05-25'

AND TX_STATUS = 'SUCCESS')

count(distinct TO_ADDRESS) as wallets,

sum(RAW_AMOUNT/1e18) as volume_OP,

count(tx_hash) as no_claim,

wallets/248699*100 as share_wallets,

volume_OP/214748364.8 *100 as share_volume

FROM optimism.core.fact_token_transfers

WHERE contract_address = '0x4200000000000000000000000000000000000042'

and tx_hash in (select tx_hash from tb1)

and from_address = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de'