NavidCopy of Untitled Query
Updated 2023-04-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
select
'Completed' as type,
sum(raw_amount/pow(10,18))/125000000*100 as progress,
progress*125000000 as val
from
ethereum.core.ez_token_transfers
where
CONTRACT_ADDRESS='0x44108f0223a3c3028f5fe7aec7f9bb2e66bef82f' AND
FROM_ADDRESS='0xe50b2ceac4f60e840ae513924033e753e2366487'
union all
select
'Not Completed' as type,
sum(raw_amount/pow(10,18))/125000000*100 as progress,
(100-progress)*125000000 as val
from
ethereum.core.ez_token_transfers
where
CONTRACT_ADDRESS='0x44108f0223a3c3028f5fe7aec7f9bb2e66bef82f' AND
FROM_ADDRESS='0xe50b2ceac4f60e840ae513924033e753e2366487'
Run a query to Download Data