hbd1994Untitled Query
Updated 2022-09-24
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
›
⌄
(SELECT
'Mellat Bank' as bank_name, count(distinct POOL_NAME) as pool_count
from ethereum.core.ez_dex_swaps
where AMOUNT_OUT_USD is not null
and ORIGIN_FROM_ADDRESS = '0xd7e1236c08731c3632519dcd1a581bfe6876a3b2'
)
union
(SELECT
'Melli Bank' as bank_name,count(distinct POOL_NAME) as pool_count
from ethereum.core.ez_dex_swaps
where AMOUNT_OUT_USD is not null
and ORIGIN_FROM_ADDRESS = '0x1fd34033240c95aabf73e186a94b9576c6dab81b'
)
Run a query to Download Data