creation_block as block_number,

creation_time as block_timestamp,

creation_tx as tx_hash,

platform,

factory_address as factory_contract,

pool_address as liquidity_pool_from_factory,

pool_name as pool_name_if_available,

tokens as token_array_can_be_more_than_2,

symbols as symbols_array_can_be_more_than_2,

symbols:token0 as token0_symbol,

symbols:token1 as token1_symbol,

decimals as decimals_array

from ethereum.defi.dim_dex_liquidity_pools

where pool_address = lower('0x9a772018FbD77fcD2d25657e5C547BAfF3Fd7D16')

##swaps

select

block_number, block_timestamp, tx_hash,

origin_from_address as user,

origin_to_address as original_contract_called,

contract_address as pool_address,

sender as router_contract,

pool_name,

event_name,

token_in as contract_of_token_into_pool,

symbol_in as symbol_of_token_into_pool,

amount_in as decimal_adjusted_amount_into_pool,

amount_in_usd as usd_value_of_amount_into_pool,

token_out as contract_of_token_from_pool,

symbol_out as symbol_of_token_from_pool,

amount_out as decimal_adjusted_amount_from_pool,