moonshot21Total supply of PYUSD
Updated 2024-09-17
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
›
⌄
-- Calculate the total supply of PYUSD on both Solana and Ethereum
-- 1/ Calculate the total supply of PYUSD on Solana
WITH TOTAL_PYUSD_SOL AS (
SELECT
SUM(BALANCE) AS TOTAL_SOL
FROM (
SELECT
BALANCE,
ROW_NUMBER() OVER (PARTITION BY ACCOUNT_ADDRESS ORDER BY BLOCK_TIMESTAMP DESC) AS rn
FROM solana.core.fact_token_balances
WHERE MINT = '2b1kV6DkPAnxd5ixfnxCpjxmKwqjjaYmCZfHsFu24GXo'
) AS ranked_solana
WHERE rn = 1
),
-- 2/ Calculate the total supply of PYUSD on Ethereum
TOTAL_PYUSD_ETH AS (
SELECT
SUM(CURRENT_BAL) AS TOTAL_ETH
FROM ethereum.core.ez_current_balances
WHERE CONTRACT_ADDRESS = LOWER('0x6c3ea9036406852006290770bedfcaba0e23a0e8')
)
-- 3/ Addition of PYUSD_SOL and PYUSD_ETH
SELECT
TOTAL_SOL + TOTAL_ETH AS TOTAL_PYUSD
FROM TOTAL_PYUSD_SOL, TOTAL_PYUSD_ETH;
QueryRunArchived: QueryRun has been archived