IBC_insiderOptimism mega part 20 wothdraw
Updated 2023-01-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
(SELECT sum(AMOUNT_USD) token,SYMBOL from ethereum.core.ez_token_transfers
where
SYMBOL!='OP' AND AMOUNT_USD IS NOT NULL AND
(to_ADDRESS=lower('0x99C9fc46f92E8a1c0deC1b1747d010903E884bE1')
OR
to_ADDRESS=lower('0x52ec2F3d7C5977A8E558C8D9C6000B615098E8fC')) and BLOCK_TIMESTAMP>CURRENT_DATE-7
group by 2
order by 1 desc)
UNION
(
SELECT SUM(AMOUNT)*30 AS token, SYMBOL from ethereum.core.ez_token_transfers
where
SYMBOL='OP' AND
(to_ADDRESS=lower('0x99C9fc46f92E8a1c0deC1b1747d010903E884bE1')
OR
to_ADDRESS=lower('0x52ec2F3d7C5977A8E558C8D9C6000B615098E8fC')) and BLOCK_TIMESTAMP>CURRENT_DATE-7
GROUP BY 2)
ORDER BY token DESC
Run a query to Download Data