select *

from (values

('6iQKfEyhr3bZMotVkW6beNZz5CPAkiwvgV2CTje9pVSS', 'jitoSOL', 'Jito'),

('6WecYymEARvjG5ZyqkrVQ6YkhPfujNzWpSPwNKXHCbV2', 'bSOL', 'BlazeStake'),

('AzZRvyyMHBm8EHEksWxq4ozFL7JxLMydCDMGhqM6BVck', 'scnSOL', 'Socean'),

('3b7XQeZ8nSMyjcQGTFJS5kBw4pXS2SqtB9ooHCnF2xV9', 'LST', 'Marginfi')

) as t(authority, token_symbol, platform_name)

sp.platform_name,

sp.token_symbol,

sum(post_tx_staked_balance) / 1e9 as total_value_locked_sol

from solana.gov.ez_staking_lp_actions actions

join staking_platforms sp ON actions.stake_authority = sp.authority

where actions.block_timestamp >= '2024-01-01'

and actions.block_timestamp < '2025-01-01'

and actions.event_type = 'delegate' -- Assuming we're looking at delegate events for staked SOL

group by sp.platform_name, sp.token_symbol

order by total_value_locked_sol desc;