vertical-olive

i_danvertical-olive

Updated 2025-01-17

SELECT --*

count(*)

-- MIN(block_timestamp) AS date

, event_type

FROM

solana.core.ez_events_decoded

WHERE

program_id = 'dvyFwAPniptQNb1ey4eM12L8iLHrzdiDsPPDndd6xAR'

-- AND

-- split_part(

-- split_part(CAST(instructions AS VARCHAR), '", "stackHeight":', 1)

-- , '"programId": "', 2),

-- '"', 1

-- ) = 'dvyFwAPniptQNb1ey4eM12L8iLHrzdiDsPPDndd6xAR'

GROUP BY event_type

--ORDER BY date DESC

LIMIT 100

-- $DVY = DVYcTNFVGxePLgK8rUjViJvurRmTnD1FZUBR7puADymT

-- Divvy CA = dvyFwAPniptQNb1ey4eM12L8iLHrzdiDsPPDndd6xAR

Last run: about 2 months ago

	COUNT(*)	EVENT_TYPE
1	2896
2	66	claim
3	17839	updateBetV2
4	27	kaminoRedeemReserveCollateral
5	3585	closeParlay
6	31	kaminoClaimRewards
7	1119	createDvypassV2
8	16	kaminoDepositReserveLiquidity
9	198	createDepositPosition
10	8165	unstakeDvypass
11	1243	claimDvypassEmission
12	2810	claimDvypass
13	78	createWithdrawPosition
14	3	cancelWithdrawPosition
15	1167	closeDvypassV2
16	8950	stakeDvypass
17	8952	closeBetV2
18	194	deposit
19	10360	closeSlip
20	72	withdraw

628B

flipside