pecio222
TJ volume
Jun 25, 2024 - Queries start: 1711929600 --Monday, 1 April 2024 00:00:00 Note, that not all users are shown on TJ Routers - only tx_count > 2 (or else there will be limit of 100k records anyway)
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
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)
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.
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
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
autopool composition fees
Jul 11, 2023 - comparison of AUM fees collected versus composition fees paid on all rebalances for different pools
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.