rajsUntitled Query
Updated 2023-02-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
SELECT
-- *
attribute_value,
count(*)
from osmosis.core.fact_msg_attributes
where tx_id IN
(
SELECT
tx_id
from osmosis.core.fact_msg_attributes
where msg_type = 'wasm'
and attribute_key = '_contract_address'
and attribute_value = 'osmo1c3ljch9dfw5kf52nfwpxd2zmj2ese7agnx0p9tenkrryasrle5sqf3ftpg'
-- and tx_id = 'D0E99C532104C9AC44449EC65C856E4C3BA0DCF1889B7C410A77EE6C3B4A0EA9'
-- and tx_id = '28AF8790828014C0BBD37D92AF581E6C6F4BCF4BDBC3ADF2EC2A6F310CDA9F3E'
order by block_timestamp
)
and attribute_key = 'action'
group by 1
order by 2 desc
Run a query to Download Data