📰 2024-06-28: Weekly Prophet!

[andrewhong5297]

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

Sector	🔧 # PRs	🟢 # Added	🟠 # Modified	🧙 # Authors
prices	9	0	11	8
cow_protocol	1	2	1	1
evms	1	0	1	1
models	2	0	5	2
nexusmutual	1	5	1	1
addresses	1	0	1	1

SECTOR: prices

toggle to see all model updates

MODEL: prices_blast_tokens.sql

🟠 Modified by:

🔧 PR: #6251, Add YOLO on Blast to prices.usd
🧙 Author: @stonehengeLR on 2024-06-25
📝 Summary: The token symbols that were added or removed are: Added: YOLO

🔧 PR: #6251, Blur on Blast Fix
🧙 Author: @hildobby on 2024-06-25
📝 Summary: The token symbols that were added are: 'bpETH'

MODEL: prices_tokens.sql

🟠 Modified by:

🔧 PR: #6270, Fix price tokens and set up tests
🧙 Author: @0xRobin on 2024-06-26
📝 Summary: contract_address, decimals

🔧 PR: #6270, Fix prices.usd
🧙 Author: @jeff-dude on 2024-06-26
📝 Summary: decimals

MODEL: prices_ethereum_tokens.sql

🟠 Modified by:

🔧 PR: #6231, Add QUARTZ token to prices.usd table
🧙 Author: @fyang1024 on 2024-06-26
📝 Summary: The token symbols that were added or removed are: ZRO, QUARTZ

🔧 PR: #6231, Add IO, LISTA and ZRO token
🧙 Author: @lydiapuspita on 2024-06-25
📝 Summary: The token symbols that were added or removed are: GIV, ZRO

MODEL: prices_linea_tokens.sql

🟠 Modified by:

🔧 PR: #6237, adding m-btc and solvBTC prices in prices_linea_tokens.sql
🧙 Author: @0xroll on 2024-06-26
📝 Summary: M-BTC, solvBTC

MODEL: prices_arbitrum_tokens.sql

🟠 Modified by:

🔧 PR: #6240, Add SLIZ token
🧙 Author: @IrishLatte19 on 2024-06-26
📝 Summary: The token symbols that were added are: SLIZ

MODEL: prices_native_tokens.sql

🟠 Modified by:

🔧 PR: #6213, Update prices_native_tokens.sql
🧙 Author: @IrishLatte19 on 2024-06-25
📝 Summary: The token symbols that were added are: MYRIA, MODE

MODEL: prices_bnb_tokens.sql

🟠 Modified by:

🔧 PR: #6231, Add IO, LISTA and ZRO token
🧙 Author: @lydiapuspita on 2024-06-25
📝 Summary: THE, LISTA

MODEL: prices_solana_tokens.sql

🟠 Modified by:

🔧 PR: #6231, Add IO, LISTA and ZRO token
🧙 Author: @lydiapuspita on 2024-06-25
📝 Summary: The tokens that were added or removed are: 'io-ionet'

SECTOR: cow_protocol

toggle to see all model updates

MODEL: cow_protocol_arbitrum_batches.sql

🟢 Added by:

🔧 PR: #6224, Adding new tables to CoW Protocol Arbitrum chain
🧙 Author: @olgafetisova on 2024-06-27
📝 Summary: This model creates a dataset that tracks solver activation events, ranks them based on block number and index, identifies registered solvers, calculates various counts related to transactions involving these solvers (such as dex swaps and token approvals), determines batch values for trades including fees and prices in USD, combines this information with transaction details like gas usage and call data size. This enables analysts to analyze trading activity associated with specific solvers on the Gnosis Protocol v2 Arbitrum platform.

MODEL: cow_protocol_arbitrum_solvers.sql

🟢 Added by:

🔧 PR: #6224, Adding new tables to CoW Protocol Arbitrum chain
🧙 Author: @olgafetisova on 2024-06-27
📝 Summary: This model aggregates solver activation events, ranks them to pick the most recent status for each unique solver, and combines this data with manually inserted metadata for known solvers. It creates a final table that includes the solver's address, environment (prod or barn), name of the solver (if known), and their current activation status. This enables data analysts to track and analyze changes in solver activations within a specific environment while also providing context on identified solvers.

MODEL: cow_protocol_batches.sql

🟠 Modified by:

🔧 PR: #6224, Adding new tables to CoW Protocol Arbitrum chain
🧙 Author: @olgafetisova on 2024-06-27
📝 Summary: A new SELECT statement was added to the SQL model, retrieving specific columns from a different source compared to the existing one. The UNION ALL operator is used to combine the results of both SELECT statements.

SECTOR: evms

toggle to see all model updates

MODEL: evms_info.sql

🟠 Modified by:

🔧 PR: #6212, evms.info updates
🧙 Author: @hildobby on 2024-06-26
📝 Summary: [changes too large] The model evms_info.sql was modified.

SECTOR: models

toggle to see all model updates

MODEL: zeroex_ethereum_api_fills.sql

🟠 Modified by:

🔧 PR: #6192, zeroex - model updates on gasless txns - ethereum
🧙 Author: @RantumBits on 2024-06-26
📝 Summary: [changes too large] The model zeroex_ethereum_api_fills.sql was modified.

MODEL: bebop_blend_arbitrum_trades.sql

🟠 Modified by:

🔧 PR: #6228, Fix Bebop infinity values
🧙 Author: @B1boid on 2024-06-25
📝 Summary: [changes too large] The model bebop_blend_arbitrum_trades.sql was modified.

MODEL: bebop_blend_base_trades.sql

🟠 Modified by:

🔧 PR: #6228, Fix Bebop infinity values
🧙 Author: @B1boid on 2024-06-25
📝 Summary: [changes too large] The model bebop_blend_base_trades.sql was modified.

MODEL: bebop_blend_ethereum_trades.sql

🟠 Modified by:

🔧 PR: #6228, Fix Bebop infinity values
🧙 Author: @B1boid on 2024-06-25
📝 Summary: [changes too large] The model bebop_blend_ethereum_trades.sql was modified.

MODEL: bebop_blend_polygon_trades.sql

🟠 Modified by:

🔧 PR: #6228, Fix Bebop infinity values
🧙 Author: @B1boid on 2024-06-25
📝 Summary: [changes too large] The model bebop_blend_polygon_trades.sql was modified.

SECTOR: nexusmutual

toggle to see all model updates

MODEL: nexusmutual_ethereum_covers_v1.sql

🟢 Added by:

🔧 PR: #6142, Nexus Mutual - products & covers
🧙 Author: @tomfutago on 2024-06-25
📝 Summary: This model creates a dataset that provides details about insurance covers, including start and end times, premium amounts, asset types, owner information, and related product details. It enables data analysts to analyze insurance cover transactions in the Nexus Mutual platform by joining various tables to gather comprehensive information for reporting and analysis purposes.

MODEL: nexusmutual_ethereum_covers_v2.sql

🟢 Added by:

🔧 PR: #6142, Nexus Mutual - products & covers
🧙 Author: @tomfutago on 2024-06-25
📝 Summary: This model creates a dataset that combines information on cover sales, staking product premiums, and cover details. It enables data analysts to analyze various aspects of insurance covers such as start and end times, pool allocations, premium amounts in different assets, commission ratios, sum assured values, and more. The dataset includes both migrated and non-migrated covers for comprehensive analysis.

MODEL: nexusmutual_ethereum_product_information.sql

🟠 Modified by:

🔧 PR: #6142, Nexus Mutual - products & covers
🧙 Author: @tomfutago on 2024-06-25
📝 Summary: [changes too large] The model nexusmutual_ethereum_product_information.sql was removed.

MODEL: nexusmutual_ethereum_product_types_v2.sql

🟢 Added by:

🔧 PR: #6142, Nexus Mutual - products & covers
🧙 Author: @tomfutago on 2024-06-25
📝 Summary: This model creates a dataset that combines information about product types from different sources. It enables data analysts to analyze the block time, block number, product type details such as name and metadata, claim method, grace period, and transaction hash for each product type. The model also provides a URL for cover wording related to each product type.

MODEL: nexusmutual_ethereum_products_v1.sql

🟢 Added by:

🔧 PR: #6142, Nexus Mutual - products & covers
🧙 Author: @tomfutago on 2024-06-25
📝 Summary: [changes too large] The model nexusmutual_ethereum_products_v1.sql was added.

MODEL: nexusmutual_ethereum_products_v2.sql

🟢 Added by:

🔧 PR: #6142, Nexus Mutual - products & covers
🧙 Author: @tomfutago on 2024-06-25
📝 Summary: This model creates a dataset that combines product event and call data, extracting various parameters related to products. It enables analysts to track product details such as type, assets covered, pricing information, pools allowed, and more. The final output provides a snapshot of the latest information for each product based on block time.

SECTOR: addresses

toggle to see all model updates

MODEL: addresses_ethereum_mev.sql

🟠 Modified by:

🔧 PR: #6220, Update addresses_ethereum_mev.sql
🧙 Author: @JacobSharples on 2024-06-25
📝 Summary: Several Ethereum addresses were added to the model, with comments indicating their source or purpose such as 'Etherscan' or 'Internal tx to Hiveon Pool'.