mattkstewAxelar & Osmosis: Liquidity on Liquidity
    Updated 2022-11-12
    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