shahdadi-9ptm8Yfuse pool USDC allocation
Updated 2022-05-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
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