KaskoazulRef_finance raw
Updated 2022-08-07
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
›
⌄
--select distinct action_name
--from near.core.fact_actions_events
with raw_to as (
select t.block_timestamp,
t.tx_signer,
t.transaction_fee / pow(10,24) as fee,
e.action_name, --if function_call table, all are FunctionCall
e.method_name,
e.deposit / pow(10,24) as deposit,
e.args,
from near.core.fact_transactions t
left join near.core.fact_actions_events_function_call e
on t.tx_hash = e.tx_hash
where t.tx_receiver = 'v2.ref-finance.near'
),
raw_from as (
select t.*,
e.*
from near.core.fact_transactions t
left join near.core.fact_actions_events_function_call e
on t.tx_hash = e.tx_hash
where t.tx_signer = 'v2.ref-finance.near'
)
select * from raw_to limit 100
Run a query to Download Data