KaskoazulNumber of tx
Updated 2022-03-15
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
›
⌄
--Create a dashboard to track the outflows of LUNA and UST to Osmosis, Secret, Axelar, and Injective. What conclusions can you draw from the outflows thus far?
select
block_timestamp::date as fecha,
case
when event_attributes:receiver like 'osmo%' then 'osmosis'
when event_attributes:receiver like 'axelar%' then 'axelar'
when event_attributes:receiver like 'secret%' then 'secret'
when event_attributes:receiver like 'inj%' then 'injection'
when event_attributes:receiver like 'juno%' then 'juno'
--when event_attributes:receiver like 'kava%' then 'kava'
--when event_attributes:receiver like 'crc%' then 'crc'
--when event_attributes:receiver like 'cosmos%' then 'cosmos'
--when event_attributes:receiver like 'terra%' then 'terra'
else 'other'
end as network,
count (tx_id) as transactions
from terra.msg_events
where event_type = 'ibc_transfer'
and fecha >= '2022-01-01'
group by fecha, network
order by transactions desc
Run a query to Download Data