nasdfajsklj2024-11-11 approvals check
Updated 2024-11-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
select
block_timestamp
,decoded_log:"owner"
,decoded_log:"spender"
,decoded_log:"value"
from arbitrum.core.fact_decoded_event_logs --_event_logs
where 1=1
and block_timestamp between '2024-10-01' and '2024-12-01'
-- and from_address = lower('0x85C153AAe1f101Af08151863306d9e0b823eA1B5')
-- and tx_hash = '0x70c89947aa275a1eeb051eabd6354521475820b2f25e740bd939272383ed7d63' --example of revoking USDC from radiant
-- and contract_address = '' --token address, could filter to USDC but might as well check if other tokens are involved
and decoded_log:"spender" = '0xf4b1486dd74d07706052a33d31d7c0aafd0659e1' --radiant contract
and decoded_log:"owner" = '0xc95c81daf315836934faba6b090e5e937c36d3e8' --example user
--and event_name = 'Approval'
limit 10
QueryRunArchived: QueryRun has been archived