winnie-fsUnique User Count copy
Updated 2023-03-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
⌄
-- forked from 1eca1b10-1bfd-4e0c-8326-216fff23cdd2
-- forked from d574eff1-8eba-4c05-ac90-9278d21b65b1
/*with Delphi_address as (
select * from osmosis.core.fact_transactions
where tx_from = 'osmo1cd4nn8yzdrrsfqsmmvaafq8r03xn38qgqt8fzh'
),
mars_contracts as (
select
distinct attribute_value,
case when attribute_value = 'osmo1mhznfr60vjdp2gejhyv2gax9nvyyzhd3z0qcwseyetkfustjauzqycsy2g' then 'Oracle'
when attribute_value = 'osmo1c3ljch9dfw5kf52nfwpxd2zmj2ese7agnx0p9tenkrryasrle5sqf3ftpg' then 'Red Bank'
when attribute_value = 'osmo1g677w7mfvn78eeudzwylxzlyz69fsgumqrscj6tekhdvs8fye3asufmvxr' then 'Address Provider'
when attribute_value = 'osmo1urvqe5mw00ws25yqdd4c4hlh8kdyf567mpcml7cdve9w08z0ydcqvsrgdy' then 'Rewards Collector'
when attribute_value = 'osmo1nkahswfr8shg8rlxqwup0vgahp0dk4x8w6tkv3rra8rratnut36sk22vrm' then 'Incentives'
when attribute_value = 'osmo1v0ezrc0f7l5tlw6ws2r8kalhmvrfhe0fywrmj8kjgrwvud5r83uqywn66c' then 'Liquidation Filter'
when attribute_value = 'osmo14w4x949nwcrqgfe53pxs3k7x53p0gvlrq34l5n' then 'Admin' end as Contract_Name
from osmosis.core.fact_msg_attributes a
join delphi_address b
on a.tx_id = b.tx_id
where a.tx_succeeded = 'true' and attribute_key = '_contract_address'
)*/
with txs as (
select
distinct a.tx_id,
action
from (
select
tx_id,
attribute_value as action
from osmosis.core.fact_msg_attributes
where attribute_key = 'action' and
Run a query to Download Data