📰 2024-02-23: Weekly Prophet!

[andrewhong5297]

This is your weekly summary of 22 PRs merged from 16 wizards. Great job everyone! 🎉
We had 40 added models 🟢 and 103 modified models 🟠 for 12 Sectors.

Sector	🔧 # PRs	🟢 # Added	🟠 # Modified	🧙 # Authors
dex	2	0	2	2
prices	3	0	5	3
synthetix	1	2	1	1
_sector	13	32	69	9
odos	1	2	0	1
transfers	1	1	0	1
layer_bank	1	1	0	1
lido	1	1	1	1
abi	1	0	1	1
rollup_economics	1	0	2	1
models	1	1	0	1
balancer	1	0	22	1

SECTOR: dex

toggle to see all model updates

MODEL: dex_info.sql

🟠 Modified by:

🔧 PR: #5378, Added sterling finance and sharkyswap dex to dex.trades
🧙 Author: @ARDev097 on 2024-02-22
📝 Summary: Added two new projects, 'Sterling Finance' and 'Sharky Swap', to the temporary table with their corresponding details.

🔧 PR: #5378, Add Scroll dexs to trades_beta
🧙 Author: @tomfutago on 2024-02-20
📝 Summary: Added new values for projects 'wombat_exchange', 'zebra', and 'scrollswap' with corresponding details in the temp table.

SECTOR: prices

toggle to see all model updates

MODEL: prices_ethereum_tokens.sql

🟠 Modified by:

🔧 PR: #5380, [URGENT] remove PEAKDEFI token
🧙 Author: @grkhr on 2024-02-21
📝 Summary: The token symbols that were added or removed are:
PEAK

🔧 PR: #5380, Add ATA price on Ethereum, BNB Chain, and Polygon
🧙 Author: @arviantodwi on 2024-02-20
📝 Summary: The token symbols that were added or removed are: AJNA, ATA

🔧 PR: #5380, add AJNA price on ethereum
🧙 Author: @gunboatsss on 2024-02-19
📝 Summary: The token symbols that were added or removed are: USDe, AJNA

MODEL: prices_bnb_tokens.sql

🟠 Modified by:

🔧 PR: #5382, Add ATA price on Ethereum, BNB Chain, and Polygon
🧙 Author: @arviantodwi on 2024-02-20
📝 Summary: The token symbols that were added or removed are: SUB, ATA

MODEL: prices_polygon_tokens.sql

🟠 Modified by:

🔧 PR: #5382, Add ATA price on Ethereum, BNB Chain, and Polygon
🧙 Author: @arviantodwi on 2024-02-20
📝 Summary: GTC, GMT, TEL, ATA

SECTOR: synthetix

toggle to see all model updates

MODEL: synthetix_base_perpetual_trades.sql

🟢 Added by:

🔧 PR: #5387, Add Synthetix Base Perpetual Trades -- Ready for review
🧙 Author: @henrystats on 2024-02-22
📝 Summary: This model combines data from the 'synthetix_v3_base_perpetual_trades' table, allowing analysts to access information on blockchain trades including assets, markets, volumes, fees, margins and traders. The model enables querying across multiple versions of the base perpetual trade data for comprehensive analysis.

MODEL: synthetix_v3_base_perpetual_trades.sql

🟢 Added by:

🔧 PR: #5387, Add Synthetix Base Perpetual Trades -- Ready for review
🧙 Author: @henrystats on 2024-02-22
📝 Summary: This model creates a dataset that tracks trading activities on Synthetix markets. It includes information such as volume, fees, margin, trade type (long/short), project details, trader info, and transaction details. The model enables data analysts to analyze trading behavior and performance metrics for different virtual assets within the Synthetix ecosystem.

MODEL: synthetix_perpetual_trades.sql

🟠 Modified by:

🔧 PR: #5387, Add Synthetix Base Perpetual Trades -- Ready for review
🧙 Author: @henrystats on 2024-02-22
📝 Summary: Two references were added to the synthetix_perpetual_trade_models list: synthetix_optimism_perpetual_trades and synthetix_base_perpetual_trades.

SECTOR: _sector

toggle to see all model updates

MODEL: dex_arbitrum_base_trades.sql

🟠 Modified by:

🔧 PR: #5385, Uniswap V2 Trades (Arbitrum, Polygon, Optimism, Base, BNB & Avalanche) - Ready for review
🧙 Author: @henrystats on 2024-02-22
📝 Summary: A reference to a new model uniswap_v2_arbitrum_base_trades was added in the dbt SQL code.

🔧 PR: #5385, Added sterling finance and sharkyswap dex to dex.trades
🧙 Author: @ARDev097 on 2024-02-22
📝 Summary: Two references were added: 'sterling_finance_arbitrum_base_trades' and 'sharkyswap_arbitrum_base_trades'.

MODEL: uniswap_v2_arbitrum_base_trades.sql

🟢 Added by:

🔧 PR: #5388, Uniswap V2 Trades (Arbitrum, Polygon, Optimism, Base, BNB & Avalanche) - Ready for review
🧙 Author: @henrystats on 2024-02-22
📝 Summary: This new dbt SQL model creates a table called uniswap_compatible_v2_trades that enables data analysts to analyze Uniswap V2 trades on the Arbitrum blockchain. It pulls data from specific sources related to Uniswap V2 pairs and factory events, allowing for in-depth analysis of trading activities within this ecosystem.

MODEL: uniswap_v3_arbitrum_base_trades.sql

🟠 Modified by:

🔧 PR: #5388, Uniswap V2 Trades (Arbitrum, Polygon, Optimism, Base, BNB & Avalanche) - Ready for review
🧙 Author: @henrystats on 2024-02-22
📝 Summary: In this change, two sources were added: 'Pair_evt_Swap' and 'Factory_evt_PoolCreated' from the database table 'uniswap_v3_arbitrum'.

MODEL: dex_avalanche_c_base_trades.sql

🟠 Modified by:

🔧 PR: #5388, Uniswap V2 Trades (Arbitrum, Polygon, Optimism, Base, BNB & Avalanche) - Ready for review
🧙 Author: @henrystats on 2024-02-22
📝 Summary: A reference to a new model uniswap_v2_avalanche_c_base_trades was added in the SQL code.

MODEL: uniswap_v2_avalanche_c_base_trades.sql

🟢 Added by:

🔧 PR: #5388, Uniswap V2 Trades (Arbitrum, Polygon, Optimism, Base, BNB & Avalanche) - Ready for review
🧙 Author: @henrystats on 2024-02-22
📝 Summary: This dbt SQL model creates a table called uniswap_compatible_v2_trades that enables data analysts to analyze and work with trade data from Uniswap version 2 on the Avalanche blockchain. It sources information from specific events related to pair swaps and pair creations within the Uniswap V2 ecosystem on Avalanche, providing a structured dataset for further analysis.

MODEL: uniswap_v3_avalanche_c_base_trades.sql

🟠 Modified by:

🔧 PR: #5388, Uniswap V2 Trades (Arbitrum, Polygon, Optimism, Base, BNB & Avalanche) - Ready for review
🧙 Author: @henrystats on 2024-02-22
📝 Summary: In this pull request, a refresh command was added to the dbt SQL model.

MODEL: dex_base_base_trades.sql

🟠 Modified by:

🔧 PR: #5388, Uniswap V2 Trades (Arbitrum, Polygon, Optimism, Base, BNB & Avalanche) - Ready for review
🧙 Author: @henrystats on 2024-02-22
📝 Summary: A reference to a new model uniswap_v2_base_base_trades was added in the SQL code.

MODEL: uniswap_v2_base_base_trades.sql

🟢 Added by:

🔧 PR: #5388, Uniswap V2 Trades (Arbitrum, Polygon, Optimism, Base, BNB & Avalanche) - Ready for review
🧙 Author: @henrystats on 2024-02-22
📝 Summary: This dbt SQL model creates a table called uniswap_compatible_v2_trades that enables data analysts to analyze and track trades on the Uniswap V2 platform. It sources data from events related to pair swaps and pair creations in the Uniswap V2 base, allowing for further analysis of trading activities within this specific version of the platform.

MODEL: uniswap_v3_base_base_trades.sql

🟠 Modified by:

🔧 PR: #5388, Uniswap V2 Trades (Arbitrum, Polygon, Optimism, Base, BNB & Avalanche) - Ready for review
🧙 Author: @henrystats on 2024-02-22
📝 Summary: In this pull request, a refresh command was added to the dbt SQL model.

MODEL: dex_bnb_base_trades.sql

🟠 Modified by:

🔧 PR: #5388, Uniswap V2 Trades (Arbitrum, Polygon, Optimism, Base, BNB & Avalanche) - Ready for review
🧙 Author: @henrystats on 2024-02-22
📝 Summary: Added a reference to 'uniswap_v2_bnb_base_trades' in the SQL model.

MODEL: uniswap_v2_bnb_base_trades.sql

🟢 Added by:

🔧 PR: #5388, Uniswap V2 Trades (Arbitrum, Polygon, Optimism, Base, BNB & Avalanche) - Ready for review
🧙 Author: @henrystats on 2024-02-22
📝 Summary: This dbt SQL model creates a table called uniswap_compatible_v2_trades that enables data analysts to analyze and track trades on the Uniswap V2 platform for the Binance Smart Chain (bnb). It sources trade events from 'UniswapV2Pair_evt_Swap' and pair creation events from 'UniswapV2Factory_evt_PairCreated'.

MODEL: uniswap_v3_bnb_base_trades.sql

🟠 Modified by:

🔧 PR: #5388, Uniswap V2 Trades (Arbitrum, Polygon, Optimism, Base, BNB & Avalanche) - Ready for review
🧙 Author: @henrystats on 2024-02-22
📝 Summary: In this change, two sources were added: 'Pair_evt_Swap' and 'Factory_evt_PoolCreated' from the 'uniswap_v3_bnb'.

MODEL: dex_optimism_base_trades.sql

🟠 Modified by:

🔧 PR: #5350, Uniswap V2 Trades (Arbitrum, Polygon, Optimism, Base, BNB & Avalanche) - Ready for review
🧙 Author: @henrystats on 2024-02-22
📝 Summary: A reference to a new model uniswap_v2_optimism_base_trades was added in the SQL query.

🔧 PR: #5350, Added Dackiewswap_v2 , Dackiewswap_v3 and Wombat_exchange dexes to dex.trades
🧙 Author: @Jason4276 on 2024-02-19
📝 Summary: Two references were added: 'dackieswap_v2_optimism_base_trades', 'dackieswap_v3_optimism_base_trades', and 'wombat_exchange_optimism_base_trades'.

MODEL: uniswap_v2_optimism_base_trades.sql

🟢 Added by:

🔧 PR: #5388, Uniswap V2 Trades (Arbitrum, Polygon, Optimism, Base, BNB & Avalanche) - Ready for review
🧙 Author: @henrystats on 2024-02-22
📝 Summary: This dbt SQL model creates a table called uniswap_compatible_v2_trades that enables data analysts to analyze and track trades on the Uniswap V2 platform specifically for the Optimism blockchain. It sources data from events related to pair swaps and pair creations in Uniswap V2 on the Optimism network.

MODEL: uniswap_v3_optimism_base_trades.sql

🟠 Modified by:

🔧 PR: #5388, Uniswap V2 Trades (Arbitrum, Polygon, Optimism, Base, BNB & Avalanche) - Ready for review
🧙 Author: @henrystats on 2024-02-22
📝 Summary: In this change, a refresh command was added to the dbt SQL model.

MODEL: dex_polygon_base_trades.sql

🟠 Modified by:

🔧 PR: #5388, Uniswap V2 Trades (Arbitrum, Polygon, Optimism, Base, BNB & Avalanche) - Ready for review
🧙 Author: @henrystats on 2024-02-22
📝 Summary: A reference to a new model called 'uniswap_v2_polygon_base_trades' was added in the SQL query.

MODEL: uniswap_v2_polygon_base_trades.sql

🟢 Added by:

🔧 PR: #5388, Uniswap V2 Trades (Arbitrum, Polygon, Optimism, Base, BNB & Avalanche) - Ready for review
🧙 Author: @henrystats on 2024-02-22
📝 Summary: This dbt SQL model creates a table called uniswap_compatible_v2_trades that enables data analysts to analyze trade data from the Uniswap V2 protocol on the Polygon blockchain. It sources information from events related to pair swaps and pair creations in the UniswapV2Pair_evt_Swap and UniswapV2Factory_evt_PairCreated tables, respectively.

MODEL: uniswap_v3_polygon_base_trades.sql

🟠 Modified by:

🔧 PR: #5388, Uniswap V2 Trades (Arbitrum, Polygon, Optimism, Base, BNB & Avalanche) - Ready for review
🧙 Author: @henrystats on 2024-02-22
📝 Summary: The code added a refresh statement to the dbt SQL model.

MODEL: contracts_contract_creator_address_list.sql

🟠 Modified by:

🔧 PR: #5372, Contracts - Static Updates
🧙 Author: @MSilb7 on 2024-02-22
📝 Summary: Three new entries were added to the 'curated_list' CTE with corresponding creator addresses and contract project names.

🔧 PR: #5372, Adding creator_contract_address of protocols to Base
🧙 Author: @Hirangi5 on 2024-02-19
📝 Summary: Rows were added to the 'curated_list' CTE for various projects such as 'Toupee.tech', 'Sweep', 'Bas3d', and others. These rows include the project's address and name.

MODEL: contracts_contract_overrides.sql

🟠 Modified by:

🔧 PR: #5395, Contracts - Static Updates
🧙 Author: @MSilb7 on 2024-02-22
📝 Summary: A new Ethereum L1 contract address with its corresponding labels was added to the model.

MODEL: nft_solana_trades.sql

🟠 Modified by:

🔧 PR: #5357, [solana] add magiceden v3 trade
🧙 Author: @tsekityam on 2024-02-22
📝 Summary: Added a reference to 'magiceden_v3_solana_trades' in the list of Solana marketplaces.

🔧 PR: #5357, [solana] add magic eden mmm trades
🧙 Author: @tsekityam on 2024-02-19
📝 Summary: A new reference to a table named 'magiceden_mmm_solana_trades' was added to the list of Solana marketplaces in this dbt SQL model.

MODEL: magiceden_v3_solana_trades.sql

🟢 Added by:

🔧 PR: #5375, [solana] add magiceden v3 trade
🧙 Author: @tsekityam on 2024-02-22
📝 Summary: This model creates a dataset that combines transaction data from different sources to analyze fees and prices related to transactions on the Solana blockchain. It enables data analysts to track buyer, seller, fees (maker fee, taker fee), royalties, and other relevant information for each transaction. Additionally, it calculates amounts in USD based on token prices and provides percentages for various fees relative to the transaction price.

MODEL: nft_scroll_approvals.sql

🟢 Added by:

🔧 PR: #5349, Add Scroll NFT models
🧙 Author: @0xRobin on 2024-02-22
📝 Summary: This dbt SQL model creates a table called nft_approvals that consolidates approval events for NFTs on the 'scroll' blockchain. It enables data analysts to analyze and track approvals for ERC721 and ERC1155 tokens, including individual approvals and approval-for-all events.

MODEL: nft_approvals.sql

🟠 Modified by:

🔧 PR: #5349, Add Scroll NFT models
🧙 Author: @0xRobin on 2024-02-22
📝 Summary: A new reference to 'nft_scroll_approvals' was added to the list of nft_models.

MODEL: zonic_optimism_base_trades.sql

🟠 Modified by:

🔧 PR: #5349, Add Scroll NFT models
🧙 Author: @0xRobin on 2024-02-22
📝 Summary: Added a CTE named events_raw with specific columns selected from the source table. Removed several sets and conditions related to incremental loading and filtering by block number or date in the initial query.

MODEL: nft_scroll_base_trades.sql

🟢 Added by:

🔧 PR: #5349, Add Scroll NFT models
🧙 Author: @0xRobin on 2024-02-22
📝 Summary: This model creates a union of data from multiple NFT models, allowing data analysts to query and analyze information related to blockchain transactions, including details such as project information, trade specifics, fees involved, and transaction addresses. This consolidated dataset enables comprehensive analysis of NFT trades across different projects and versions.

MODEL: element_scroll_base_trades.sql

🟢 Added by:

🔧 PR: #5349, Add Scroll NFT models
🧙 Author: @0xRobin on 2024-02-22
📝 Summary: This model creates a base table that consolidates data on ERC721 token transactions for the 'scroll' blockchain project. It includes details such as trade type, amount, category, seller/buyer information, price in raw form and currency contract. The model also generates additional fields like platform fee amount/address and royalty fee amount/address to enhance analysis capabilities for data analysts working with ERC721 token transactions.

MODEL: zonic_scroll_base_trades.sql

🟢 Added by:

🔧 PR: #5349, Add Scroll NFT models
🧙 Author: @0xRobin on 2024-02-22
📝 Summary: This model creates a dataset that combines information from Zonic Marketplace events and transfers, enabling data analysts to analyze trade transactions including buyer, seller, price, fees paid (platform and royalty), as well as blockchain-specific details like block number and time. The model also categorizes trades by type ('secondary'), project version ('v1'), and includes additional metadata for further analysis.

MODEL: nft_base_trades.sql

🟠 Modified by:

🔧 PR: #5349, Add Scroll NFT models
🧙 Author: @0xRobin on 2024-02-22
📝 Summary: A reference to a new model called 'nft_scroll_base_trades' was added to the SQL query.

MODEL: nft_scroll_transfers.sql

🟢 Added by:

🔧 PR: #5349, Add Scroll NFT models
🧙 Author: @0xRobin on 2024-02-22
📝 Summary: This dbt SQL model creates a table that tracks NFT transfers on the Scroll blockchain. It combines data from different sources including base transactions, ERC721 transfers, ERC1155 single transfers, and ERC1155 batch transfers. This model enables data analysts to analyze and understand the movement of NFTs within the Scroll blockchain ecosystem.

MODEL: nft_transfers.sql

🟠 Modified by:

🔧 PR: #5349, Add Scroll NFT models
🧙 Author: @0xRobin on 2024-02-22
📝 Summary: A new reference to 'nft_scroll_transfers' was added in the dbt SQL model.

MODEL: arbitrum_sources.yml

🟠 Modified by:

🔧 PR: #5349, Add Scroll NFT models
🧙 Author: @0xRobin on 2024-02-22
📝 Summary: [changes too large] The model arbitrum_sources.yml was renamed.

MODEL: base_sources.yml

🟠 Modified by:

🔧 PR: #5349, Add Scroll NFT models
🧙 Author: @0xRobin on 2024-02-22
📝 Summary: [changes too large] The model base_sources.yml was renamed.

MODEL: bnb_sources.yml

🟠 Modified by:

🔧 PR: #5349, Add Scroll NFT models
🧙 Author: @0xRobin on 2024-02-22
📝 Summary: [changes too large] The model bnb_sources.yml was renamed.

MODEL: ethereum_sources.yml

🟠 Modified by:

🔧 PR: #5349, Add Scroll NFT models
🧙 Author: @0xRobin on 2024-02-22
📝 Summary: [changes too large] The model ethereum_sources.yml was renamed.

MODEL: old_sources.yml

🟠 Modified by:

🔧 PR: #5349, Add Scroll NFT models
🧙 Author: @0xRobin on 2024-02-22
📝 Summary: [changes too large] The model old_sources.yml was renamed.

MODEL: optimism_sources.yml

🟠 Modified by:

🔧 PR: #5349, Add Scroll NFT models
🧙 Author: @0xRobin on 2024-02-22
📝 Summary: [changes too large] The model optimism_sources.yml was renamed.

MODEL: polygon_sources.yml

🟠 Modified by:

🔧 PR: #5349, Add Scroll NFT models
🧙 Author: @0xRobin on 2024-02-22
📝 Summary: [changes too large] The model polygon_sources.yml was renamed.

MODEL: quix_optimism_sources.yml

🟠 Modified by:

🔧 PR: #5349, Add Scroll NFT models
🧙 Author: @0xRobin on 2024-02-22
📝 Summary: [changes too large] The model quix_optimism_sources.yml was renamed.

MODEL: solana_sources.yml

🟠 Modified by:

🔧 PR: #5349, Add Scroll NFT models
🧙 Author: @0xRobin on 2024-02-22
📝 Summary: [changes too large] The model solana_sources.yml was renamed.

MODEL: lending_base_borrow.sql

🟠 Modified by:

🔧 PR: #5379, Add Scroll to lending
🧙 Author: @tomfutago on 2024-02-22
📝 Summary: A reference to a model named 'lending_zksync_base_borrow' was removed, and references to models named 'lending_zksync_base_borrow' and 'lending_scroll_base_borrow' were added.

MODEL: lending_scroll_base_borrow.sql

🟢 Added by:

🔧 PR: #5379, Add Scroll to lending
🧙 Author: @tomfutago on 2024-02-22
📝 Summary: This model combines data from two sources related to borrowing activities in Aave V3 and Layer Bank. It enables data analysts to analyze blockchain transactions including details such as project, loan type, borrower information, transaction amounts, and timestamps across different tokens. The union of these datasets allows for a comprehensive view of borrowing behavior across multiple platforms within the specified parameters.

MODEL: aave_v3_scroll_base_borrow.sql

🟢 Added by:

🔧 PR: #5379, Add Scroll to lending
🧙 Author: @tomfutago on 2024-02-22
📝 Summary: This dbt SQL model creates a table called lending_aave_v3_compatible_borrow, focusing on data related to borrowing activities in the Aave project version 3. It enables data analysts to analyze and understand borrowing behavior specifically within the L2Pool contract in the Aave protocol on the Scroll blockchain.

MODEL: lending_base_flashloans.sql

🟠 Modified by:

🔧 PR: #5379, Add Scroll to lending
🧙 Author: @tomfutago on 2024-02-22
📝 Summary: A reference to a model named 'lending_zksync_base_flashloans' was removed, and references to models named 'lending_zksync_base_flashloans' and 'lending_scroll_base_flashloans' were added.

MODEL: lending_scroll_base_flashloans.sql

🟢 Added by:

🔧 PR: #5379, Add Scroll to lending
🧙 Author: @tomfutago on 2024-02-22
📝 Summary: This SQL model creates a union of data from the 'aave_v3_scroll_base_flashloans' table, enabling data analysts to access information related to blockchain transactions such as blockchain type, project details, transaction version, recipient details, transaction amounts and fees, token and contract addresses involved in the transactions. Additionally, it provides metadata like block month and time stamp along with transaction hash and event index for further analysis.

MODEL: aave_v3_scroll_base_flashloans.sql

🟢 Added by:

🔧 PR: #5379, Add Scroll to lending
🧙 Author: @tomfutago on 2024-02-22
📝 Summary: This SQL model creates a table that enables data analysts to analyze lending flashloans compatible with Aave version 3 on the Scroll blockchain, specifically focusing on transactions involving the decoded contract name 'L2Pool.'

MODEL: lending_base_supply.sql

🟠 Modified by:

🔧 PR: #5379, Add Scroll to lending
🧙 Author: @tomfutago on 2024-02-22
📝 Summary: A reference to a model named 'lending_scroll_base_supply' was added, while the reference to 'lending_zksync_base_supply' was removed.

MODEL: lending_scroll_base_supply.sql

🟢 Added by:

🔧 PR: #5379, Add Scroll to lending
🧙 Author: @tomfutago on 2024-02-22
📝 Summary: This model combines data from two different sources, 'aave_v3_scroll_base_supply' and 'layer_bank_scroll_base_supply', into a single dataset. It includes information such as blockchain, project details, transaction specifics (type, addresses involved), amounts transacted, block details (month/time/number), and unique identifiers like transaction hash and event index. By using UNION ALL to merge the datasets together in SQL queries, this model enables data analysts to analyze aggregated supply-related transactions across multiple platforms efficiently.

MODEL: aave_v3_scroll_base_supply.sql

🟢 Added by:

🔧 PR: #5379, Add Scroll to lending
🧙 Author: @tomfutago on 2024-02-22
📝 Summary: This SQL model creates a table called lending_aave_v3_compatible_supply that enables data analysts to analyze supply data related to the Aave project on the Scroll blockchain. The table specifically focuses on version 3 of the project and decodes contract names related to 'L2Pool'.

MODEL: sharkyswap_arbitrum_base_trades.sql

🟢 Added by:

🔧 PR: #5385, Added sterling finance and sharkyswap dex to dex.trades
🧙 Author: @ARDev097 on 2024-02-22
📝 Summary: This dbt SQL model creates a table called uniswap_compatible_v2_trades that enables data analysts to analyze and track trades on the SharkySwap project in the Arbitrum blockchain. It sources data from events related to pair creation and swapping within the SharkySwap project, allowing for further analysis of trading activities specific to this platform.

MODEL: sterling_finance_arbitrum_base_trades.sql

🟢 Added by:

🔧 PR: #5385, Added sterling finance and sharkyswap dex to dex.trades
🧙 Author: @ARDev097 on 2024-02-22
📝 Summary: This model creates a table named uniswap_compatible_v2_trades that enables data analysts to analyze trades compatible with Uniswap V2 on the Arbitrum blockchain for the Sterling Finance project. It includes information about swap events and pair creation events sourced from specific tables related to Sterling Finance on Arbitrum.

MODEL: tokens_arbitrum_transfers.sql

🟠 Modified by:

🔧 PR: #5360, SPE-266 finalize chain-level transfers spells
🧙 Author: @jeff-dude on 2024-02-21
📝 Summary: Added additional parameters to the transfers_enrich macro including tokens_erc20_model, prices_model, evms_info_model, and transfers_start_date. The parameter names were also updated for clarity.

🔧 PR: #5360, Revert 'finalize chain-level transfers spells (#5360)'
🧙 Author: @jeff-dude on 2024-02-16
📝 Summary: The logic of the changes made in the SQL model involves adding parameters such as 'blockchain', 'transfers_base', and 'native_symbol' to the transfers_enrich macro. The parameter blockchain is set to 'arbitrum' and a new parameter native_symbol with a value of 'ETH' was added.

🔧 PR: #5360, finalize chain-level transfers spells
🧙 Author: @jeff-dude on 2024-02-16
📝 Summary: The changes involve updating the transfers_enrich macro by adding parameters for tokens_erc20_model, prices_model, evms_info_model, and setting a specific start date for transfers. The parameter 'blockchain' and 'native_symbol' were removed from the macro call.

MODEL: tokens_avalanche_c_transfers.sql

🟠 Modified by:

🔧 PR: #5360, SPE-266 finalize chain-level transfers spells
🧙 Author: @jeff-dude on 2024-02-21
📝 Summary: The changes involve updating the transfers_enrich macro call by adding additional parameters such as base_transfers, tokens_erc20_model, prices_model, and others. The parameter names have been adjusted, and a new parameter for the start date of transfers has been included. The blockchain specified remains 'avalanche_c'.

🔧 PR: #5360, Revert 'finalize chain-level transfers spells (#5360)'
🧙 Author: @jeff-dude on 2024-02-16
📝 Summary: The logic of the dbt SQL model was updated to include a new parameter 'blockchain' with the value 'avalanche_c', and removed parameters related to ERC20 tokens, prices, EVMs info, and transfers start date. Additionally, a new parameter 'native_symbol' with the value 'AVAX' was added.

🔧 PR: #5360, finalize chain-level transfers spells
🧙 Author: @jeff-dude on 2024-02-16
📝 Summary: Added additional parameters to the transfers_enrich macro including tokens_erc20_model, prices_model, evms_info_model, and transfers_start_date. The parameter names were also updated for clarity.

MODEL: tokens_base_transfers.sql

🟢 Added by:

🔧 PR: #5360, SPE-266 finalize chain-level transfers spells
🧙 Author: @jeff-dude on 2024-02-21
📝 Summary: This model creates an enriched table called transfers_enrich by joining data from base_transfers, tokens_erc20_model, prices_model, and evms_info_model. It filters the data based on a specified start date and blockchain type. This enables data analysts to analyze enriched transfer information starting from June 15, 2023 in the context of the base blockchain network.

🔧 PR: #5360, Revert 'finalize chain-level transfers spells (#5360)'
🧙 Author: @jeff-dude on 2024-02-16
📝 Summary: This SQL model creates a union of multiple base transfer tables for different token blockchains. It enables data analysts to query and analyze transfer data across various blockchain networks in a single consolidated view, including details such as unique keys, block information, transaction hashes, addresses involved in the transactions, token standards used, amounts transferred and contract addresses.

🔧 PR: #5360, finalize chain-level transfers spells
🧙 Author: @jeff-dude on 2024-02-16
📝 Summary: This model creates an enriched table called transfers_enrich by joining data from base_transfers, tokens_erc20_model, prices_model, and evms_info_model. It filters the data based on a specified start date and enables analysts to analyze enriched transfer information starting from June 15, 2023.

MODEL: tokens_bnb_transfers.sql

🟠 Modified by:

🔧 PR: #5360, SPE-266 finalize chain-level transfers spells
🧙 Author: @jeff-dude on 2024-02-21
📝 Summary: Added logic to enrich transfer data for BNB blockchain starting from a specific date. The model now references additional models for ERC20 tokens, USD prices, and EVMs info.

🔧 PR: #5360, Revert 'finalize chain-level transfers spells (#5360)'
🧙 Author: @jeff-dude on 2024-02-16
📝 Summary: The logic of the dbt SQL model was updated to include a new parameter 'blockchain' with a value of 'bnb', and removed parameters related to ERC20 tokens, prices, EVMs info, and transfers start date. Additionally, a new parameter 'native_symbol' with the value 'BNB' was added.

🔧 PR: #5360, finalize chain-level transfers spells
🧙 Author: @jeff-dude on 2024-02-16
📝 Summary: The changes involve updating the transfers_enrich function by adding parameters for tokens_erc20_model, prices_model, evms_info_model, and setting a specific start date for transfers. The blockchain parameter was removed, and the base_transfers parameter was renamed to transfers_base.

MODEL: tokens_celo_transfers.sql

🟠 Modified by:

🔧 PR: #5360, SPE-266 finalize chain-level transfers spells
🧙 Author: @jeff-dude on 2024-02-21
📝 Summary: Added additional parameters to the transfers_enrich function including base_transfers, tokens_erc20_model, prices_model, evms_info_model, and specified a start date for transfers. The blockchain parameter was also updated to 'celo'.

🔧 PR: #5360, Revert 'finalize chain-level transfers spells (#5360)'
🧙 Author: @jeff-dude on 2024-02-16
📝 Summary: The logic of the changes made in the SQL model involves updating the transfers_enrich macro by adding parameters for blockchain, transfers_base, and native_symbol. The previous parameters related to ERC20 tokens, prices, EVMs info, and start date were removed.

🔧 PR: #5360, finalize chain-level transfers spells
🧙 Author: @jeff-dude on 2024-02-16
📝 Summary: The logic for enriching transfer data from the 'celo' blockchain was updated. The function now includes additional references to base transfers, ERC20 tokens, USD prices, EVMs info, and a specified start date for transfers.

MODEL: tokens_ethereum_transfers.sql

🟠 Modified by:

🔧 PR: #5360, SPE-266 finalize chain-level transfers spells
🧙 Author: @jeff-dude on 2024-02-21
📝 Summary: Added additional parameters to the transfers_enrich macro including tokens_erc20_model, prices_model, evms_info_model, and transfers_start_date. The parameter names were updated for clarity.

🔧 PR: #5360, Revert 'finalize chain-level transfers spells (#5360)'
🧙 Author: @jeff-dude on 2024-02-16
📝 Summary: The logic of the changes made in this pull request is to update the transfers_enrich model by adding parameters for blockchain, transfers_base, and native_symbol. The previous parameters related to ERC20 tokens, prices, EVMs info, and start date were removed.

🔧 PR: #5360, finalize chain-level transfers spells
🧙 Author: @jeff-dude on 2024-02-16
📝 Summary: Added additional parameters to the transfers_enrich macro including tokens_erc20_model, prices_model, evms_info_model, and transfers_start_date. The parameter names were also updated for clarity.

MODEL: tokens_fantom_transfers.sql

🟠 Modified by:

🔧 PR: #5360, SPE-266 finalize chain-level transfers spells
🧙 Author: @jeff-dude on 2024-02-21
📝 Summary: The changes involve updating the transfers_enrich macro with additional parameters such as tokens_erc20_model, prices_model, and evms_info_model. The parameter names have been adjusted, and a new parameter for the start date of transfers has been added.

🔧 PR: #5360, Revert 'finalize chain-level transfers spells (#5360)'
🧙 Author: @jeff-dude on 2024-02-16
📝 Summary: The logic of the changes made in the dbt SQL model is to update the transfers_enrich macro by adding parameters for blockchain, transfers_base, and native_symbol. The previous parameters related to ERC20 tokens, prices, EVMs info, and start date were removed.

🔧 PR: #5360, finalize chain-level transfers spells
🧙 Author: @jeff-dude on 2024-02-16
📝 Summary: Added additional parameters to the transfers_enrich macro including tokens_erc20_model, prices_model, evms_info_model, and transfers_start_date. The parameter names were also updated, and a specific date was set for the transfers start date.

MODEL: tokens_gnosis_transfers.sql

🟠 Modified by:

🔧 PR: #5360, SPE-266 finalize chain-level transfers spells
🧙 Author: @jeff-dude on 2024-02-21
📝 Summary: Added additional parameters to the transfers_enrich macro including base_transfers, tokens_erc20_model, prices_model, evms_info_model, and specified a start date for transfers. The blockchain parameter was also updated to 'gnosis'.

🔧 PR: #5360, Revert 'finalize chain-level transfers spells (#5360)'
🧙 Author: @jeff-dude on 2024-02-16
📝 Summary: The logic of the changes made in the SQL model involves updating the transfers_enrich macro by adding parameters for blockchain, native_symbol, and removing parameters related to ERC20 tokens, prices, EVMs info, and start date.

🔧 PR: #5360, finalize chain-level transfers spells
🧙 Author: @jeff-dude on 2024-02-16
📝 Summary: Added additional parameters to the transfers_enrich function including tokens_erc20_model, prices_model, evms_info_model, and transfers_start_date. The blockchain parameter was removed, and the native_symbol parameter was replaced with base_transfers.

MODEL: tokens_optimism_transfers.sql

🟠 Modified by:

🔧 PR: #5360, SPE-266 finalize chain-level transfers spells
🧙 Author: @jeff-dude on 2024-02-21
📝 Summary: The logic of the changes made in this pull request is to update the transfers_enrich model by adding additional parameters such as tokens_erc20_model, prices_model, evms_info_model, and setting a specific start date for transfers. The blockchain parameter is also explicitly defined as 'optimism'.

🔧 PR: #5360, Revert 'finalize chain-level transfers spells (#5360)'
🧙 Author: @jeff-dude on 2024-02-16
📝 Summary: The logic of the changes made in the dbt SQL model is to update the transfers_enrich macro by adding parameters for blockchain, transfers_base, and native_symbol. The previous parameters related to models like tokens, prices, evms_info, and transfers_start_date were removed.

🔧 PR: #5360, finalize chain-level transfers spells
🧙 Author: @jeff-dude on 2024-02-16
📝 Summary: The logic of the changes made in this pull request is to update the transfers_enrich macro by adding additional parameters such as tokens_erc20_model, prices_model, evms_info_model, and setting a specific start date for transfers. The blockchain parameter was removed, and instead, the base_transfers parameter was renamed from transfers_base.

MODEL: tokens_polygon_transfers.sql

🟠 Modified by:

🔧 PR: #5360, SPE-266 finalize chain-level transfers spells
🧙 Author: @jeff-dude on 2024-02-21
📝 Summary: The changes involve updating the transfers_enrich macro in a dbt model for the 'polygon' blockchain. The new logic includes additional references to models such as tokens_erc20_model, prices_model, and evms_info_model. The parameter 'native_symbol' is removed, and a new parameter 'transfers_start_date' with value '2020-05-30' is added.

🔧 PR: #5360, Revert 'finalize chain-level transfers spells (#5360)'
🧙 Author: @jeff-dude on 2024-02-16
📝 Summary: The logic added in the SQL model is to enrich transfers data for the Polygon blockchain by specifying the base transfers, native symbol as 'MATIC', and setting other necessary parameters. The previous logic involving ERC20 tokens, USD prices, EVMs info, and a specific start date was removed.

🔧 PR: #5360, finalize chain-level transfers spells
🧙 Author: @jeff-dude on 2024-02-16
📝 Summary: The logic of the changes made in this pull request involves updating the transfers_enrich function by adding additional parameters such as tokens_erc20_model, prices_model, evms_info_model, and setting a specific start date for transfers. The blockchain parameter was removed, and instead, the base_transfers parameter was renamed to transfers_base.

MODEL: tokens_zksync_transfers.sql

🟠 Modified by:

🔧 PR: #5360, SPE-266 finalize chain-level transfers spells
🧙 Author: @jeff-dude on 2024-02-21
📝 Summary: The logic of the dbt SQL model was updated to include additional parameters such as 'tokens_erc20_model', 'prices_model', 'evms_info_model', and 'transfers_start_date'. The parameter names were also adjusted for clarity.

🔧 PR: #5360, Revert 'finalize chain-level transfers spells (#5360)'
🧙 Author: @jeff-dude on 2024-02-16
📝 Summary: The logic of the changes made in this pull request is to update the transfers_enrich model by adding parameters for blockchain, native_symbol, and removing parameters related to ERC20 tokens, prices, EVMS info, and start date.

🔧 PR: #5360, finalize chain-level transfers spells
🧙 Author: @jeff-dude on 2024-02-16
📝 Summary: The logic of the dbt SQL model was updated to include additional parameters such as 'tokens_erc20_model', 'prices_model', 'evms_info_model', and 'transfers_start_date'. The parameter names were also adjusted, with the removal of the parameter 'blockchain' and renaming of 'transfers_base' to 'base_transfers'.

MODEL: tokens_zora_transfers.sql

🟠 Modified by:

🔧 PR: #5360, SPE-266 finalize chain-level transfers spells
🧙 Author: @jeff-dude on 2024-02-21
📝 Summary: The changes involve updating the transfers_enrich function by adding additional parameters such as tokens_erc20_model, prices_model, evms_info_model, and setting a specific start date for transfers. The blockchain parameter is also explicitly defined as 'zora'.

🔧 PR: #5360, Revert 'finalize chain-level transfers spells (#5360)'
🧙 Author: @jeff-dude on 2024-02-16
📝 Summary: Added logic to enrich transfers data for the Zora blockchain by specifying the base transfers model, native symbol as 'ETH', and removing references to ERC20 tokens, USD prices, EVMs info model, and a specific start date.

🔧 PR: #5360, finalize chain-level transfers spells
🧙 Author: @jeff-dude on 2024-02-16
📝 Summary: The changes involve updating the transfers_enrich function by adding parameters such as tokens_erc20_model, prices_model, and evms_info_model. Additionally, a new parameter called transfers_start_date is included with a specific date value. The blockchain parameter has been removed, and the native_symbol parameter has been replaced with base_transfers.

MODEL: dex_base_trades.sql

🟠 Modified by:

🔧 PR: #5378, Add Scroll dexs to trades_beta
🧙 Author: @tomfutago on 2024-02-20
📝 Summary: A new reference to 'dex_scroll_base_trades' was added in the model.

MODEL: dex_scroll_base_trades.sql

🟢 Added by:

🔧 PR: #5378, Add Scroll dexs to trades_beta
🧙 Author: @tomfutago on 2024-02-20
📝 Summary: This model combines data from multiple base trade tables related to different projects like Uniswap, Sushiswap, Zebra, and Scrollswap. It creates a unified dataset with additional transaction columns for analysis.

MODEL: scrollswap_scroll_base_trades.sql

🟢 Added by:

🔧 PR: #5378, Add Scroll dexs to trades_beta
🧙 Author: @tomfutago on 2024-02-20
📝 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 Scroll blockchain for the project 'scrollswap'. The model sources data from events related to pair creation and swapping pairs in the ScrollSwap project.

MODEL: sushiswap_v2_scroll_base_trades.sql

🟢 Added by:

🔧 PR: #5378, Add Scroll dexs to trades_beta
🧙 Author: @tomfutago on 2024-02-20
📝 Summary: This dbt SQL model creates a table called uniswap_compatible_v3_trades that enables data analysts to analyze Uniswap V3 trades from the Sushiswap project on the Scroll blockchain. It sources data from specific events related to swaps and pool creation in UniswapV3Pool and UniswapV3Factory, respectively.

MODEL: uniswap_v3_scroll_base_trades.sql

🟢 Added by:

🔧 PR: #5378, Add Scroll dexs to trades_beta
🧙 Author: @tomfutago on 2024-02-20
📝 Summary: This model creates a table called uniswap_compatible_v3_trades that enables data analysts to analyze Uniswap V3 trades from the Scroll blockchain project. It sources trade information from events related to swaps and pool creations in the Uniswap V3 Pool and Factory contracts on the Scroll blockchain.

MODEL: zebra_scroll_base_trades.sql

🟢 Added by:

🔧 PR: #5378, Add Scroll dexs to trades_beta
🧙 Author: @tomfutago on 2024-02-20
📝 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 Scroll blockchain for the Zebra project. It sources data from events related to swaps and pool creations in Zebra's V2Pool and V2Factory.

MODEL: magiceden_mmm_solana_trades.sql

🟢 Added by:

🔧 PR: #5357, [solana] add magic eden mmm trades
🧙 Author: @tsekityam on 2024-02-19
📝 Summary: [changes too large] The model magiceden_mmm_solana_trades.sql was added.

MODEL: dackieswap_v2_optimism_base_trades.sql

🟢 Added by:

🔧 PR: #5350, Added Dackiewswap_v2 , Dackiewswap_v3 and Wombat_exchange dexes to dex.trades
🧙 Author: @Jason4276 on 2024-02-19
📝 Summary: This dbt SQL model creates a table called uniswap_compatible_v2_trades that enables data analysts to analyze and track trades on the DackieSwap project within the Optimism blockchain version 2. It sources data from DackiePair_evt_Swap and DackieFactory_evt_PairCreated tables in the dackieswap_v2_optimism schema.

MODEL: dackieswap_v3_optimism_base_trades.sql

🟢 Added by:

🔧 PR: #5350, Added Dackiewswap_v2 , Dackiewswap_v3 and Wombat_exchange dexes to dex.trades
🧙 Author: @Jason4276 on 2024-02-19
📝 Summary: This model creates a table called uniswap_compatible_v3_trades that enables data analysts to analyze trades compatible with Uniswap v3 on the Optimism blockchain for the project 'dackieswap'. It sources trade information from specific events related to swaps and pool creations in the 'DackieV3Pool_evt_Swap' and 'DonaswapV3Factory_evt_PoolCreated' tables.

MODEL: tokens_base_transfers_view.sql

🟢 Added by:

🔧 PR: #5363, Revert 'finalize chain-level transfers spells (#5360)'
🧙 Author: @jeff-dude on 2024-02-16
📝 Summary: This SQL model creates an enriched version of the transfers data from the base tokens table for Ethereum (ETH) blockchain. It enables data analysts to access and analyze additional information related to transfers within the Ethereum blockchain, providing more insights into token movements and transactions.

SECTOR: odos

toggle to see all model updates

MODEL: odos_base_trades.sql

🟢 Added by:

🔧 PR: #5393, ODOS_BASE: ADDED ODOS BASE
🧙 Author: @sophie-analytics on 2024-02-22
📝 Summary: This model combines data from the 'odos_v2_base_trades' table, allowing analysts to query and analyze trade information across different blockchains, projects, tokens, transactions, and addresses. The UNION ALL statement merges the selected columns from each source table into a single dataset for comprehensive analysis of token trades.

MODEL: odos_v2_base_trades.sql

🟢 Added by:

🔧 PR: #5393, ODOS_BASE: ADDED ODOS BASE
🧙 Author: @sophie-analytics on 2024-02-22
📝 Summary: This model creates a dataset that enables data analysts to analyze decentralized exchange transactions. It includes information such as block time, tokens bought and sold, token symbols, amounts in different currencies, transaction details like addresses and hashes. The model also allows for joining with other sources to include additional information like token prices at the time of the transaction.

SECTOR: transfers

toggle to see all model updates

MODEL: transfers_scroll_eth.sql

🟢 Added by:

🔧 PR: #5349, Add Scroll NFT models
🧙 Author: @0xRobin on 2024-02-22
📝 Summary: This model creates a table of ETH transfers from deposits and withdrawals, specifically focusing on ERC20 transfers of the 'deadeadead' ETH token. It includes various details such as sender, receiver, transaction hash, block information, and unique transfer ID. The model enables data analysts to analyze these specific types of Ethereum transactions for further insights or reporting purposes.

SECTOR: layer_bank

toggle to see all model updates

MODEL: layer_bank_scroll_ctokens.sql

🟢 Added by:

🔧 PR: #5379, Add Scroll to lending
🧙 Author: @tomfutago on 2024-02-22
📝 Summary: This model selects and displays the asset symbol, ctoken address, and asset address for different assets such as ETH, USDC, and wstETH. It provides a way for data analysts to easily access this specific information about these assets in the database.

SECTOR: lido

toggle to see all model updates

MODEL: lido_liquidity.sql