keshanimpact of terra on thor
Updated 2022-04-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
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