with Stablecoins as (

select

token_address,

Symbol,

Name,

case when DECIMALS is null then 6 else decimals end as decimal

from solana.price.ez_asset_metadata

where token_address in (

'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v', -- USDC

'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB', -- USDT

'2b1kV6DkPAnxd5ixfnxCpjxmKwqjjaYmCZfHsFu24GXo', -- PYUSD

'A1KLoBrKBde8Ty9qtNQUtq3C2ortoC3u7twggz7sEto6', -- USDY

'USDSwr9ApdHk5bvJKMjzff41FfuX8bSxdKcR81vTwcA', -- USDS

'9zNQRsGLjNKwCUU5Gq5LR8beUCPzQMVMqKAi3SSZh54u', -- FDUSD

'susdabGDNbhrnCa6ncrYo81u4s9GM8ecK2UwMyZiq4X', -- sUSD

'FrBfWJ4qE5sCzKm3k3JaAtqZcXUh4LvJygDeketsrsH4', -- ZUSD

-- 'DEkqHyPN7GMRJ5cArtQFAWefqbZb33Hyf6s5iCwjEonT', -- USDe

'HzwqbKZw8HxMN6bF2yFZNrht3c2iXXzpKcFu7uBEDKtr' -- EURC

)

union

select

'susdabGDNbhrnCa6ncrYo81u4s9GM8ecK2UwMyZiq4X' as token_address,

'sUSD' as Symbol,

'Solayer USD' as Name,

6 as decimal

,

dates as (

select

date_trunc('day',DATE_DAY) as date,

token_address

from crosschain.core.dim_dates cross join (select token_address from Stablecoins)