date_trunc('day', hour::DATE) as date

,AVG(case when token_address = 'So11111111111111111111111111111111111111112'

then price end) AS sol_price

,AVG(case when token_address = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx'

then price end) AS atlas_price

,AVG(case when token_address = 'poLisWXnNRwC6oBu1vHiuKQzFjGL4XDSu4g9qjz9qVk'

then price end) AS polis_price

,AVG(case when token_address = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'

then price end) AS usdc_price

---

,AVG(case when token_address = '9W6jTkjabViRr6XhvW734HDt9RuoAunjj1zi5bjhxdpa'

then price end) AS prtl_price

SOLANA.price.ez_prices_hourly

hour::DATE >= date_trunc('week', current_timestamp) - interval '130 days'

GROUP BY 1

,assets AS (

--*

date_trunc('day', block_timestamp::date) as date

,sum(case when inner_instruction:instructions[2]:parsed:info:mint::string = 'fueL3hBZjLLLJHiFH9cqZoozTG3XQZ53diwFPwbzNim' then inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount end) AS FUEL