KaskoazulLUNA whales on crc
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
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
--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 me.block_timestamp::date as fecha,
te.amount,
te.currency,
te.amount_usd,
me.event_attributes:receiver,
te.recipient,
me.tx_id
from terra.msg_events me
inner join terra.transfer_events te
on me.tx_id = te.tx_id
where fecha = '2022-02-25'
and event_type = 'ibc_transfer'
--and event_attributes:receiver not like 'osmo%'
--and event_attributes:receiver not like 'axelar%'
--and event_attributes:receiver not like 'secret%'
--and event_attributes:receiver not like 'inj%'
--and event_attributes:receiver not like 'juno%'
--and event_attributes:receiver not like 'kava%'
--and event_attributes:receiver not like 'cosmos%'
and event_attributes:receiver like 'crc%'
--and event_attributes:recevier not like 'terra%'
--group by fecha, 3
--and msg_type = 'applications/transfer.v1.MsgTransfer'
-- and tx_id = '7EFCA831C6567EEB7C4FE8D073C32E3BD56367574D1DBBBEC98E838037BFC7A9'
--or tx_id = '5B9F30C78698FEDBB0FD1B75D265EB930D120C06D2D18CA95322E41AEDDAD1A2'
and te.currency like 'LUNA'
and te.amount > 49000
-- and event_from_address_name IN ('osmosis bridge', 'secret bridge', 'axelar bridge', 'injective bridge')--, 'ethereum bridge', 'binance bridge')
--and event_to = 'terra1kq2rzz6fq2q7fsu75a9g7cpzjeanmk68wplle5'
--GROUP by fecha, bridge, currency
--ORDER BY total_outflow
Run a query to Download Data