date_trunc('day', block_timestamp) as "Day",

max(total_supply / 1e24) as "Total Supply"

from near.core.fact_blocks

where "Day" between '2022-07-01' and '2022-09-30'

group by 1