flipside

    Number of $AI Pools on Different Chains
    Eman-RazNumber of $AI Pools on Different Chains
    Updated 2024-10-02
    with final_tab as (with ethereum as (select creation_time, creation_tx, platform, pool_address, pool_name, 'Ethereum' as "Chain"
    from ethereum.defi.dim_dex_liquidity_pools
    where to_varchar(tokens) ilike '%0x2598c30330D5771AE9F983979209486aE26dE875%'),

    bsc as (select creation_time, creation_tx, platform, pool_address, pool_name, 'BSC' as "Chain"
    from bsc.defi.dim_dex_liquidity_pools
    where to_varchar(tokens) ilike '%0x2598c30330D5771AE9F983979209486aE26dE875%'),

    base as (select creation_time, creation_tx, platform, pool_address, pool_name, 'Base' as "Chain"
    from base.defi.dim_dex_liquidity_pools
    where to_varchar(tokens) ilike '%0x2598c30330D5771AE9F983979209486aE26dE875%'),

    arbitrum as (select creation_time, creation_tx, platform, pool_address, pool_name, 'Arbitrum' as "Chain"
    from arbitrum.defi.dim_dex_liquidity_pools
    where to_varchar(tokens) ilike '%0x2598c30330D5771AE9F983979209486aE26dE875%'),

    avalanche as (select creation_time, creation_tx, platform, pool_address, pool_name, 'Avalanche' as "Chain"
    from avalanche.defi.dim_dex_liquidity_pools
    where to_varchar(tokens) ilike '%0x2598c30330D5771AE9F983979209486aE26dE875%'),

    optimism as (select creation_time, creation_tx, platform, pool_address, pool_name, 'Optimism' as "Chain"
    from optimism.defi.dim_dex_liquidity_pools
    where to_varchar(tokens) ilike '%0x2598c30330D5771AE9F983979209486aE26dE875%'),

    polygon as (select creation_time, creation_tx, platform, pool_address, pool_name, 'Polygon' as "Chain"
    from polygon.defi.dim_dex_liquidity_pools
    where to_varchar(tokens) ilike '%0x2598c30330D5771AE9F983979209486aE26dE875%')

    SELECT * from ethereum union all
    SELECT * from base union all
    SELECT * from bsc union all
    SELECT * from arbitrum union all
    SELECT * from avalanche union all
    SELECT * from optimism union all
    SELECT * from polygon)

    Auto-refreshes every 24 hours
    QueryRunArchived: QueryRun has been archived