TOTAL_BALANCE_IN_OLAS | |
|---|---|
1 | 4842894 |
SniperTotal staked OLAS
Updated 2025-05-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
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')
)
SELECT
gnosis_balance.balance_in_olas
AS total_balance_in_olas
FROM
gnosis_balance
Last run: 23 days ago
1
11B
6s