date_trunc(day,block_timestamp)::date as date

,count(DISTINCT tx_hash) as tx_count

,sum(tx_count) over (order by date) as growth_tx_count

,count(DISTINCT from_address) as wallets

,sum(wallets) over (order by date) as growth_tx_wallets

-----------------------------------internal query-------------------------------------

,(select avg(price) from ethereum.core.fact_hourly_token_prices where

token_address=lower('0x7D1AfA7B718fb893dB30A3aBc0Cfc608AaCfeBB0') and

HOUR::date=date_trunc(day,block_timestamp)::date) as MATIC_price

--------------------------------------------------------------------------------------

from polygon.core.fact_transactions

where status='SUCCESS'

and block_timestamp::date >='2022-07-01'

group by 1

order by 1