date(block_timestamp) as day,

count(distinct USER_ADDRESS) as holders_cnt,

avg(balance/1e18) as amt

from

ethereum.core.fact_token_balances

where

contract_address = '0x4d224452801aced8b2f0aebe155379bb5d594381' and day>='2022-03-15' and balance>0 and day<CURRENT_DATE

group by day