freemartianBolide Deposits & Withdraws Altcoins
Updated 2023-09-10
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 altcoins
select
tx_hash,
decoded_log:from as Depositor,
decoded_log:value/pow(10,decimals) as deposit_amount,
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 in (
'0x7083609fce4d1d8dc0c979aab8c869ea2c873402',
'0xcc42724c6683b7e57334c4e856f4c9965ed682bd',
'0xcf6bb5389c92bdda8a3747ddb454cb7a64626c63',
'0x3ee2200efb3400fabb9aacf31297cbdd1d435d47',
'0xf8a0bf9cf54bb92f17374d9e9a321e6a111a51bd',
'0x1d2f0da169ceb9fc7b3144628db156f3f6c60dbe',
'0x4338665cbb7b2485a8855a139b75d5e34ab0db94')
and origin_function_signature = '0x6e553f65'
and decoded_log:to = '0x5d735e9ffe9664b80c405d16921912e5b989688c'
limit 10
-- withdraw altcoins
select
tx_hash,
decoded_log:to as Withdrawer,
decoded_log:value/pow(10,decimals) as withdraw_amount,
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 in (
'0x7083609fce4d1d8dc0c979aab8c869ea2c873402',
'0xcc42724c6683b7e57334c4e856f4c9965ed682bd',
'0xcf6bb5389c92bdda8a3747ddb454cb7a64626c63',
Run a query to Download Data