granadohoUSDC Pool
Updated 2022-03-23
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT
event_inputs:pool as pool_no,
sum(event_inputs:amount)/pow(10,6) as USDC_amount
FROM ethereum.events_emitted
WHERE lower(contract_address) = lower('0x66f4856f1bbd1eb09e1c8d9d646f5a3a193da569')
AND tx_succeeded = 'TRUE'
AND tx_to_label_subtype = 'pool'
AND event_name = 'PoolAllocation'
AND event_inputs:pool != 3
group by 1
order by 1
Run a query to Download Data