I am using Amazon Athena to get all console login that happened in past week, right now i am able to just get all the console logins regardless of the data. I need to modify the below query so that this query picks up all the aws console logins that happened in last week always. 

```
WITH events AS (
  SELECT
    event.eventVersion,
    event.eventID,
    event.eventTime,
    event.eventName,
    event.eventType,
    event.eventSource,
    event.awsRegion,
    event.sourceIPAddress,
    event.userAgent,  
    event.userIdentity.type AS userType,
    event.userIdentity.arn AS userArn,
    event.userIdentity.principalId as userPrincipalId,
    event.userIdentity.accountId as userAccountId,
    event.userIdentity.userName as userName
  FROM cloudtrail.events
  CROSS JOIN UNNEST (Records) AS r (event)
)
SELECT userName,sourceIPAddress,eventName,eventTime FROM events WHERE eventName='ConsoleLogin';

```

The eventTime looks like": 
[![enter image description here](https://i.stack.imgur.com/rgvGJ.jpg)](https://i.stack.imgur.com/rgvGJ.jpg)

T