date(block_timestamp) as date,

event_inputs:pool as pool_number,

count(tx_hash) as transactions,

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

case

when pool_number='106' then 'Fuse11'

when pool_number='104' then 'Fuse15'

when pool_number='102' then 'Fuse13'

when pool_number='100' then 'Fuse4'

when pool_number='108' then 'Fuse18'

when pool_number='101' then 'Fuse7'

when pool_number='109' then 'Fuse6'

when pool_number='103' then 'Fuse14'

else 'Other_Pools'

end as pool_number

from flipside_prod_db.ethereum_core.fact_event_logs

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

AND TX_STATUS = 'SUCCESS'

and event_inputs:amount > 0

AND event_inputs:pool > 100

AND event_inputs:pool != '3'

group by 1,2