date_trunc('Hour', BLOCK_TIMESTAMP) AS Day,

CASE

when ATTRIBUTE_VALUE = 'osmo164357hnc5jc0pw9lv958h6chrpjucr4sy47hwpm9k4av6zh74gnq7uvcpj' THEN 'BNB'

when ATTRIBUTE_VALUE = 'osmo186nlf2fwfglq8u4nj3f7mwg8uc79j22qhaau4scdyur47e0fatas34vcn9' THEN 'SEI'

when ATTRIBUTE_VALUE = 'osmo19uqdjvk6j9yjtev7j25sc0v0mszqy3jwwak8z4n0qf6l4wp9csvq0jn0qw' THEN 'LINK'

when ATTRIBUTE_VALUE = 'osmo1d5zsvupzvq5ru6635a0agrcdrj0t8ycj8vpewm8z4y8xf85gvh3qk0ka33' THEN 'DOT'

when ATTRIBUTE_VALUE = 'osmo19c7hdlfvu7cddr0smfz9luaj8375qhfr3s0gtsk087laqfzxlu3qsnk47e' THEN 'axlETH'

when ATTRIBUTE_VALUE = 'osmo1hd7r733w49wrqnxx3daz4gy7kvdhgwsjwn28wj7msjfk4tde89aqjqhu8x' THEN 'ATOM'

when ATTRIBUTE_VALUE = 'osmo1f5vfcph2dvfeqcqkhetwv75fda69z7e5c2dldm3kvgj23crkv6wqcn47a0' THEN 'milkTIA'

when ATTRIBUTE_VALUE = 'osmo196l7z8fvqz2v685vpsk2vuw5qyesw4v7y3w7ek08aacx5c0k5heqy8twn4' THEN 'stDYDX'

when ATTRIBUTE_VALUE = 'osmo1jprh8f4ytxar0q3z5n5p6swqnmunnsvuuhnhteskwxjzyc8jayms4r7e3e' THEN 'SOL'

when ATTRIBUTE_VALUE = 'osmo1353cxacx74lfugp0sdkdpasa7d09rlwwdaeeql9usw2w6g773vqsxgp053' THEN 'INJ'

when ATTRIBUTE_VALUE = 'osmo19uqdjvk6j9yjtev7j25sc0v0mszqy3jwwak8z4n0qf6l4wp9csvq0jn0qw' THEN 'LINK'

when ATTRIBUTE_VALUE = 'osmo1kqzkupfec3zemmaj3kuhcf0h2wke02wa7sgp2a9vq5mugtgs5pzs8avjzt' THEN 'TIA'

when ATTRIBUTE_VALUE = 'osmo1ufpu3nudumzh53sek246zrwvv2cc7leplaqruuggeny7wlcvfrzq4cqmwd' THEN 'stATOM'

when ATTRIBUTE_VALUE = 'osmo127aqy4697zqn27z0vqr3x2n8lraf27t7udvl6ef5hcwmwhjadegq9vytdj' THEN 'OSMO'

when ATTRIBUTE_VALUE = 'osmo1wszczd8y6lk53ygr59cxt60ualydtwsnr7tu63zkgvu704r7yqdshc47w8' THEN 'PYTH'

when ATTRIBUTE_VALUE = 'osmo1xmuwpu2v97cgk2lmevdylkfvtzrlznv826zht8mezh7979fh9y5sdck8ws' THEN 'AXL'

end AS Pool,

avg(Long_Rate) AS "Long Rate",

avg(Short_Rate) AS "Short Rate"

osmosis.core.fact_msg_attributes m

inner join (

select

TX_ID,

ATTRIBUTE_VALUE AS Long_Rate

from

osmosis.core.fact_msg_attributes

where

TX_SUCCEEDED = TRUE

and MSG_TYPE like 'wasm-funding-rate-change'

and ATTRIBUTE_KEY = 'long-rate'

) l on l.TX_ID = m.TX_ID