sei-models/models/evm/streamline/_max_evm_block_by_date.sql

{{ config (
    materialized = "ephemeral",
    unique_key = "block_number",
) }}

WITH base AS (

    SELECT
        block_timestamp :: DATE AS block_date,
        MAX(block_number) as block_number
    FROM
        {{ ref("core_evm__fact_blocks") }}
    GROUP BY
        block_timestamp :: DATE
)
SELECT
    block_date,
    block_number
FROM
    base
WHERE
    block_date <> (
        SELECT
            MAX(block_date)
        FROM
            base
    )