VOLUME | MINTS | MINTERS | MINT_FEE | |
|---|---|---|---|---|
1 | 143450 | 2344 | 2133 | 5355.017937921 |
0-MIDmint stats
Updated 2025-02-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with tab1 as (
select TX_HASH
from ronin.nft.ez_nft_transfers
where origin_TO_ADDRESS='0xa8e9fdf57bbd991c3f494273198606632769db99'
and ORIGIN_FUNCTION_SIGNATURE='0xfb4d364c'
and FROM_ADDRESS='0x0000000000000000000000000000000000000000'
and name='Fableborne Kingdoms'
)
select --date_trunc('hour',BLOCK_TIMESTAMP) as hour
sum(VALUE)as volume
,count(distinct TX_HASH) as mints
,count(distinct FROM_ADDRESS) as minters
,sum(GAS_PRICE/1e9*CUMULATIVE_GAS_USED) as mint_fee
from ronin.core.fact_transactions
where TX_HASH in (select TX_HASH from tab1)
--group by 1
Last run: 27 days ago
1
35B
13s