Kruys-CollinsAxl token 0 copy
Updated 2024-04-16
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
›
⌄
-- Define a Common Table Expression (CTE) named 'base'
WITH base AS (
-- First part of the UNION ALL
SELECT
ADDRESS,
'Osmosis' AS chain,
SUM(balance/POW(10, decimal)) AS axl_holding
FROM
osmosis.core.fact_daily_balances
WHERE
currency = 'ibc/903A61A498756EA560B85A85132D3AEE21B5DEDD41213725D22ABF276EA6945E'
AND DATE::date = CURRENT_DATE - 1
GROUP BY
ADDRESS
UNION ALL
-- Second part of the UNION ALL
SELECT
ADDRESS,
'Axelar' AS chain,
SUM(balance/POW(10, 6)) AS axl_holding
FROM
axelar.core.fact_daily_balances
WHERE
currency = 'uaxl'
AND DATE::date = CURRENT_DATE - 1
AND ADDRESS NOT IN (SELECT address FROM axelar.core.dim_labels)
GROUP BY
ADDRESS
)
-- Main SELECT statement
SELECT
chain,
COUNT(DISTINCT ADDRESS),
QueryRunArchived: QueryRun has been archived