nitsHow many users withdrew a day before ?
Updated 2022-01-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with not_new_users as (SELECT from_address from (select from_address, min(block_timestamp) as first_use from thorchain.swaps
where from_address in
(select unique_LP_providers from (select DISTINCT from_address as unique_LP_providers from thorchain.swaps
where to_asset like '%DOGE%' ))
GROUP by from_address) where first_use < '2021-01-15'),
doge_lp_first_use as (select from_address as unique_LP_providers , min(block_timestamp) as doge_first_use from thorchain.swaps
where to_asset like '%DOGE%'
GROUP by from_address )
select count(DISTINCT from_address) as users_who_withdrew_from_other_pools, sum(from_amount_usd)/pow(10,6) as total_lqiudity_withdrawn_in_M , avg(from_amount_usd) as avg_withdrawal from
(select * from thorchain.swaps
where from_address not in (select * from not_new_users))
inner join doge_lp_first_use
on from_address = unique_LP_providers and block_timestamp < doge_first_use and block_timestamp > date(doge_first_use ) -1 and to_asset = 'THOR.RUNE'
limit 1000
Run a query to Download Data