select

trunc(x.block_timestamp,'day') as date,

count(distinct x.tx_hash) as transactions,

sum(transactions) over (order by date) as total_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(neat_amount) over (order by date) as total_neat_amount,

sum(transaction_fee/pow(10,24)) as fees_in_near,

sum(fees_in_near) over (order by date) as total_fees_in_near,

avg(transaction_fee/pow(10,24)) as avg_tx_fee_in_near,

min(transaction_fee/pow(10,24)) as min_tx_fee_spent,

max(transaction_fee/pow(10,24)) as max_tx_fee_spent,

median(transaction_fee/pow(10,24)) as median_tx_fee_spent,

sum(gas_used/pow(10,18)) as gas_spent,

sum(gas_spent) over (order by date) as total_gas_spent,

avg(gas_used/pow(10,12)) as avg_tx_gas_spent,

min(gas_used/pow(10,12)) as min_tx_gas_spent,

max(gas_used/pow(10,12)) as max_tx_gas_spent,

median(gas_used/pow(10,12)) as median_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'

group by 1

order by 1 asc