Hourly Withdraws

JhanlycnHourly Withdraws

Updated 2024-04-12

-- forked from h4wk / MGNF_KPI TVL @ https://flipsidecrypto.xyz/h4wk/q/N9KZBKDc8y5J/mgnf_kpi-tvl

-- 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

-- 8RcZHucpVHkHWRRdMhJZsxBK9mqKSYnMKGqtF84U8YEo -- BSOL

-- 2SQcKvhxwyBHzwgWFvBT9DdbEkAQ8EDdVpL1LXuswN1T -- DUST

-- 6PWVauGLhBFHUJspsnBVZHr56ZnbvmhSD2gS7czBHGpE -- LST

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

2 qualify row_number() over (

partition by price_symbol

order by

price_date desc

) = 1

QueryRunArchived: QueryRun has been archived