chill9m
Updated 2023-01-25
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select sum(amount/pow(10,18)) , count(*) , case
when receiver like 'axelar%' then 'axelar'
when receiver like 'kujira%' then 'kujira'
when receiver like 'cosmos%' then 'cosmos'
when receiver like 'gravity%' then 'gravity'
when receiver like 'osmo%' then 'osmo'
else receiver end protocol , date_trunc('day', block_timestamp::date)
from osmosis.core.fact_transfers
where currency='ibc/AB589511ED0DD5FA56171A39978AFBF1371DB986EC1C3526CE138A16377E39BB' and receiver!='comdex1hpuzvp3sguqrwnf2094x57p2a9hrz95rs5nl8s'
group by 3,4
Run a query to Download Data