zanglangGlobal IBC Packets by Day (Osmosis)
Updated 2024-02-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
-- forked from Global IBC Packets by Hour (Osmosis) @ https://flipsidecrypto.xyz/edit/queries/9c52f5df-739c-4449-a7f1-d6ac83af6887
-- forked from Global IBC Packets by Day @ https://flipsidecrypto.xyz/edit/queries/6bafaf52-8974-4cba-a9b4-1687616a1867
with ibc_msgs as (
select
tx_id,
block_timestamp,
split_part(attribute_value, '.', 5) as pkt_type
from osmosis.core.fact_msg_attributes
where tx_succeeded = 1
and block_timestamp >= CURRENT_DATE - interval '{{ day }} day'
and attribute_key = 'action'
and attribute_value like '/ibc.%'
)
select
date_trunc('month', block_timestamp) as date,
count(distinct tx_id) as txs
from ibc_msgs
group by 1
order by 1
QueryRunArchived: QueryRun has been archived