narrow-cyan

mmdrezanarrow-cyan

Updated 1 day 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	7zdKHey3pA8TGoMastY8D9YWWSFmfW2mwkHCgVd7ykBb	289
3	GvorXn7mZwkttPN1Kju2E8SvKAsEZjaKw2duNqzWaYXs	251
4	DzuFm2kodaZ4CM3fYK6ZgafmxuwLiL8D16n3jmkmApjH	230
5	Edyq4kJEhPEE3MXU5vJ1XTBim1uvDrGFeMLpEaLaxdmR	197
6	CPwoBaMMuijYBE6TFKhB3ebKTQGAG3EAS8jadxa5zudD	162
7	3wJQ4cgEcaHv65ouThHXz7uads8MauBYojvDurbKEWkp	149
8	49BTVmjM24sLTNK5ouRnQY96cSkU7j7BSzQAxsftZuq2	120
9	8gBHz4g7zQ1V63CsFJHpwtEvtiijsBvEpjNZgT7oJfVf	119
10	127zLBXrKAs7VXHewSqQkymLCG6vjoUbLc3ngLpV5Qai	115
11	BnXVo1CQRR37YK3T3SXgSnNAfq6UpwZTtseN5eeV7Pji	113
12	Bx6ZqPbTreF5LdZd2YYNqJvwuYfvuSFjjc2t2ipjwkLc	105
13	Axzgt6nHxBG6XfoCL4yJgFvYNzvZAcsRhBWzpwhu33e1	102
14	5G6CR8f69WuLLQWyUaYhMeJMD8KRgVdbK2HDnksg6sob	100
15	7AvHvEgxQeJ73iovwVNCWYxUFGstVyP6uQokAaMrcCtu	95
16	CbCuazi7B2UamWto1bWu1PQY2TAjDVPwHaaKTwZBJUv1	93
17	FZRbJz7Hu2hq8GwMYK56tbbCtvCmkFzXa4QgWEMo5gmy	92
18	DaMpdSt1WiZJrheTHBKTS949JuBURyfaevFzMsjNpTxE	90
19	BH3znc2Az9MbbRprRz2csowb2skBrbHGLdaCeREWTBL3	90
20	BCvCMdjm7oZJ1fu89WDzJXH49im5g7jAURTGfPejRip2	89

...

100000

5MB

10s

flipside