yasminAXON-STABLE Pool
Updated 2024-10-17
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
USDC_withdrawals AS (
SELECT SUM(DECODED_LOG:amount/POW(10,6)) AS total_withdrawn
FROM avalanche.core.ez_decoded_event_logs
WHERE DECODED_LOG:token='0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e'
--AND DECODED_LOG:dst='0x29eeb257a2a6ecde2984acedf80a1b687f18ec91'
AND EVENT_NAME ='Withdraw'
AND CONTRACT_ADDRESS='0x74163b79733aea2d9c4ced777dc49d591db739e9' ),
USDC_deposits AS (
SELECT
SUM(DECODED_LOG:amount/POW(10,6))AS total_deposited
FROM avalanche.core.ez_decoded_event_logs
WHERE DECODED_LOG:token='0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e'
--AND DECODED_LOG:dst='0x29eeb257a2a6ecde2984acedf80a1b687f18ec91'
AND EVENT_NAME ='Deposit'
AND CONTRACT_ADDRESS='0x74163b79733aea2d9c4ced777dc49d591db739e9' ),
UXDA_withdrawals AS (
SELECT SUM(DECODED_LOG:amount/POW(10,18))AS total_withdrawn
FROM avalanche.core.ez_decoded_event_logs
WHERE DECODED_LOG:token='0xc8e9053d354976ccd78f58fdbc7df2b0a9a127e6'
--AND DECODED_LOG:dst='0x29eeb257a2a6ecde2984acedf80a1b687f18ec91'
AND EVENT_NAME ='Withdraw'
AND CONTRACT_ADDRESS='0x74163b79733aea2d9c4ced777dc49d591db739e9'
),
UXDA_deposits AS (
SELECT SUM(DECODED_LOG:amount/POW(10,18))AS total_deposited
FROM avalanche.core.ez_decoded_event_logs
WHERE DECODED_LOG:token='0xc8e9053d354976ccd78f58fdbc7df2b0a9a127e6'
--AND DECODED_LOG:dst='0x29eeb257a2a6ecde2984acedf80a1b687f18ec91'
QueryRunArchived: QueryRun has been archived