mints | mmdreza | Flipside

Updated 2 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	7zdKHey3pA8TGoMastY8D9YWWSFmfW2mwkHCgVd7ykBb	289
3	GvorXn7mZwkttPN1Kju2E8SvKAsEZjaKw2duNqzWaYXs	251
4	ATndReUE5ExpJBWdBk3rmx8pm2t6nj5WX5fLMYGEitoo	233
5	DzuFm2kodaZ4CM3fYK6ZgafmxuwLiL8D16n3jmkmApjH	230
6	Edyq4kJEhPEE3MXU5vJ1XTBim1uvDrGFeMLpEaLaxdmR	197
7	CPwoBaMMuijYBE6TFKhB3ebKTQGAG3EAS8jadxa5zudD	162
8	3wJQ4cgEcaHv65ouThHXz7uads8MauBYojvDurbKEWkp	149
9	49BTVmjM24sLTNK5ouRnQY96cSkU7j7BSzQAxsftZuq2	127
10	8gBHz4g7zQ1V63CsFJHpwtEvtiijsBvEpjNZgT7oJfVf	119
11	127zLBXrKAs7VXHewSqQkymLCG6vjoUbLc3ngLpV5Qai	115
12	BnXVo1CQRR37YK3T3SXgSnNAfq6UpwZTtseN5eeV7Pji	113
13	Bx6ZqPbTreF5LdZd2YYNqJvwuYfvuSFjjc2t2ipjwkLc	105
14	7AvHvEgxQeJ73iovwVNCWYxUFGstVyP6uQokAaMrcCtu	102
15	Axzgt6nHxBG6XfoCL4yJgFvYNzvZAcsRhBWzpwhu33e1	102
16	5G6CR8f69WuLLQWyUaYhMeJMD8KRgVdbK2HDnksg6sob	100
17	CbCuazi7B2UamWto1bWu1PQY2TAjDVPwHaaKTwZBJUv1	98
18	BH3znc2Az9MbbRprRz2csowb2skBrbHGLdaCeREWTBL3	94
19	EJG2fessB9a4mrMx1ViiegfVHvAwdwgRYg7jjsByfYB5	92
20	FZRbJz7Hu2hq8GwMYK56tbbCtvCmkFzXa4QgWEMo5gmy	92

...

100000

5MB

flipside