0xaimanPower User 2
Updated 2021-12-18
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
›
⌄
select measure, count(sender) as n_user
from (select month, sender, n_txn, case when n_txn<10 then 'Address with Less than 10 collateral txn per month'
else 'Address with more than 10 collateral txn per month' end as measure,
bLuna_col
from (with a as (select block_timestamp,tx_id, msg_value:sender, msg_value:contract, x.value
from terra.msgs, table(flatten(input=>msg_value:execute_msg:lock_collateral:collaterals[0]))X
where --tx_id='26545D2261CFE0DE4D864766D4F4286233750F12ABDFEF834CAE6880367967A9' and
x.index='0' and x.value='terra1kc87mu460fwkqte29rquh4hc20m54fxwtsx7gp'),
b as (
select block_timestamp as t,tx_id, msg_value:sender as sender , msg_value:contract as contr, x.value/1000000 as amount
from terra.msgs, table(flatten(input=>msg_value:execute_msg:lock_collateral:collaterals[0]))X
where --tx_id='26545D2261CFE0DE4D864766D4F4286233750F12ABDFEF834CAE6880367967A9' and
x.index='1'
)
select date_trunc('month',t) as month, sender,count(b.tx_id) as n_txn, sum(amount) as bLuna_col
from a
inner join b on a.tx_id=b.tx_id
group by 1,2 order by 1))
group by 1
Run a query to Download Data