SELECT
-- date_trunc('week', block_timestamp) as week,
-- sum(
-- CASE when action LIKE 'deposit' then amount
-- else -1 * amount end
-- ) / power(10, 9) as net_pool_bal
-- DISTINCT action
*
FROM solana.defi.fact_stake_pool_actions
WHERE STAKE_POOL_NAME LIKE 'blazestake'
ORDER BY block_timestamp DESC
LIMIT 100