select date_trunc('day', block_timestamp) as dt, sum(rune_amount_usd) as rune_vol, sum(asset_amount_usd) as doge_vol, count(distinct from_address) as provider
from thorchain.liquidity_actions
where pool_name = 'DOGE.DOGE' and lp_action = 'add_liquidity'
group by 1