GE | OPT | TOTAL_BALANCE_IN_OLAS | |
|---|---|---|---|
1 | 2992204 | 160 | 2992364 |
mamad-5XN3k3Total staked OLAS copy
Updated 2025-02-16
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
›
⌄
⌄
-- forked from MLDZMN / Total staked OLAS @ https://flipsidecrypto.xyz/MLDZMN/q/lDI3EuQYet6U/total-staked-olas
WITH gnosis_balance AS (
SELECT
*
/*COALESCE(SUM(CASE WHEN TO_ADDRESS = lower('0xa45E64d13A30a51b91ae0eb182e88a40e9b18eD8') THEN AMOUNT ELSE 0 END), 0) AS total_received_in_olas,
COALESCE(SUM(CASE WHEN FROM_ADDRESS = lower('0xa45E64d13A30a51b91ae0eb182e88a40e9b18eD8') THEN AMOUNT ELSE 0 END), 0) AS total_sent_in_olas,
COALESCE(SUM(CASE WHEN TO_ADDRESS = lower('0xa45E64d13A30a51b91ae0eb182e88a40e9b18eD8') THEN AMOUNT ELSE 0 END), 0)
- COALESCE(SUM(CASE WHEN FROM_ADDRESS = lower('0xa45E64d13A30a51b91ae0eb182e88a40e9b18eD8') THEN AMOUNT ELSE 0 END), 0) AS balance_in_olas*/
FROM gnosis.core.ez_token_transfers
WHERE contract_address = lower('0xcE11e14225575945b8E6Dc0D4F2dD4C570f79d9f')
),
optimism_balance AS (
SELECT
COALESCE(SUM(CASE WHEN TO_ADDRESS = lower('0xBb7e1D6Cb6F243D6bdE81CE92a9f2aFF7Fbe7eac') THEN AMOUNT ELSE 0 END), 0) AS total_received_in_olas,
COALESCE(SUM(CASE WHEN FROM_ADDRESS = lower('0xBb7e1D6Cb6F243D6bdE81CE92a9f2aFF7Fbe7eac') THEN AMOUNT ELSE 0 END), 0) AS total_sent_in_olas,
COALESCE(SUM(CASE WHEN TO_ADDRESS = lower('0xBb7e1D6Cb6F243D6bdE81CE92a9f2aFF7Fbe7eac') THEN AMOUNT ELSE 0 END), 0)
- COALESCE(SUM(CASE WHEN FROM_ADDRESS = lower('0xBb7e1D6Cb6F243D6bdE81CE92a9f2aFF7Fbe7eac') THEN AMOUNT ELSE 0 END), 0) AS balance_in_olas
FROM optimism.core.ez_token_transfers
WHERE
contract_address = lower('0xFC2E6e6BCbd49ccf3A5f029c79984372DcBFE527')
)
SELECT
gnosis_balance.balance_in_olas as ge,
optimism_balance.balance_in_olas as opt,
gnosis_balance.balance_in_olas + optimism_balance.balance_in_olas AS total_balance_in_olas
FROM
gnosis_balance,
optimism_balance
Last run: 30 days ago
1
23B
5s