peteer1opevmos20
Updated 2023-11-09
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select 'EVMOS --> OSMOSIS' , count(*) as transfer_count , count(distinct sender) as transfer_sender
, count(distinct receiver) as transfer_receiver , sum(amount/pow(10,decimal)) as transfer_amount , avg(amount/pow(10,decimal)) as avg_amount
, median(amount/pow(10,decimal)) as median_amount
from osmosis.core.fact_transfers
where TX_SUCCEEDED='TRUE' and sender like 'evmos%' and receiver like 'osmo%' and block_timestamp::date>='2022-01-01'
UNION
select 'OSMOSIS --> EVMOS' ,count(*) as transfer_count , count(distinct sender) as transfer_sender
, count(distinct receiver) as transfer_receiver , sum(amount/pow(10,decimal)) as transfer_amount , avg(amount/pow(10,decimal)) as avg_amount
, median(amount/pow(10,decimal)) as median_amount
from osmosis.core.fact_transfers
where TX_SUCCEEDED='TRUE' and sender like 'osmo%' and receiver like 'evmos%' and block_timestamp::date>='2022-01-01'
Run a query to Download Data