liquidity

Updated 2025-01-31

SELECT DISTINCT

symbols:token0::string AS symbol0,

symbols:token1::string AS symbol1,

tokens:token0::string AS token0,

tokens:token1::string AS token1

FROM kaia.defi.dim_dex_liquidity_pools

WHERE (symbols:token0::string IS NOT NULL AND symbols:token0::string != '')

AND (symbols:token1::string IS NOT NULL AND symbols:token1::string != '')

AND (tokens:token0::string = '0x19aac5f612f524b754ca7e7c41cbfa2e981a4432'

OR tokens:token1::string = '0x19aac5f612f524b754ca7e7c41cbfa2e981a4432');

--SELECT creation_tx from kaia.defi.dim_dex_liquidity_pools

--limit 50

SELECT * FROM kaia.core.ez_decoded_event_logs

where contract_address = '0x19aac5f612f524b754ca7e7c41cbfa2e981a4432'

LIMIT 1000;

--SELECT tx_id from sei.defi.fact_lp_actions

--limit 20;

QueryRunArchived: QueryRun has been archived

flipside