freemartianBolide USDT V2
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
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- deposit USDT
select
tx_hash,
decoded_log:from as Depositor,
decoded_log:value/pow(10,decimals) as deposit_amount,
symbol as token_symbol
from bsc.core.ez_decoded_event_logs l
inner join bsc.core.dim_contracts c on c.address = l.contract_address
where event_name = 'Transfer'
and contract_address = '0x55d398326f99059ff775485246999027b3197955'
and origin_function_signature = '0x6e553f65'
and decoded_log:to = '0x881a0faa347e610c0b0f5abaf89dc23bbd6dd702'
limit 5
-- withdraw USDT
select
tx_hash,
decoded_log:to as Withdrawer,
decoded_log:value/pow(10,decimals) as withdraw_amount,
symbol as token_symbol
from bsc.core.ez_decoded_event_logs l
inner join bsc.core.dim_contracts c on c.address = l.contract_address
where event_name = 'Transfer'
and contract_address = '0x55d398326f99059ff775485246999027b3197955'
and origin_function_signature = '0x00f714ce'
and decoded_log:from = '0x881a0faa347e610c0b0f5abaf89dc23bbd6dd702'
--and tx_hash = '0x606652d4ce38289e54b239b6f97596763a8579f69febb25a2d7c02885b29e19c'
limit 10
-- deposit BLID into ETH vault for boost
select
Run a query to Download Data