Afonso_Diazneth-
Updated 2023-03-03
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
29
30
31
32
33
›
⌄
with
t as (
select
distinct tx_signer
from near.core.fact_transactions
where tx_receiver = 'nethmap.near'
and tx_status = 'Success'
and block_timestamp >= '2022-12-19'
),
t2 as (
select
count(distinct tx_hash) as inflow_transfers,
sum(deposit / 1e24) as total_inflow_volume_near,
avg(deposit / 1e24) as average_inflow_volume_near,
median(deposit / 1e24) as median_inflow_volume_near
from near.core.fact_transfers
where tx_signer in (select tx_signer from t)
and status = 1
),
t3 as (
select
count(distinct tx_hash) as outflow_transfers,
sum(deposit / 1e24) as total_outflow_volume_near,
avg(deposit / 1e24) as average_outflow_volume_near,
median(deposit / 1e24) as median_outflow_volume_near
from near.core.fact_transfers
where tx_receiver in (select tx_signer from t)
and status = 1
)
select * from t2 join t3
Run a query to Download Data