ola11 daily new pools by chain
    Updated 2024-07-17
    with t1 as (

    (
    SELECT
    'Ethereum' as chain,
    block_timestamp::date as date,
    tx_hash as tx_hash
    from
    ethereum.core.ez_decoded_event_logs
    where
    contract_address = lower('0x1F98431c8aD98523631AE4a59f267346ea31F984')
    and block_timestamp::date >= '2023-06-01'
    and event_name = 'PoolCreated'
    and tx_status = 'SUCCESS'
    )

    union all

    (
    SELECT
    'Arbitrum' as chain,
    block_timestamp::date as date,
    tx_hash as tx_hash
    from
    arbitrum.core.ez_decoded_event_logs
    where
    contract_address = lower('0x1F98431c8aD98523631AE4a59f267346ea31F984')
    and block_timestamp::date >= '2023-06-01'
    and event_name = 'PoolCreated'
    and tx_status = 'SUCCESS'
    )

    union all

    (
    SELECT
    QueryRunArchived: QueryRun has been archived