TVL | defi__josh | Flipside

Updated 2025-05-12

-- WITH marinade_actions AS (

-- SELECT

-- block_timestamp,

-- SUM(CASE

-- WHEN action_type = 'deposit' THEN deposit_amount

-- WHEN action_type = 'claim' THEN -claim_amount

-- END) as net_staked_sol

-- FROM solana.marinade.ez_liquid_staking_actions

-- WHERE block_timestamp >= DATEADD('day', -30, CURRENT_TIMESTAMP())

-- GROUP BY 1

-- ),

-- latest_tvl AS (

-- SELECT

-- SUM(net_staked_sol) as total_staked_sol

-- FROM marinade_actions

-- )

-- -- ,ranked_tvl as (

-- SELECT

-- 'mSOL' as token,

-- -total_staked_sol as staked_sol,

-- p.price as sol_price_usd,

-- -total_staked_sol * p.price as tvl_usd

-- -- ,

-- -- "121.20" as sol_price_usd ---- 2025-04-05

-- -- -total_staked_sol * p.price as tvl_usd

-- -- row_number() over (partition by 2,3 order by 4 desc)

-- FROM latest_tvl

-- LEFT JOIN solana.price.ez_prices_hourly p

-- ON p.symbol = 'SOL'

-- AND p.blockchain = 'solana'

-- AND p.hour = (

-- SELECT MAX(hour)

-- FROM solana.price.ez_prices_hourly

-- WHERE symbol = 'SOL' AND blockchain = 'solana'

-- -- )

Last run: 18 days ago

	TOKEN	STAKED_SOL	SOL_PRICE_USD	TVL_USD	ROW_NUM
1	mSOL	-382751.580285673	174.47	-66778668.2124414	1
2	mSOL	-382751.580285673	174.49	-66786323.2440471	2

109B

flipside