, sum(from_amount_usd) as swap_volume

, count(distinct tx_id) as n_swaps

from thorchain.defi.fact_swaps s

where block_timestamp >= '2024-06-04' and lower(s.from_address) in

'0x042d21b306d6274c6a12f27b6a94c899d0d0b167'

, '0x04be6616bb87f0a7bda77c19bb761a7da8d195da'

, '0x0770457567feaae5dd8ad4d6e441ccd9dc34b44c'

, '0x085720fd7fcacb6a59340070373ae1660d992769'

, '0x09715f3a4f72032546fb5a9c0500cb701699763f'

, '0x09bee2e57d1c0edca7a45b7d8db4a1c5e806a27e'

, '0x0c3fc56b2b9eb5dc3623a73c1b3787d0f521128c'

, '0x106c62f52907a8348ce93fe7b265cd36c6c64c47'

, '0x110c7971aad9188be4bdf7ac28a96b56f7c52df4'

, '0x11866fe915ad2ed16a1cd45e0c6c648799093f08'

, '0x19c5899132680d07f87ca9186040d7496a4a8e1d'

, '0x1aad6f9793bb2ed50f7dc362faf2a71afdc50876'

, '0x20dc31fe377de1dc5ee837360f3073eee4d3a31e'

, '0x22c6284526fa0f6b3ec00807517c1f5e67417d48'

, '0x23d3397345fd4f74d07c748f8a19a68668cf47d5'

, '0x288d7c57e6a18549d2290f5a1a0eb988ac813418'

, '0x2f2a2f8e1da4b340c47b4373fdb34799f765804d'

, '0x2f6eb9d4e5844135543610d6d3fa67ad799ba30b'

, '0x2f94c5ebd682b14a60d9b8717b073d5434313765'

, '0x30de50679bc2d653d3af62db835416d250deb578'

, '0x35abe1ff5a549659bbef0c9c20cbebbf6bc99a33'

, '0x3c9a9b541db5189b4872a64f1f98d644d1c9604a'

, '0x3ecbe1eefb004cb694a9c0278a9a1e5613ab3357'

, '0x3fc931b0671a912eb6551daf99651aac6e0dd7de'

, '0x455a92a4523034adceaf55ccdb85f379912e3e2e'

, '0x5126672144bb5771674129e2430e28c7871ba388'

, '0x51b940b0d49da59f67921bb64c1d81002db82a24'

, '0x5df2fdfc32b6039cb560367cfcdad6d747afd8d2'

, '0x66ee56fa8f48a73bfd8d9704922d9c361d53e83e'

, '0x6982aaabfc2577cd38d40d73b709351ca60ab394'