📰 2024-04-05: Weekly Prophet!

[andrewhong5297]

This is your weekly summary of 20 PRs merged from 12 wizards. Great job everyone! 🎉
We had 5 added models 🟢 and 21 modified models 🟠 for 6 Sectors.

Sector	🔧 # PRs	🟢 # Added	🟠 # Modified	🧙 # Authors
nft	1	0	1	1
labels	1	0	1	1
prices	10	0	10	4
_sector	6	5	6	5
cex	1	0	2	1
cow_protocol	1	0	1	1

SECTOR: nft

toggle to see all model updates

MODEL: nft_marketplaces_info.sql

🟠 Modified by:

🔧 PR: #5734, Add NFT marketplaces info
🧙 Author: @hildobby on 2024-04-05
📝 Summary: Added new projects 'Kreatorland', 'MOOAR', 'Aurem', and 'Tevaera' with their corresponding details to the existing list of projects in the SQL model.

SECTOR: labels

toggle to see all model updates

MODEL: labels_dex.sql

🟠 Modified by:

🔧 PR: #5717, Drop balances and transfers prod_exclude models
🧙 Author: @aalan3 on 2024-04-03
📝 Summary: In this pull request, the model was updated to include a new set of dex models. Additionally, some lines related to enabling balances were removed from the model.

SECTOR: prices

toggle to see all model updates

MODEL: prices_solana_tokens.sql

🟠 Modified by:

🔧 PR: #5711, Updated prices_solana_tokens.sql with a lot more tokens
🧙 Author: @jasparw on 2024-04-05
📝 Summary: [changes too large] The model prices_solana_tokens.sql was modified.

MODEL: prices_polygon_tokens.sql

🟠 Modified by:

🔧 PR: #5725, add tokens to price list - polygon
🧙 Author: @RantumBits on 2024-04-04
📝 Summary: PYR, GEOD, PAR, MIM, CONE, PZCX, ORBS, MASKICE

MODEL: prices_ethereum_tokens.sql

🟠 Modified by:

🔧 PR: #5726, Update prices_ethereum_tokens.sql
🧙 Author: @lydiapuspita on 2024-04-04
📝 Summary: The token symbols that were added are: STRK, ELA

🔧 PR: #5726, Add FRXETH to prices.usd
🧙 Author: @viniabussafi on 2024-04-04
📝 Summary: The token symbols that were added are: FRXETH

🔧 PR: #5726, add tokens to price list - ethereum
🧙 Author: @RantumBits on 2024-04-04
📝 Summary: The token symbols that were added are: CGPT, CSWAP, BOBO, BVM, NAKA, POOH,
MUMU,WRLD,GROK ,DEAI and DSYNC.

MODEL: prices_fantom_tokens.sql

🟠 Modified by:

🔧 PR: #5730, add tokens to price list - fantom
🧙 Author: @RantumBits on 2024-04-04
📝 Summary: The token symbols that were added or removed are: FUSDT

MODEL: prices_bnb_tokens.sql

🟠 Modified by:

🔧 PR: #5729, add tokens to price list - bnb
🧙 Author: @RantumBits on 2024-04-04
📝 Summary: BONK, WETH, AGEUR, SOL, USX, STRAINZ, DIS, SHIB,
BTT,AITECH ,RCM,LITT ,TRIAS,PZP,BABYGROK,AI,KALM,XAI,SIS,RDNT,CYBER,
CGPT,AI,SLEEPLESS- AI ,USDV,XPE

MODEL: prices_arbitrum_tokens.sql

🟠 Modified by:

🔧 PR: #5728, add tokens to price list - arbitrum
🧙 Author: @RantumBits on 2024-04-04
📝 Summary: The token symbols that were added are: XPET, BPET, SUNDAE, GNS, GSWIFT

MODEL: prices_base_tokens.sql

🟠 Modified by:

🔧 PR: #5727, add tokens to price list - base
🧙 Author: @RantumBits on 2024-04-04
📝 Summary: The tokens that were added are: BAL, DOG, HIGHER, KEYCAT, BRIUN, BENJI,
ROOST, TYBG,CIRCLE,PONCHO,BABYBRETT and COINYE.

MODEL: prices_avalanche_c_tokens.sql

🟠 Modified by:

🔧 PR: #5731, add tokens to price list - avalanche
🧙 Author: @RantumBits on 2024-04-04
📝 Summary: MONK, MAN, ROCO, VCHF, VEUR, KIMBO, GEC, HEC,
PNG,CYL ,ROCKET,SPELL,GURS,HON ,BAWLS

SECTOR: _sector

toggle to see all model updates

MODEL: zk_markets_zksync_base_trades.sql

🟠 Modified by:

🔧 PR: #5743, nft_trades royalty fix for zk_markets
🧙 Author: @tomfutago on 2024-04-05
📝 Summary: A condition was added to the SQL model to filter rows where the contract address matches a specific value. Additionally, another condition was included to only include transfers from either the marketplace or buyer addresses.

MODEL: nft_avalanche_c_base_trades.sql

🟢 Added by:

🔧 PR: #5653, Add Hyperspace avalanche NFT trades - Ready for Review
🧙 Author: @henrystats on 2024-04-05
📝 Summary: This model combines data from the 'hyperspace_avalanche_c_base_trades' table to provide a comprehensive view of blockchain trades involving NFTs. It includes details such as trade category, type, participants (buyers and sellers), NFT contract information, pricing, fees, transaction details, and duplicate handling. This SQL query enables data analysts to analyze and track various aspects of NFT transactions within different projects on the blockchain at both daily and monthly levels while ensuring that duplicate entries are accounted for appropriately.

🟠 Modified by:

🔧 PR: #5653, Add campfire avalanche nft trades - Ready for Review
🧙 Author: @henrystats on 2024-04-05
📝 Summary: A reference to a dbt model named 'campfire_avalanche_c_base_trades' was added, and the order of references in the list was changed.

MODEL: campfire_avalanche_c_base_trades.sql

🟢 Added by:

🔧 PR: #5651, Add campfire avalanche nft trades - Ready for Review
🧙 Author: @henrystats on 2024-04-05
📝 Summary: This model creates a base table of trades related to the 'Campfire' project on the Avalanche blockchain. It includes details such as trade type, buyer, seller, price, and transaction information. Additionally, it incorporates NFT transaction data for further analysis by data analysts.

MODEL: hyperspace_avalanche_c_base_trades.sql

🟢 Added by:

🔧 PR: #5653, Add Hyperspace avalanche NFT trades - Ready for Review
🧙 Author: @henrystats on 2024-04-05
📝 Summary: This model creates a base table of trade data for the 'hyperspace' project on the 'avalanche_c' blockchain. It includes information such as block time, NFT details, trade type (buy/sell), seller and buyer details, price, transaction hash, contract addresses, and additional fee-related fields. The model also incorporates incremental loading based on event block time or a specified start date to enable data analysts to analyze trading activities within the specified parameters.

MODEL: nft_base_trades.sql

🟠 Modified by:

🔧 PR: #5653, Add Hyperspace avalanche NFT trades - Ready for Review
🧙 Author: @henrystats on 2024-04-05
📝 Summary: A reference to a new table nft_avalanche_c_base_trades was added in the dbt SQL model.

MODEL: depin_revenue.sql

🟠 Modified by:

🔧 PR: #5746, Fix local compile
🧙 Author: @0xRobin on 2024-04-05
📝 Summary: Removed a CTE named 'results' and replaced it with a dynamic SQL query that selects specific columns from multiple models using UNION ALL. The new logic uses a set of models to iterate over, selecting date, blockchain, project, and revenue fields from each model in the set before combining them with UNION ALL.

MODEL: mint_square_zksync_base_trades.sql

🟠 Modified by:

🔧 PR: #5712, [EASY] Fix missing USD pricing on certain zkSync nft.trades
🧙 Author: @lgingerich on 2024-04-05
📝 Summary: Added a CASE statement to handle specific values of 'currency_contract' by replacing them with fixed values.

MODEL: dex_zksync_base_trades.sql

🟠 Modified by:

🔧 PR: #5701, Add iziswap on zksync to dex.trades
🧙 Author: @thetroyharris on 2024-03-29
📝 Summary: Two references were added to the SQL model: 'iziswap_v1_zksync_base_trades' and 'iziswap_v2_zksync_base_trades'.

MODEL: iziswap_v1_zksync_base_trades.sql

🟢 Added by:

🔧 PR: #5701, Add iziswap on zksync to dex.trades
🧙 Author: @thetroyharris on 2024-03-29
📝 Summary: This model creates a dataset for the iZiSwap project on the ZkSync blockchain. It includes information such as transaction details, block time, token addresses, amounts exchanged, and participant details. The model enables data analysts to analyze swap events within iZiSwap on ZkSync starting from a specified date or incrementally based on block time criteria.

MODEL: iziswap_v2_zksync_base_trades.sql

🟢 Added by:

🔧 PR: #5701, Add iziswap on zksync to dex.trades
🧙 Author: @thetroyharris on 2024-03-29
📝 Summary: This model creates a dataset for data analysts that includes information about swaps happening in the iZiSwap project on the ZkSync blockchain. It provides details such as transaction hashes, block numbers, token addresses, amounts bought and sold, as well as taker and maker information. The model allows analysts to track swap activities over time and analyze trading behavior within the iZiSwap platform on ZkSync.

SECTOR: cex

toggle to see all model updates

MODEL: cex_evms_addresses.sql

🟠 Modified by:

🔧 PR: #5716, More CEX addresses
🧙 Author: @hildobby on 2024-04-05
📝 Summary: [changes too large] The model cex_evms_addresses.sql was modified.

MODEL: cex_info.sql

🟠 Modified by:

🔧 PR: #5716, More CEX addresses
🧙 Author: @hildobby on 2024-04-05
📝 Summary: Three new values were added to the temporary table: 'Wealthsimple', 'HashKey Exchange', and 'Gamdom'.

SECTOR: cow_protocol

toggle to see all model updates

MODEL: cow_protocol_ethereum_solvers.sql

🟠 Modified by:

🔧 PR: #5733, [CoW Protocol] Add the new Odos solver
🧙 Author: @harisang on 2024-04-04
📝 Summary: Two entries were added to the known_solver_metadata model: one for 'Odos' in the 'prod' environment and another for 'Odos' in the 'barn' environment.