permaryobjective-apricot
    Updated 2024-10-02
    with dex_contracts as (
    select
    creator_address,
    created_block_timestamp
    from berachain.testnet.dim_contracts
    where dim_contracts_id like '%dex%'
    or dim_contracts_id like '%swap%'
    or dim_contracts_id like '%liquidity%'
    )

    select
    creator_address,
    created_block_timestamp
    from dex_contracts
    order by created_block_timestamp desc;
    QueryRunArchived: QueryRun has been archived