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 day, TODAY_SWAPS_DOGE, TODAY_SWAPS, TODAY_SWAPS_DOGE/ 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