CHAIN | USDZ_SUPPLY | |
---|---|---|
1 | arbitrum | 79013.6990648 |
2 | blast | 146726.239184 |
3 | base | 79306721.744043 |
4 | ethereum | 17119027.0730277 |
alessio9567USDz Supply 2
Updated 6 days ago
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
›
⌄
SELECT
chain,
usdz_supply
from
(
select
chain,
day,
ROW_NUMBER() OVER (
PARTITION BY chain
ORDER BY
day DESC
) AS row_num,
sum(usdz_minted_amount) as daily_net_usdz_minted_amount,
sum(daily_net_usdz_minted_amount) over (
partition by chain
order by
day
) as usdz_supply
from
(
-- mint
SELECT
'ethereum' as chain,
date_trunc('day', block_timestamp) as day,
SUM(amount) as usdz_minted_amount
from
ethereum.core.ez_token_transfers
where
contract_address = '0xa469b7ee9ee773642b3e93e842e5d9b5baa10067'
and from_address = '0x0000000000000000000000000000000000000000'
GROUP by
day
union
all -- reedem
SELECT
Last run: 6 days agoAuto-refreshes every 24 hours
4
107B
333s