MNDE Staked copy

solananaMNDE Staked copy

Updated 2025-03-17

with base as (select

date_trunc('day', block_timestamp) as day

, sum(amount) as sum_locked

from solana.gov.fact_gov_actions

where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey'

and program_name = 'marinade'

and action in ('MINT LOCK', 'UPDATE LOCK')

and succeeded = 'TRUE'

group by 1)

select *

from solana.gov.fact_gov_actions

where program_name = 'marinade' and succeeded = true

and (locker_account = 'BHrd4Fmdi7LeZ7FnTq6Go2arV6ECnZCyds6eNtuTYdUU'

or locker_nft = '6nrXenspXseqiwhs5ccoD2iirZGv3Dmr2WcoRh3qDFBV')

-- select

-- block_timestamp

-- , locker_account

-- , action

-- , case when action in ('MINT LOCK', 'UPDATE LOCK') then 1.00

-- when action in ('EXIT') then -1.00

-- end

-- * amount as amount

-- , sum(case when action in ('MINT LOCK', 'UPDATE LOCK') then 1.00

-- when action in ('EXIT') then -1.00

-- end

-- * amount) as amount_cumulative

-- from solana.gov.fact_gov_actions

-- where program_name = 'marinade' and succeeded = true

-- order by block_timestamp

-- limit 10

Last run: about 1 month ago

	PROGRAM_NAME	BLOCK_TIMESTAMP	BLOCK_ID	TX_ID	SUCCEEDED	SIGNER	LOCKER_ACCOUNT	LOCKER_NFT	MINT	ACTION	AMOUNT	FACT_GOV_ACTIONS_ID	INSERTED_TIMESTAMP	MODIFIED_TIMESTAMP
1	marinade	2023-06-30 02:42:13.000	202503139	5KWtJ2mJriGrSqfFVsHYt1zwRngWqfnV2GcwBRbuYjanueXFZShiqzoZFBP4NZwKAWWLkqRt...	TRUE	81ymj2NtXzgjmQ4gTc4e5XrmEoy6ASgNCdHXsiwVGuD	BHrd4Fmdi7LeZ7FnTq6Go2arV6ECnZCyds6eNtuTYdUU	6nrXenspXseqiwhs5ccoD2iirZGv3Dmr2WcoRh3qDFBV	MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey	MINT LOCK	13514.979946131	dd8d9ce083eb020086f0aeb2ed25edbd	2000-01-01 00:00:00.000	2000-01-01 00:00:00.000
2	marinade	2023-07-02 22:53:05.000	203052462	91uQzZ6mBmj5XCpXvzvnh5TL53trMF4aPuFjk7V1zjbPWKvVfXQc7NyQ3r34JfZsTXwD4bX8...	TRUE	81ymj2NtXzgjmQ4gTc4e5XrmEoy6ASgNCdHXsiwVGuD		6nrXenspXseqiwhs5ccoD2iirZGv3Dmr2WcoRh3qDFBV		START UNLOCK		9d0e85b4b3b98b61e9b287d822c52a0d	2000-01-01 00:00:00.000	2000-01-01 00:00:00.000

801B

flipside