narrow-cyan

mmdrezanarrow-cyan

Updated 4 days ago

with tab as (

select

block_timestamp,

signers[0] as minter,

tx_id as mint

from eclipse.core.fact_events_inner

where

instruction_program_id in ('5hEa5j38yNJRM9vQA44Q6gXVj4Db8y3mWxkDtQeofKKs','RariUNM3vz1rwxPg8UJyRAN7rSKXxgd2ncS2ddCa4ZE')

and SUCCEEDED = 'TRUE'

and EVENT_TYPE = 'mintTo')

select

distinct minter as minters,

count (distinct mint) as mints

from tab

group by 1

order by 2 desc

Last run: 1 day ago

	MINTERS	MINTS
1	3uiYpWUZhxNi6FNFtKh58FWLPBT1sMivRzcENu876xMV	2933
2	ATndReUE5ExpJBWdBk3rmx8pm2t6nj5WX5fLMYGEitoo	2507
3	7zdKHey3pA8TGoMastY8D9YWWSFmfW2mwkHCgVd7ykBb	289
4	GvorXn7mZwkttPN1Kju2E8SvKAsEZjaKw2duNqzWaYXs	251
5	DzuFm2kodaZ4CM3fYK6ZgafmxuwLiL8D16n3jmkmApjH	230
6	Edyq4kJEhPEE3MXU5vJ1XTBim1uvDrGFeMLpEaLaxdmR	197
7	CPwoBaMMuijYBE6TFKhB3ebKTQGAG3EAS8jadxa5zudD	162
8	3wJQ4cgEcaHv65ouThHXz7uads8MauBYojvDurbKEWkp	149
9	49BTVmjM24sLTNK5ouRnQY96cSkU7j7BSzQAxsftZuq2	130
10	8gBHz4g7zQ1V63CsFJHpwtEvtiijsBvEpjNZgT7oJfVf	119
11	127zLBXrKAs7VXHewSqQkymLCG6vjoUbLc3ngLpV5Qai	115
12	BnXVo1CQRR37YK3T3SXgSnNAfq6UpwZTtseN5eeV7Pji	114
13	Bx6ZqPbTreF5LdZd2YYNqJvwuYfvuSFjjc2t2ipjwkLc	105
14	Axzgt6nHxBG6XfoCL4yJgFvYNzvZAcsRhBWzpwhu33e1	102
15	7AvHvEgxQeJ73iovwVNCWYxUFGstVyP6uQokAaMrcCtu	102
16	5G6CR8f69WuLLQWyUaYhMeJMD8KRgVdbK2HDnksg6sob	100
17	CbCuazi7B2UamWto1bWu1PQY2TAjDVPwHaaKTwZBJUv1	98
18	BH3znc2Az9MbbRprRz2csowb2skBrbHGLdaCeREWTBL3	95
19	uw3mxpPUkmL7K7upVkNU5eWKwMyT9rnFo9nPZ5Wzrfn	93
20	EJG2fessB9a4mrMx1ViiegfVHvAwdwgRYg7jjsByfYB5	92

...

100000

5MB

10s

flipside