USER | TOTAL_AMOUNT | |
|---|---|---|
1 | 2ZixuuJXyZbkwbRTsLVXfEDaukEeoM2L9mfPCdHV249v | -310762.659849424 |
2 | 5ioKxH1YFPEFjhgoxS9qse8D272wg48FVHHR2oHxgPFR | 0.02 |
3 | 4kUVmxrvrPQH2BNH7s1SeXUxatvNepNEKnjvNF8G1ZPH | 63.734177346 |
4 | Bnu9miHMReKHtSjQy3L1JrTb4XKhi54VAZhVhgx6pCuV | 0.1 |
5 | HL1NqYC4H3HsPY6pb9TY3sf2qU4cMv88GDLJDnmX4oih | 0.025 |
6 | 7FwT3aBC7SiVqMtcrrGvthQz7YYXG22XAxcmnsoQjPA2 | 3 |
7 | 77rjJGhR3LG7NyBihVrvjweVNxbZ9yDMwW1EVRGjCHJC | 40.067358495 |
8 | 4Av2QQAeBVcpdaMfum1111oTFqGVroNHHptksSdMxfxu | 1.17 |
9 | G5Q39PhYjYPAwqM5n5SVpDuGfP3JK4rjfE8yX1CmEj7i | 100 |
10 | 4fjYoAVmqrSyfq6zLfKvkrZAwBkkNgtVEYvtJ4m1Z6Te | 4.88 |
11 | 5DnsDd8HSQeNn4r2DWowegZGjH8ZXGVQKHEpZXo1sMaA | 2.26 |
12 | Fkbbhes5P2STp9uAPmMEDKSAPkjBQdEaey8z3t95fT2S | 5 |
13 | 2AvPfuetCHZ49Cu8TrYbqGhuNnf2R6yzmzXQVpgdwA85 | 14.130792714 |
14 | 7cZx76kp6jBfq2mYqLN43ynAC3Zw9PVtnbUmMFhGtfEe | 10 |
15 | 2giED832JTZWUvRAfKrYrLVr5LsWN9QVnKrcdqYv9Adp | 2.4 |
16 | 2QahBm4SASpKBT8NPAQoCunXZZbpHu27WJQbXnYjWEXM | 1.4 |
17 | A5PmqEYs8uBxbjQGSdCqAMBGxAZbdDCWDYVCTR6K3Beu | 6.78254728 |
18 | Fjswd2XtU3vV11Ncr3PAFAB7ocfDKJgcbn3tATynMcw9 | 2260.01789919 |
19 | 5Mrap77X1U3sryXsHQsz6kT3aqg4qeEDz724gqF8dxKD | 32.572580847 |
20 | AWhgA4q5bq7xHSZ1iwbA5bQfGf86ECXmFsFnEXzkhENy | 3 |
datavortexstake and unstake
Updated 2025-02-18
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
›
⌄
/*
WITH msol_holders AS (
SELECT owner wallet,
balance
FROM (
SELECT owner,
balance,
row_number() OVER (PARTITION BY owner ORDER BY BLOCK_TIMESTAMP DESC) AS rn
FROM solana.core.fact_token_balances
WHERE mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So'
AND balance > 1e-9
) ranked
WHERE rn = 1
),
txns AS (
WITH stake_txns AS (
SELECT BLOCK_TIMESTAMP::Date date,
tx_id,
PROVIDER_ADDRESS user,
DEPOSIT_AMOUNT amount,
'Stake' type
FROM solana.marinade.ez_liquid_staking_actions
RIGHT JOIN msol_holders ON PROVIDER_ADDRESS = wallet
WHERE ACTION_TYPE IN ('depositStakeAccount', 'deposit')
),
unstake_txns AS (
SELECT BLOCK_TIMESTAMP::Date date,
tx_id,
PROVIDER_ADDRESS user,
-CLAIM_AMOUNT amount,
'Unstake' type
FROM solana.marinade.ez_liquid_staking_actions
RIGHT JOIN msol_holders ON PROVIDER_ADDRESS = wallet
WHERE ACTION_TYPE IN ('claim')
)
SELECT * FROM stake_txns
Last run: 3 months ago
...
100000
5MB
319s