Clefcodex

48 posts

Clefcodex

Clefcodex

@clefcodex

Aspiring Software developer

Software Katılım Aralık 2023
36 Takip Edilen43 Takipçiler
ismarty
ismarty@smartymetrics·
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
English
10
2
34
563
Clefcodex retweetledi
CoreNex
CoreNex@CoreNexGlobal·
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...
CoreNex tweet media
English
131
165
431
24.7K
Clefcodex
Clefcodex@clefcodex·
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.
English
0
0
1
23
Clefcodex
Clefcodex@clefcodex·
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
Clefcodex tweet media
English
1
0
3
32
Clefcodex
Clefcodex@clefcodex·
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
English
7
4
13
1.5K