KaskoazulParas TVL
Updated 2022-08-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with raw as (
select ft.block_timestamp,
ft.tx_signer,
ft.tx_hash,
ft.transaction_fee / pow (10,24) as fee_near,
ftf.deposit / pow (10,24) as deposit_transfer,
e.deposit / pow (10,24) as deposit_event,
e.method_name
from near.core.fact_transactions ft
left join near.core.fact_transfers ftf
on ft.tx_hash = ftf.tx_hash
left join near.core.fact_actions_events_function_call e
on ft.tx_hash = e.tx_hash
where ft.tx_receiver = 'marketplace.paras.near'
)
select method_name,
sum (deposit_event),
count (distinct tx_hash)
from raw
group by 1
order by 2 desc
Run a query to Download Data