DATE_TRUNC('week',block_timestamp) as date,

COUNT(DISTINCT TX_HASH) as number_of_transactions,

SUM(AMOUNT) as total_amount,

SUM(AMOUNT_USD) as total_amount_usd,

total_amount_usd/number_of_transactions as average_amount_per_transaction

FROM flipside_prod_db.ethereum_core.ez_token_transfers

WHERE TX_HASH=ANY(

SELECT

FROM flipside_prod_db.ethereum_core.fact_event_logs

WHERE CONTRACT_ADDRESS=LOWER('0xaFD2AaDE64E6Ea690173F6DE59Fc09F5C9190d74')

AND EVENT_NAME = 'PoolAllocation')

AND SYMBOL='DAI'

GROUP BY date

ORDER BY date