Abolfazl_771025Squid user categorize
Updated 2023-03-03
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
›
⌄
with main as (select
a.origin_from_address as sender,
'Arbitrum' as from_chain
from arbitrum.core.fact_token_transfers a join arbitrum.core.fact_event_logs b on a.tx_hash=b.tx_hash
where a.to_address LIKE lower('0xce16f69375520ab01377ce7b88f5ba8c48f8d666')
and a.contract_address LIKE lower('0xEB466342C4d449BC9f53A865D5Cb90586f405215')
and topics[0] = '0x999d431b58761213cf53af96262b67a069cbd963499fd8effd1e21556217b841'
group by 1,2
union
select
a.origin_from_address as sender,
'Polygon' as from_chain
from polygon.core.fact_token_transfers a join polygon.core.fact_event_logs b on a.tx_hash=b.tx_hash
where a.to_address LIKE lower('0xce16f69375520ab01377ce7b88f5ba8c48f8d666')
and a.contract_address LIKE lower('0x750e4C4984a9e0f12978eA6742Bc1c5D248f40ed')
and topics[0] = '0x999d431b58761213cf53af96262b67a069cbd963499fd8effd1e21556217b841'
group by 1,2
union
select
a.origin_from_address as sender,
'Binance smart chain' as from_chain
from bsc.core.fact_token_transfers a join bsc.core.fact_event_logs b on a.tx_hash=b.tx_hash
where a.to_address LIKE lower('0xce16f69375520ab01377ce7b88f5ba8c48f8d666')
and a.contract_address LIKE lower('0x4268B8F0B87b6Eae5d897996E6b845ddbD99Adf3')
and topics[0] = '0x999d431b58761213cf53af96262b67a069cbd963499fd8effd1e21556217b841'
group by 1,2
union
select
a.origin_from_address as sender,
'Avalanche' as from_chain
from avalanche.core.fact_token_transfers a join avalanche.core.fact_event_logs b on a.tx_hash=b.tx_hash
where a.to_address LIKE lower('0xce16f69375520ab01377ce7b88f5ba8c48f8d666')
and a.contract_address LIKE lower('0xfaB550568C688d5D8A52C7d794cb93Edc26eC0eC')
and topics[0] = '0x999d431b58761213cf53af96262b67a069cbd963499fd8effd1e21556217b841'
group by 1,2
)
Run a query to Download Data