![pecio222 | Flipside Analyst pecio222 | Flipside Analyst](https://res.cloudinary.com/dsr37ut2z/image/upload/assets/backgrounds/analyst-bg.png)
pecio222
JOE Router swaps amount
Oct 3, 2022 - Swaps only: swapExactTokensForTokens(uint256,uint256,address[],address,uint256) 0x38ed1739 swapExactTokensForAVAX(uint256,uint256,address[],address,uint256) 0x676528d1 swapExactAVAXForTokens(uint256,address[],address,uint256) 0xa2a1623d swapTokensForExactTokens(uint256,uint256,address[],address,uint256) 0x8803dbee swapAVAXForExactTokens(uint256,address[],address,uint256) 0x8a657e67 swapExactTokensForTokensSupportingFeeOnTransferTokens(uint256,uint256,address[],address,uint256) 0x5c11d795 swapExactTokensForAVAXSupportingFeeOnTransferTokens(uint256,uint256,address[],address,uint256) 0x762b1562 swapTokensForExactAVAX(uint256,uint256,address[],address,uint256) 0x7a42416a swapExactAVAXForTokensSupportingFeeOnTransferTokens(uint256,address[],address,uint256) 0xc57559dd
ROUTERS' FAILED TRANSACTIONS
Apr 8, 2023 - `BEFORE/AFTER` columns relate to LegacyLBRouter, X days before gas limit fix (est. 1680714000 -> Wednesday, April 5, 2023 17:00:00 UTC) and after gas limit fix. Amount of days can be changed by modifying parameter time_before (in seconds). 604800 -> 7 days, 1296000 -> 15 days, 2592000 -> 30 days, `V21` relates to new Router 2.1. `FAIL` columns show percentage of given function transactions that were failing
LB swap behaviour
Sep 25, 2023 - All data in this dashboard is about ETH-USDC.e pool, can be changed by applying pool_address parameter (while being logged in to flipside). different pools give very different characteristics of usage. all queries are using "swap" events emited by given pool, so volume is counted regardless of where it originated
![curve curve](https://res.cloudinary.com/dsr37ut2z/image/upload/assets/project-icons/curve.png)
JOE_HOLDERS
Dec 20, 2022 - Queries below operate under assumption for sJOE and veJOE, that whoever initiated transaction is owner of Joe that was sent to end contract, which is a) 'fair' for user (not really?) b) not exactly true. This gives credit for owning Joe to anyone that uses Yield Yak compounder, zapped with hJOE etc. This can be changed. This query doesn't include any LPs.
EURC buyers
Jun 9, 2023 - Only EOA addresses, that used LBRouter directly are took into consideration. This does NOT include: arbitrage contracts, aggregators. Does not include any sells either.
Autopool AVAX
Jun 2, 2023 - GET DATA FROM: https://snowtrace.io/address/0x32833a12ed3fd5120429fb01564c98ce3c60fc1d#readProxyContract token X - AVAX (input price in tokenXPrice) token Y - USDC (price hardcoded a 1)
DEPOSITOR FIRST TX DATE
Sep 21, 2023 - transactions to contracts are not supported (autopools, vaults, strategies, floor tokens etc)
LBPair daily volatility
Dec 2, 2023 - Pool address can be customized, as well as start date. Find pools address on TJ website, and timestamp from https://www.epochconverter.com/ Need to be logged in to Flipside to change parameters default timestamp 1672531200 shows all existing data Bin volatility is defined as MAX_BIN-MIN_BIN. Actual volatility might have been higher, as price doesn't move in a straight line
GAS COSTS PER MAKER
Jan 20, 2024 - NOTES: LimitOrderManager is ignored i'm not 100% sure about results (yet), there are weird interactions with Delta Prime (and others?) change pool to any address and it should work, query might take some time
autopool composition fees
Jul 11, 2023 - comparison of AUM fees collected versus composition fees paid on all rebalances for different pools
Autopool ARBI
Jun 2, 2023 - GET DATA FROM: https://arbiscan.io/address/0xfd421d60905d2f7cabd49e6a5703a3499367b8f4#readProxyContract token X - ETH (input price in tokenXPrice) token Y - USDC (price hardcoded a 1)
![[Easy] Ideal Airdrop Recipients: Part One [Easy] Ideal Airdrop Recipients: Part One](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
[Easy] Ideal Airdrop Recipients: Part One
Oct 12, 2021 - In paragraphs below I will try to identify potential metrics, that will differentiate between good airdrop receivers and less desirable ones.