nitsNumber of bonds made for yLUNA over time
Updated 2022-04-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT date(block_timestamp) as day,
sum(msg_value:execute_msg:send:amount)/pow(10,6) as amt,
count(DISTINCT msg_value:sender) as unique_senders,
sum(unique_senders) over (order by day) as cumulative_senders
from terra.msgs
WHERE
-- tx_id ilike 'BF69A84BEAD4C6C42AB510E7EE6AD3C0A04DBCD6FDF79BCD0481BE935800CC5C' and
msg_value:contract = 'terra17wkadg0tah554r35x6wvff0y5s7ve8npcjfuhz'
and msg_value:execute_msg:send:contract = 'terra1ns5nsvtdxu53dwdthy3yxs6x3w2hf3fclhzllc'
-- where msg_value:contract = 'terra1p7jp8vlt57cf8qwazjg58qngwvarmszsamzaru'
-- and amt is NULL and contains(msg_value, 'bond')
GROUP by 1
limit 100