date_trunc('day', block_timestamp) as block_day,

count(distinct(tx_hash)) as daily_tx

from polygon.core.fact_event_logs

where block_timestamp >= '2022-7-1'

and block_timestamp < current_date()

group by block_day)

select * from transactions