mint as (

select

BLOCK_TIMESTAMP,

TX_HASH ,

tokenflow_eth.hextoint(substr(data,1,66)) as project ,

concat('0x',substr(data,283,41)) as minter ,

concat('0x',substr(data,219,40)) as nft_address ,

tokenflow_eth.hextoint(substr(data,131,64)) as token_id

from optimism.core.fact_event_logs

where

-- TX_HASH ='0x7fcbf95853b26367a953819ac2bbfced8e6979315fa5de0584e5f07ea4bfebb7'

CONTRACT_ADDRESS ='0x2e42f214467f647fe687fd9a2bf3baddfa737465'

and ORIGIN_TO_ADDRESS ='0x2e42f214467f647fe687fd9a2bf3baddfa737465'

and concat('0x',substr(data,219,40)) = '0xfa14e1157f35e1dad95dc3f822a9d18c40e360e2'

and TX_STATUS ='SUCCESS'

, nft as (select

case when project='6340'then'Stargate'

when project='6343'then'Uniswap'

when project='6344'then'Velodrome'

when project='6346'then'Polynomial'

when project='6347'then'Synapse'

when project='6349'then'Perpetual Protocol'

when project='6351'then'Pooltogether'

when project='6357'then'Clipper'

when project='6358'then'Lyra'

when project='6359'then'Hop Protocol'

when project='6360'then'Rubicon'

when project='6361'then'Pika'

when project='6362'then'Synthetix'

when project='6363'then'QiDao/Mai Finance'

when project='6364'then'Kwenta'

when project='6367'then'Granary'

when project='6369'then'Quix'