Clefcodex

@smartymetrics @AnalyticSages Good job. Well detailed

I'm excited to share the results of my latest capstone project from the topics I was taught at @AnalyticSages! Python cohort 1. I built a data pipeline using Python to investigate the relationship between large cryptocurrency transactions and price movement. My video explainer answers the big question: Does price increase when whales interact? The findings: My analysis, using data from @CoinGecko (a huge thank you to them for sponsoring!) and @Dune Analytics, shows a complex relationship. While there's a weak positive correlation on the same day, my lagged correlation plot found a stronger, negative correlation at a four-day lag. This suggests that a surge in whale activity might be a leading indicator of a price decline a few days later. #DataAnalysis #Python #Crypto #DataScience #DataAnalytics #FinancialAnalysis #Blockchain #CoinGecko

@rubi_daily_ Good project 👍

In this new digital economy, every action builds your trust score Mining, referring, even tweeting—it’s all value. Your Rubi journey is more than tokens—it’s your identity in Web3 Own it. Build it. 💼 #RubiMining #Rubi #PiNetwork #Airdrop #CORE #ICE #PAWS #CPEN #IceNetwork $SUI

@CoreNexGlobal Let's go

Technical Analysis And Futures Trading Class Loading...... (No fees attached by the way) More Info Coming Shortly. But let's see How many are actually ready for what's Coming. Like, retweet and Tag Friends below.👇👇 Let's test The publicity Waters...

Explanation: This query gives you a leaderboard of the top 10 DEX projects by USD trading volume over the past 7 days. It shows: Project name Total volume in USD Number of trades Sorted from most to least active by volume.

BONUS: Query: SELECT project, SUM(amount_usd) AS total_volume_usd, COUNT(*) AS trade_count FROM dex.trades WHERE block_time >= CURRENT_DATE - INTERVAL '7' day GROUP BY project ORDER BY total_volume_usd DESC LIMIT 10 Rows Returned: 10

Just completed an SQL assignment on @DuneAnalytics! Dived into DEX trading data with some solid SQL magic: 🔍 Top projects by volume 📈 Daily trade counts 💰 High-value transaction filters ⏱️ Time-based, DEX-specific, and volume-based trade analysis 🔥 Stay tuned! @AnalyticSages