from flipside_prod_db.ethereum_core.ez_token_transfers

where BLOCK_TIMESTAMP >= '2021-05-01'

and SYMBOL = 'DAI'

and AMOUNT >= '1000000')

select date_trunc('day',block_timestamp) as date ,

sum(amount)as total_amount, count (distinct TX_HASH) as transactions, count (distinct FROM_ADDRESS) as wallets,

(transactions/wallets)as average_transactions, (total_amount/transactions)as average_amount

from A

where date = '2022-01-16'

group by date