0xtoshitokenomy_summary
    Updated 2024-05-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