germantop 10 holders
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
›
⌄
⌄
/*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 logs as (
SELECT
address,
balance/1e6 as volume,
date
FROM osmosis.core.fact_daily_balances
WHERE CURRENCY='ibc/903A61A498756EA560B85A85132D3AEE21B5DEDD41213725D22ABF276EA6945E'
AND date >= '2022-09-27')
SELECT sum(volume) as total_volume,
address
FROM logs
WHERE date >= current_date - 1
GROUP BY 2
order by 1 DESC
limit 10
Run a query to Download Data