nitsDOGE swaps impact net
    Updated 2022-01-22
    with total_swaps as (select date(block_timestamp) as day, sum(from_amount_usd) as today_swaps from thorchain.swaps
    where block_timestamp > (select min(block_timestamp) as first_ from thorchain.swaps
    where contains(from_asset, 'DOGE') or contains(to_asset, 'DOGE'))
    GROUP by day )
    select sum(TODAY_SWAPS_DOGE)/ sum(TODAY_SWAPS)*100 as percent_impact from
    (select date(block_timestamp) as day_, sum(from_amount_usd) as today_swaps_doge from thorchain.swaps
    where contains(from_asset, 'DOGE') or contains(to_asset, 'DOGE')
    GROUP by day_ )
    inner join total_swaps
    on day = day_
    limit 100
    Run a query to Download Data