0xtoshitokenomy_summary
Updated 2024-05-30
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
›
⌄
With TokenomyStaker as (
SELECT FROM_ADDRESS as address,
zeroifnull(sum(RAW_AMOUNT/1e18)) as deposit
FROM base.core.fact_token_transfers
WHERE TO_ADDRESS = '0x5f0166c0d1c63baef825183edc6466a6e4dfa8a2'
AND CONTRACT_ADDRESS = '0x4fb9b20dafe45d91ae287f2e07b2e79709308178'
GROUP BY 1
),
TokenomyUnstaker as (
SELECT TO_ADDRESS as address,
zeroifnull(-1 * sum(RAW_AMOUNT/1e18)) as withdraw
FROM base.core.fact_token_transfers
WHERE FROM_ADDRESS = '0x5f0166c0d1c63baef825183edc6466a6e4dfa8a2'
AND CONTRACT_ADDRESS = '0x4fb9b20dafe45d91ae287f2e07b2e79709308178'
GROUP BY 1
)
SELECT COUNT(DISTINCT users) as users,
sum(deposit_amount) as total_deposit,
sum(withdraw_amount) as total_withdraw,
sum(net_deposit) as net_volume
FROM(
SELECT d.address as users,
zeroifnull(deposit) as deposit_amount,
zeroifnull(withdraw) as withdraw_amount,
deposit_amount + withdraw_amount as net_deposit
FROM TokenomyStaker d LEFT JOIN TokenomyUnstaker w ON d.address = w.address
ORDER BY 4 DESC
)
QueryRunArchived: QueryRun has been archived