Afonso_Diaz2023-02-04 04:45 AM
Updated 2023-02-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with
t2 as (
select block_timestamp as day,
try_parse_json(args) as args,
args:proposal:kind:Transfer:receiver_id as receiver_id,
args:proposal:kind:Transfer:amount/1e24 as amount
from near.core.fact_actions_events_function_call
join near.core.fact_transactions
using(tx_hash)
where method_name = 'add_proposal'
and tx_receiver = 'marketing.sputnik-dao.near'
)
select
count(distinct receiver_id) as receivers_count,
sum(amount) as transfer_volume,
avg(amount) as average_transfer_volume,
median(amount) as median_transfer_volume,
count(*) as proposals_count
from t2
having transfer_volume > 0
Run a query to Download Data