with deposit as (select from_address, count(DISTINCT tx_hash) as stake_txns, count(DISTINCT from_address) as depositors, sum(amount) as deposit_amount, sum(amount_usd) as deposit_volume, avg(amount_usd) as avg_deposit_usd, max(amount_usd) as max_deposit_usd, median(amount_usd) as median_deposit_usd from ethereum.core.ez_token_transfers where contract_address = lower('0xa5f2211b9b8170f694421f2046281775e8468044') and to_address = lower('0x815c23eca83261b6ec689b60cc4a58b54bc24d8d') group by 1) , redeem as ( select to_address, count(DISTINCT tx_hash) as redeem_txns, count(DISTINCT to_address) as withdrawers, sum(amount) as redeemed_amount, sum(amount_usd) as redeemed_volume from ethereum.core.ez_token_transfers where contract_address = lower('0xa5f2211b9b8170f694421f2046281775e8468044') and from_address = lower('0x815c23eca83261b6ec689b60cc4a58b54bc24d8d') and origin_to_address = lower('0x815c23eca83261b6ec689b60cc4a58b54bc24d8d') and tx_hash in (select DISTINCT tx_hash from ethereum.core.ez_token_transfers where contract_address = lower('0x815c23eca83261b6ec689b60cc4a58b54bc24d8d') and to_address = '0x0000000000000000000000000000000000000000') group by 1) , final as ( select a.from_address as users, deposit_amount-ifnull(redeemed_amount,0) as current_balance from deposit a left outer join redeem b on a.from_address = b.to_address ) select count(DISTINCT users) as user, case when current_balance <= 1 then 'a. <= 1 THOR' when current_balance <= 10 then 'b. 1-10 THOR' when current_balance <= 50 then 'c. 10-50 THOR' when current_balance <= 100 then 'd. 50-100 THOR' when current_balance <= 500 then 'e. 100-500 THOR' when current_balance <= 1000 then 'f. 500-1K THOR' when current_balance <= 10000 then 'g. 1K-10K THOR' when current_balance <= 100000 then 'h. 10K-100K THOR' when current_balance <= 500000 then 'i. 100K-500K THOR' when current_balance > 500000 then 'j. > 500K THOR' end as category from final group by 2 order by 2 asc

$THOR Staking 2.0 ($vTHOR)!