shahdadi-9ptm8Yfuse pool USDC allocation
    Updated 2022-05-24
    SELECT event_inputs:pool as pool_number, sum(event_inputs:amount)/pow(10,6) as usdc_amount,
    case
    when pool_number='100' then 'FuseR4'
    when pool_number='101' then 'Fuse7'
    when pool_number='102' then 'Fuse13'
    when pool_number='103' then 'Fuse14'
    when pool_number='104' then 'Fuse15'
    when pool_number='106' then 'Fuse11'
    when pool_number='108' then 'Fuse18'
    when pool_number='109' then 'Fuse6'
    else 'other pool'
    end as pool_name
    FROM flipside_prod_db.ethereum.events_emitted
    WHERE lower(contract_address) = lower('0x66f4856f1bbd1eb09e1c8d9d646f5a3a193da569') -- USDC
    and tx_succeeded = 'TRUE' and pool_number<>'3'
    and event_name = 'PoolAllocation'
    group by 1
    Run a query to Download Data