-- What are the various clusters of behavior among THORChain addresses?
-- One cluster we would expect to see would be arbitrage bot addresses,
-- but feel free to get creative in the clusters you identify.
-- Hint: Use whatever Tables you want!
-- Transaction Volume
-- Transaction Frequency
-- Joining Date
-- Common swaps
with base_txns as (
select
from_address as wallet,
min(block_timestamp) as joining_date
from
thorchain.swaps
group by wallet
)
select
date_trunc('month',joining_date) as date,
count(distinct(wallet)) as n_wallets
from base_txns
group by date