MGNF_KPI Period NET

h4wkMGNF_KPI Period NET

Updated 2024-04-11

-- forked from MGNF_KPI @ https://flipsidecrypto.xyz/edit/queries/9747d8cb-aeb3-4760-ae65-c7de473752f6

-- Program log: Instruction: LendingAccountDeposit -- LEND

-- Program log: Instruction: LendingAccountBorrow -- BORROW

-- Program log: Instruction: LendingAccountRepay -- REPAY

-- Program log: Instruction: LendingAccountWithdraw -- WITHDRAW

-- Treasury Address

-- ELXogWuyXrFyUG1vevffVbEhVxdFrHf2GCJTtRGKBWdM -- ETH

-- 3uxNepDbmkDNq6JhRja5Z8QwbTrfmkKP8AKZV5chYDGG -- USDC

-- 9r6z6KgkEytHCdQWNxvDQH98PsfU98f1m5PCg47mY2XE -- USDT

-- 7Ng54qf7BrCcZLqXmKA9WSR7SVRn4q6RX1YpLksBQ21A -- JITOSOL

-- DD3AeAssFvjqTvRTrRAtpfjkBF8FpVKnFuwnMLN9haXD -- SOL

-- 6YxGd65JbXzgFGWjE44jsyVeCnZp7Bb1wfL9jDia1n8w -- MSOL

-- AjsyrYpgaH275DBSnvNWdGK33hVycSFuXN87FKnX6fVY -- HNT

-- 6uQDwA2MAxCPNGho6yxPGbtPDky3mn8dfZ3atb1aB6SG -- UXD

-- 7P2TQHYgVJkXv1VPaREsL5Pi1gnNjVif5aF3pJewZ9kj -- WBTC

-- 7VDS9KHnHuebmN8maraoiDAomdf4xdJ8tNF8KLJCKHin -- STSOL

-- 26kcZkdjJc94PdhqiLiEaGiLCYgAVVUfpDaZyK4cqih3 ** BONK

with base_price as (

select recorded_hour::date as price_date,

symbol as price_symbol,

avg(close) as price

from solana.price.fact_token_prices_hourly

where symbol != 'UXP'

group by 1,2

qualify row_number() over (partition by price_symbol order by price_date desc) = 1

)

-- Fill missing bSOL ~price by SOL price * 1.084

, bsol_price as (

select current_date as price_date,

'BSOL' as price_symbol,

( select price*1.084 from base_price where price_symbol = 'SOL'

) as price

)

QueryRunArchived: QueryRun has been archived