Updated 2022-10-16
9
1
2
3
4
5
6
7
8
9
›
⌄
select trunc(block_timestamp,'day') as date,
event_name, count(distinct(tx_hash)) as tx_num from gnosis.core.fact_event_logs
where tx_status = 'SUCCESS'
and event_name != ''
and date >= CURRENT_DATE - 30
group by 1,2
order by tx_num desc
limit 100
Run a query to Download Data