flipside

    Base Check
    flipperjo0Base Check
    Updated 8 hours ago
    WITH initial_addresses AS (
    SELECT
    DISTINCT to_address
    FROM
    base.core.ez_token_transfers
    WHERE
    LOWER(contract_address) IN (
    LOWER('0xefb79d04aae9c1619aeea423f2685230a1d8d200'),
    LOWER('0xd9c5A67Dc8c782438864439f407f6cE2DA48D690')
    )
    AND to_address IS NOT NULL
    ),
    filtered_transactions AS (
    SELECT
    block_timestamp,
    tx_hash,
    from_address,
    to_address,
    amount,
    amount_usd,
    contract_address,
    symbol
    FROM
    base.core.ez_token_transfers
    WHERE
    to_address IN (
    SELECT
    to_address
    FROM
    initial_addresses
    )
    AND amount_usd > 0
    )
    SELECT
    *
    FROM
    Last run: about 8 hours ago
    No Data to Display
    0
    2B
    75s