nitsHow many users withdrew a day before ?
    Updated 2022-01-29
    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