yasmin copy
Updated 2025-04-19
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
›
⌄
WITH multi_token_transfers AS (
-- Track transfers (mints and burns) for various tokens
SELECT
block_timestamp::date AS date,
tx_hash,
symbol AS token,
CASE
WHEN symbol = 'SKHC' THEN amount * 1000
WHEN symbol = 'PARAVII' THEN amount * 1000
ELSE amount * 1
END AS amount_usd
FROM
avalanche.core.ez_token_transfers
WHERE
block_timestamp::date < current_date
AND from_address = '0x0000000000000000000000000000000000000000'
AND contract_address IN (
'0xad6605f4987031fd2d6d6816be53eb7c5b764bf7', -- XTBT
'0x53fc82f14f009009b440a706e31c9021e1196a2f', -- BUIDL
'0xe08b4c1005603427420e64252a8b120cace4d122', -- BENJI
'0x0b84f124596dac26010a9f79b7d8feade4ebbdbf', -- SKHC
'0xbb9360d57f68075e98d022784c12f2fda082316b', -- XRV
'0xbfdef5e389bb403426337081ecd1d05bc5193203', -- XEVT
'0x3a206f8f7cec45f1bd48ee5f370d04f609504d56', -- PARAVII
'0x7c6a937943f135283a2561938de2200994a8f7a7' -- NOTE
)
UNION
SELECT
block_timestamp::date AS date,
tx_hash,
symbol AS token,
CASE
WHEN symbol = 'SKHC' THEN -amount * 1000
WHEN symbol = 'PARAVII' THEN -amount * 1000
QueryRunArchived: QueryRun has been archived