with MSOL_PRICE as (

select

date_trunc(day,hour)::date date ,

symbol ,

median (price) price_usd

from solana.price.ez_prices_hourly

where token_address ='mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So'

and date_trunc(day,hour)::date >= current_date

group by 1 ,2

),

SOL_price as (

SELECT

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

symbol,

median(price) as price_usd

FROM solana.price.ez_prices_hourly

WHERE symbol = 'SOL'

AND date_trunc('day', hour)::date = CURRENT_DATE

GROUP BY 1, 2

),

txns as (

with stake_txns as (

select BLOCK_TIMESTAMP ::Date date ,

tx_id ,

PROVIDER_ADDRESS user ,

DEPOSIT_AMOUNT amount ,

DEPOSIT_AMOUNT_USD amount_usd ,

'Stake' type

from solana.marinade.ez_liquid_staking_actions

where ACTION_TYPE in ('depositStakeAccount', 'deposit')

) ,

unstake_txns as (

select BLOCK_TIMESTAMP ::Date date ,

tx_id ,

PROVIDER_ADDRESS user ,