Crafting fee month USE

ludicrousCrafting fee month USE

Updated 8 days ago

SELECT

CASE when signers[0] = 'FEEPAYye6DtaJhSXFR65ENXMroiseL1jqYT4QxHKRoZr'

then signers[1] else signers[0] end AS WALLET

,ROUND(zeroifnull(sum(CASE when value:parsed:info:destination = '5XJei3jBZi8WuqDGUQ5KCe8t72vMRMTWLr6ok3hhXE2R'

AND value:parsed:type = 'transfer'

then value:parsed:info:amount / POW(10,8)

end)),2) AS ATLAS

FROM solana.core.fact_events, lateral flatten(input => inner_instruction:instructions)

WHERE program_id IN ('SAGE2HAwep459SNq61LHvjxPk4pLPEJLoMETef7f7EE')

AND block_timestamp > '2025-04-01' AND block_timestamp < '2025-05-01'

AND wallet != 'FEEPAYye6DtaJhSXFR65ENXMroiseL1jqYT4QxHKRoZr'

GROUP BY 1

ORDER BY 2 DESC

Last run: 8 days ago

	WALLET	ATLAS
1	8fvJhm5p7QQFLRofFHeT1bjNDa8FppZZwLkb6MR257Cp	839221.64
2	6LVuNtS4BHc5bdXr6V5v1fFUyRnWwYPF4bDABoh3evrt	676055.05
3	HajLgwYKTvxuJVg8GhWhx1GkeqQ4P3wWk9SHbZJPvJnh	625720.46
4	7szk9kq77N8qj6M1wVgTWLHz1ijZ6ar2tDF8w4mXUM48	599437.72
5	6bQFKL5AAY6xYPSbajfxa9c88jqPBfh7w4MwisFrdrp1	419338.71
6	H7C39WVE2teJgDwj8xsCW2XZGFnreRdp7njY3SzDkr7G	378639.23
7	DoM5yS39H8Vam3FnWMgAJGRfxByqXv5rB9PmGSC5iVfr	314691.67
8	7edjdvKdivY18HpYkSic2mMcvwqeGw2ni19GYXhyi3nn	308395.36
9	CzCVAd1TjCLqzLQ5tmkQobVhZdByVib9K99rfUrbBjG5	307089.88
10	Cfoe8NiqC5nhmagU14DjasWeAT1NXDkdfbWhTXHriEUw	242043.86
11	FK2nVHmxSNGY6DSoohurCPABeyK5teH6pnfysnYdh1dQ	239692.39
12	AUqGyEG8LN9DX8ksoHMJKpeMiFRYFgCcQVZveDWEDeeb	202420.63
13	G29mGtMUX2WqJ5zqjfUHBxqFZDWWG4bW9SM86tKrgGCw	199767.19
14	ESrRf8M6G5gV5xAEHmEeUPBffzXXxU4fb9Hq5iY4ZNC9	182685.26
15	HFb6x3wLLp9CrJP9eGgvi9TBnJkqkKGoDeGP61b1EHUD	180708.33
16	AM6vdxe2PDjNWBWyGFd3p3h2yXxb5UnHvQiyahcijcyC	164708.23
17	GzRDwuZNavZjqjKaVKsbBkGLQHXKPSX3e9cnD92uxra7	154130.84
18	AQJcamK1QJ4NqbYAZxgSaCoavcX5LDkeCrHgS6eMyaCv	151854.54
19	VVpW4aBC7o83H6WvhquFk2aHkRjQFBEKJA5phMZGHb9	138725.48
20	44o4uy5s9iQ9RMqaUfUpY9AVEiFiqW689VuQF8yPxbqt	137183.34

...

1819

96KB

flipside