Updated 2024-08-02
    WITH recent_transactions AS (
    SELECT
    tx_hash,
    block_number,
    block_timestamp,
    tx_position,
    trace_index,
    origin_from_address,
    origin_to_address,
    origin_function_signature,
    amount,
    amount_usd
    FROM
    ethereum.core.ez_native_transfers
    WHERE
    block_timestamp >= DATEADD(minutes, -30, CURRENT_TIMESTAMP)
    AND amount_usd > 1000
    ),
    labels AS (
    SELECT
    address,
    label,
    label_subtype,
    label_type
    FROM
    ethereum.core.dim_labels
    ),
    latest_block_numbers AS (
    SELECT
    user_address,
    MAX(block_number) AS latest_block_number
    FROM
    ethereum.core.fact_eth_balances
    GROUP BY
    user_address
    ),
    QueryRunArchived: QueryRun has been archived