PLAYER_PROFILE | WALLET | CS_TIER_1 | CS_TIER_2 | CS_TIER_3 | CS_TIER_4 | CS_TIER_5 | MINING_DRILL | |
|---|---|---|---|---|---|---|---|---|
1 | FsqHiS2J9CGb8hsy8FgoRRYZRctKZcL3yFnCw1eiXr8h | xVdb1HnSFhD7xd83SsqyQci4TMBWSJ2dXQ8VCqvdMPX | 22 | 6 | 0 | 0 | 0 | 0 |
2 | AVapw3FDbhbbZnV9ifMB3sHfopLVUHeud9djrvDTnUv6 | uhZzDtWYXwqd2Pnrbk9ux1HkuamSaD2qSLX7HQgNyRB | -3 | 0 | 0 | 0 | 0 | 0 |
3 | 4qKBhohow4zQVvfW2qXEnoDtrdjztJqTB74FEctr2sBX | kQMU2Bu7be4veoX7dZkNMK6NW9ns2m6njdLeKMV2Nm1 | -5 | -1 | 0 | 0 | 0 | 0 |
4 | 9YJGuTWuh6v4xjDSsdBcRH9DMtgeD4oDj9y3G2rDZcZ2 | iwmKTwMuUaZfnkd9AskQivJm98Gbm7na4TvCh8KeT6u | -2 | 0 | 0 | 0 | 0 | 0 |
5 | 9bPshB62SXE63P5bdSc71UJzeSwG16h2XauxAhUBPiph | fPUdFBFkjKYcuSRKKGCE5SzuSXYDQj8XZXmiN8yW7H7 | -10 | 0 | -10 | 0 | 0 | -1 |
6 | 8M2ECwvDGHbQykN9wmFu9CrQ7QPyd8TdoGHdWDYuKqi3 | fAcEdh4KUcGPL4pjZSNS8pCAzrgqHsyNYhHtgEEyts6 | 0 | 0 | 0 | 0 | 0 | 0 |
7 | FMpXoGQxjRk3ckUhWt62WumGFQv5Q8eCJtXUDL6oFYYC | bEVzABHDJFxPZBiR69mucRjnzg9BUWweuGED1SARQ4t | 0 | 0 | 0 | 0 | 0 | 1 |
8 | 8nCEkbxQ3UYAXWLuFCbYpkiGWkP9pwfDYVGuaJ4NcemT | WXGTN7tGjVXcWy26wrvWmNJegk6x3wDDkr873m8NsmZ | 3 | 0 | 0 | 0 | 0 | 6 |
9 | GArgHVmZAxCVp6mbnqCfwRb7iVjjnaZF18rbCWsTS5yi | SjJJMxrzXQp2Xr1LxMdz1PQqBc5hwjM8DEkCuqusDzG | -4 | 1 | 0 | 0 | 0 | 0 |
10 | NcxaF5jCgMJUDgLxvVL16WZb2VeM7KZTCK29Be2zkyR | QQQXjXbPRXM221cGdLsXmQwBw9gzP5QA9P5ac1DzD2q | 0 | 0 | 0 | 0 | 0 | 0 |
11 | AJ2snfS7NfLDJtiBfvG9Kodi51X17rvYx4t6H4MoSTyd | PnnitvW5Vq6bjUGpFEWnskwLwpwTvH1ftJRa8qCTVSh | 0 | 0 | 1 | 0 | 0 | 0 |
12 | 7xhEJb4zZewQZJV3Uh4WH5ECuyPYL7tgUz8ryj5tw5iD | KXT1drRtqeLCNEtuCrsMD6FVAu5YKjdUZP3bBnUwJFC | -3 | 0 | 0 | 0 | 0 | -1 |
13 | DFwrispFQs1bW9FZ6CLNXa3ZQcEtJAB9aTcuZcWqrFtC | JE92b4U9b4PNjxnzKzq21tZZbTz2DJSJjJ1xwMmEtvg7 | 0 | 0 | 0 | 0 | 0 | 1 |
14 | HPcVMPtoprQYQGBQhciSa3BwMXMkJWxSczpTwuZSzz65 | JE92b4U9b4PNjxnzKzq21tZZbTz2DJSJjJ1xwMmEtvg7 | 0 | 0 | 0 | 0 | 0 | 1 |
15 | 3g1oheiNPY2u5NhwdKshqBmYi2d5ERc2tvJ7cYPnibsh | J9txxNJy5jPcjquz9U3sEfTMzTskEdjubEj2HCyJPEBd | 5 | 0 | 0 | 0 | 0 | 0 |
16 | E5vYPeE9VJzPCvKC96Bsd565uzSc2uuSnKUYhc7G7F4A | J1fSPhhQ1rQzMeDeYUVQCU9Lm6qevirt6JMbEBjL7p8L | 0 | 0 | 0 | 0 | 0 | -1 |
17 | HyxPkBY7XB1xt91fLar6KVD54CXhYGy7pqsKcETZke8w | HzAtuVCSNSnxJcwVMwRRumN7V9gmGEp5Mkbd74jt8VUs | -20 | 0 | 0 | 0 | 0 | -2 |
18 | GrLjgAzeutWuJZUxGjvDVGBrkj8QTgpHv2KseuXqZhPm | Hyq6uXwJDRVsChQEU1SsaqXh4cDHCLETtgbGSNokh1UM | -4 | -1 | 0 | 0 | 0 | 0 |
19 | GNT2pRqx8C4oZkcruYwPEvE2A62nziWzfj1k33Y1a94o | Hxxq9S9mvPHur1YCB9rppcj4A2GG2AaMJYnM2guwZjxB | 0 | 3 | 0 | 0 | 0 | 0 |
20 | 8t8PXsPaGB7no6yv6J8Eduw1j7UFXrVSaAvndCuXmogu | HvTHeZdhCHW29UFPK1y3hBmHiPsw4dv4EyammcyesazY | 0 | 0 | 1 | 0 | 0 | 6 |
AephiaCS4 preparation leaderboard
Updated 7 days ago
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 player_profiles AS (
SELECT
player_profile
,wallet
FROM SOLANA.SA.PROFILE_WALLETS
GROUP BY 1,2
)
,asset_in AS (
select
tx_to as wallet
,sum(case when mint = 'HzUBawF9xxTy4mTuvSkk1a4voJcm65tSHZz6voCDUB33' then amount end) as CS1_in
,sum(case when mint = '2piSPCxbuibsraBnnK4M5rGeHSraNe2oiD8hDw42bPKq' then amount end) as CS2_in
,sum(case when mint = 'C2uF4fECabWryVCV1bDuxP7jMspbf2gei3YAP2UBn292' then amount end) as CS3_in
,sum(case when mint = 'EBEJj1LKuo1k1J2ZvNJxsXATdGYnfaLWzqxck5p4PXSz' then amount end) as CS4_in
,sum(case when mint = '3aTW9zvPz5f7vt2Mfnr5zWA2RcgNTtDSSrBwaxyZ6t7d' then amount end) as CS5_in
,sum(case when mint = 'AuxCj2T4Mdb6h5i1pZd2yDJy5pdiEpZCPtTHAR1DqKdT' then amount end) as MD1_in
from solana.core.fact_transfers ft
inner join solana.core.fact_events fe USING (block_timestamp, tx_id)
WHERE mint IN ('HzUBawF9xxTy4mTuvSkk1a4voJcm65tSHZz6voCDUB33', '2piSPCxbuibsraBnnK4M5rGeHSraNe2oiD8hDw42bPKq', 'C2uF4fECabWryVCV1bDuxP7jMspbf2gei3YAP2UBn292', 'EBEJj1LKuo1k1J2ZvNJxsXATdGYnfaLWzqxck5p4PXSz', '3aTW9zvPz5f7vt2Mfnr5zWA2RcgNTtDSSrBwaxyZ6t7d', 'AuxCj2T4Mdb6h5i1pZd2yDJy5pdiEpZCPtTHAR1DqKdT')
AND fe.program_id != 'STAKEr4Bh8sbBMoAVmTDBRqouPzgdocVrvtjmhJhd65'
AND fe.program_id IN ('DRAWeeJdvAdJTzPRRbAPgABUuKziyH3C4pbizHemPcAq', 'traderDnaR5w6Tcoi3NFm53i48FTDNbGjBSZwWXDRrg')
AND block_timestamp > '2024-12-01'
group by 1
)
,asset_out AS (
select
tx_from as wallet
,sum(case when mint = 'HzUBawF9xxTy4mTuvSkk1a4voJcm65tSHZz6voCDUB33' then amount end) as CS1_out
Last run: 7 days ago
...
438
46KB
49s