flipside

    BNB Check
    flipperjo0BNB Check
    Updated 8 days ago
    WITH initial_addresses AS (
    SELECT DISTINCT to_address
    FROM bsc.core.ez_token_transfers
    WHERE LOWER(contract_address) IN (
    -- My Tokens --
    LOWER('0xCC2212FD511b5E13B52e0a89026adFB72114436A'),
    LOWER('0xB1F6078fc1bc983F0eF549A44CfDF3d562b87e87')
    -- Competitors --
    -- LOWER('0x35bFb76e1Dc8eE5a697C7c5ab883b209d37780D4'),
    -- LOWER('0xAB8bB77f847AA786315EBB364013d215D2F7848a')
    )
    AND to_address IS NOT NULL
    ),

    token_transfers AS (
    SELECT
    block_timestamp,
    tx_hash,
    from_address,
    to_address,
    amount,
    amount_usd,
    contract_address,
    symbol,
    'ERC20' AS transfer_type
    FROM bsc.core.ez_token_transfers
    WHERE to_address IN (SELECT to_address FROM initial_addresses)
    AND amount_usd > 0
    ),

    native_transfers AS (
    SELECT
    block_timestamp,
    tx_hash,
    from_address,
    to_address,
    Last run: 8 days ago
    No Data to Display
    0
    2B
    201s