CURRENT_DEPOSITS | |
|---|---|
1 | 81878720.6198294 |
freemartianTotal Stake
Updated 2025-03-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with deposits AS(
SELECT block_timestamp, tx_hash, from_address AS user, amount
FROM base.core.ez_token_transfers
WHERE contract_address = '0x3e64cd8fd4d2fae3d7f4710817885b0941838d0b'
AND to_address = '0x2b31bdb96cca849f128b56b3f8f84c89dad5719d'
AND origin_function_signature = '0xb6b55f25'
UNION ALL
SELECT block_timestamp, tx_hash, to_address AS user, -amount AS amount
FROM base.core.ez_token_transfers
where contract_address = '0x3e64cd8fd4d2fae3d7f4710817885b0941838d0b'
AND from_address = '0x2b31bdb96cca849f128b56b3f8f84c89dad5719d'
AND origin_function_signature = '0x2e1a7d4d'
)
SELECT SUM(amount) AS current_deposits FROM deposits
Last run: 21 days agoAuto-refreshes every 1 hour
1
20B
763s