0-MIDDaily mints
Updated 2025-02-13
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select BLOCK_TIMESTAMP::date as day
,count(distinct tx_hash) as mints
,count(distinct ORIGIN_from_ADDRESS) as minters
,sum(mints)over(order by day) as total_mints
from ronin.nft.ez_nft_transfers
where ORIGIN_TO_ADDRESS='0x19f70ecd63f40f11716c3ce2b50a6d07491c12fe'
and ORIGIN_FUNCTION_SIGNATURE='0xd85d3d27'
and NAME='Lumiterra Game Item'
and BLOCK_TIMESTAMP::date>='2024-11-11'
group by 1
QueryRunArchived: QueryRun has been archived