andreafiandroLp Volume
Updated 2023-11-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
select
BLOCK_TIMESTAMP,
TX_HASH,
'Add' AS Action,
origin_from_address AS user,
Pool_name AS pool,
TOKENS:token0 AS Token0,
SYMBOLS:token0 AS Symbol0,
DECODED_LOG:amount0/power(10,A.DECIMALS:token0) AS amount0,
TOKENS:token1 AS Token1,
SYMBOLS:token1 AS Symbol1,
DECODED_LOG:amount1/power(10,A.DECIMALS:token1) AS amount1,
DECODED_LOG
from
avalanche.core.ez_decoded_event_logs
inner join avalanche.defi.dim_dex_liquidity_pools A on pool_address='0xe6c7e4142b0cb24f2bfa7b9a50911375f8ee8db9'
-- where ORIGIN_FUNCTION_SIGNATURE IN ('0x88316456','0x219f5d17','0xac9650d8')
WHERE ORIGIN_TO_ADDRESS='0x655c406ebfa14ee2006250925e54ec43ad184f8b'
and EVENT_NAME='Mint'
LIMIT 10
Run a query to Download Data