Based on the Swap Count

Eman-RazBased on the Swap Count

Updated 2023-08-17

with final_tab as (with tab1 as (select symbol_in,

sum(amount_in_usd) as selling_vol,

count(distinct tx_hash) as selling_count, COUNT(DISTINCT SYMBOL_OUT) AS SELLING_PAIRS

from avalanche.core.ez_dex_swaps

where token_in in ('0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7',

'0x22d4002028f537599be9f666d1c4fa138522f9c8'

,'0x60781c2586d68229fde47564546784ab3faca982'

,'0x6e84a6216ea6dacc71ee8e6b0a5b7322eebc0fdd'

,'0xeeee99b35eb6af5e7d76dd846dbe4bcc0c60ca1d'

,'0x3712871408a829c5cd4e86da1f4ce727efcd28f6'

,'0xeeeeeb57642040be42185f49c52f7e9b38f8eeee'

,'0x8729438eb15e2c8b576fcc6aecda6a148776c0f5'

,'0x31c994ac062c1970c086260bc61babb708643fac'

,'0xb54f16fb19478766a268f172c9480f8da1a7c9c3'

,'0xec3492a2508ddf4fdc0cd76f31f340b30d1793e6'

,'0x1fe70939c2cec8f31e8f7729442658586b469972'

,'0xfcde4a87b8b6fa58326bb462882f1778158b02f1'

,'0xd1c3f94de7e5b45fa4edbba472491a9f4b166fc4'

,'0xd4d026322c88c2d49942a75dff920fcfbc5614c1'

,'0x961c8c0b1aad0c0b10a51fef6a867e3091bcef17'

,'0x03e8d118a1864c7dc53bf91e007ab7d91f5a06fa'

--,'0xa56f9a54880afbc30cf29bb66d2d9adcdcaeadd6'

,'0x59414b3089ce2af0010e7523dea7e2b35d776ec7'

,'0x4bfc90322dd638f81f034517359bd447f8e0235a'

,'0xa4fb4f0ff2431262d236778495145ecbc975c38b'

,'0x333000333b26ee30214b4af6419d9ab07a450400'

,'0xb2a85c5ecea99187a977ac34303b80acbddfa208'

,'0x7d1232b90d3f809a54eeaeebc639c62df8a8942f'

,'0x5817d4f0b62a59b17f75207da1848c2ce75e7af4'

,'0xc11bf915db4b43714bc8d32bf83bf5ea53d40981'

,'0x48f88a3fe843ccb0b5003e70b4192c1d7448bef0'

,'0xb0a6e056b587d0a85640b39b1cb44086f7a26a1e'

,'0x1b88d7ad51626044ec62ef9803ea264da4442f32'

,'0xb27c8941a7df8958a1778c0259f76d1f8b711c35'

,'0xbd3936ec8d83a5d4e73eca625ecfa006da8c8f52'

,'0x9e3ca00f2d4a9e5d4f0add0900de5f15050812cf'

Run a query to Download Data

flipside