rajsUntitled Query
    Updated 2023-01-11
    SELECT
    block_timestamp,
    tx_id,
    address,
    amount
    FROM
    (
    SELECT
    block_timestamp,
    tx_id,
    sender as address,
    -amount / pow(10,6) as amount
    from cosmos.core.fact_transfers
    where currency = 'uatom'

    union ALL

    SELECT
    block_timestamp,
    tx_id,
    receiver as address,
    amount / pow(10,6) as amount
    from cosmos.core.fact_transfers
    where currency = 'uatom'
    )
    where address = 'cosmos1my7d7egfkz5k00q97fmwdmvcmac02axmezapdc'
    -- group by 1
    order by 1
    Run a query to Download Data