Hessishdex ch - Weekly IBC transfer
Updated 2022-11-16Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
select date_trunc('week',block_timestamp) as date ,-1*count(tx_id) as txs
,TRANSFER_TYPE,-1*count(DISTINCT SENDER) as wallet
from osmosis.core.fact_transfers
--join osmosis.core.dim_labels
-- on ADDRESS = CURRENCY
WHERE TRANSFER_TYPE = 'IBC_TRANSFER_OUT'
and BLOCK_TIMESTAMP >= CURRENT_DATE - 60
GROUP by 1,3
union
select date_trunc('week',block_timestamp) as date ,count(tx_id) as txs
,TRANSFER_TYPE,count(DISTINCT SENDER) as wallet
from osmosis.core.fact_transfers
-- join osmosis.core.dim_labels
--on ADDRESS = CURRENCY
WHERE TRANSFER_TYPE = 'IBC_TRANSFER_IN'
and BLOCK_TIMESTAMP >= CURRENT_DATE - 60
GROUP by 1,3
Run a query to Download Data