📰 2024-03-29: Weekly Prophet!

[andrewhong5297]

This is your weekly summary of 50 PRs merged from 20 wizards. Great job everyone! 🎉
We had 93 added models 🟢 and 218 modified models 🟠 for 24 Sectors.

Sector	🔧 # PRs	🟢 # Added	🟠 # Modified	🧙 # Authors
dex	12	1	11	4
labels	2	0	4	1
prices	5	0	11	4
_sector	16	25	16	7
rollup_economics	2	0	2	2
evms	1	0	1	1
opensea	5	3	3	4
seaport	1	0	1	1
balancer	1	1	4	1
addresses_events	1	1	0	1
sol_trading_bot	1	2	0	1
pepe_boost	1	2	0	1
maestro	1	2	0	1
shuriken	1	2	0	1
magnum	1	2	0	1
readyswap	1	2	0	1
trojan	1	2	0	1
banana_gun	1	2	0	1
cow_protocol	3	0	3	2
staking	1	0	2	1
bonkbot	1	0	1	1
gyroscope	1	0	1	1
chainlink	3	46	157	2
boost	1	0	1	1

SECTOR: dex

toggle to see all model updates

MODEL: dex_info.sql

🟠 Modified by:

🔧 PR: #5683, Add DerpDEX to dex.trades for zkSync
🧙 Author: @lgingerich on 2024-03-29
📝 Summary: A new value 'derpdex' with corresponding details was added to the existing list of values in the model.

🔧 PR: #5683, Add eZKalibur to dex.trades for zkSync
🧙 Author: @lgingerich on 2024-03-29
📝 Summary: A new value 'ezkalibur' with corresponding details was added to the list of values in the model.

🔧 PR: #5683, Add Wagmi to dex.trades for zkSync
🧙 Author: @lgingerich on 2024-03-29
📝 Summary: A new value 'wagmi' with corresponding details was added to the list of values in the SQL model.

🔧 PR: #5683, Add zkSwap Finance to dex.trades for zkSync
🧙 Author: @lgingerich on 2024-03-29
📝 Summary: A new row for 'zkswap_finance' with corresponding values was added to the existing list of rows in the model.

🔧 PR: #5683, Add GemSwap to dex.trades for zkSync
🧙 Author: @lgingerich on 2024-03-29
📝 Summary: A new row for 'GemSwap' was added to the temporary table.

🔧 PR: #5683, Add veSync to dex.trades on zkSync
🧙 Author: @lgingerich on 2024-03-29
📝 Summary: A new project 'veSync' was added to the temporary table.

🔧 PR: #5683, Add Dracula Finance to dex.trades for zkSync
🧙 Author: @lgingerich on 2024-03-29
📝 Summary: A new project called 'Dracula Finance' was added to the list of projects in the SQL model.

🔧 PR: #5683, Add SpaceFi V1 dex.trades for zkSync
🧙 Author: @lgingerich on 2024-03-27
📝 Summary: A new row with project 'spacefi', name 'SpaceFi', marketplace_type 'Direct', and x_username 'SpaceFi' was added to the temporary table.

MODEL: dex_solana_bot_trades.sql

🟢 Added by:

🔧 PR: #5633, Introduce dex_solana_bot_trades
🧙 Author: @Hosuke on 2024-03-26
📝 Summary: This model creates a dataset that consolidates trading data from the 'bonkbot_solana_bot_trades' table. It includes information such as block time, blockchain details, trade amounts in USD and tokens, fees, project specifics, transaction IDs, and indices. By querying this model analysts can analyze trading activities on Solana blockchain executed by the specified bot for further insights and decision-making processes.

🟠 Modified by:

🔧 PR: #5633, dex_solana.bot_trades add all bot trades
🧙 Author: @jeff-dude on 2024-03-26
📝 Summary: Several new references to different Solana bot trades were added in this pull request. The model now includes additional trading bots such as 'sol_trading_bot_solana', 'pepe_boost_solana', 'maestro_solana', 'shuriken_solana', 'magnum_solana' and more.

🔧 PR: #5633, feat: add trojan trades spellbook
🧙 Author: @whalehunting on 2024-03-26
📝 Summary: A reference to a new table named 'trojan_solana_bot_trades' was added to the list of tables in the dbt SQL model.

🔧 PR: #5633, feat: add banana gun trades spellbook
🧙 Author: @whalehunting on 2024-03-26
📝 Summary: A contributor 'whale_hunter' was added to the list of contributors in the model. Additionally, a new reference 'banana_gun_solana_bot_trades' was included in the solana_trading_bot list.

SECTOR: labels

toggle to see all model updates

MODEL: labels_balancer_v2_gauges_ethereum.sql

🟠 Modified by:

🔧 PR: #5684, Updates to Balancer spells
🧙 Author: @viniabussafi on 2024-03-27
📝 Summary: Added a new SELECT statement to UNION ALL with the existing query. The new SELECT retrieves specific columns from a reference table and adds hardcoded values for other columns.

MODEL: labels_balancer_v2_pools_avalanche_c.sql

🟠 Modified by:

🔧 PR: #5670, add Xave's FX pools to balancer spells
🧙 Author: @viniabussafi on 2024-03-25
📝 Summary: Added a new section to the SQL model that selects specific columns from a source table and performs a cross join with an array. The logic involves filtering based on certain conditions and setting default values for some columns. Additionally, updated the CASE statement in the 'settings' section to include an additional pool type ('FX') when checking for specific values before performing transformations on selected columns.

MODEL: labels_balancer_v2_pools_ethereum.sql

🟠 Modified by:

🔧 PR: #5670, add Xave's FX pools to balancer spells
🧙 Author: @viniabussafi on 2024-03-25
📝 Summary: Added a section to the SQL model that selects specific columns from a source table and performs an UNNEST operation. Also, included additional conditions in the CASE statement within the 'settings' CTE to handle another pool_type ('FX').

MODEL: labels_balancer_v2_pools_polygon.sql

🟠 Modified by:

🔧 PR: #5670, add Xave's FX pools to balancer spells
🧙 Author: @viniabussafi on 2024-03-25
📝 Summary: Added a section to select pool information from a specific source and unnest assets. Modified the CASE statement in settings to include 'FX' as a pool type condition.

SECTOR: prices

toggle to see all model updates

MODEL: prices_avalanche_c_tokens.sql

🟠 Modified by:

🔧 PR: #5674, Add tokens to prices.usd
🧙 Author: @viniabussafi on 2024-03-28
📝 Summary: The tokens that were added or removed are:
VEUR, YYAVAX

🔧 PR: #5674, Add missing tokens to prices.usd
🧙 Author: @viniabussafi on 2024-03-25
📝 Summary: VEUR, VCHF

MODEL: prices_polygon_tokens.sql

🟠 Modified by:

🔧 PR: #5696, Add tokens to prices.usd
🧙 Author: @viniabussafi on 2024-03-28
📝 Summary: PAR

🔧 PR: #5696, rm bad tokens
🧙 Author: @grkhr on 2024-03-28
📝 Summary: SHIB, PGX, KLIMA, BCT, MV, ROND, ELON,QI ,GMEE,FISH,PYR,GEOD

MODEL: prices_bnb_tokens.sql

🟠 Modified by:

🔧 PR: #5696, rm bad tokens
🧙 Author: @grkhr on 2024-03-28
📝 Summary: The token symbols that were added or removed are:
Added: DG
Removed: ANT, GALA, METIS

MODEL: prices_ethereum_tokens.sql

🟠 Modified by:

🔧 PR: #5659, rm bad tokens
🧙 Author: @grkhr on 2024-03-28
📝 Summary: The token symbols that were added or removed are: XDEFI, YLD, APY, ARCX and BLOCKS.

🔧 PR: #5659, Drop outlier token
🧙 Author: @aalan3 on 2024-03-26
📝 Summary: The token symbols that were removed are: FLONA

🔧 PR: #5659, Add missing tokens to prices.usd
🧙 Author: @viniabussafi on 2024-03-25
📝 Summary: The token symbols that were added are: TUNA, PXETH, SDAI

🔧 PR: #5659, add TUNA price to erc20 price
🧙 Author: @GoodDataBadGuy on 2024-03-25
📝 Summary: The token symbols that were added or removed are: 'tuna-tunachain', 'TUNA'

MODEL: prices_base_tokens.sql

🟠 Modified by:

🔧 PR: #5674, Add missing tokens to prices.usd
🧙 Author: @viniabussafi on 2024-03-25
📝 Summary: RETH, BAL

MODEL: prices_gnosis_tokens.sql

🟠 Modified by:

🔧 PR: #5674, Add missing tokens to prices.usd
🧙 Author: @viniabussafi on 2024-03-25
📝 Summary: The tokens that were added or removed are: SUSHI, WSTETH

SECTOR: _sector

toggle to see all model updates

MODEL: nft_zksync_base_trades.sql

🟠 Modified by:

🔧 PR: #5679, Add Mint Square to nft.trades on zkSync
🧙 Author: @lgingerich on 2024-03-29
📝 Summary: A reference to a model named 'mint_square_zksync_base_trades' was added, and a reference to 'zk_markets_zksync_base_trades' was removed. The model is iterating over nft_models.

MODEL: mint_square_zksync_base_trades.sql

🟢 Added by:

🔧 PR: #5679, Add Mint Square to nft.trades on zkSync
🧙 Author: @lgingerich on 2024-03-29
📝 Summary: This model creates a dataset that combines information on trades, royalties, and platform fees related to NFT transactions. It enables data analysts to analyze trade details such as buyer/seller information, prices, and transaction IDs. Additionally, it allows for the calculation of platform fees and royalty payments associated with these transactions. The model also includes blockchain-specific data like block time and contract addresses for further analysis by date or month.

MODEL: dex_zksync_base_trades.sql

🟠 Modified by:

🔧 PR: #5683, Add DerpDEX to dex.trades for zkSync
🧙 Author: @lgingerich on 2024-03-29
📝 Summary: A reference to a new model called 'derpdex_v1_zksync_base_trades' was added in this dbt SQL model.

🔧 PR: #5683, Add eZKalibur to dex.trades for zkSync
🧙 Author: @lgingerich on 2024-03-29
📝 Summary: A reference to a new model called 'ezkalibur_v2_zksync_base_trades' was added in the SQL code.

🔧 PR: #5683, Add Wagmi to dex.trades for zkSync
🧙 Author: @lgingerich on 2024-03-29
📝 Summary: A reference to a new model called 'wagmi_v1_zksync_base_trades' was added in the SQL file.

🔧 PR: #5683, Add zkSwap Finance to dex.trades for zkSync
🧙 Author: @lgingerich on 2024-03-29
📝 Summary: A reference to a new table called 'zkswap_finance_zksync_base_trades' was added in the dbt SQL model.

🔧 PR: #5683, Add GemSwap to dex.trades for zkSync
🧙 Author: @lgingerich on 2024-03-29
📝 Summary: A reference to a new table called 'gemswap_zksync_base_trades' was added in the dbt SQL model.

🔧 PR: #5683, Add veSync to dex.trades on zkSync
🧙 Author: @lgingerich on 2024-03-29
📝 Summary: A reference to a model named 'vesync_v1_zksync_base_trades' was added in the dbt SQL model.

🔧 PR: #5683, Add Dracula Finance to dex.trades for zkSync
🧙 Author: @lgingerich on 2024-03-29
📝 Summary: A reference to a new model called 'dracula_finance_zksync_base_trades' was added to the existing list of references in the SQL model.

🔧 PR: #5683, Add Pancakeswap V3 dex.trades to zkSync
🧙 Author: @lgingerich on 2024-03-27
📝 Summary: A reference to a new base trades model for PancakeSwap V3 was added to the list of base models.

🔧 PR: #5683, Add SpaceFi V1 dex.trades for zkSync
🧙 Author: @lgingerich on 2024-03-27
📝 Summary: A reference to a new model spacefi_v1_zksync_base_trades was added to the existing list of models being referenced in the SQL query.

MODEL: derpdex_v1_zksync_base_trades.sql

🟢 Added by:

🔧 PR: #5693, Add DerpDEX to dex.trades for zkSync
🧙 Author: @lgingerich on 2024-03-29
📝 Summary: This new dbt SQL model creates a table called uniswap_compatible_v3_trades that enables data analysts to analyze and work with Uniswap V3 trades specifically for the blockchain 'zksync' and project 'derpdex'. It sources data from events related to pair swaps and pool creations within the specified version.

MODEL: nft_arbitrum_base_trades.sql

🟠 Modified by:

🔧 PR: #5697, Add Zonic to nft_trades for Arbitrum & Zora
🧙 Author: @tomfutago on 2024-03-29
📝 Summary: A reference to a new model called 'zonic_arbitrum_base_trades' was added in the dbt SQL model.

MODEL: zonic_arbitrum_base_trades.sql

🟢 Added by:

🔧 PR: #5697, Add Zonic to nft_trades for Arbitrum & Zora
🧙 Author: @tomfutago on 2024-03-29
📝 Summary: This new dbt SQL model creates a table called zonic_base_trades that focuses on trade data from the Arbitrum blockchain. It filters data based on a minimum block number and project start date, as well as includes an alternative token address for analysis by data analysts.

MODEL: nft_zora_base_trades.sql

🟢 Added by:

🔧 PR: #5697, Add Zonic to nft_trades for Arbitrum & Zora
🧙 Author: @tomfutago on 2024-03-29
📝 Summary: This model creates a union of data from different NFT trading tables, allowing data analysts to query and analyze a consolidated dataset that includes information such as blockchain details, trade specifics (buyer/seller), NFT contract details, pricing information, fees involved in transactions, and transaction identifiers. This enables analysts to perform comprehensive analysis on NFT trades across various projects and versions.

MODEL: zonic_zora_base_trades.sql

🟢 Added by:

🔧 PR: #5697, Add Zonic to nft_trades for Arbitrum & Zora
🧙 Author: @tomfutago on 2024-03-29
📝 Summary: This dbt SQL model creates a table called zonic_base_trades that enables data analysts to analyze trades specific to the Zora blockchain. It filters data based on a minimum block number, project start date, and an alternative token address for further analysis.

MODEL: ezkalibur_v2_zksync_base_trades.sql

🟢 Added by:

🔧 PR: #5692, Add eZKalibur to dex.trades for zkSync
🧙 Author: @lgingerich on 2024-03-29
📝 Summary: This dbt SQL model creates a table called uniswap_compatible_v2_trades that enables data analysts to analyze and track trades compatible with Uniswap V2 on the ZkSync blockchain for the project 'ezkalibur'. It sources data from events related to pair swaps and factory pair creations in EZKalibur's V2 implementation on ZkSync.

MODEL: wagmi_v1_zksync_base_trades.sql

🟢 Added by:

🔧 PR: #5691, Add Wagmi to dex.trades for zkSync
🧙 Author: @lgingerich on 2024-03-29
📝 Summary: This dbt SQL model creates a table called uniswap_compatible_v3_trades that enables data analysts to analyze and track trades compatible with Uniswap V3 on the Zksync blockchain for the project 'wagmi'. It sources data from events related to pair swaps and pool creations in the specified version.

MODEL: zkswap_finance_zksync_base_trades.sql

🟢 Added by:

🔧 PR: #5690, Add zkSwap Finance to dex.trades for zkSync
🧙 Author: @lgingerich on 2024-03-29
📝 Summary: This model creates a table called uniswap_compatible_v2_trades that enables data analysts to analyze trade data from the zkswap_finance project on the zksync blockchain version 1. It sources information from events related to pair swaps and pair creations in the specified factory.

MODEL: gemswap_zksync_base_trades.sql

🟢 Added by:

🔧 PR: #5700, Add GemSwap to dex.trades for zkSync
🧙 Author: @lgingerich on 2024-03-29
📝 Summary: This model creates a table called uniswap_compatible_v2_trades that enables data analysts to analyze trade data from the GemSwap project on the ZkSync blockchain version 1. It sources information from events related to pair swaps and pair creations in the GemSwap ZkSync factory contract.

MODEL: vesync_v1_zksync_base_trades.sql

🟢 Added by:

🔧 PR: #5702, Add veSync to dex.trades on zkSync
🧙 Author: @lgingerich on 2024-03-29
📝 Summary: This dbt SQL model creates a table called uniswap_compatible_v2_trades that enables data analysts to analyze and track trades on the Zksync blockchain for the Vesync project. It sources data from two specific events, Pair_evt_Swap and Factory_evt_PairCreated, allowing for further analysis of trading activities within this context.

MODEL: dracula_finance_zksync_base_trades.sql

🟢 Added by:

🔧 PR: #5703, Add Dracula Finance to dex.trades for zkSync
🧙 Author: @lgingerich on 2024-03-29
📝 Summary: This dbt SQL model creates a table called uniswap_compatible_v2_trades that enables data analysts to analyze and track trades on the ZkSync blockchain for the Dracula Finance project. It sources data from events related to pair swaps and pair creations in the Dracula Finance ZkSync environment, allowing for further analysis of trading activities within this ecosystem.

MODEL: cex_arbitrum_flows.sql

🟢 Added by:

🔧 PR: #5586, Expand cex_{chain}.flows to all EVM chains
🧙 Author: @hildobby on 2024-03-27
📝 Summary: This SQL model creates a CEX flows table that enables data analysts to track and analyze the flow of tokens on the Arbitrum blockchain. It references tables for token transfers and addresses specific to the Arbitrum blockchain, allowing for detailed analysis of token movements within centralized exchanges on this network.

MODEL: cex_avalanche_c_flows.sql

🟢 Added by:

🔧 PR: #5586, Expand cex_{chain}.flows to all EVM chains
🧙 Author: @hildobby on 2024-03-27
📝 Summary: This model creates a table that tracks flows of tokens on the Avalanche blockchain from centralized exchanges. It enables data analysts to analyze and understand the movement of tokens between centralized exchange addresses on the Avalanche blockchain.

MODEL: cex_base_flows.sql

🟢 Added by:

🔧 PR: #5586, Expand cex_{chain}.flows to all EVM chains
🧙 Author: @hildobby on 2024-03-27
📝 Summary: This SQL model creates a view that calculates flows of tokens between addresses on a centralized exchange (CEX) for a specified blockchain. It enables data analysts to analyze and track token transfers within the CEX ecosystem, providing insights into user behavior and transaction patterns.

MODEL: cex_bnb_flows.sql

🟢 Added by:

🔧 PR: #5586, Expand cex_{chain}.flows to all EVM chains
🧙 Author: @hildobby on 2024-03-27
📝 Summary: This SQL model creates a CEX flows table that enables data analysts to track and analyze the flow of tokens on the Binance blockchain. It references tables for token transfers and CEX addresses specific to the Binance blockchain, allowing for in-depth analysis of token movements within centralized exchanges on this blockchain.

MODEL: cex_celo_flows.sql

🟢 Added by:

🔧 PR: #5586, Expand cex_{chain}.flows to all EVM chains
🧙 Author: @hildobby on 2024-03-27
📝 Summary: This model creates a table that tracks flows of tokens on the Celo blockchain, enabling data analysts to analyze and understand the movement of tokens within centralized exchanges related to Celo.

MODEL: cex_ethereum_flows.sql

🟠 Modified by:

🔧 PR: #5586, Expand cex_{chain}.flows to all EVM chains
🧙 Author: @hildobby on 2024-03-27
📝 Summary: The changes involve updating the references for 'transfers' and 'addresses' by dynamically incorporating the blockchain variable into their names.

MODEL: cex_gnosis_flows.sql

🟢 Added by:

🔧 PR: #5586, Expand cex_{chain}.flows to all EVM chains
🧙 Author: @hildobby on 2024-03-27
📝 Summary: This model creates a table that tracks flows of tokens on the Gnosis blockchain, utilizing data from tables related to token transfers and addresses specific to centralized exchanges on the Gnosis blockchain. This enables data analysts to analyze and understand the movement of tokens within centralized exchanges operating on the Gnosis blockchain.

MODEL: cex_optimism_flows.sql

🟢 Added by:

🔧 PR: #5586, Expand cex_{chain}.flows to all EVM chains
🧙 Author: @hildobby on 2024-03-27
📝 Summary: This SQL model creates a CEX flows table that enables data analysts to track and analyze the flow of tokens on the Optimism blockchain. It references tables for token transfers and addresses specific to the Optimism blockchain, allowing for detailed analysis of token movements within centralized exchanges on this network.

MODEL: cex_polygon_flows.sql

🟢 Added by:

🔧 PR: #5586, Expand cex_{chain}.flows to all EVM chains
🧙 Author: @hildobby on 2024-03-27
📝 Summary: This SQL model creates a CEX flows table that enables data analysts to track and analyze the flow of tokens on the Polygon blockchain. It references tables for token transfers and CEX addresses specific to the Polygon blockchain, providing insights into transaction activities within centralized exchanges on this network.

MODEL: cex_scroll_flows.sql

🟢 Added by:

🔧 PR: #5586, Expand cex_{chain}.flows to all EVM chains
🧙 Author: @hildobby on 2024-03-27
📝 Summary: This model creates a dbt SQL macro called cex_flows that takes in parameters related to blockchain transfers and addresses. It enables data analysts to analyze flows of tokens between centralized exchange (CEX) addresses on a specified blockchain, facilitating insights into transaction patterns and volumes for further analysis.

MODEL: cex_zksync_flows.sql

🟢 Added by:

🔧 PR: #5586, Expand cex_{chain}.flows to all EVM chains
🧙 Author: @hildobby on 2024-03-27
📝 Summary: This SQL model creates a table that tracks flows of tokens on the zkSync blockchain from centralized exchanges (CEX) addresses. It enables data analysts to analyze and understand the movement of tokens between CEX addresses on the zkSync blockchain.

MODEL: cex_zora_flows.sql

🟢 Added by:

🔧 PR: #5586, Expand cex_{chain}.flows to all EVM chains
🧙 Author: @hildobby on 2024-03-27
📝 Summary: This SQL model creates a CEX flows table that enables data analysts to track and analyze the flow of tokens on the Zora blockchain. It references tables for token transfers and addresses specific to the Zora blockchain, providing insights into transaction activities within centralized exchanges on this blockchain.

MODEL: pancakeswap_v3_zksync_base_trades.sql

🟢 Added by:

🔧 PR: #5682, Add Pancakeswap V3 dex.trades to zkSync
🧙 Author: @lgingerich on 2024-03-27
📝 Summary: This dbt SQL model creates a table called uniswap_compatible_v3_trades that enables data analysts to analyze and track trades on the PancakeSwap project using the ZkSync blockchain technology. The model specifically focuses on version 3 of PancakeSwap, allowing for detailed analysis of swap events and pool creations within this ecosystem.

MODEL: spacefi_v1_zksync_base_trades.sql

🟢 Added by:

🔧 PR: #5683, Add SpaceFi V1 dex.trades for zkSync
🧙 Author: @lgingerich on 2024-03-27
📝 Summary: This model creates a table called uniswap_compatible_v2_trades that enables data analysts to analyze trade data from the Uniswap V2 protocol on the ZkSync blockchain for the SpaceFi project version 1. It sources swap and pair creation events from specific tables for further analysis.

MODEL: contracts_contract_creator_address_list.sql

🟠 Modified by:

🔧 PR: #5686, Update contracts_contract_creator_address_list.sql
🧙 Author: @MarcoVugts on 2024-03-27
📝 Summary: Rows for 'GMX' with its corresponding address were added to the curated_list CTE.

MODEL: nft_old_base_trades.sql

🟠 Modified by:

🔧 PR: #5539, add seaport on base
🧙 Author: @BroderickBonelli on 2024-03-26
📝 Summary: A reference to a new model opensea_v4_base_events was added.

🔧 PR: #5539, Add Zora Opensea trades to nft.trades
🧙 Author: @kaiblade on 2024-03-25
📝 Summary: A reference to a new model opensea_v4_zora_events was added in the dbt SQL code.

MODEL: opensea_events.sql

🟠 Modified by:

🔧 PR: #5539, Add Zora Opensea trades to nft.trades
🧙 Author: @kaiblade on 2024-03-25
📝 Summary: The logic removed was a SELECT statement with multiple columns from the 'opensea_polygon_events' table.

MODEL: geodnet_polygon_revenue.sql

🟢 Added by:

🔧 PR: #5584, Add DePin Revenue Table (+GEODNET as first entry)
🧙 Author: @0xnirmal on 2024-03-25
📝 Summary: This model enables data analysts to calculate and track the daily burned value in USD for a specific project on the Polygon blockchain. It processes hourly burn events, token prices, and imputes missing values to determine the total tokens burned and their corresponding USD value each day. The final output includes the date, blockchain name (Polygon), project name ('geodnet'), and revenue generated from tokens burned in USD.

SECTOR: rollup_economics

toggle to see all model updates

MODEL: l1_verification_fees.sql

🟠 Modified by:

🔧 PR: #5704, Fix Rollup Economics for zkSync Verification Fees
🧙 Author: @lgingerich on 2024-03-29
📝 Summary: Added logic to filter transactions settling at a specific address post-EIP4844.

MODEL: l1_data_fees.sql

🟠 Modified by:

🔧 PR: #5660, Add new Arbitrum batch submitter transactions to rollup economics
🧙 Author: @Jam516 on 2024-03-25
📝 Summary: A new SQL logic was added to the model that selects specific columns from an Ethereum transactions table based on certain conditions. The query filters transactions where the 'from' address is a specific value, the 'to' address is another specific value, and additional criteria related to data and block number are met. This logic also includes a conditional check for incremental loading based on block time within a specified timeframe.

SECTOR: evms

toggle to see all model updates

MODEL: evms_contracts.sql

🟠 Modified by:

🔧 PR: #5699, add abi_id field to evms.contracts
🧙 Author: @0xRobin on 2024-03-28
📝 Summary: An abi_id column was added to the SELECT statement, while a UNION ALL clause was removed from the query.

SECTOR: opensea

toggle to see all model updates

MODEL: opensea_v3_optimism_events.sql

🟠 Modified by:

🔧 PR: #5698, Cleanup seaport decoded tables
🧙 Author: @0xRobin on 2024-03-28
📝 Summary: Added sources for 'Seaport_optimism' and updated the source names in the dbt SQL model.

MODEL: opensea_base_events.sql

🟢 Added by:

🔧 PR: #5677, add seaport on base
🧙 Author: @BroderickBonelli on 2024-03-26
📝 Summary: This model creates a dataset with various fields related to blockchain transactions, including details about projects, tokens, trade types, fees, addresses involved in the transaction, and more. It enables data analysts to analyze and track activities such as token trades on the OpenSea platform.

MODEL: opensea_v4_base_events.sql

🟢 Added by:

🔧 PR: #5677, add seaport on base
🧙 Author: @BroderickBonelli on 2024-03-26
📝 Summary: This model creates a view that combines data from different sources related to trades on the Seaport platform. It allows data analysts to analyze trade information, filter by specific criteria such as fee wallet name or hash value, and extract insights for further analysis.

MODEL: opensea_v4_ethereum_events.sql

🟠 Modified by:

🔧 PR: #5672, Add seaport v1.6
🧙 Author: @0xRobin on 2024-03-26
📝 Summary: A new signed zone for seaport v1.6 was added to the model, alongside a comment indicating that it is newly added on seaport v1.4.

MODEL: opensea_v4_zora_events.sql

🟢 Added by:

🔧 PR: #5539, Add Zora Opensea trades to nft.trades
🧙 Author: @kaiblade on 2024-03-25
📝 Summary: This model creates a CTE called 'fee_wallets' with wallet addresses and names. It then uses this CTE along with other sources to populate the 'trades' table, filtering by specific criteria such as fee wallet name and hash value. This model enables data analysts to analyze trades related to a blockchain platform (zora) starting from a certain date, focusing on transactions involving specific wallets and tokens.

MODEL: opensea_v4_polygon_events.sql

🟠 Modified by:

🔧 PR: #5646, clean up opensea bugs and standardize for short-term
🧙 Author: @jeff-dude on 2024-03-22
📝 Summary: A temporary fix was added to exclude duplicates in the SQL model. This logic filters out rows where certain columns have duplicate values by grouping them and selecting only those with a count greater than 1.

SECTOR: seaport

toggle to see all model updates

MODEL: seaport_optimism_base_pairs.sql

🟠 Modified by:

🔧 PR: #5698, Cleanup seaport decoded tables
🧙 Author: @0xRobin on 2024-03-28
📝 Summary: In this diff, changes were made to the SQL model 'base_pairs' in an incremental materialization. The modifications include adjusting the column aliases and source table names for 'Seaport_evt_OrderFulfilled' from 'opensea_optimism' to 'seaport_optimism'. Additionally, there are adjustments related to columns like sender, receiver, zone, offer_idx and consideration_item.

SECTOR: balancer

toggle to see all model updates

MODEL: balancer_bpt_prices.sql

🟠 Modified by:

🔧 PR: #5684, Updates to Balancer spells
🧙 Author: @viniabussafi on 2024-03-27
📝 Summary: Added a new column pool_type to the SELECT statement from the bpt_prices table.

MODEL: balancer_liquidity.sql

🟠 Modified by:

🔧 PR: #5684, Updates to Balancer spells
🧙 Author: @viniabussafi on 2024-03-27
📝 Summary: Added a new column pool_type to the SQL model.

MODEL: balancer_protocol_fee.sql

🟠 Modified by:

🔧 PR: #5684, Updates to Balancer spells
🧙 Author: @viniabussafi on 2024-03-27
📝 Summary: A new column pool_type was added to the SQL model.

MODEL: balancer_single_recipient_gauges.sql

🟢 Added by:

🔧 PR: #5684, Updates to Balancer spells
🧙 Author: @viniabussafi on 2024-03-27
📝 Summary: This model creates a whitelist_token CTE that manually links each gauge to its corresponding pool and project by deploying gauges through the SingleRecipientGauge contract. This enables data analysts to easily access information about different tokens, their associated pool IDs, projects, and blockchains in one consolidated view.

MODEL: balancer_v1_ethereum_liquidity.sql

🟠 Modified by:

🔧 PR: #5684, Updates to Balancer spells
🧙 Author: @viniabussafi on 2024-03-27
📝 Summary: Added a new column 'pool_type' with the value 'V1' to the pool_labels CTE.

SECTOR: addresses_events

toggle to see all model updates

MODEL: addresses_events_solana_first_funded_by.sql

🟢 Added by:

🔧 PR: #5675, Create addresses_events_solana.first_funded_by
🧙 Author: @hildobby on 2024-03-27
📝 Summary: This model creates a table that tracks transactions on the Solana blockchain. It includes information such as the blockchain name, addresses involved in transactions, details about funding sources, block time and slot of transactions, as well as transaction IDs and indexes. This model enables data analysts to analyze transaction data on the Solana blockchain at a granular level.

SECTOR: sol_trading_bot

toggle to see all model updates

MODEL: sol_trading_bot_solana_bot_trades.sql

🟢 Added by:

🔧 PR: #5657, feat: add sol trading bot solana trades spellbook
🧙 Author: @whalehunting on 2024-03-26
📝 Summary: This model creates a dataset that combines fee payments with trade data from the Solana blockchain. It enables data analysts to analyze trades, including token amounts, prices, fees in USD and tokens, project details, user information, and transaction structure. The model also identifies the last trade within each transaction based on inner instruction indexes.

MODEL: sol_trading_bot_solana_trades_seed.csv

🟢 Added by:

🔧 PR: #5657, feat: add sol trading bot solana trades spellbook
🧙 Author: @whalehunting on 2024-03-26
📝 Summary: [changes too large] The model sol_trading_bot_solana_trades_seed.csv was added.

SECTOR: pepe_boost

toggle to see all model updates

MODEL: pepe_boost_solana_bot_trades.sql

🟢 Added by:

🔧 PR: #5658, feat: add pepe boost solana trades spellbook
🧙 Author: @whalehunting on 2024-03-26
📝 Summary: This model enables data analysts to analyze fee payments and bot trades on the Solana blockchain. It combines information about fee payments in SOL or SPL tokens with details of bot trades, including trade amounts, symbols, addresses, fees in USD and tokens, project details, user IDs, transaction IDs. The model also identifies the last trade within a transaction based on inner instruction indexes.

MODEL: pepe_boost_solana_trades_seed.csv

🟢 Added by:

🔧 PR: #5658, feat: add pepe boost solana trades spellbook
🧙 Author: @whalehunting on 2024-03-26
📝 Summary: [changes too large] The model pepe_boost_solana_trades_seed.csv was added.

SECTOR: maestro

toggle to see all model updates

MODEL: maestro_solana_bot_trades.sql

🟢 Added by:

🔧 PR: #5662, feat: add maestro solana trades spellbook
🧙 Author: @whalehunting on 2024-03-26
📝 Summary: This model creates a dataset that combines fee payments with trade data from the Solana blockchain. It calculates and includes fees in USD, token amounts, symbols, addresses, project details, user information, transaction IDs and indexes. The model also identifies the last trade in each transaction based on inner instruction indexes. This enables data analysts to analyze trading activity including fees associated with transactions on the Solana blockchain effectively.

MODEL: maestro_solana_trades_seed.csv

🟢 Added by:

🔧 PR: #5662, feat: add maestro solana trades spellbook
🧙 Author: @whalehunting on 2024-03-26
📝 Summary: [changes too large] The model maestro_solana_trades_seed.csv was added.

SECTOR: shuriken

toggle to see all model updates

MODEL: shuriken_solana_bot_trades.sql

🟢 Added by:

🔧 PR: #5663, feat: add shuriken solana trades spellbook
🧙 Author: @whalehunting on 2024-03-26
📝 Summary: This model creates a dataset that combines fee payments in SOL tokens with bot trades on the Solana blockchain. It includes details such as trade amounts, symbols, addresses, fees in USD and tokens, project information, user IDs, transaction IDs and indices. Additionally, it identifies the last trade within each transaction based on inner instruction index comparison. The model enables data analysts to analyze fee payments associated with specific trades and determine the final trade within transactions for further insights into trading activities on Solana.

MODEL: shuriken_solana_trades_seed.csv

🟢 Added by:

🔧 PR: #5663, feat: add shuriken solana trades spellbook
🧙 Author: @whalehunting on 2024-03-26
📝 Summary: [changes too large] The model shuriken_solana_trades_seed.csv was added.

SECTOR: magnum

toggle to see all model updates

MODEL: magnum_solana_bot_trades.sql

🟢 Added by:

🔧 PR: #5664, feat: add magnum solana trades spellbook
🧙 Author: @whalehunting on 2024-03-26
📝 Summary: This model creates a dataset that combines fee payments on the Solana blockchain with bot trades data, allowing data analysts to analyze trade details such as amounts, symbols, fees in USD and tokens, project information, user IDs, transaction details like indexes and timestamps. The final output includes information on each trade along with flags indicating if it is the last trade in a transaction.

MODEL: magnum_solana_trades_seed.csv

🟢 Added by:

🔧 PR: #5664, feat: add magnum solana trades spellbook
🧙 Author: @whalehunting on 2024-03-26
📝 Summary: [changes too large] The model magnum_solana_trades_seed.csv was added.

SECTOR: readyswap

toggle to see all model updates

MODEL: readyswap_solana_bot_trades.sql

🟢 Added by:

🔧 PR: #5665, feat: add readyswap solana trades spellbook
🧙 Author: @whalehunting on 2024-03-26
📝 Summary: This model enables data analysts to analyze fee payments and bot trades on the Solana blockchain. It combines fee payment information with trade details, including transaction amounts, symbols, addresses, fees in USD and tokens, project details, user IDs, and transaction indexes. The model also identifies the last trade in each transaction based on inner instruction indexes.

MODEL: readyswap_solana_trades_seed.csv

🟢 Added by:

🔧 PR: #5665, feat: add readyswap solana trades spellbook
🧙 Author: @whalehunting on 2024-03-26
📝 Summary: [changes too large] The model readyswap_solana_trades_seed.csv was added.

SECTOR: trojan

toggle to see all model updates

MODEL: trojan_solana_bot_trades.sql

🟢 Added by:

🔧 PR: #5615, feat: add trojan trades spellbook
🧙 Author: @whalehunting on 2024-03-26
📝 Summary: This model creates a dataset that combines fee payments with bot trades data from the Solana blockchain. It calculates various trade metrics such as USD amounts, token symbols, addresses, fees in USD and tokens, project details, user IDs, transaction information like indexes and timestamps. Additionally it identifies the last trade in each transaction based on inner instruction index comparison. This enables data analysts to analyze trading activities including fees paid by specific receivers on Solana blockchain projects starting from a specified date.

MODEL: trojan_solana_trades_seed.csv

🟢 Added by:

🔧 PR: #5615, feat: add trojan trades spellbook
🧙 Author: @whalehunting on 2024-03-26
📝 Summary: [changes too large] The model trojan_solana_trades_seed.csv was added.

SECTOR: banana_gun

toggle to see all model updates

MODEL: banana_gun_solana_bot_trades.sql

🟢 Added by:

🔧 PR: #5614, feat: add banana gun trades spellbook
🧙 Author: @whalehunting on 2024-03-26
📝 Summary: This model creates a dataset that combines fee payments with bot trades on the Solana blockchain. It calculates various trade metrics such as USD amounts, token symbols, addresses, fees in USD and tokens, project details, user IDs, and transaction information. The model also identifies the last trade within each transaction based on inner instruction indexes. This enables data analysts to analyze trading activity involving specific fee receivers and understand the flow of fees within transactions effectively for reporting or further analysis purposes.

MODEL: banana_gun_solana_trades_seed.csv

🟢 Added by:

🔧 PR: #5614, feat: add banana gun trades spellbook
🧙 Author: @whalehunting on 2024-03-26
📝 Summary: [changes too large] The model banana_gun_solana_trades_seed.csv was added.

SECTOR: cow_protocol

toggle to see all model updates

MODEL: cow_protocol_ethereum_solvers.sql

🟠 Modified by:

🔧 PR: #5655, [CoW Protocol] Add SeaSolver_v2 solver address
🧙 Author: @harisang on 2024-03-26
📝 Summary: Rows were added and removed in the known_solver_metadata CTE. Two rows with 'Seasolver_v2' as the name were added, one for 'prod' environment and another for 'barn'. Additionally, a row with 'Seasolver_v1' as the name was changed to have an environment of 'barn'. Two rows were removed: one with address 0x94aEF67903bFe8Bf65193A78074C887ba901d043 from staging environment and another row from test environment.

MODEL: cow_protocol_ethereum_trades.sql

🟠 Modified by:

🔧 PR: #5647, Update cow_protocol_ethereum_trades.sql
🧙 Author: @olgafetisova on 2024-03-22
📝 Summary: Added logic:

• Joined the 'trades_with_token_units' table with a new condition on 'hash=tx_hash'.
• Added columns 'evt_tx_hash' and derived columns from JSON data in the 'uid_to_app_id' CTE.

MODEL: cow_protocol_gnosis_trades.sql

🟠 Modified by:

🔧 PR: #5649, Update cow_protocol_gnosis_trades.sql
🧙 Author: @olgafetisova on 2024-03-22
📝 Summary: Added logic:

• Joined the 'trades_with_token_units' table with the 'uid_to_app_id' table on conditions where 'uid' matches 'order_uid', and also added a condition where 'hash' matches 'tx_hash'.

SECTOR: staking

toggle to see all model updates

MODEL: staking_ethereum_entities_depositor_addresses.sql

🟠 Modified by:

🔧 PR: #5639, Tagging more ETH stakers
🧙 Author: @hildobby on 2024-03-25
📝 Summary: One entry was removed from the first section related to 'Cumberland' and three entries were added in the second section for 'Copper.co', 'Upbit 1', and 'Upbit 2'. The context seems to be about different entities categorized into types like CEX, Staking Pool, Liquid Restaking.

MODEL: staking_ethereum_info.sql

🟠 Modified by:

🔧 PR: #5639, Tagging more ETH stakers
🧙 Author: @hildobby on 2024-03-25
📝 Summary: Added a new row for 'Copper.co' with the corresponding x_username 'CopperHQ' to the temporary table.

SECTOR: bonkbot

toggle to see all model updates

MODEL: bonkbot_solana_trades_seed.csv

🟠 Modified by:

🔧 PR: #5661, fix: make bonkbot spellbook seed blockchain column lowercase
🧙 Author: @whalehunting on 2024-03-25
📝 Summary: [changes too large] The model bonkbot_solana_trades_seed.csv was modified.

SECTOR: gyroscope

toggle to see all model updates

MODEL: gyroscope_gyro_tokens.sql

🟠 Modified by:

🔧 PR: #5668, Add missing tokens
🧙 Author: @viniabussafi on 2024-03-25
📝 Summary: Two new entries were added to the gyro_tokens Common Table Expression (CTE) for tokens related to Polygon blockchain.

SECTOR: chainlink

toggle to see all model updates

MODEL: chainlink_arbitrum_ccip_fulfilled_transactions.sql

🟠 Modified by:

🔧 PR: #5650, Feature/ccip v1.2.0
🧙 Author: @AnonJon on 2024-03-22
📝 Summary: Added logic to select data from a new table chainlink_arbitrum_ccip_send_requested_logs_v1 and join it with the transactions table. Also, added similar logic for another table chainlink_arbitrum_ccip_send_requested_logs_v1_2. Replaced references to columns like 'from' with 'caller_address' and trace_address with tx_index.

🔧 PR: #5650, updated ccip v1.2
🧙 Author: @AnonJon on 2024-03-22
📝 Summary: Added logic to select data from a new table chainlink_arbitrum_ccip_send_requested_logs_v1 and join it with the transactions table. Another similar block of logic was added for a different version of the logs table (chainlink_arbitrum_ccip_send_requested_logs_v1_2). The model now selects specific columns from these tables, renames some columns, and filters based on successful transactions and incremental conditions.

🔧 PR: #5650, Revert 'updated ccip v1.2 (#5621)'
🧙 Author: @jeff-dude on 2024-03-22
📝 Summary: Added logic to select data from a new source chainlink_arbitrum_ccip_send_traces and renamed columns in the final output. Removed logic related to another source chainlink_arbitrum_ccip_send_requested_logs_v1_2. Updated conditions for selecting successful transactions based on the new source.

MODEL: chainlink_arbitrum_ccip_onramp_meta.sql

🟢 Added by:

🔧 PR: #5621, Feature/ccip v1.2.0
🧙 Author: @AnonJon on 2024-03-22
📝 Summary: This model creates a table with columns for blockchain, onramp, chain selector, and version. It populates the table with values for different blockchains such as Ethereum, Optimism, Avalanche C-Chain, Polygon (Matic), Binance Smart Chain (BNB), and Wemix. The data includes unique identifiers for each blockchain along with their corresponding versions like v1.0.0 and v1.2.0.This enables data analysts to track and analyze various blockchains' information in a structured format within the databa