shivering-pink

yasminshivering-pink

Updated 2025-03-18

SELECT * FROM avalanche.core.ez_decoded_event_logs

WHERE TX_HASH='0xf57ae592caf1d7245263b20a6cb099bf7e594a8b28f3f65ed2782e31335462b8'

AND EVENT_NAME='PoolDeposit'

-- -- -- TOPIC_0 0xfbde797d201c681b91056529119e0b02407c7bb96a4a2c75c01fc9667232c8db

-- -- -- AND DECODED_LOG:assets /1E6 ----------USD

-- -- -- AND DECODED_LOG:shares /1E6 ----------XTBT

-- -- -- CONTRACT_NAME 'Flexible Term USDC Vault AVAX'

-- -- -- -----------------------مینت

-- SELECT

-- DATE_TRUNC('WEEK', BLOCK_TIMESTAMP) AS day,

-- SUM(DECODED_LOG:shares / 1E6) AS total_xtbt_minted

-- FROM avalanche.core.ez_decoded_event_logs

-- WHERE TOPIC_0 = '0x0af19f929dc1d7b34887d6f1a7e36b8d6bc0a9071daf7f65d2bffff866683e73'

-- AND EVENT_NAME = 'PoolDeposit'

-- AND CONTRACT_NAME = 'Flexible Term EURC Vault (AVAX)'

-- GROUP BY 1

-- ORDER BY 1 DESC;

-- -- ----------------------------------------

-- -- ------------

-- SELECT

-- DATE_TRUNC('WEEK', BLOCK_TIMESTAMP) AS day,

-- SUM(DECODED_LOG:shares / 1E6) AS total_xtbt_BURN

-- FROM avalanche.core.ez_decoded_event_logs

-- WHERE TOPIC_0 = '0xfbde797d201c681b91056529119e0b02407c7bb96a4a2c75c01fc9667232c8db'

-- AND EVENT_NAME = 'Withdraw'

-- AND CONTRACT_NAME = 'Flexible Term USDC Vault AVAX'

-- GROUP BY 1

-- ORDER BY 1 DESC;

QueryRunArchived: QueryRun has been archived

flipside