SUM(MINT_AMOUNT) | |
|---|---|
1 | 1012000000 |
cloudr3nausd holders
Updated 2025-01-26
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
›
⌄
-- https://developer.agora.finance/contract-deployments
-- eth/mnt/sol/avax/poly
with
mnt_ausd as (
select
date(block_timestamp) as day,
sum(case when from_address = '0x0000000000000000000000000000000000000000' then raw_amount*pow(10,-6) else raw_amount*-1*pow(10,-6) end) daily_changes,
sum(daily_changes) over (order by day asc) ausd_supply
from
mantle.core.ez_token_transfers
where
contract_address=lower('0x00000000eFE302BEAA2b3e6e1b18d08D69a9012a')
and (to_address='0x0000000000000000000000000000000000000000' or from_address='0x0000000000000000000000000000000000000000')
group by
day
),
eth_ausd as (
select
date(block_timestamp) as day,
sum(case when from_address = '0x0000000000000000000000000000000000000000' then raw_amount*pow(10,-6) else raw_amount*-1*pow(10,-6) end) daily_changes,
sum(daily_changes) over (order by day asc) ausd_supply
from
ethereum.core.ez_token_transfers
where
contract_address=lower('0x00000000eFE302BEAA2b3e6e1b18d08D69a9012a')
and (to_address='0x0000000000000000000000000000000000000000' or from_address='0x0000000000000000000000000000000000000000')
group by
day
),
avax_ausd as (
select
date(block_timestamp) as day,
sum(case when from_address = '0x0000000000000000000000000000000000000000' then raw_amount*pow(10,-6) else raw_amount*-1*pow(10,-6) end) daily_changes,
Last run: 3 months ago
1
14B
3s