Sandeshnear avg_fee
Updated 2022-08-11
9
1
2
3
4
5
6
7
8
›
⌄
select fc.method_name,avg(t.gas_used) as avg_gas
from near.core.fact_transactions t inner join near.core.fact_actions_events_function_call fc
on t.tx_hash=fc.tx_hash
where t.tx_receiver = 'v2.ref-finance.near'
group by fc.method_name
having count(distinct t.tx_hash) >1000
order by avg_gas desc
limit 10
Run a query to Download Data