keshanimpact of terra on thor
    Updated 2022-04-16
    with all_users as (
    select distinct(rune_address) as address, min(block_timestamp::date) as date from thorchain.stake_events group by address
    union
    select distinct(from_address) as address, min(block_timestamp::date) as date from thorchain.swaps where blockchain='THOR' group by address
    union
    select distinct(from_address) as address, min(block_timestamp::date) as date from thorchain.transfers group by address
    union
    select distinct(to_address) as address, min(block_timestamp::date) as date from thorchain.transfers group by address
    union
    select distinct(from_address) as address, min(block_timestamp::date) as date from thorchain.liquidity_actions where from_address is not null group by address
    ),
    all_addresses as (select distinct(address) as address, min(date) as date from all_users group by address)

    select terra_launch, date, count(address)
    from (
    select address, date, case when date >= '2022-3-25' then 'After' else 'Before' end as terra_launch from all_addresses
    )
    group by terra_launch, date
    Run a query to Download Data