with gp as ( SELECT * FROM

( values

('6uQDwA2MAxCPNGho6yxPGbtPDky3mn8dfZ3atb1aB6SG', 'uxd'),

('7P2TQHYgVJkXv1VPaREsL5Pi1gnNjVif5aF3pJewZ9kj', 'wbtc'),

('26kcZkdjJc94PdhqiLiEaGiLCYgAVVUfpDaZyK4cqih3', 'bonk'),

('DD3AeAssFvjqTvRTrRAtpfjkBF8FpVKnFuwnMLN9haXD', 'sol'),

('ELXogWuyXrFyUG1vevffVbEhVxdFrHf2GCJTtRGKBWdM', 'eth'),

('8RcZHucpVHkHWRRdMhJZsxBK9mqKSYnMKGqtF84U8YEo', 'bsol'),

('9r6z6KgkEytHCdQWNxvDQH98PsfU98f1m5PCg47mY2XE', 'usdt'),

('3uxNepDbmkDNq6JhRja5Z8QwbTrfmkKP8AKZV5chYDGG', 'usdc'),

('7VDS9KHnHuebmN8maraoiDAomdf4xdJ8tNF8KLJCKHin', 'stsol'),

('7Ng54qf7BrCcZLqXmKA9WSR7SVRn4q6RX1YpLksBQ21A', 'jitosol'),

('2SQcKvhxwyBHzwgWFvBT9DdbEkAQ8EDdVpL1LXuswN1T', 'dust'),

('6YxGd65JbXzgFGWjE44jsyVeCnZp7Bb1wfL9jDia1n8w', 'msol')

) as a(account,symbol))

,

tokens_price as (

SELECT

date_trunc('d',RECORDED_HOUR) as date,

symbol,

token_address,

median(close) as usd_price

FROM solana.price.ez_token_prices_hourly a

WHERE date >= current_date - 180

GROUP BY 1 , 2 , 3

UNION ALL

SELECT

date_trunc('d',RECORDED_HOUR) as date,

'bsol' as symbol,

'bSo13r4TkiE4KumL71LsHTPpL2euBYLFx6h9HP3piy1' as token_address,

median(close*1.087) as usd_price

FROM solana.price.ez_token_prices_hourly

WHERE symbol = 'sol'

AND date >= current_date - 180