buzzresearchUsers daily by transaction type
    Updated 2024-09-24
    WITH FilteredTransfers AS (
    -- Withdrawal: User sends funds to the pool
    SELECT
    DATE_TRUNC('week', block_timestamp) AS week,
    from_address AS user,
    'withdrawal' AS transaction_type
    FROM ethereum.core.ez_native_transfers
    WHERE
    to_address IN (
    '0xaa0A1EfD35d6578ea6B5704dbc2c40B36A55B590',
    '0xACB886b75D76d1c8d9248cFdDfA09b70C71c5393',
    '0xdDa53E23f8a32640b04D7256e651C1db98dB11C1',
    '0x994e3B01D130944a3E67BFd3B8Fc73069b959FEc',
    '0x5557408ab14013ce9Dbb300dE0D87D386BB09cb6',
    '0x59191bD38EBA4a642C9FEc308dc188731b229822',
    '0xE3d981643b806FB8030CDB677D6E60892E547EdA',
    '0xF2dc77c697e892542cC53336178a78Bb313DFDC7',
    '0x0d9f416260598313Be6FDf6B010f2FbC34957Cd0',
    '0x5fF93263D5181b2A826f8c51d54BC0da2d20D50a',
    '0x0640c9377a4fAC00225097EACbB0295f4D5fbd76',
    '0xEEAfA156A5dd3811Ee0D9F91db57A77eA53A8d31',
    '0xA67fc05D295d2Be6bC4cBfad4f880c1c58734212',
    '0x3f6ce1b36e5120bbc59d0cfe8a5ac8b6464ac1f7',
    '0x091df5e1284e49fa682407096ad34cfd42b95b72',
    '0x8adee124447435fe03e3cd24df3f4cae32e65a3e',
    '0x450d55a4b4136805b0e5a6bb59377c71fc4facbb'
    )
    UNION ALL
    -- Deposit: User receives funds from the pool
    SELECT
    DATE_TRUNC('week', block_timestamp) AS week,
    to_address AS user,
    'deposit' AS transaction_type
    FROM ethereum.core.ez_native_transfers