TOTAL_MARKET_CAP_NOW | TOTAL_MARKET_CAP_30_DAYS_AGO | MARKET_CAP_CHANGE_PCT | |
|---|---|---|---|
1 | -1.18990266742051e+62 | -1.14113103943375e+62 | 4.273972603 |
datavortexTV Change
Updated 2025-04-16
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 buidl_transfers AS (
SELECT
contract_address,
LOWER('0x' || SUBSTR(topics [1], 27)) AS "from",
LOWER('0x' || SUBSTR(topics [2], 27)) AS "to",
CAST(
ethereum.public.udf_hex_to_int(SUBSTRING(data, 3, 64)) AS FLOAT
) / CASE
WHEN contract_address IN (
LOWER('0xad6605f4987031fd2d6d6816be53eb7c5b764bf7'),
LOWER('0x53fc82f14f009009b440a706e31c9021e1196a2f')
) THEN POWER(10, 6)
ELSE POWER(10, 18)
END AS token_amount,
block_timestamp
FROM
avalanche.core.fact_event_logs
WHERE
block_timestamp >= CURRENT_DATE - INTERVAL '30 days'
),
supply_snapshot AS (
SELECT
contract_address,
SUM(
CASE
WHEN "from" = '0x0000000000000000000000000000000000000000' THEN token_amount
ELSE 0
END
) AS minted,
SUM(
CASE
WHEN "to" = '0x0000000000000000000000000000000000000000' THEN token_amount
ELSE 0
END
) AS burned
FROM
Last run: 2 months ago
1
59B
4s