block_timestamp,

tx_hash,

event_name,

decoded_log,

pool_address,

pool_name,

platform

from

ethereum.core.fact_decoded_event_logs

inner join

ethereum.defi.dim_dex_liquidity_pools on pool_address=contract_address

limit 1000;

select utils.udf_hex_to_bech32('1c0317071103070805161b0a1c0710010b171619070216180d0b08060c1c120f')