BLOCK_TIMESTAMP :: date as days,

sum(TX_FEE) as daily_transaction,

daily_transaction* 0.01 as daily_$

FROM polygon.core.fact_transactions

where days between '2022-07-01' and CURRENT_DATE

group by 1

order by 1 DESC