germanTime holdings
Updated 2022-12-03
999
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
›
⌄
⌄
/*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 buyers_AXL as (
SELECT
trader as buyer,
block_timestamp :: date as date_bought,
sum(to_amount) as volume_bought
FROM
osmosis.core.fact_swaps
WHERE
trader is not null
AND TO_CURRENCY ILIKE 'ibc/903A61A498756EA560B85A85132D3AEE21B5DEDD41213725D22ABF276EA6945E'
AND block_timestamp >= current_date - 30
GROUP BY
1,
2
),
sellers_AXL as (
SELECT
trader as seller,
block_timestamp :: date as date_sold,
sum(from_amount) as volume_sold
FROM
osmosis.core.fact_swaps
WHERE
FROM_CURRENCY ILIKE 'ibc/903A61A498756EA560B85A85132D3AEE21B5DEDD41213725D22ABF276EA6945E'
AND block_timestamp >= current_date - 30
GROUP BY
1,
2
),
balances as (
SELECT
Run a query to Download Data