kasadeghUntitled Query
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 receive_axelar as
(
select block_timestamp::date as date,
tx_id,
receiver,
amount / pow (10,decimal) as Receive_Volume
from axelar.core.fact_transfers
where currency = 'uaxl'
and transfer_type in ('AXELAR','IBC_TRANSFER_IN')
),
send_axelar as
(
select block_timestamp::date as date,
tx_id,
sender,
amount / pow (10,decimal) as Send_Volume
from axelar.core.fact_transfers
where currency = 'uaxl'
and transfer_type in ('AXELAR','IBC_TRANSFER_OUT')
),
holder_daily_info as
(
select t1.date,
receiver as AXL_Holder,
sum (Send_Volume) as Daily_Send_Volume,
sum (Receive_Volume) as Daily_Receive_Volume
from receive_axelar t1 join send_axelar t2 on t1.Date = t2.Date and t1.Receiver = t2.Sender
group by 1,2
),
holder_balance_on_axelar as
(
select
AXL_Holder,
Run a query to Download Data