with mtokenlist as (

select '0x73b06d8d18de422e269645eace15400de7462417' as mTokenAddress, 'mDAI' as mTokenName, '0x50c5725949a6f0c72e6c4a641f24049a917db0cb' as TokenAddress

union all

select '0xcb1dacd30638ae38f2b94ea64f066045b7d45f44' as mTokenAddress, 'mrETH' as mTokenName,'0xb6fe221fe9eef5aba221c348ba20a1bf5e73624c' as TokenAddress

union all

select '0x627fe393bc6edda28e99ae648fd6ff362514304b' as mTokenAddress, 'mwstETH' as mTokenName, '0xc1cba3fcea344f92d9239c08c0568f6f2f0ee452' as TokenAddress

union all

select '0xedc817a28e8b93b03976fbd4a3ddbc9f7d176c22' as mTokenAddress, 'mUSDC' as mTokenName, '0x833589fcd6edb6e08f4c7c32d4f71b54bda02913' as TokenAddress

union all

select '0x703843c3379b52f9ff486c9f5892218d2a065cc8' as mTokenAddress, 'mUSDbC' as mTokenName, '0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca' as TokenAddress

union all

select '0x628ff693426583d9a7fb391e54366292f509d457' as mTokenAddress, 'mWETH' as mTokenName, '0x4200000000000000000000000000000000000006' as TokenAddress

union all

select '0x3bf93770f2d4a794c3d9ebefbaebae2a8f09a5e5' as mTokenAddress, 'mcbETH' as mTokenName, '0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22' as TokenAddress

),

date_ls as (

date_day

ethereum.core.dim_dates

date_day>='2023-08-09' and date_day<=current_date()

),

token_date_ls as (

date_day,

mTokenAddress as mTokenAddress2,

mTokenName as mTokenName2,

TokenAddress as TokenAddress2

from

date_ls

full outer join