Cipher009-CpUJ5k2023-12-02 11:47 PM
    Updated 2023-12-03
    SELECT
    t.eth_from_address AS user_address,
    SUM(t.amount) / 1e18 AS total_value_in_ether,
    COUNT(*) AS transaction_count,
    SUBSTRING(t.origin_function_signature, 3, 8) AS function_selector
    FROM
    ethereum.core.ez_eth_transfers AS t
    WHERE
    t.eth_to_address = '0x9DBd0FFD43A3D440CEc5Eb76c3dc02B9eeA56912'
    AND SUBSTRING(t.origin_function_signature, 3, 8) = 'f994144d'
    GROUP BY
    t.eth_from_address,
    SUBSTRING(t.origin_function_signature, 3, 8)
    ORDER BY
    total_value_in_ether DESC;

    Run a query to Download Data