event_inputs:pool as pool_no,

sum(event_inputs:amount)/pow(10,18) as USDC_amount

FROM ethereum.events_emitted

WHERE lower(contract_address) = lower('0x66f4856f1bbd1eb09e1c8d9d646f5a3a193da569')

AND tx_succeeded = 'TRUE'

AND event_name = 'PoolAllocation'

GROUP by 1

order by 2 desc