nitsUntitled Query
Updated 2022-06-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
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