headitmanager2incen
Updated 2023-02-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
select 'WBNB' , sum(amount/1e18) , avg(amount/1e18) , median(amount/1e18) , count(1) , block_timestamp::date from axelar.core.fact_transfers
where currency like '%wbnb%' and sender like 'osmo%' and block_timestamp::date > '2022-11-01'
group by 6
UNION
select 'WETH' , sum(amount/1e18) , avg(amount/1e18) , median(amount/1e18) , count(1) , block_timestamp::date from axelar.core.fact_transfers
where currency like '%weth%' and sender like 'osmo%' and block_timestamp::date > '2022-11-01'
group by 6
UNION
select 'WMATIC' , sum(amount/1e18) , avg(amount/1e18), median(amount/1e18) , count(1) , block_timestamp::date from axelar.core.fact_transfers
where currency like '%wmatic%' and sender like 'osmo%' and block_timestamp::date > '2022-11-01'
group by 6
UNION
select 'WAVAX' , sum(amount/1e18) , avg(amount/1e18) , median(amount/1e18) , count(1) , block_timestamp::date from axelar.core.fact_transfers
where currency like '%wavax%' and sender like 'osmo%' and block_timestamp::date > '2022-11-01'
group by 6
Run a query to Download Data