adriaparcerisasnear inscriptions
Updated 2023-12-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
select
count(distinct x.tx_hash) as transactions,
count(distinct x.signer_id) as active_wallets,
sum(TRY_CAST(REGEXP_REPLACE(args:amt, '[^0-9]', '') AS NUMBER))/100000000 as neat_amount,
sum(transaction_fee/pow(10,24)) as fees_in_near,
avg(transaction_fee/pow(10,24)) as avg_tx_fee_in_near,
sum(gas_used/pow(10,18)) as gas_spent,
avg(gas_used/pow(10,18)) as avg_tx_gas_spent
from near.core.fact_actions_events_function_call x
join near.core.fact_transactions y on x.tx_hash=y.tx_hash
where method_name='inscribe'
and action_name='FunctionCall'
and args:op='mint' and args:p='nrc-20' and args:tick='neat'
--limit 100
Run a query to Download Data