📰 2024-06-21: Weekly Prophet!

[andrewhong5297]

This is your weekly summary of 18 PRs merged from 14 wizards. Great job everyone! 🎉
We had 3 added models 🟢 and 1213 modified models 🟠 for 30 Sectors.

Sector	🔧 # PRs	🟢 # Added	🟠 # Modified	🧙 # Authors
dex	2	1	2	2
labels	1	0	24	1
prices	4	0	5	4
models	6	2	755	5
seeds	3	0	294	3
tests	3	0	10	3
_sector	2	0	4	2
_trino_upgrade	2	0	3	1
evms	1	0	16	1
lido	1	0	35	1
nexusmutual	1	0	1	1
blobs	1	0	1	1
macros	1	0	16	1
_project	1	0	10	1
alchemydao	1	0	1	1
beethoven_x	1	0	1	1
camelot	1	0	1	1
cow_protocol	1	0	12	1
dao	1	0	8	1
gearbox	1	0	1	1
gyroscope	1	0	4	1
hashflow	1	0	1	1
keep3r_network	1	0	1	1
paraswap	1	0	1	1
safe	1	0	1	1
thales	1	0	1	1
uniswap	1	0	1	1
value_defi	1	0	1	1
velodrome	1	0	1	1
curvefi	1	0	1	1

SECTOR: dex

toggle to see all model updates

MODEL: dex_solana_price_hour.sql

🟢 Added by:

🔧 PR: #6080, Add solana dex price hrs
🧙 Author: @thanhlmm on 2024-06-18
📝 Summary: This model calculates the average price of tokens bought and sold on the Solana blockchain per hour. It combines data from two subqueries to create a final dataset that includes contract addresses, hours, token symbols, decimals, blockchain information (Solana), average prices, and block months. This enables data analysts to analyze token trading patterns over time on the Solana blockchain at an hourly level.

MODEL: dex_schema.yml

🟠 Modified by:

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: [changes too large] The model dex_schema.yml was modified.

MODEL: dex_trades_seed.csv

🟠 Modified by:

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: [changes too large] The model dex_trades_seed.csv was removed.

SECTOR: labels

toggle to see all model updates

MODEL: labels_balancer_v2_gauges_arbitrum.sql

🟠 Modified by:

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: A new source was added for 'balancer_v2_pools_arbitrum' in the LEFT JOIN clause, replacing the previous reference. This change was made in multiple sections of the SQL model to ensure that pools with a non-null name are included.

MODEL: labels_balancer_v2_gauges_avalanche_c.sql

🟠 Modified by:

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: A join to a source named 'labels' was added, replacing a reference to 'labels_balancer_v2_pools_avalanche_c'. The change involves updating the source for fetching data related to pools in the model.

MODEL: labels_balancer_v2_gauges_base.sql

🟠 Modified by:

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: Added a source reference to 'labels' for joining with the child table, replacing a reference to 'ref'.

MODEL: labels_balancer_v2_gauges_ethereum.sql

🟠 Modified by:

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: A new source is added for 'labels' in the LEFT JOIN clause, replacing the previous reference to 'labels_balancer_v2_pools_ethereum'. This change affects both SELECT statements in the model.

MODEL: labels_balancer_v2_gauges_gnosis.sql

🟠 Modified by:

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: Added a source reference to 'labels' for the table 'balancer_v2_pools_gnosis', replacing the previous reference to a ref.

MODEL: labels_balancer_v2_gauges_optimism.sql

🟠 Modified by:

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: Added a left join to source 'labels' for pools on streamer.pool in two sections. Replaced ref('labels_balancer_v2_pools_optimism') with source('labels', 'balancer_v2_pools_optimism').

MODEL: labels_balancer_v2_gauges_polygon.sql

🟠 Modified by:

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: Added a left join to a source named 'labels' for the table 'balancer_v2_pools_polygon', replacing the previous reference join. This change was made in multiple sections of the SQL model where joins were performed between different tables.

MODEL: labels_balancer_v2_gauges_zkevm.sql

🟠 Modified by:

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: A join to a source was changed from using a ref() function to directly accessing the source.

MODEL: labels_op_chains_likely_bot_addresses.sql

🟠 Modified by:

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: Added logic to calculate the number of DEX trade transactions by checking for existence in a specific source table.

MODEL: labels_op_chains_likely_bot_contracts.sql

🟠 Modified by:

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: Added logic to count the number of DEX trade transactions by checking for existence in a specific source table. The condition includes matching transaction hash, block time, month, and blockchain.

MODEL: labels_arbitrage_traders_ethereum.sql

🟠 Modified by:

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: The changes involve replacing references to dbt models with sources. The model now uses source instead of ref to reference the tables 'dex_trades' and 'dex_aggregator_trades'. This change affects the data source being queried in the SQL model.

MODEL: labels_dex_aggregator_traders.sql

🟠 Modified by:

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: The SQL model was updated to change the source of data from a dbt ref to a dbt source. The logic remains the same, where distinct taker addresses are selected along with their corresponding blockchain information.

MODEL: labels_dex_pools.sql

🟠 Modified by:

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: The SQL model was updated to change the source of data from a dbt ref() function referencing 'dex_pools' to a source() function specifying schema 'dex' and table 'pools'. The SELECT statement includes columns for blockchain, current timestamp as updated_at, static values for model_name and label_type.

MODEL: labels_dex_traders.sql

🟠 Modified by:

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: The SQL model was updated to change the reference from 'dex_trades' to source('dex', 'trades'). The GROUP BY clause for taker and tx_from columns were also removed, and a UNION ALL statement was added.

MODEL: labels_op_dex_traders.sql

🟠 Modified by:

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: The change made in the SQL model involves updating the source of data from a dbt ref to a dbt source. The table being referenced is now sourced from 'dex' schema and 'trades' table instead of 'dex_trades'.

MODEL: labels_sandwich_attackers_ethereum.sql

🟠 Modified by:

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: The SQL model was updated to change the references from a dbt ref() function to a source() function. The logic remains the same, where distinct addresses are selected based on certain conditions involving trades in the dex.

MODEL: labels_smart_dex_traders_ethereum.sql

🟠 Modified by:

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: Added logic to calculate cost basis and venue for swappers based on trades from the 'dex' source in Ethereum blockchain within the last 60 days.

MODEL: labels_trader_platforms.sql

🟠 Modified by:

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: The SQL model was updated to change the references for two sources, 'dex_aggregator_trades' and 'dex_trades', to use the source function instead of ref. The logic remains the same with a union all operation on selected columns from each source, followed by grouping and ordering based on specific columns.

MODEL: labels_average_trade_values.sql

🟠 Modified by:

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: The SQL model was updated to change the references for two tables, dex_aggregator_trades and dex_trades, to use sources from dex_aggregator and dex. The logic remains the same where data is selected from these sources, combined using UNION ALL, and then grouped by 'taker' and 'blockchain'.

MODEL: labels_trader_age.sql

🟠 Modified by:

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: The SQL model was updated to change the source of data for two tables, 'dex_aggregator_trades' and 'dex_trades', from ref() to source(). The logic remains the same where data is selected from these tables and combined using UNION ALL, followed by grouping based on taker and blockchain.

MODEL: labels_trader_dex_diversity.sql

🟠 Modified by:

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: Added a source reference to 'dex_aggregator' and 'trades', and removed a reference to 'dex_aggregator_trades'. Added a source reference to 'dex' and 'trades', and removed a reference to 'dex_trades'.

MODEL: labels_trader_frequencies.sql

🟠 Modified by:

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: The SQL model was updated to change the source of data for trades from 'dex_aggregator_trades' and 'dex_trades' to sources named 'dex_aggregator' and 'dex', respectively. The logic groups the data by taker and blockchain, filtering for entities with more than one trade per day.

MODEL: labels_trader_kyt.sql

🟠 Modified by:

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: Added logic to calculate monthly trade amount and row number based on the sum of trade amounts. Changed source reference from 'dex_trades' to 'dex.trades'. Added a join condition with a subquery filtering trades within the last 3 months. Removed filter for block_time in the main query, keeping only a filter for trades within the last year.

MODEL: labels_addresses.sql

🟠 Modified by:

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: labels_balancer_v1_pools, labels_balancer_v2_pools

SECTOR: prices

toggle to see all model updates

MODEL: prices_tokens.sql

🟠 Modified by:

🔧 PR: #6190, [easy] Add USDB & WETH Prices on Blast - Ready for review
🧙 Author: @henrystats on 2024-06-18
📝 Summary: prices_blast_tokens

MODEL: prices_ethereum_tokens.sql

🟠 Modified by:

🔧 PR: #6173, Add GIV token to ethereum prices
🧙 Author: @aminlatifi on 2024-06-18
📝 Summary: The tokens that were added or removed are: GIV

🔧 PR: #6173, [EASY] chore: add DOUGH price feed
🧙 Author: @whalehunting on 2024-06-18
📝 Summary: DOUGH

MODEL: prices_arbitrum_tokens.sql

🟠 Modified by:

🔧 PR: #6174, Add THE, NMT, PEPECOIN, VRTX token
🧙 Author: @lydiapuspita on 2024-06-18
📝 Summary: The token symbols that were added or removed are: VRTX

MODEL: prices_bnb_tokens.sql

🟠 Modified by:

🔧 PR: #6174, Add THE, NMT, PEPECOIN, VRTX token
🧙 Author: @lydiapuspita on 2024-06-18
📝 Summary: THE, THENA

SECTOR: models

toggle to see all model updates

MODEL: oneinch_arbitrum_project_calls.sql

🟠 Modified by:

🔧 PR: #6161, 1inch-U27-3: project_* lineage split to stages - migrate
🧙 Author: @grkhr on 2024-06-21
📝 Summary: [changes too large] The model oneinch_arbitrum_project_calls.sql was renamed.

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: [changes too large] The model oneinch_arbitrum_project_calls.sql was renamed.

MODEL: oneinch_arbitrum_project_orders.sql

🟠 Modified by:

🔧 PR: #6161, 1inch-U27-3: project_* lineage split to stages - migrate
🧙 Author: @grkhr on 2024-06-21
📝 Summary: [changes too large] The model oneinch_arbitrum_project_orders.sql was renamed.

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: [changes too large] The model oneinch_arbitrum_project_orders.sql was renamed.

MODEL: oneinch_arbitrum_project_swaps.sql

🟠 Modified by:

🔧 PR: #6161, 1inch-U27-3: project_* lineage split to stages - migrate
🧙 Author: @grkhr on 2024-06-21
📝 Summary: [changes too large] The model oneinch_arbitrum_project_swaps.sql was renamed.

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: [changes too large] The model oneinch_arbitrum_project_swaps.sql was renamed.

MODEL: oneinch_avalanche_c_project_calls.sql

🟠 Modified by:

🔧 PR: #6161, 1inch-U27-3: project_* lineage split to stages - migrate
🧙 Author: @grkhr on 2024-06-21
📝 Summary: [changes too large] The model oneinch_avalanche_c_project_calls.sql was renamed.

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: [changes too large] The model oneinch_avalanche_c_project_calls.sql was renamed.

MODEL: oneinch_avalanche_c_project_orders.sql

🟠 Modified by:

🔧 PR: #6161, 1inch-U27-3: project_* lineage split to stages - migrate
🧙 Author: @grkhr on 2024-06-21
📝 Summary: [changes too large] The model oneinch_avalanche_c_project_orders.sql was renamed.

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: [changes too large] The model oneinch_avalanche_c_project_orders.sql was renamed.

MODEL: oneinch_avalanche_c_project_swaps.sql

🟠 Modified by:

🔧 PR: #6161, 1inch-U27-3: project_* lineage split to stages - migrate
🧙 Author: @grkhr on 2024-06-21
📝 Summary: [changes too large] The model oneinch_avalanche_c_project_swaps.sql was renamed.

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: [changes too large] The model oneinch_avalanche_c_project_swaps.sql was renamed.

MODEL: oneinch_base_project_calls.sql

🟠 Modified by:

🔧 PR: #6161, 1inch-U27-3: project_* lineage split to stages - migrate
🧙 Author: @grkhr on 2024-06-21
📝 Summary: [changes too large] The model oneinch_base_project_calls.sql was renamed.

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: [changes too large] The model oneinch_base_project_calls.sql was renamed.

MODEL: oneinch_base_project_orders.sql

🟠 Modified by:

🔧 PR: #6161, 1inch-U27-3: project_* lineage split to stages - migrate
🧙 Author: @grkhr on 2024-06-21
📝 Summary: [changes too large] The model oneinch_base_project_orders.sql was renamed.

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: [changes too large] The model oneinch_base_project_orders.sql was renamed.

MODEL: oneinch_base_project_swaps.sql

🟠 Modified by:

🔧 PR: #6161, 1inch-U27-3: project_* lineage split to stages - migrate
🧙 Author: @grkhr on 2024-06-21
📝 Summary: [changes too large] The model oneinch_base_project_swaps.sql was renamed.

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: [changes too large] The model oneinch_base_project_swaps.sql was renamed.

MODEL: oneinch_bnb_project_calls.sql

🟠 Modified by:

🔧 PR: #6161, 1inch-U27-3: project_* lineage split to stages - migrate
🧙 Author: @grkhr on 2024-06-21
📝 Summary: [changes too large] The model oneinch_bnb_project_calls.sql was renamed.

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: [changes too large] The model oneinch_bnb_project_calls.sql was renamed.

MODEL: oneinch_bnb_project_orders.sql

🟠 Modified by:

🔧 PR: #6161, 1inch-U27-3: project_* lineage split to stages - migrate
🧙 Author: @grkhr on 2024-06-21
📝 Summary: [changes too large] The model oneinch_bnb_project_orders.sql was renamed.

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: [changes too large] The model oneinch_bnb_project_orders.sql was renamed.

MODEL: oneinch_bnb_project_swaps.sql

🟠 Modified by:

🔧 PR: #6161, 1inch-U27-3: project_* lineage split to stages - migrate
🧙 Author: @grkhr on 2024-06-21
📝 Summary: [changes too large] The model oneinch_bnb_project_swaps.sql was renamed.

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: [changes too large] The model oneinch_bnb_project_swaps.sql was renamed.

MODEL: oneinch_ethereum_project_calls.sql

🟠 Modified by:

🔧 PR: #6161, 1inch-U27-3: project_* lineage split to stages - migrate
🧙 Author: @grkhr on 2024-06-21
📝 Summary: [changes too large] The model oneinch_ethereum_project_calls.sql was renamed.

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: [changes too large] The model oneinch_ethereum_project_calls.sql was renamed.

MODEL: oneinch_ethereum_project_orders.sql

🟠 Modified by:

🔧 PR: #6161, 1inch-U27-3: project_* lineage split to stages - migrate
🧙 Author: @grkhr on 2024-06-21
📝 Summary: [changes too large] The model oneinch_ethereum_project_orders.sql was renamed.

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: [changes too large] The model oneinch_ethereum_project_orders.sql was renamed.

MODEL: oneinch_ethereum_project_swaps.sql

🟠 Modified by:

🔧 PR: #6161, 1inch-U27-3: project_* lineage split to stages - migrate
🧙 Author: @grkhr on 2024-06-21
📝 Summary: [changes too large] The model oneinch_ethereum_project_swaps.sql was renamed.

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: [changes too large] The model oneinch_ethereum_project_swaps.sql was renamed.

MODEL: oneinch_fantom_project_calls.sql

🟠 Modified by:

🔧 PR: #6161, 1inch-U27-3: project_* lineage split to stages - migrate
🧙 Author: @grkhr on 2024-06-21
📝 Summary: [changes too large] The model oneinch_fantom_project_calls.sql was renamed.

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: [changes too large] The model oneinch_fantom_project_calls.sql was renamed.

MODEL: oneinch_fantom_project_orders.sql

🟠 Modified by:

🔧 PR: #6161, 1inch-U27-3: project_* lineage split to stages - migrate
🧙 Author: @grkhr on 2024-06-21
📝 Summary: [changes too large] The model oneinch_fantom_project_orders.sql was renamed.

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: [changes too large] The model oneinch_fantom_project_orders.sql was renamed.

MODEL: oneinch_fantom_project_swaps.sql

🟠 Modified by:

🔧 PR: #6161, 1inch-U27-3: project_* lineage split to stages - migrate
🧙 Author: @grkhr on 2024-06-21
📝 Summary: [changes too large] The model oneinch_fantom_project_swaps.sql was renamed.

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: [changes too large] The model oneinch_fantom_project_swaps.sql was renamed.

MODEL: oneinch_gnosis_project_calls.sql

🟠 Modified by:

🔧 PR: #6161, 1inch-U27-3: project_* lineage split to stages - migrate
🧙 Author: @grkhr on 2024-06-21
📝 Summary: [changes too large] The model oneinch_gnosis_project_calls.sql was renamed.

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: [changes too large] The model oneinch_gnosis_project_calls.sql was renamed.

MODEL: oneinch_gnosis_project_orders.sql

🟠 Modified by:

🔧 PR: #6161, 1inch-U27-3: project_* lineage split to stages - migrate
🧙 Author: @grkhr on 2024-06-21
📝 Summary: [changes too large] The model oneinch_gnosis_project_orders.sql was renamed.

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: [changes too large] The model oneinch_gnosis_project_orders.sql was renamed.

MODEL: oneinch_gnosis_project_swaps.sql

🟠 Modified by:

🔧 PR: #6161, 1inch-U27-3: project_* lineage split to stages - migrate
🧙 Author: @grkhr on 2024-06-21
📝 Summary: [changes too large] The model oneinch_gnosis_project_swaps.sql was renamed.

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: [changes too large] The model oneinch_gnosis_project_swaps.sql was renamed.

MODEL: oneinch_optimism_project_calls.sql

🟠 Modified by:

🔧 PR: #6161, 1inch-U27-3: project_* lineage split to stages - migrate
🧙 Author: @grkhr on 2024-06-21
📝 Summary: [changes too large] The model oneinch_optimism_project_calls.sql was renamed.

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: [changes too large] The model oneinch_optimism_project_calls.sql was renamed.

MODEL: oneinch_optimism_project_orders.sql

🟠 Modified by:

🔧 PR: #6161, 1inch-U27-3: project_* lineage split to stages - migrate
🧙 Author: @grkhr on 2024-06-21
📝 Summary: [changes too large] The model oneinch_optimism_project_orders.sql was renamed.

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: [changes too large] The model oneinch_optimism_project_orders.sql was renamed.

MODEL: oneinch_optimism_project_swaps.sql

🟠 Modified by:

🔧 PR: #6161, 1inch-U27-3: project_* lineage split to stages - migrate
🧙 Author: @grkhr on 2024-06-21
📝 Summary: [changes too large] The model oneinch_optimism_project_swaps.sql was renamed.

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: [changes too large] The model oneinch_optimism_project_swaps.sql was renamed.

MODEL: oneinch_polygon_project_calls.sql

🟠 Modified by:

🔧 PR: #6161, 1inch-U27-3: project_* lineage split to stages - migrate
🧙 Author: @grkhr on 2024-06-21
📝 Summary: [changes too large] The model oneinch_polygon_project_calls.sql was renamed.

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: [changes too large] The model oneinch_polygon_project_calls.sql was renamed.

MODEL: oneinch_polygon_project_orders.sql

🟠 Modified by:

🔧 PR: #6161, 1inch-U27-3: project_* lineage split to stages - migrate
🧙 Author: @grkhr on 2024-06-21
📝 Summary: [changes too large] The model oneinch_polygon_project_orders.sql was renamed.

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: [changes too large] The model oneinch_polygon_project_orders.sql was renamed.

MODEL: oneinch_polygon_project_swaps.sql

🟠 Modified by:

🔧 PR: #6161, 1inch-U27-3: project_* lineage split to stages - migrate
🧙 Author: @grkhr on 2024-06-21
📝 Summary: [changes too large] The model oneinch_polygon_project_swaps.sql was renamed.

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: [changes too large] The model oneinch_polygon_project_swaps.sql was renamed.

MODEL: oneinch_zksync_project_calls.sql

🟠 Modified by:

🔧 PR: #6161, 1inch-U27-3: project_* lineage split to stages - migrate
🧙 Author: @grkhr on 2024-06-21
📝 Summary: [changes too large] The model oneinch_zksync_project_calls.sql was renamed.

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: [changes too large] The model oneinch_zksync_project_calls.sql was renamed.

MODEL: oneinch_zksync_project_orders.sql

🟠 Modified by:

🔧 PR: #6161, 1inch-U27-3: project_* lineage split to stages - migrate
🧙 Author: @grkhr on 2024-06-21
📝 Summary: [changes too large] The model oneinch_zksync_project_orders.sql was renamed.

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: [changes too large] The model oneinch_zksync_project_orders.sql was renamed.

MODEL: oneinch_zksync_project_swaps.sql

🟠 Modified by:

🔧 PR: #6161, 1inch-U27-3: project_* lineage split to stages - migrate
🧙 Author: @grkhr on 2024-06-21
📝 Summary: [changes too large] The model oneinch_zksync_project_swaps.sql was renamed.

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: [changes too large] The model oneinch_zksync_project_swaps.sql was renamed.

MODEL: oneinch_project_orders_macro.sql

🟠 Modified by:

🔧 PR: #6191, 1inch-U27-3: project_* lineage split to stages - migrate
🧙 Author: @grkhr on 2024-06-21
📝 Summary: [changes too large] The model oneinch_project_orders_macro.sql was modified.

🔧 PR: #6191, 1inch-U27: project_* lineage split to stages
🧙 Author: @grkhr on 2024-06-21
📝 Summary: [changes too large] The model oneinch_project_orders_macro.sql was renamed.

🔧 PR: #6191, 1inch-U26: fixed project_orders & optimized project_calls flows
🧙 Author: @max-morrow on 2024-06-19
📝 Summary: [changes too large] The model oneinch_project_orders_macro.sql was modified.

MODEL: oneinch_project_calls_macro.sql

🟠 Modified by:

🔧 PR: #6222, 1inch-U27: project_* lineage split to stages
🧙 Author: @grkhr on 2024-06-21
📝 Summary: [changes too large] The model oneinch_project_calls_macro.sql was renamed.

MODEL: oneinch_project_cfg_events_macro.sql

🟢 Added by:

🔧 PR: #6222, 1inch-U27: project_* lineage split to stages
🧙 Author: @grkhr on 2024-06-21
📝 Summary: [changes too large] The model oneinch_project_cfg_events_macro.sql was added.

MODEL: oneinch_project_cfg_methods_macro.sql

🟢 Added by:

🔧 PR: #6222, 1inch-U27: project_* lineage split to stages
🧙 Author: @grkhr on 2024-06-21
📝 Summary: [changes too large] The model oneinch_project_cfg_methods_macro.sql was added.

MODEL: oneinch_project_swaps_macro.sql

🟠 Modified by:

🔧 PR: #6222, 1inch-U27: project_* lineage split to stages
🧙 Author: @grkhr on 2024-06-21
📝 Summary: [changes too large] The model oneinch_project_swaps_macro.sql was renamed.

MODEL: nft_solana_old_trades.sql

🟠 Modified by:

🔧 PR: #6202, move NFT solana models
🧙 Author: @0xRobin on 2024-06-20
📝 Summary: [changes too large] The model nft_solana_old_trades.sql was renamed.

MODEL: nft_solana_trades.sql

🟠 Modified by:

🔧 PR: #6202, move NFT solana models
🧙 Author: @0xRobin on 2024-06-20
📝 Summary: [changes too large] The model nft_solana_trades.sql was renamed.

MODEL: _schema.yml

🟠 Modified by:

🔧 PR: #6161, move NFT solana models
🧙 Author: @0xRobin on 2024-06-20
📝 Summary: [changes too large] The model _schema.yml was renamed.

🔧 PR: #6161, Solana subproject
🧙 Author: @aalan3 on 2024-06-19
📝 Summary: [changes too large] The model _schema.yml was renamed.

🔧 PR: #6161, dex sector subproject creation
🧙 Author: @jeff-dude on 2024-06-17
📝 Summary: [changes too large] The model _schema.yml was renamed.

MODEL: magiceden_solana_events.sql

🟠 Modified by:

🔧 PR: #6202, move NFT solana models
🧙 Author: @0xRobin on 2024-06-20
📝 Summary: [changes too large] The model magiceden_solana_events.sql was renamed.

MODEL: opensea_solana_events.sql

🟠 Modified by:

🔧 PR: #6202, move NFT solana models
🧙 Author: @0xRobin on 2024-06-20
📝 Summary: [changes too large] The model opensea_solana_events.sql was renamed.

MODEL: magiceden_mmm_solana_trades.sql

🟠 Modified by:

🔧 PR: #6202, move NFT solana models
🧙 Author: @0xRobin on 2024-06-20
📝 Summary: [changes too large] The model magiceden_mmm_solana_trades.sql was renamed.

MODEL: magiceden_v2_solana_trades.sql

🟠 Modified by:

🔧 PR: #6202, move NFT solana models
🧙 Author: @0xRobin on 2024-06-20
📝 Summary: [changes too large] The model magiceden_v2_solana_trades.sql was renamed.

MODEL: magiceden_v3_solana_trades.sql

🟠 Modified by:

🔧 PR: #6202, move NFT solana models
🧙 Author: @0xRobin on 2024-06-20
📝 Summary: [changes too large] The model magiceden_v3_solana_trades.sql was renamed.

MODEL: tensorswap_v1_solana_trades.sql

🟠 Modified by:

🔧 PR: #6202, move NFT solana models
🧙 Author: @0xRobin on 2024-06-20
📝 Summary: [changes too large] The model tensorswap_v1_solana_trades.sql was renamed.

MODEL: tensorswap_v2_solana_trades.sql

🟠 Modified by:

🔧 PR: #6202, move NFT solana models
🧙 Author: @0xRobin on 2024-06-20
📝 Summary: [changes too large] The model tensorswap_v2_solana_trades.sql was renamed.

MODEL: dex_solana_bot_trades.sql

🟠 Modified by:

🔧 PR: #6197, Solana subproject
🧙 Author: @aalan3 on 2024-06-19
📝 Summary: [changes too large] The model dex_solana_bot_trades.sql was renamed.

MODEL: banana_gun_solana_bot_trades.sql

🟠 Modified by:

🔧 PR: #6197, Solana subproject
🧙 Author: @aalan3 on 2024-06-19
📝 Summary: [changes too large] The model banana_gun_solana_bot_trades.sql was renamed.

MODEL: bonkbot_solana_bot_trades.sql

🟠 Modified by:

🔧 PR: #6197, Solana subproject
🧙 Author: @aalan3 on 2024-06-19
📝 Summary: [changes too large] The model bonkbot_solana_bot_trades.sql was renamed.

MODEL: consortium_key_solana_bot_trades.sql

🟠 Modified by:

🔧 PR: #6197, Solana subproject
🧙 Author: @aalan3 on 2024-06-19
📝 Summary: [changes too large] The model consortium_key_solana_bot_trades.sql was renamed.

MODEL: looter_solana_bot_trades.sql

🟠 Modified by:

🔧 PR: #6197, Solana subproject
🧙 Author: @aalan3 on 2024-06-19
📝 Summary: [changes too large] The model looter_solana_bot_trades.sql was renamed.

MODEL: maestro_solana_bot_trades.sql

🟠 Modified by:

🔧 PR: #6197, Solana subproject
🧙 Author: @aalan3 on 2024-06-19
📝 Summary: [changes too large] The model maestro_solana_bot_trades.sql was renamed.

MODEL: magnum_solana_bot_trades.sql

🟠 Modified by:

🔧 PR: #6197, Solana subproject
🧙 Author: @aalan3 on 2024-06-19
📝 Summary: [changes too large] The model magnum_solana_bot_trades.sql was renamed.

MODEL: pepe_boost_solana_bot_trades.sql

🟠 Modified by:

🔧 PR: #6197, Solana subproject
🧙 Author: @aalan3 on 2024-06-19
📝 Summary: [changes too large] The model pepe_boost_solana_bot_trades.sql was renamed.

MODEL: readyswap_solana_bot_trades.sql

🟠 Modified by:

🔧 PR: #6197, Solana subproject
🧙 Author: @aalan3 on 2024-06-19
📝 Summary: [changes too large] The model readyswap_solana_bot_trades.sql was renamed.

MODEL: shuriken_solana_bot_trades.sql

🟠 Modified by:

🔧 PR: #6197, Solana subproject
🧙 Author: @aalan3 on 2024-06-19
📝 Summary: [changes too large] The model shuriken_solana_bot_trades.sql was renamed.

MODEL: sol_gun_solana_bot_trades.sql

🟠 Modified by:

🔧 PR: #6197, Solana subproject
🧙 Author: @aalan3 on 2024-06-19
📝 Summary: [changes too large] The model sol_gun_solana_bot_trades.sql was renamed.

MODEL: sol_trading_bot_solana_bot_trades.sql

🟠 Modified by:

🔧 PR: #6197, Solana subproject
🧙 Author: @aalan3 on 2024-06-19
📝 Summary: [changes too large] The model sol_trading_bot_solana_bot_trades.sql was renamed.

MODEL: soul_sniper_solana_bot_trades.sql

🟠 Modified by:

🔧 PR: #6197, Solana subproject
🧙 Author: @aalan3 on 2024-06-19
📝 Summary: [changes too large] The model soul_sniper_solana_bot_trades.sql was renamed.

MODEL: trojan_solana_bot_trades.sql

🟠 Modified by:

🔧 PR: #6197, Solana subproject
🧙 Author: @aalan3 on 2024-06-19
📝 Summary: [changes too large] The model trojan_solana_bot_trades.sql was renamed.

MODEL: wifbot_solana_bot_trades.sql

🟠 Modified by:

🔧 PR: #6197, Solana subproject
🧙 Author: @aalan3 on 2024-06-19
📝 Summary: [changes too large] The model wifbot_solana_bot_trades.sql was renamed.

MODEL: dex_solana_price_hour.sql

🟠 Modified by:

🔧 PR: #6197, Solana subproject
🧙 Author: @aalan3 on 2024-06-19
📝 Summary: [changes too large] The model dex_solana_price_hour.sql was renamed.

MODEL: dex_solana_schema.yml

🟠 Modified by:

🔧 PR: #6197, Solana subproject
🧙 Author: @aalan3 on 2024-06-19
📝 Summary: [changes too large] The model dex_solana_schema.yml was renamed.

MODEL: dex_solana_trades.sql

🟠 Modified by:

🔧 PR: #6197, Solana subproject
🧙 Author: @aalan3 on 2024-06-19
📝 Summary: [changes too large] The model dex_solana_trades.sql was renamed.

MODEL: goosefx_ssl_v2_solana_trades.sql

🟠 Modified by:

🔧 PR: #6197, Solana subproject
🧙 Author: @aalan3 on 2024-06-19
📝 Summary: [changes too large] The model goosefx_ssl_v2_solana_trades.sql was renamed.

MODEL: jupiter_solana_perp_events.sql

🟠 Modified by:

🔧 PR: #6197, Solana subproject
🧙 Author: @aalan3 on 2024-06-19
📝 Summary: [changes too large] The model jupiter_solana_perp_events.sql was renamed.

MODEL: jupiter_solana_schema.yml

🟠 Modified by:

🔧 PR: #6197, Solana subproject
🧙 Author: @aalan3 on 2024-06-19
📝 Summary: [changes too large] The model jupiter_solana_schema.yml was renamed.

MODEL: lifinity_v1_trades.sql

🟠 Modified by:

🔧 PR: #6197, Solana subproject
🧙 Author: @aalan3 on 2024-06-19
📝 Summary: [changes too large] The model lifinity_v1_trades.sql was renamed.

MODEL: lifinity_v2_trades.sql

🟠 Modified by:

🔧 PR: #6197, Solana subproject
🧙 Author: @aalan3 on 2024-06-19
📝 Summary: [changes too large] The model lifinity_v2_trades.sql was renamed.

MODEL: schema.yml

🟠 Modified by:

🔧 PR: #6197, Solana subproject
🧙 Author: @aalan3 on 2024-06-19
📝 Summary: [changes too large] The model schema.yml was renamed.

MODEL: sources.yml

🟠 Modified by:

🔧 PR: #6197, Solana subproject
🧙 Author: @aalan3 on 2024-06-19
📝 Summary: [changes too large] The model sources.yml was renamed.

MODEL: meteora_v1_solana_trades.sql

🟠 Modified by:

🔧 PR: #6197, Solana subproject
🧙 Author: @aalan3 on 2024-06-19
📝 Summary: [changes too large] The model meteora_v1_solana_trades.sql was renamed.

MODEL: meteora_v2_solana_trades.sql

🟠 Modified by:

🔧 PR: #6197, Solana subproject
🧙 Author: @aalan3 on 2024-06-19
📝 Summary: [changes too large] The model meteora_v2_solana_trades.sql was renamed.

MODEL: orca_whirlpool_schema.yml

🟠 Modified by:

🔧 PR: #6197, Solana subproject
🧙 Author: @aalan3 on 2024-06-19
📝 Summary: [changes too large] The model orca_whirlpool_schema.yml was renamed.

MODEL: orca_whirlpool_token_prices.sql

🟠 Modified by:

🔧 PR: #6197, Solana subproject
🧙 Author: @aalan3 on 2024-06-19
📝 Summary: [changes too large] The model orca_whirlpool_token_prices.sql was renamed.

MODEL: orca_whirlpool_token_prices_hour.sql

🟠 Modified by:

🔧 PR: #6197, Solana subproject
🧙 Author: @aalan3 on 2024-06-19
📝 Summary: [changes too large] The model orca_whirlpool_token_prices_hour.sql was renamed.

MODEL: orca_whirlpool_trades.sql

🟠 Modified by:

🔧 PR: #6197, Solana subproject
🧙 Author: @aalan3 on 2024-06-19
📝 Summary: [changes too large] The model orca_whirlpool_trades.sql was renamed.

MODEL: phoenix_v1_trades.sql

🟠 Modified by:

🔧 PR: #6197, Solana subproject
🧙 Author: @aalan3 on 2024-06-19
📝 Summary: [changes too large] The model phoenix_v1_trades.sql was renamed.

MODEL: raydium_v3_trades.sql

🟠 Modified by:

🔧 PR: #6197, Solana subproject
🧙 Author: @aalan3 on 2024-06-19
📝 Summary: [changes too large] The model raydium_v3_trades.sql was renamed.

MODEL: raydium_v4_trades.sql

🟠 Modified by:

🔧 PR: #6197, Solana subproject
🧙 Author: @aalan3 on 2024-06-19
📝 Summary: [changes too large] The model raydium_v4_trades.sql was renamed.

MODEL: hivemapper_solana_rewards.sql

🟠 Modified by:

🔧 PR: #6197, Solana subproject
🧙 Author: @aalan3 on 2024-06-19
📝 Summary: [changes too large] The model hivemapper_solana_rewards.sql was renamed.

MODEL: hivemapper_solana_schema.yml

🟠 Modified by:

🔧 PR: #6197, Solana subproject
🧙 Author: @aalan3 on 2024-06-19
📝 Summary: [changes too large] The model hivemapper_solana_schema.yml was renamed.

MODEL: solana_utils_daily_balances.sql

🟠 Modified by:

🔧 PR: #6197, [Solana subproject](https://github.com/duneanalyti