ramishoowUntitled Query
Updated 2022-09-29
9
1
2
3
4
›
⌄
select ORIGIN_FROM_ADDRESS as address , sum(event_inputs:value)/1e18 as amounnt from ethereum.core.fact_event_logs
where block_timestamp::date >= '2022-08-01' and contract_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
and origin_to_address = '0x3b968d2d299b895a5fcf3bba7a64ad0f566e6f88' and event_name = 'Deposit' and origin_function_signature = '0x58c22be7'
group by 1 having amounnt> 0 order by 2 desc limit 5
Run a query to Download Data