tongzzezUSDC (Fantom) Volume
Updated 2022-07-27
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
›
⌄
-- GST = AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB
-- USDC = EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v
-- USDT = Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB
-- GMT = 7i5KKsX2weiTkry7jA4ZwSuXGhs5eJBEjY8vVxR4pfRx
-- BUSD Token (Portal from BSC) = 5RpUwQ8wtdPCZHhu6MERp2RGrpobsbZ6MH5dDHkUjs2
-- Tether USD (Portal from BSC) = 8qJSyQprMC57TWKaYEmetUR3UUiTP2M3hXdcvFhkZdmv
-- GMT
-- USD Coin (Portal from Ethereum) = A9mUU4qviSctJVPJdBJWkb28deg915LYJKrzQ19ji3FM
-- Tether USD (Portal from Ethereum) = Dn4noZ5jgGfkntzcQSUZ8czkreiZ1ForXYoV2H8Dm7S1
-- USD Coin (Portal from Polygon) = E2VmbootbVCBkMNNxKQgCLMS1X3NoGMaYAsufaAsf7M
-- Tether USD (Portal from Polygon) = 5goWRao6a3yNC4d6UjMdQxonkCMvKBwdpubU3qhfcdf1
-- USDCav (Portal from Avalanche) = AGqKX7F4mqJ8x2mUQVangJb5pWQJApaKoUfe5gXM53CV
-- USDTav (Portal from Avalanche) = B2wfeYz5VtBnQVrX4M8F6FeDrprVrzKPws5qg1in8bzR
-- Wrapped USDC (Allbridge from Fantom) = Grk6b4UMRWkgyq4Y6S1BnNRF4hRgtnMFp7Sorkv6Ez4u
with usdc_fantom_in as(
select
block_timestamp::date as date,
sum(PRE_TOKEN_BALANCES[0]:uiTokenAmount:uiAmount) as sum_pre,
sum(POST_TOKEN_BALANCES[0]:uiTokenAmount:uiAmount) as sum_post,
ifnull(sum_post,0) - ifnull(sum_pre,0) as amount_in,
count(tx_id) as tx_in
from
solana.core.fact_transactions
where
PRE_TOKEN_BALANCES[0]:mint = 'Dnr8fDaswHtYMSKbtR9e8D5EadyxqyJwE98xp17ZxE2E'
and INSTRUCTIONS[0]:programId like '%wormDT%'
Run a query to Download Data