defi_funds1
Orderbook level market stats. for vertex protocol
Apr 16, 2024 - This SQL query retrieves aggregated data from the `arbitrum.vertex.ez_market_stats` table, combining on-chain data with data from Vertex's ticker V2 API. It calculates the total fee amount and total amount in USD for each ticker_id from the on-chain data. Additionally, it aggregates the last price and quote volume for each ticker_id from the Vertex ticker V2 API data within the last 24 hours. The results are joined based on the ticker_id column and ordered by the third column in descending order.
AXELAR REVENUE JOURNEY FROM Q4 2023 - Q1 2024
Apr 18, 2024 - This SQL query analyzes daily revenue data for the first quarter of 2024 and last quarter of 2023. It calculates various metrics such as revenue ratio, revenue growth, and revenue percentage growth compared to the previous day. The analysis provides insights into daily revenue trends and projections for the future based on the provided dataset from the axelar.stats.ez_core_metrics_hourly INSPIRED BY APOSTLE OF FINANCE
Base Ecosystem in the first week on Q2
Apr 9, 2024 - Analyzing the performance of the Base Ecosystem during the initial week of the second quarter (Q2) involves a comprehensive examination of various metrics and factors to understand the ecosystem's health, growth trajectory, and user engagement dynamics. This analysis aims to provide stakeholders with actionable insights into the ecosystem's performance during a specific timeframe, enabling informed decision-making and strategic planning.
Solana Dex Performance for Q1
Apr 4, 2024 - The comprehensive SQL query for analyzing DEX performances on Solana encompasses various metrics such as trade volumes, liquidity, fees generated, and more. It provides insights into the activities within the DEX ecosystem on the Solana blockchain. This query aggregates data from relevant tables, calculates key performance indicators, and offers a holistic view of DEX performance over a specified timeframe. It enables users to track trends, identify top-performing pools, and make informed decisions based on the comprehensive analysis of DEX activities. including The provided SQL query analyzes swap transactions involving the WEN token and another token $bonk on the Solana blockchain between January 1st, 2024, and March 31st, 2024. It identifies the swap program and counts the number of distinct transactions (`swaps`). The query is modified to include only transactions involving exactly two tokens.
Solana Ecosystem Q1
Apr 2, 2024 - As we have moved into Q2 it is necessary to look at the past metrics of solana Defi ecosystem performance for Q1
Summary analysis on $Pundu fairlunch contribution
Mar 23, 2024 - SOLANA Contributions are now CLOSED 212,404 SOL was collected. 613% oversubscription! Your final allocation will be 15.69% of your SOL deposit. The Remaining 179,071 SOL will be refunded! Hardcap: 33,333 SOL MORE WAS SENT THO
$PUNDU Presale contribution
Mar 22, 2024 - Fair Launch Contribution: ABFxDJUJ8Xkc8JrbpQAjpExSE4ZpfsZymbgXkw67CE5x 1. Raise on Solana Hardcap: 33,333 SOL (SPL) Offering Style: Oversubscription Min Deposit: 0.5 SOL, Lower deposits are used to buy and burn $PUNDU Contributions opened for 36 hrs! Important: 10% of the refunded SOL will be swapped to $DAO (Wormhole) and refunded This is the next Shiba inu token on solana the bears are taking over from the dogs ad the cats 🙌🙌🙌🙌
Overview Of Nft activites for Q1
Mar 18, 2024 - It no doubt that non-fungible tokens(NFT) are really redefining the entire digital Art world by unlocking a very roboust liquidity underlying the in this market. Here is a comprehensive analysis for Nft activities covering: Minted Nfts, Burnt Nfts, TVL/Volume on each Nft market place on solana. Let's explore.
Comprehensive analysis on Gas fees charged on polygon per hour
Mar 16, 2024 - Gain insight on what is going with gas fees on polygon blockchain covering it effect on hourly transaction on polygon blockchain.
Analyst Corne
Mar 9, 2024 - Hi guys this is an analysis that covered what has been going on with polygon in the past 180 days covering: 180 days daily swap on polygon; Total trading volume on polygon in the last180 days ; Dex with most daily swap on polygon in the past 180 days; Accounts with up to 100 transaction in the last 180 days on polygon;. This helps you to gain insight on what is happening on the polygon blockchain in the past few days so as to make some great decisions in your journey here in the space and also to stay ahead of others when it comes to leveraging on opportunities. Remember if it is trending!! You are late!!