messariIBC transfers basics
Updated 2024-07-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with ibc_transfers as (
select
date(block_timestamp) as date,
*
from
cosmos.core.fact_transfers
where
transfer_type = 'IBC_TRANSFER_IN'
or transfer_type = 'IBC_TRANSFER_OUT'
)
SELECT
date,
transfer_type,
count(*) as transfers,
count(distinct sender) as unique_senders,
count(distinct receiver) as unique_receivers,
count(distinct tx_id) as ibc_transactions
from ibc_transfers group by 1, 2 order by date desc;
QueryRunArchived: QueryRun has been archived