-- select * from tab_bar_tapped limit 5;

select
 DATE(CONVERT_TIMEZONE('America/New_York', (TIMESTAMP 'epoch' + time * INTERVAL '1 Second '))),
 count(*)
from tab_bar_tapped
where tab_title = 'DISCOVER'
group by 1
order by 1 desc;

select
 tab_title
from tab_bar_tapped;

select
 DATE(CONVERT_TIMEZONE('America/New_York', (TIMESTAMP 'epoch' + time * INTERVAL '1 Second '))),
 count(*)
from tab_bar_tapped
where tab_title = 'GIFTS'
group by 1
order by 1 desc;