select block_timestamp::date as date, event_inputs:pool as pool_number,
sum(event_inputs:amount/1e18) as amount_of_dai
from ethereum.events_emitted
where contract_address = lower('0xaFD2AaDE64E6Ea690173F6DE59Fc09F5C9190d74')
and tx_succeeded = 'TRUE'
and event_name = 'PoolAllocation'
and tx_to_label_subtype = 'pool'
and tx_to_label = 'rari capital'
GROUP BY date, pool_number
ORDER BY date DESC