binhachonMoonbirds Gas Fees - Compare with Shinsei Galverse Official
Updated 2022-04-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
›
⌄
with mint_transactions as (
select
block_timestamp,
tx_fee as mint_fee,
'Moonbird' as NFT,
floor(mint_fee, 3) as rounded_mint_cost
from ethereum_core.fact_transactions
where block_timestamp > '2022-04-10'
and to_address = '0x23581767a106ae21c074b2276d25e5c3e136a68b'
and origin_function_signature = '0x0dfd025a'
and status = 'SUCCESS'
union all
select
block_timestamp,
tx_fee as mint_fee,
'Shinsei Galverse' as NFT,
floor(mint_fee, 3) as rounded_mint_cost
from ethereum_core.fact_transactions
where block_timestamp > '2022-04-10'
and to_address = '0x582048c4077a34e7c3799962f1f8c5342a3f4b12'
and origin_function_signature = '0x1b59169d'
and status = 'SUCCESS'
)
select
NFT,
rounded_mint_cost::string --Just to make the chart easier to read
as rounded_mint_cost,
count(*) as number_of_transactions,
100 * ratio_to_report(number_of_transactions) over (partition by NFT) as percentage
from mint_transactions
group by 1, 2
Run a query to Download Data