Pipo
USDC deposits to PoolTogether
Jun 22, 2022 - *USDC deposits to PoolTogether is made by depositing to the following addresses: '0xde9ec95d7708b8319ccca4b8bc92c0a3b70bf416', -- USDC price pool '0x32e8D4c9d1B711BC958d0Ce8D14b41F77Bb03a64', -- PoolTogether aUSDC Yield '0xd89a09084555a7d0abe7b111b1f78dfeddd638be' -- YieldSourcePrizePool
stETH/ETH Fluctuation
Jun 13, 2022 - For this analysis I took the data from June 18th 2021 to December 3rd 2021.
Most Common Transactions for Metamask Users
Jun 25, 2022 - * For this analysis in some instances due to the fact that some fields have blank rows, I based on an approximation when referring to the insights. * I defined Metamask wallets (users) as wallets who have used the Metamask swap feature
Algorand Price Correlation
Jun 29, 2022 - * BTC and ETH line charts are based on WBTC and WETH respectively which is equal in price. * For this analysis data is based on the last 180 days.
Prizes in PoolTogether
Jun 22, 2022 - * Assumptions for this analysis - Date when the prize was claimed is the same when the prize was withdrawn. - I considered withdrawing same as claiming as when withdrawing you require to burn tokens. - I based the amount of prizes awarded/claimed based on the number of unique transactions in each query.
ERC20 Tokens (zkSync)
Jun 17, 2022 - * Analysis is based on the last 60 days and figures for all charts reflect deposits into ZkSync. I took the Top 10 ERC20 tokens.
User activity in NFTX vaults
Jun 13, 2022 - A couple of definitions to keep in mind for this analysis: * Data based on the last 60 days. * Liquidity from NFTX vaults refers to transfers and trades. * Total sales volume refers to transactions where someone redeemed their NFTX tokens for a specific NFT. * I decided to filter down to the Top 10 NFT projects in terms of Total Value Locked in the NFTX platform to analyse user activity. * Due to missing fields in the ethereum.core.fact_event_logs table, below a snapshot of the Top 10 NFT projects by TVL. '0xb47e3cd837dDF8e4c57F05d70Ab865de6e193BBB' --> cryptopunks '0x8a90CAb2b38dba80c64b7734e58Ee1dB38B8992e' --> doodle 0x521f9C7505005CFA19A8E5786a9c3c9c9F5e6f42' --> wizard '0x7Bd29408f11D2bFC23c34f18275bBf23bB716Bc7' --> meeb '0x5Af0D9827E0c53E4799BB226655A1de152A425a5' --> mylady '0x059EDD72Cd353dF5106D2B9cC5ab83a52287aC3a' --> sqgl '0xe785E82358879F061BC3dcAC6f0444462D4b5330' --> wow '0x60E4d786628Fea6478F785A6d7e704777c86a7c6' --> mayc '0x34d85c9CDeB23FA97cb08333b511ac86E1C4E258' --> otherdeed '0xFF9C1b15B16263C61d017ee9F65C50e4AE0113D7' --> loot * Due to missing fields in the ethereum.core.ez_nft_sales table, as reflected in the second graph, 'null' refers to the Moshi Mochi project.