address

, COUNT(*) AS staking_transactions

, SUM(stk.amounts * pr.price) AS staking_volume

FROM (SELECT --*

block_timestamp

, stake_pool_name

, tx_id

, address

, CASE when token is null then 'SOL' else token end AS token_symbol

, CASE when token_symbol = 'SOL' then 'So11111111111111111111111111111111111111111'

when token_symbol = 'mSOL' then 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' end AS token_address

, (amount * 1e-9) AS amounts

FROM solana.defi.fact_stake_pool_actions

WHERE succeeded

--AND amounts is not null

) AS stk

JOIN solana.price.ez_prices_hourly pr ON date_trunc(hour, stk.block_timestamp) = pr.hour AND stk.token_address = pr.token_address

GROUP BY 1

ORDER BY 2 DESC

SELECT

action_type

, count(*)

FROM solana.defi.ez_liquidity_pool_actions

GROUP BY 1