Athena Queries with Time Internval
SELECT *
FROM cloudtrail_logs_aws_cloudtrail_logs
where eventsource ='kinesisvideo.amazonaws.com'
and eventname='DeleteSignalingChannel'
and eventtime > to_iso8601(current_timestamp - interval '12' hour)
order by eventtime desc
limit 1000