bachiaxl6
Updated 2022-12-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with osmosis_transfers as (
select
date(block_timestamp) as day,
transfer_type,
count(distinct tx_id) as no_of_txns,
count(distinct sender) as no_of_senders,
round(sum(amount / pow(10, decimal)),2) as tot_volume,
round(avg(amount / pow(10, decimal)),2) as avg_volume,
count(distinct receiver) as no_of_receivers
from
osmosis.core.fact_transfers
where
currency like 'ibc/903A61A498756EA560B85A85132D3AEE21B5DEDD41213725D22ABF276EA6945E'
and tx_status = 'SUCCEEDED'
group by
1,2
),
axelar_transfers as (
select
date(block_timestamp) as day,
transfer_type,
count(distinct tx_id) as no_of_txns,
count(distinct sender) as no_of_sendeers,
round(sum(amount / pow(10, decimal)),2) as tot_volume,
round(avg(amount / pow(10, decimal)),2) as avg_volume,
count(distinct receiver) as no_of_receivers
from
axelar.core.fact_transfers
where
currency like 'uaxl'
and TX_SUCCEEDED = 'TRUE'
group by
1,2
)
select *, 'Osmosis' as network from osmosis_transfers
Run a query to Download Data