BLOCKCHAIN | CONTRACT_ADDRESS | SYMBOL | CIRCULATING_SUPPLY | CURRENT_PRICE | MARKET_CAP | |
|---|---|---|---|---|---|---|
1 | base | 0x9c632e6aaa3ea73f91554f8a3cb2ed2f29605e0c | XCN | 27699497.4340683 | 0.00976922 | 270602.484322848 |
defi__joshCross-Chain Token Supply, Price, and Market Cap Analysis
Updated 2025-03-28
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
›
⌄
WITH token_supply AS (
-- Ethereum transfers
SELECT
'ethereum' as blockchain,
contract_address,
symbol,
SUM(amount) as total_supply
FROM ethereum.core.ez_token_transfers
WHERE contract_address = LOWER('0x9c632E6Aaa3eA73f91554f8A3cB2ED2F29605e0C')
AND block_timestamp >= DATEADD('day', -7, CURRENT_TIMESTAMP())
GROUP BY 1,2,3
UNION ALL
-- Base transfers
SELECT
'base' as blockchain,
contract_address,
symbol,
SUM(amount) as total_supply
FROM base.core.ez_token_transfers
WHERE contract_address = LOWER('0x9c632E6Aaa3eA73f91554f8A3cB2ED2F29605e0C')
AND block_timestamp >= DATEADD('day', -7, CURRENT_TIMESTAMP())
GROUP BY 1,2,3
UNION ALL
-- Arbitrum transfers
SELECT
'arbitrum' as blockchain,
contract_address,
symbol,
SUM(amount) as total_supply
FROM arbitrum.core.ez_token_transfers
WHERE contract_address = LOWER('0x9c632E6Aaa3eA73f91554f8A3cB2ED2F29605e0C')
AND block_timestamp >= DATEADD('day', -7, CURRENT_TIMESTAMP())
Last run: 20 days ago
1
106B
8s