How to find all matches in the database?

Question

PostgreSQL

async with request.app['db'].acquire() as conn:
            result = await conn.execute(
                select([db.my, ]).where(db.my.c.date == date)
            )
            print(await result.first())

Thus I find only 1 match, but how to find all matches and pull them out?