HosseinUntitled Query
Updated 2022-12-29
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select
distinct method_name
from near.core.fact_actions_events_function_call call
join near.core.fact_transactions tr
using(tx_hash)
join near.core.fact_receipts as rc
using(tx_hash)
where ACTION_NAME = 'FunctionCall'
and split(split(rc.status_value,':')[0],'{')[1] ilike '%Success%'
and tr.block_timestamp >= '2022-01-01'
Run a query to Download Data