Total Mint Events | Total Burn Events | |
|---|---|---|
1 | 356 | 51 |
datavortexmints and burns events
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
›
⌄
WITH buidl_transfers AS (
SELECT
contract_address,
LOWER('0x' || SUBSTR(topics[1], 27)) AS "from",
LOWER('0x' || SUBSTR(topics[2], 27)) AS "to",
tx_hash
FROM avalanche.core.fact_event_logs
WHERE
contract_address IN (
LOWER('0xad6605f4987031fd2d6d6816be53eb7c5b764bf7'), -- XTBT
LOWER('0x53fc82f14f009009b440a706e31c9021e1196a2f'), -- BUIDL
LOWER('0xe08b4c1005603427420e64252a8b120cace4d122'), -- $BENJI
LOWER('0x7c6a937943f135283a2561938de2200994a8f7a7'), -- $NOTE
LOWER('0x7c64925002bfa705834b118a923e9911bee32875'), -- $ACRED
LOWER('0x0b84f124596dac26010a9f79b7d8feade4ebbdbf'), -- $SKHC
LOWER('0xbb9360d57f68075e98d022784c12f2fda082316b'), -- $XRV
LOWER('0xbfdef5e389bb403426337081ecd1d05bc5193203'), -- $XEVT
LOWER('0x3a206f8f7cec45f1bd48ee5f370d04f609504d56') -- $PARAVII
)
)
SELECT
COUNT(DISTINCT CASE WHEN "from" = '0x0000000000000000000000000000000000000000' THEN tx_hash END) AS "Total Mint Events",
COUNT(DISTINCT CASE WHEN "to" = '0x0000000000000000000000000000000000000000' THEN tx_hash END) AS "Total Burn Events"
FROM buidl_transfers;
Last run: about 1 month ago
1
10B
3s