SocioCryptoTotal Swap
    Updated 2023-10-11
    with t_txs as(
    SELECT
    DISTINCT tx_id ,
    block_timestamp
    FROM sei.core.fact_msg_attributes
    WHERE ATTRIBUTE_KEY = '_contract_address'
    AND ATTRIBUTE_VALUE = 'sei1d9fgdm2vgcknz5prdumkg5apml0vv3lfulkfd0gn07uesysek74sn34hjw'
    )
    ,
    swap as (
    SELECT
    DISTINCT tx_id
    FROM sei.core.fact_msg_attributes
    WHERE tx_id IN (SELECT tx_id FROM t_txs)
    EXCEPT
    SELECT
    DISTINCT tx_id
    FROM sei.core.fact_msg_attributes
    WHERE tx_id IN (SELECT tx_id FROM t_txs)
    AND (ATTRIBUTE_VALUE = 'mint' OR ATTRIBUTE_VALUE = 'burn_from')
    )
    ,
    token_in as (
    SELECT
    tx_id,
    ATTRIBUTE_VALUE as token_in
    FROM sei.core.fact_msg_attributes
    WHERE tx_id IN (SELECT tx_id FROM swap)
    AND ATTRIBUTE_KEY = 'amount' AND msg_type = 'coin_received' AND msg_index = 7
    ),
    token_out as (
    SELECT
    tx_id,
    ATTRIBUTE_VALUE as token_out
    FROM sei.core.fact_msg_attributes
    WHERE tx_id IN (SELECT tx_id FROM swap)
    Run a query to Download Data