AzinTotal swap number
Updated 2023-02-15Copy Reference Fork
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
›
⌄
--bridge in 0x3c659741
--bridge in and swap 0x8ca3bf68
-- swap only
-- bridge out 0xf35af1f8
(select count(*) as ethereum , 'ethereum' as blockchain
from ethereum.core.fact_event_logs
where
EVENT_NAME='Swap'
and
ORIGIN_TO_ADDRESS='0xce16f69375520ab01377ce7b88f5ba8c48f8d666')
union all
(select count(*) as arbitrum , 'arbitrum' as blockchain
from arbitrum.core.fact_event_logs
where
EVENT_NAME='Swap'
and
ORIGIN_TO_ADDRESS='0xce16f69375520ab01377ce7b88f5ba8c48f8d666')
union all
(select count(*) as avalanche , 'avalanche' as blockchain
from avalanche.core.fact_event_logs
where
EVENT_NAME='Swap'
and
ORIGIN_TO_ADDRESS='0xce16f69375520ab01377ce7b88f5ba8c48f8d666')
union all
(select count(*) as bsc , 'bsc' as blockchain
from bsc.core.fact_event_logs
where
EVENT_NAME='Swap'
Run a query to Download Data