freemartianequivalent-sapphire
    Updated 2025-02-05
    SELECT
    block_timestamp,
    to_address AS user,
    amount AS balance_change
    FROM base.core.ez_token_transfers
    WHERE contract_address = lower('0x0521AaA7C96E25afeE79FDd4f1Bb48F008aE4eac')
    AND to_address in ('0x5d64d14d2cf4fe5fe4e65b1c7e3d11e18d493091')
    -- AND to_address in ('0x11ddd59c33c73c44733b4123a86ea5ce57f6e854','0x732328989073f71f68d196197f4cf0f41120fa3f','0x5d64d14d2cf4fe5fe4e65b1c7e3d11e18d493091')
    UNION ALL
    SELECT
    block_timestamp,
    from_address AS user,
    -amount AS balance_change
    FROM base.core.ez_token_transfers
    WHERE contract_address = lower('0x0521AaA7C96E25afeE79FDd4f1Bb48F008aE4eac')
    AND from_address in ('0x5d64d14d2cf4fe5fe4e65b1c7e3d11e18d493091')
    -- AND from_address in ('0x11ddd59c33c73c44733b4123a86ea5ce57f6e854','0x732328989073f71f68d196197f4cf0f41120fa3f','0x5d64d14d2cf4fe5fe4e65b1c7e3d11e18d493091')

    order by 1,2
    Last run: about 2 months ago
    BLOCK_TIMESTAMP
    USER
    BALANCE_CHANGE
    1
    2024-12-28 02:28:07.0000x5d64d14d2cf4fe5fe4e65b1c7e3d11e18d4930912368.599162978
    2
    2024-12-28 02:28:29.0000x5d64d14d2cf4fe5fe4e65b1c7e3d11e18d493091270.255776428
    3
    2024-12-28 02:28:39.0000x5d64d14d2cf4fe5fe4e65b1c7e3d11e18d493091152.887779357
    4
    2024-12-28 02:28:55.0000x5d64d14d2cf4fe5fe4e65b1c7e3d11e18d493091990.771978591
    5
    2024-12-28 02:29:31.0000x5d64d14d2cf4fe5fe4e65b1c7e3d11e18d493091682.409085915
    6
    2024-12-28 02:29:33.0000x5d64d14d2cf4fe5fe4e65b1c7e3d11e18d49309119.71969086
    7
    2024-12-28 02:29:45.0000x5d64d14d2cf4fe5fe4e65b1c7e3d11e18d4930913083.90140874
    8
    2024-12-28 02:30:07.0000x5d64d14d2cf4fe5fe4e65b1c7e3d11e18d493091566.534222564
    9
    2024-12-28 02:30:57.0000x5d64d14d2cf4fe5fe4e65b1c7e3d11e18d49309123.073361884
    10
    2024-12-28 02:31:17.0000x5d64d14d2cf4fe5fe4e65b1c7e3d11e18d493091178.284174733
    11
    2024-12-28 02:31:29.0000x5d64d14d2cf4fe5fe4e65b1c7e3d11e18d493091184.962692278
    12
    2024-12-28 02:31:31.0000x5d64d14d2cf4fe5fe4e65b1c7e3d11e18d493091250
    13
    2024-12-28 02:31:31.0000x5d64d14d2cf4fe5fe4e65b1c7e3d11e18d493091183.499606878
    14
    2024-12-28 02:31:33.0000x5d64d14d2cf4fe5fe4e65b1c7e3d11e18d493091398.272290207
    15
    2024-12-28 02:31:37.0000x5d64d14d2cf4fe5fe4e65b1c7e3d11e18d493091580.45213116
    16
    2024-12-28 02:31:45.0000x5d64d14d2cf4fe5fe4e65b1c7e3d11e18d493091207.60843218
    17
    2024-12-28 02:31:45.0000x5d64d14d2cf4fe5fe4e65b1c7e3d11e18d493091937.317398712
    18
    2024-12-28 02:31:51.0000x5d64d14d2cf4fe5fe4e65b1c7e3d11e18d49309195.644803741
    19
    2024-12-28 02:32:05.0000x5d64d14d2cf4fe5fe4e65b1c7e3d11e18d493091603.398016311
    20
    2024-12-28 02:32:07.0000x5d64d14d2cf4fe5fe4e65b1c7e3d11e18d4930911943.468456377
    ...
    7494
    629KB
    6s