WALLET | CS_TIER_1 | CS_TIER_2 | CS_TIER_3 | CS_TIER_4 | CS_TIER_5 | MINING_DRILL | |
|---|---|---|---|---|---|---|---|
1 | HwbqQcZW72W3sJvvSbnxNLTJWNG8nfTYriu5XarMwzzn | 105 | 0 | 0 | 0 | 0 | 0 |
2 | 4HEqiDGTDg6qUwxtWwA7rVc1FtNGX3tpTdrjG3mPtsEL | 49 | 0 | 0 | 0 | 0 | 0 |
3 | AmhSjA1mSDicWjoU727oDrGJ3qajjWtXLUsMVWF2yZLt | 49 | 0 | 0 | 0 | 0 | 0 |
4 | CWvcXf9TxBCuSpVePP7ZgmETbGhB3VSkiyFgKJMj84y1 | 33 | 6 | 12 | 0 | 0 | 0 |
5 | 5taEG63uiTrmjooPje7edLW7eqdhktnK2KUADo9ezYCv | 30 | 0 | 0 | 0 | 0 | 0 |
6 | G7h187CdNysDwnSSPikd1ZXZArty93EkgWo2Xan8Y88t | 23 | 0 | 0 | 0 | 0 | 0 |
7 | 3YCSCTuCod2RovRNutsismLC6GY9978pgxeJqJMaEhLU | 23 | 1 | 2 | 0 | 0 | 0 |
8 | 2m59GZVMQM7kpHNG2hEK9Ens4ZQRLwj5mgqCa7X57MAp | 23 | 0 | 0 | 0 | 0 | 0 |
9 | xVdb1HnSFhD7xd83SsqyQci4TMBWSJ2dXQ8VCqvdMPX | 22 | 6 | 0 | 0 | 0 | 0 |
10 | EwP8nXcGWuseRYXFajRkAvQUFQZhymxijUB3XBir3R4k | 20 | 0 | 0 | 0 | 0 | 0 |
11 | 8x4JL2E123W7i8Na11oUoUFESA2hJGRgEDauqMHoDcSj | 20 | 0 | 0 | 0 | 0 | 0 |
12 | 9C2khHQRDkedsM3SDW3JJfNNDmbTkX9cLMALt9ncnwcU | 16 | 0 | 0 | 0 | 0 | 0 |
13 | 7qyq4b88UEjKhpaL76SiL4STwXNQNUCzJ22y19iMSftZ | 14 | 1 | 0 | 0 | 0 | 0 |
14 | 46LVS5qoDPJaTWAYm61VBC2c59RTQ9K5aSjy7wK3ZfBa | 14 | 0 | 0 | 0 | 0 | 0 |
15 | KXT1drRtqeLCNEtuCrsMD6FVAu5YKjdUZP3bBnUwJFC | 13 | 0 | 0 | 0 | 0 | 4 |
16 | 7JEpUDszGNRxf5h1UWsaXGFrrCUo3fhujAZeuLAjVRrc | 13 | 0 | 0 | 0 | 0 | -1 |
17 | 2Sntku1bv49jgBRZjchyEKWMsX9maNCbzVmWUMjan8UZ | 12 | 0 | 0 | 0 | 0 | 0 |
18 | A1FNSkHMdTbe9duVdS2UYsgH5kSVizusrnXFVoT1a6jP | 12 | 0 | 0 | 0 | 0 | 0 |
19 | 5ys3sK5DPQvYFjgss9uepnfSNe4Kxm4AtnXTPQ97mnHr | 11 | 0 | 0 | 0 | 0 | 0 |
20 | GY3n4cUzVLe6P9VjrNZHWXZUKixxbTADeA1WyLRk16Qw | 11 | 0 | 0 | 0 | 0 | 0 |
AephiaCS4 preparation leaderboard
Updated 2025-02-23
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 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
,sum(case when mint = '2piSPCxbuibsraBnnK4M5rGeHSraNe2oiD8hDw42bPKq' then amount end) as CS2_out
,sum(case when mint = 'C2uF4fECabWryVCV1bDuxP7jMspbf2gei3YAP2UBn292' then amount end) as CS3_out
,sum(case when mint = 'EBEJj1LKuo1k1J2ZvNJxsXATdGYnfaLWzqxck5p4PXSz' then amount end) as CS4_out
,sum(case when mint = '3aTW9zvPz5f7vt2Mfnr5zWA2RcgNTtDSSrBwaxyZ6t7d' then amount end) as CS5_out
,sum(case when mint = 'AuxCj2T4Mdb6h5i1pZd2yDJy5pdiEpZCPtTHAR1DqKdT' then amount end) as MD1_out
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')
Last run: about 1 month ago
...
742
45KB
24s