yasminsmiling-coffee
Updated 2025-04-11
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
›
⌄
SELECT
logs.TX_HASH,
logs.CONTRACT_ADDRESS AS ROUTER_ADDRESS,
logs.EVENT_NAME,
'0x' || SUBSTRING(logs.TOPIC_1, 27) AS TOKEN_IN_ADDRESS,
token_in.symbol AS TOKEN_IN_SYMBOL,
token_in.decimals AS TOKEN_IN_DECIMALS,
TRY_TO_DECIMAL(logs.DECODED_LOG:_amountIn::STRING) / POWER(10, token_in.decimals) AS AMOUNT_IN_FORMATTED,
'0x' || SUBSTRING(logs.TOPIC_2, 27) AS TOKEN_OUT_ADDRESS,
token_out.symbol AS TOKEN_OUT_SYMBOL,
token_out.decimals AS TOKEN_OUT_DECIMALS,
TRY_TO_DECIMAL(logs.DECODED_LOG:_amountOut::STRING) / POWER(10, token_out.decimals) AS AMOUNT_OUT_FORMATTED
FROM
avalanche.core.ez_decoded_event_logs logs
LEFT JOIN
avalanche.core.dim_contracts token_in
ON '0x' || SUBSTRING(logs.TOPIC_1, 27) = token_in.address
LEFT JOIN
avalanche.core.dim_contracts token_out
ON '0x' || SUBSTRING(logs.TOPIC_2, 27) = token_out.address
WHERE
logs.EVENT_NAME = 'YakSwap'
AND logs.TOPIC_0 = '0x9fc8352e52998db4087d5e6e1c1aafa38788e749e5d7a24f5cb230f737954402'
AND logs.TX_HASH = '0x36f7827bb1b58b0b5646ab723f34d5e7fd7daa2d2cf7156d62748e5ec2c6a827'
AND logs.CONTRACT_ADDRESS = '0xc4729e56b831d74bbc18797e0e17a295fa77488c'
-- -----------------------------------------------------------
-- SELECT
-- TOKEN_ADDRESS,
-- AVG(PRICE) AS average_price
-- FROM
-- avalanche.price.ez_prices_hourly
-- WHERE
-- HOUR >= DATEADD(day, -1, CURRENT_DATE())
-- AND HOUR < CURRENT_DATE()
QueryRunArchived: QueryRun has been archived