select pool_name, sum(from_amount_usd)/pow(10,6) as total_swap_amt_in_M_USD, count(DISTINCT from_address) as unique_users from
(select * from (select pool_name as pn , min(block_timestamp) as first_addition from thorchain.swaps
GROUP by pool_name)
inner join thorchain.swaps
on pool_name = pn and timestampdiff(SQL_TSI_HOUR, first_addition, block_timestamp)< 24)
GROUP by pool_name
order by total_swap_amt_in_M_Usd desc
limit 100