what signifies a whale? What percent of whales participate in swaps? the number of swaps per whale in 2022

gholiwhat signifies a whale? What percent of whales participate in swaps? the number of swaps per whale in 2022

Updated 2022-04-20

select 'number of whales ' , count(address) from (select sum(balance) as balance_amount, address from algorand.account

group by address

having balance_amount > 50000

)

UNION

-- -

select 'number of whales swaps' , count(DISTINCT swapper) from algorand.swaps where swapper in (select address from algorand.account

having balance > 50000)

UNION

select 'percentage of whales swaps' , count(DISTINCT swapper)/2971 * 100 from algorand.swaps where swapper in (select address from algorand.account

having balance > 50000)

Run a query to Download Data

flipside