📰 2024-04-19: Weekly Prophet!

[andrewhong5297]

This is your weekly summary of 18 PRs merged from 9 wizards. Great job everyone! 🎉
We had 7 added models 🟢 and 41 modified models 🟠 for 10 Sectors.

Sector	🔧 # PRs	🟢 # Added	🟠 # Modified	🧙 # Authors
dex	1	0	1	1
nft	2	0	2	1
prices	7	0	10	4
balancer	2	0	10	1
_sector	2	3	11	2
gyroscope	2	0	2	1
addresses_events	1	4	2	1
evms	1	0	1	1
addresses	1	0	1	1
cow_protocol	1	0	1	1

SECTOR: dex

toggle to see all model updates

MODEL: dex_solana_trades.sql

🟠 Modified by:

🔧 PR: #5763, Finalize dex_solana_bot_trades
🧙 Author: @Hosuke on 2024-04-18
📝 Summary: A schema named 'dex_solana' with an alias of 'trades' was added as a materialized view.

SECTOR: nft

toggle to see all model updates

MODEL: nft_marketplaces_info.sql

🟠 Modified by:

🔧 PR: #5765, Add AlienSwap metadata
🧙 Author: @hildobby on 2024-04-17
📝 Summary: A new row for 'alienswap' with corresponding values was added to the temporary table.

🔧 PR: #5765, Add NFT marketplaces metadata
🧙 Author: @hildobby on 2024-04-15
📝 Summary: Rows for projects 'zk_markets', 'campfire', and 'joepegs' were added to the temporary table. The row for project 'aurem' was removed from the temporary table.

SECTOR: prices

toggle to see all model updates

MODEL: prices_ethereum_tokens.sql

🟠 Modified by:

🔧 PR: #5771, Updatedof the number of decimals for GROK
🧙 Author: @PoloX2021 on 2024-04-19
📝 Summary: The token symbols that were added or removed are: GROK

🔧 PR: #5771, Update prices_ethereum_tokens.sql - TRUMP
🧙 Author: @monidob on 2024-04-16
📝 Summary: The token symbols that were added or removed are: NEXT, TRUMP

🔧 PR: #5771, Update prices_ethereum_tokens.sql
🧙 Author: @lydiapuspita on 2024-04-15
📝 Summary: ENA, NEXT

MODEL: prices_gnosis_tokens.sql

🟠 Modified by:

🔧 PR: #5793, Updatedof the number of decimals for GROK
🧙 Author: @PoloX2021 on 2024-04-19
📝 Summary: The token symbols that were added or removed are: WSTETH

MODEL: prices_arbitrum_tokens.sql

🟠 Modified by:

🔧 PR: #5777, Update prices_arbitrum_tokens.sql
🧙 Author: @peterrliem on 2024-04-16
📝 Summary: The token symbols that were added or removed are: GSWIFT, EZETH

MODEL: prices_base_tokens.sql

🟠 Modified by:

🔧 PR: #5785, Update prices_base_tokens.sql - TRUMP
🧙 Author: @monidob on 2024-04-16
📝 Summary: The token symbols that were added or removed are: COINYE, TRUMP

MODEL: prices_bnb_tokens.sql

🟠 Modified by:

🔧 PR: #5784, Update prices_bnb_tokens.sql - TRUMP
🧙 Author: @monidob on 2024-04-16
📝 Summary: TRUMP,XPE

MODEL: prices_solana_tokens.sql

🟠 Modified by:

🔧 PR: #5771, Update prices_solana_tokens.sql - TRUMP
🧙 Author: @monidob on 2024-04-16
📝 Summary: The tokens that were added or removed are: TRUMP

🔧 PR: #5771, Update prices_ethereum_tokens.sql
🧙 Author: @lydiapuspita on 2024-04-15
📝 Summary: FTT, W

MODEL: prices_native_tokens.sql

🟠 Modified by:

🔧 PR: #5771, Update prices_ethereum_tokens.sql
🧙 Author: @lydiapuspita on 2024-04-15
📝 Summary: The token symbols that were added are: ASTR, DYM, MANTA

SECTOR: balancer

toggle to see all model updates

MODEL: balancer_ethereum_vebal_balances_day.sql

🟠 Modified by:

🔧 PR: #5795, Update to balancer_ethereum_vebal_balances_day
🧙 Author: @viniabussafi on 2024-04-19
📝 Summary: Added logic to generate a sequence of days between the minimum day in the dataset and one year from now. Also, adjusted the lead function to calculate the next change date based on each provider's current day value plus one year.

MODEL: balancer_arbitrum_trades.sql

🟠 Modified by:

🔧 PR: #5789, Add block_number to balancer.trades
🧙 Author: @viniabussafi on 2024-04-17
📝 Summary: A new column block_number was added to the SQL model.

MODEL: balancer_avalanche_c_trades.sql

🟠 Modified by:

🔧 PR: #5789, Add block_number to balancer.trades
🧙 Author: @viniabussafi on 2024-04-17
📝 Summary: Added the column 'block_number' to the SQL model.

MODEL: balancer_trades.sql

🟠 Modified by:

🔧 PR: #5789, Add block_number to balancer.trades
🧙 Author: @viniabussafi on 2024-04-17
📝 Summary: Added the column 'block_number' to the SQL model.

MODEL: balancer_base_trades.sql

🟠 Modified by:

🔧 PR: #5789, Add block_number to balancer.trades
🧙 Author: @viniabussafi on 2024-04-17
📝 Summary: Added the column 'block_number' to the SQL model.

MODEL: balancer_ethereum_trades.sql

🟠 Modified by:

🔧 PR: #5789, Add block_number to balancer.trades
🧙 Author: @viniabussafi on 2024-04-17
📝 Summary: A new column block_number was added to the SQL model.

MODEL: balancer_v1_ethereum_trades.sql

🟠 Modified by:

🔧 PR: #5789, Add block_number to balancer.trades
🧙 Author: @viniabussafi on 2024-04-17
📝 Summary: Added the column block_number from the table trades.evt_block_number.

MODEL: balancer_gnosis_trades.sql

🟠 Modified by:

🔧 PR: #5789, Add block_number to balancer.trades
🧙 Author: @viniabussafi on 2024-04-17
📝 Summary: A new column block_number was added to the SQL model.

MODEL: balancer_optimism_trades.sql

🟠 Modified by:

🔧 PR: #5789, Add block_number to balancer.trades
🧙 Author: @viniabussafi on 2024-04-17
📝 Summary: Added the column 'block_number' to the model.

MODEL: balancer_polygon_trades.sql

🟠 Modified by:

🔧 PR: #5789, Add block_number to balancer.trades
🧙 Author: @viniabussafi on 2024-04-17
📝 Summary: A new column block_number was added to the SQL model.

SECTOR: _sector

toggle to see all model updates

MODEL: dex_solana_bot_trades.sql

🟠 Modified by:

🔧 PR: #5763, Finalize dex_solana_bot_trades
🧙 Author: @Hosuke on 2024-04-18
📝 Summary: [changes too large] The model dex_solana_bot_trades.sql was renamed.

MODEL: banana_gun_solana_bot_trades.sql

🟠 Modified by:

🔧 PR: #5763, Finalize dex_solana_bot_trades
🧙 Author: @Hosuke on 2024-04-18
📝 Summary: [changes too large] The model banana_gun_solana_bot_trades.sql was renamed.

MODEL: bonkbot_solana_bot_trades.sql

🟠 Modified by:

🔧 PR: #5763, Finalize dex_solana_bot_trades
🧙 Author: @Hosuke on 2024-04-18
📝 Summary: [changes too large] The model bonkbot_solana_bot_trades.sql was renamed.

MODEL: maestro_solana_bot_trades.sql

🟠 Modified by:

🔧 PR: #5763, Finalize dex_solana_bot_trades
🧙 Author: @Hosuke on 2024-04-18
📝 Summary: [changes too large] The model maestro_solana_bot_trades.sql was renamed.

MODEL: magnum_solana_bot_trades.sql

🟠 Modified by:

🔧 PR: #5763, Finalize dex_solana_bot_trades
🧙 Author: @Hosuke on 2024-04-18
📝 Summary: [changes too large] The model magnum_solana_bot_trades.sql was renamed.

MODEL: pepe_boost_solana_bot_trades.sql

🟠 Modified by:

🔧 PR: #5763, Finalize dex_solana_bot_trades
🧙 Author: @Hosuke on 2024-04-18
📝 Summary: [changes too large] The model pepe_boost_solana_bot_trades.sql was renamed.

MODEL: readyswap_solana_bot_trades.sql

🟠 Modified by:

🔧 PR: #5763, Finalize dex_solana_bot_trades
🧙 Author: @Hosuke on 2024-04-18
📝 Summary: [changes too large] The model readyswap_solana_bot_trades.sql was renamed.

MODEL: shuriken_solana_bot_trades.sql

🟠 Modified by:

🔧 PR: #5763, Finalize dex_solana_bot_trades
🧙 Author: @Hosuke on 2024-04-18
📝 Summary: [changes too large] The model shuriken_solana_bot_trades.sql was renamed.

MODEL: sol_trading_bot_solana_bot_trades.sql

🟠 Modified by:

🔧 PR: #5763, Finalize dex_solana_bot_trades
🧙 Author: @Hosuke on 2024-04-18
📝 Summary: [changes too large] The model sol_trading_bot_solana_bot_trades.sql was renamed.

MODEL: trojan_solana_bot_trades.sql

🟠 Modified by:

🔧 PR: #5763, Finalize dex_solana_bot_trades
🧙 Author: @Hosuke on 2024-04-18
📝 Summary: [changes too large] The model trojan_solana_bot_trades.sql was renamed.

MODEL: nft_base_wash_trades.sql

🟢 Added by:

🔧 PR: #5779, NFT wash for base, scroll and zora
🧙 Author: @hildobby on 2024-04-16
📝 Summary: This new dbt SQL model creates a table that identifies and filters out wash trades for NFT transactions on the base blockchain. It enables data analysts to analyze NFT trading activities more accurately by excluding wash trades from their analysis, providing cleaner and more reliable insights into genuine transaction behaviors.

MODEL: nft_scroll_wash_trades.sql

🟢 Added by:

🔧 PR: #5779, NFT wash for base, scroll and zora
🧙 Author: @hildobby on 2024-04-16
📝 Summary: This new dbt SQL model creates a table that identifies wash trades for NFTs on the Scroll blockchain. It enables data analysts to analyze and track potentially fraudulent trading activities involving NFTs funded by specific addresses sourced from another reference table.

MODEL: nft_zora_wash_trades.sql

🟢 Added by:

🔧 PR: #5779, NFT wash for base, scroll and zora
🧙 Author: @hildobby on 2024-04-16
📝 Summary: This new dbt SQL model creates a table called nft_wash_trades that is specific to the blockchain 'zora'. It enables data analysts to analyze and track wash trades involving NFTs on the Zora blockchain, using information about the first funding source from another referenced table.

MODEL: nft_wash_trades.sql

🟠 Modified by:

🔧 PR: #5779, NFT wash for base, scroll and zora
🧙 Author: @hildobby on 2024-04-16
📝 Summary: Three new references were added to the SQL model: 'nft_base_wash_trades', 'nft_scroll_wash_trades', and 'nft_zora_wash_trades'.

SECTOR: gyroscope

toggle to see all model updates

MODEL: gyroscope_gyro_tokens.sql

🟠 Modified by:

🔧 PR: #5778, Add block_number to balancer.trades
🧙 Author: @viniabussafi on 2024-04-17
📝 Summary: A new row was added to the gyro_tokens CTE with values for a token address, name, decimals, and chain.

🔧 PR: #5778, add missing tokens to tokens.erc20
🧙 Author: @viniabussafi on 2024-04-16
📝 Summary: Added a new row to the gyro_tokens CTE with values for address, token name, decimals, and chain.

SECTOR: addresses_events

toggle to see all model updates

MODEL: addresses_events_first_activity.sql

🟠 Modified by:

🔧 PR: #5780, addresses_events for Base & Scroll
🧙 Author: @hildobby on 2024-04-16
📝 Summary: Two new references were added in the dbt SQL model: 'addresses_events_base_first_activity' and 'addresses_events_scroll_first_activity'.

MODEL: addresses_events_first_funded_by.sql

🟠 Modified by:

🔧 PR: #5780, addresses_events for Base & Scroll
🧙 Author: @hildobby on 2024-04-16
📝 Summary: Two references were added to the SQL model: 'addresses_events_base_first_funded_by' and 'addresses_events_scroll_first_funded_by'.

MODEL: addresses_events_base_first_activity.sql

🟢 Added by:

🔧 PR: #5780, addresses_events for Base & Scroll
🧙 Author: @hildobby on 2024-04-16
📝 Summary: This model creates a base table that includes information about blockchain transactions, such as the address of the sender, the first activity recipient, timestamp of the first block, block number of the first transaction, hash of the first transaction, function involved in the first activity and amount transferred in native currency. It also joins with another table to filter out specific functions and addresses based on certain conditions.

MODEL: addresses_events_base_first_funded_by.sql

🟢 Added by:

🔧 PR: #5780, addresses_events for Base & Scroll
🧙 Author: @hildobby on 2024-04-16
📝 Summary: This model creates a table that enables data analysts to track the first funding event associated with addresses in a blockchain dataset.

MODEL: addresses_events_scroll_first_activity.sql

🟢 Added by:

🔧 PR: #5780, addresses_events for Base & Scroll
🧙 Author: @hildobby on 2024-04-16
📝 Summary: This model creates a dataset that tracks the first activity of addresses on the blockchain, including details such as the first block time, block number, transaction hash, function executed, and amount transferred in native currency. It enables data analysts to analyze initial interactions with addresses and their corresponding blockchain activities.

MODEL: addresses_events_scroll_first_funded_by.sql

🟢 Added by:

🔧 PR: #5780, addresses_events for Base & Scroll
🧙 Author: @hildobby on 2024-04-16
📝 Summary: This new dbt SQL model creates a table that links addresses to events based on the first time they were funded by the blockchain 'scroll'. This enables data analysts to analyze and track the initial funding event for each address in relation to the specified blockchain.

SECTOR: evms

toggle to see all model updates

MODEL: evms_info.sql

🟠 Modified by:

🔧 PR: #5756, Add more chains & update evms.info
🧙 Author: @hildobby on 2024-04-15
📝 Summary: [changes too large] The model evms_info.sql was modified.

SECTOR: addresses

toggle to see all model updates

MODEL: addresses_ethereum_l2_batch_submitters.sql

🟠 Modified by:

🔧 PR: #5757, Fix OVM1 SCC Batcher Distinction
🧙 Author: @MSilb7 on 2024-04-15
📝 Summary: A row was updated in the model where the 'from_address' value was changed to 'to_address' for a specific entity related to the State Commitment Chain within Optimism on OP Mainnet.

SECTOR: cow_protocol

toggle to see all model updates

MODEL: cow_protocol_ethereum_solvers.sql

🟠 Modified by:

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