andreafiandroLp Volume
    Updated 2023-11-14
    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