adambalaMirror Bounty
Updated 2021-11-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with mp as (
select msg_value:sender sender, ts.tx_ID, fee[0]:amount[0]:amount::DECIMAL amount from terra.transactions ts
JOIN
terra.msgs ms
on ts.tx_ID=ms.tx_ID
where
msg_value:contract = 'terra1kalp2knjm4cs3f59ukr4hdhuuncp648eqrgshw'
AND ms.block_timestamp::date > current_date-30
AND ms.tx_status = 'SUCCEEDED'
)
select sender,
(avg(amount)/1000000) as fee_amount
from mp group by sender
Run a query to Download Data