TOTAL_SUPPLY | CURRENT_USD_PRICE | MARKETCAP | |
---|---|---|---|
1 | 1000000000 | 0.1389742143 | 138974214.285714 |
Updated 2025-02-02
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
›
⌄
--------------- Supply------------------
WITH supply_data AS (
SELECT
value:total_supply / POW(10, 18) :: FLOAT AS total_supply
FROM (SELECT chainbase_utils.get(
'/v1/token/metadata',
PARSE_JSON(
'{"chain_id": 43114, "contract_address": "0xFFFF003a6BAD9b743d658048742935fFFE2b6ED7"}'
)) AS resp
),
LATERAL FLATTEN(input => resp:data)
WHERE
value:total_supply IS NOT NULL
),
---------------- Price------------------
price_data AS (
SELECT AVG(PRICE) AS current_usd_price
FROM crosschain.price.ez_prices_hourly
WHERE
TOKEN_ADDRESS = LOWER('0xFFFF003a6BAD9b743d658048742935fFFE2b6ED7')
AND HOUR::DATE = CURRENT_DATE
)
--------------- Market Cap--------------------
SELECT
supply_data.total_supply,
price_data.current_usd_price,
supply_data.total_supply * price_data.current_usd_price AS marketcap
FROM
supply_data,
price_data;
Last run: 13 days ago
1
44B
24s