PROVIDER_ADDRESS | TOTAL_SOL_DEPOSITED | TOTAL_USD_DEPOSITED | TOTAL_MSOL_MINTED | TOTAL_MSOL_BURNED | TOTAL_SOL_CLAIMED | TOTAL_USD_CLAIMED | DEPOSIT_COUNT | CLAIM_COUNT | TOTAL_TRANSACTIONS | FIRST_ACTIVITY | LAST_ACTIVITY | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | GGztQqQ6pCPaJQnNpXBgELr5cs3WwDakRbh1iEMzjgSJ | 61867.876896307 | 11240475.53 | 48846.608286944 | 0 | 0 | 0 | 104 | 0 | 104 | 2025-02-01 12:21:10.000 | 2025-03-02 06:05:55.000 |
gigiokobamsol
Updated 2025-03-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
SELECT
provider_address,
-- Deposit stats
COALESCE(SUM(CASE WHEN action_type IN ('deposit', 'depositStakeAccount')
THEN deposit_amount ELSE 0 END), 0) as total_sol_deposited,
COALESCE(SUM(CASE WHEN action_type IN ('deposit', 'depositStakeAccount')
THEN deposit_amount_usd ELSE 0 END), 0) as total_usd_deposited,
-- MSOL minting stats
COALESCE(SUM(CASE WHEN msol_minted IS NOT NULL
THEN msol_minted ELSE 0 END), 0) as total_msol_minted,
-- MSOL burning stats
COALESCE(SUM(CASE WHEN msol_burned IS NOT NULL
THEN msol_burned ELSE 0 END), 0) as total_msol_burned,
-- Claim stats
COALESCE(SUM(CASE WHEN claim_amount IS NOT NULL
THEN claim_amount ELSE 0 END), 0) as total_sol_claimed,
COALESCE(SUM(CASE WHEN claim_amount_usd IS NOT NULL
THEN claim_amount_usd ELSE 0 END), 0) as total_usd_claimed,
-- Activity counts
COUNT(CASE WHEN action_type IN ('deposit', 'depositStakeAccount') THEN 1 END) as deposit_count,
COUNT(CASE WHEN action_type = 'claim' THEN 1 END) as claim_count,
COUNT(*) as total_transactions,
-- First and last activity
MIN(block_timestamp) as first_activity,
MAX(block_timestamp) as last_activity
FROM solana.marinade.ez_liquid_staking_actions
WHERE block_timestamp >= DATEADD('day', -30, CURRENT_DATE)
AND ( '{{provider_address}}' IS NULL OR provider_address = '{{provider_address}}' )
GROUP BY provider_address
HAVING total_sol_deposited > 0 OR total_sol_claimed > 0
Last run: 13 days ago
1
162B
1s