mattkstewAxelar & Osmosis: Liquidity on Liquidity
Updated 2022-11-12Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
select
date_trunc('day', block_timestamp) as day,
CASE WHEN attribute_value LIKE '%uusdc%' THEN 'USDC'
WHEN attribute_value LIKE '%weth-wei%' THEN 'ETH'
WHEN attribute_value LIKE '%wbtc-satoshi%' THEN 'WBTC'
WHEN attribute_value LIKE 'ibc/0CD3A0285E1341859B5E86B6AB7682F023D03E97607CCC1DC95706411D866DF7' THEN 'DAI' END as token,
count(*) as trasfer
from axelar.core.fact_msg_attributes
LEFT outer JOIN (
SELECT
tx_id as tx,
attribute_value as to_chain
FROM axelar.core.fact_msg_attributes
WHERE attribute_key LIKE 'destinationChain'
)
ON tx = tx_id
WHERE msg_type LIKE 'coin_spent'
AND attribute_index = 1
AND to_chain like 'osmosis'
GROUP BY 1,2
having not token is NULL
Run a query to Download Data