select e.BLOCK_TIMESTAMP::date as day, count(distinct proposer) as intrest,count(distinct e.tx_id) as tx_volume
from flow.core.fact_events e left join flow.core.fact_transactions t on e.tx_id=t.tx_id
where e.BLOCK_TIMESTAMP::date>='2022-05-09' and e.BLOCK_TIMESTAMP::date<='2022-06-04'
group by 1
order by 1 asc