select

tx_hash

,block_timestamp

,to_address

,token_id

,concat ('https://ronin.metadata.ragmon.gg/0x89b84f8dd9be7ba6aafba802c6e4a7fc8be242ca/', token_id) as nft_metadata

from ronin.nft.ez_nft_transfers

where 1=1

and contract_address= '0x89b84f8dd9be7ba6aafba802c6e4a7fc8be242ca'

and IS_MINT = 'TRUE'

and from_address = '0x0000000000000000000000000000000000000000'

),

flatten as (

select

tx_hash

,block_timestamp

,to_address

,token_id

,nft_metadata

,live.udf_api(nft_metadata) as response

--,case when key = 'description' then value end as mob_name

--,value[3]:value end as mob_name

,value[1]:value as rarity

,value[2]:value as mob_name

,to_timestamp(value[7]:value) as hatchable_at

from egg_mints

, lateral flatten (input => response:data)

where key = 'attributes'

select

token_id

,mob_name