/* ------ BSC select SYMBOL_IN, SYMBOL_OUT, POOL_NAME, CONTRACT_ADDRESS, PLATFORM, EVENT_NAME, COUNT(DISTINCT TX_HASH) as count from bsc.defi.ez_dex_swaps where BLOCK_TIMESTAMP<'2022-05-13 00:00:00.000' and BLOCK_TIMESTAMP>'2022-05-01 00:00:00.000' and SYMBOL_IN ='UST' OR SYMBOL_OUT='UST' group by 1,2,3,4,5,6 --- Avalanche select SYMBOL_IN, SYMBOL_OUT, POOL_NAME, CONTRACT_ADDRESS, PLATFORM, COUNT(DISTINCT TX_HASH) as count from avalanche.defi.ez_dex_swaps where BLOCK_TIMESTAMP<'2022-05-13 00:00:00.000' and BLOCK_TIMESTAMP>'2022-05-01 00:00:00.000' and SYMBOL_IN ='UST' OR SYMBOL_OUT='UST' group by 1,2,3,4,5 --- Ethereum select SYMBOL_IN, SYMBOL_OUT, POOL_NAME, CONTRACT_ADDRESS, PLATFORM, COUNT(DISTINCT TX_HASH) as count from ethereum.defi.ez_dex_swaps where BLOCK_TIMESTAMP<'2022-05-13 00:00:00.000' and BLOCK_TIMESTAMP>'2022-05-01 00:00:00.000' and SYMBOL_IN ='UST' OR SYMBOL_OUT='UST' group by 1,2,3,4,5 -- Sur Solona -- pas de tokens symbol, on recup dans solscan l'adresse du token UST portal --UST portal '9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i' -- il existe un token ust wormwhole v1 mais qui n'est quasi pas tradé SELECT SWAP_PROGRAM, SWAP_FROM_MINT, SWAP_TO_MINT, PROGRAM_ID, --tx_id COUNT(DISTINCT TX_ID) as count from solana.defi.fact_swaps--solana.defi.fact_liquidity_pool_actions where BLOCK_TIMESTAMP<'2022-05-13 00:00:00.000' and BLOCK_TIMESTAMP>'2022-05-01 00:00:00.000' and SWAP_TO_MINT='9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i' OR SWAP_FROM_MINT='9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i' group by 1,2,3,4 order by count desc limit 100 --- uniswap v3 (PAS BESOIN est inclus dans eth swap) select TOKEN1_SYMBOL, TOKEN1_ADDRESS, TOKEN0_SYMBOL, TOKEN0_ADDRESS, POOL_NAME, POOL_ADDRESS, COUNT(DISTINCT TX_HASH) as count from ethereum.uniswapv3.ez_swaps where BLOCK_TIMESTAMP<'2022-05-13 00:00:00.000' and BLOCK_TIMESTAMP>'2022-05-01 00:00:00.000' and TOKEN1_ADDRESS ='0xa693B19d2931d498c5B318dF961919BB4aee87a5' OR TOKEN1_ADDRESS='0xa693B19d2931d498c5B318dF961919BB4aee87a5' or TOKEN0_ADDRESS ='0xa47c8bf37f92abed4a126bda807a7b7498661acd' OR TOKEN0_ADDRESS='0xa47c8bf37f92abed4a126bda807a7b7498661acd' group by 1,2,3,4,5,6 -- sur arbitrum, on s'en fiche, moins de 200 transactions select SYMBOL_IN, SYMBOL_OUT, POOL_NAME, CONTRACT_ADDRESS, PLATFORM, COUNT(DISTINCT TX_HASH) as count from arbitrum.defi.ez_dex_swaps where BLOCK_TIMESTAMP<'2022-05-13 00:00:00.000' and BLOCK_TIMESTAMP>'2022-05-01 00:00:00.000' group by 1,2,3,4,5 --- manque solana et les count ne matchent pas exactement sur bsc, eth et avalanche + bring in polygon select SYMBOL_IN, SYMBOL_OUT, token_IN, token_OUT, BLOCKCHAIN, CONTRACT_ADDRESS, PLATFORM, COUNT(DISTINCT TX_HASH) as count from crosschain.defi.ez_dex_swaps where BLOCK_TIMESTAMP<'2022-05-13 00:00:00.000' and BLOCK_TIMESTAMP>'2022-05-01 00:00:00.000' and SYMBOL_IN ='UST' OR SYMBOL_OUT='UST' OR token_IN ='UST' OR token_OUT='UST' group by 1,2,3,4,5,6,7 --- Polygon select SYMBOL_IN, SYMBOL_OUT, POOL_NAME, CONTRACT_ADDRESS, PLATFORM, COUNT(DISTINCT TX_HASH) as count from polygon.defi.ez_dex_swaps where BLOCK_TIMESTAMP<'2022-05-13 00:00:00.000' and BLOCK_TIMESTAMP>'2022-05-01 00:00:00.000' and SYMBOL_IN ='UST' OR SYMBOL_OUT='UST' OR token_IN ='UST' OR token_OUT='UST' group by 1,2,3,4,5 -- Astroport pools select OFFER_CURRENCY, RETURN_CURRENCY, POOL_NAME, POOL_ADDRESS, --PLATFORM, COUNT(DISTINCT TX_ID) as count from terra.classic.ez_astroport_swaps where BLOCK_TIMESTAMP<'2022-05-13 00:00:00.000' and BLOCK_TIMESTAMP>'2022-05-01 00:00:00.000' and OFFER_CURRENCY ='uusd' OR RETURN_CURRENCY='uusd' group by 1,2,3,4--,5 SELECT ADDRESS, ADDRESS_NAME, CREATOR, LABEL, LABEL_SUBTYPE, LABEL_TYPE from terra.classic.dim_labels group by 1,2,3,4, 5,6 */ SELECT FROM_ASSET, TO_ASSET, COUNT(DISTINCT TX_ID) as count from thorchain.defi.fact_swaps where BLOCK_TIMESTAMP<'2022-05-13 00:00:00.000' and BLOCK_TIMESTAMP>'2022-05-01 00:00:00.000' group by 1,2

maytsu