nitsUntitled Query
    Updated 2022-06-06
    with addr as
    (SELECT address, case when label ilike '%Bitcoin%' then 'BTC' else 'ETH' end as token_name
    from osmosis.core.dim_labels
    where label ilike '%Wrapped%'),
    osmo as
    (SELECT tx_id as tx, token_name, address from osmosis.core.fact_msg_attributes
    inner join addr
    on address = attribute_value )

    SELECT *,replace(attribute_value, address, '' )/pow(10,18) as amt
    from osmosis.core.fact_msg_attributes
    inner join osmo on tx_id = tx
    where msg_type = 'coin_received' and attribute_key = 'amount' and contains(attribute_value, address)
    limit 100


    -- 867E3A0B67AD2339C88AA8CFFE8B363956894A7AA0ECDEB258AAC7AC069DCAC9 589BF7E90123664C3633864408E59670C5673FA1B7457B386FD0A0675785514B
    Run a query to Download Data