afraid-sapphire

alfredfx10afraid-sapphire

Updated 2025-04-10

--JUPyiwrYJFskUPiHa7hkeR8VUtAeFoSYbKedZNsDvCN

SELECT *

FROM solana.defi.fact_stake_pool_actions

WHERE STAKE_POOL_NAME = 'JUP'

LIMIT 10

-- with price AS (

-- SELECT

-- hour::date AS Date,

-- symbol,

-- avg(price) AS price_in_usd

-- FROM crosschain.price.ez_prices_hourly

-- WHERE token_address = 'So11111111111111111111111111111111111111112'

-- GROUP BY 1,2

-- )

-- SELECT

-- date_trunc('day', block_timestamp) as date,

-- CASE

-- when action ='deposit' then 'Stake'

-- when action = 'withdraw' then 'Instant UnStake'

-- when action = 'withdraw_stake' then 'Delayed UnStake'

-- END AS type,

-- COUNT(DISTINCT tx_id) as txs,

-- COUNT(DISTINCT address) as users,

-- SUM(amount/pow(10,9)) as sol_amount,

-- SUM(amount/pow(10,9)*price_in_usd) as usd_amount,

-- AVG(amount/pow(10,9)*price_in_usd) as average_volume

-- FROM solana.defi.fact_stake_pool_actions

-- JOIN price

-- ON block_timestamp::date = Date

-- AND symbol = upper(token)

-- WHERE 1 = 1

Last run: about 2 months ago

No Data to Display

flipside