germanDaily Volume AXL txs and OSMOSIS wallet
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
›
⌄
⌄
/*Since the $AXL token launch, how have wallets that bought $AXL used it?
Are most wallets hodling or trading? What is the average holding period for wallets buying $AXL in the last month?
Generally speaking, have users kept $AXL on exchange (in their Osmosis wallet) or have they bridge to other places?
Analyze $AXL balances on Osmosis as compared to native on Axelar. How have these balances changed over time?*/
WITH axelar_stats as (
SELECT amount,block_timestamp::date as date,
SUBSTRING(sender, 0, charindex('1',sender) - 1 ) as sender_chain,
lower(split(currency,'-')[0]) as token
FROM axelar.core.fact_transfers
WHERE sender_chain = 'axelar'
AND token = 'uaxl'
AND TX_SUCCEEDED = 'TRUE' AND date >= '2022-09-27'),
volume_transferred as (
SELECT
date,
SUM(amount / 1e6) as AXL_volume_transfers,
SUM(AXL_volume_transfers) OVER (ORDER BY date) as cumulative_volume_transfers
FROM axelar_stats GROUP BY 1),
AXL_osmosis_balance as (
SELECT sum(balance /1e6) as AXL_volume_holding_Osmosis, date,
sum(AXL_volume_holding_Osmosis) OVER (order by date) as cum_volume_osmosis
FROM osmosis.core.fact_daily_balances
WHERE currency='ibc/903A61A498756EA560B85A85132D3AEE21B5DEDD41213725D22ABF276EA6945E'
AND date >= '2022-09-27' GROUP BY 2)
SELECT a.date,cumulative_volume_transfers, cum_volume_osmosis
FROM volume_transferred a
JOIN AXL_osmosis_balance b ON a.date = b.date
ORDER BY 1
Run a query to Download Data