You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
🔧 PR: #5417, 1inch: AggregationRouterV6 to 1inch spellbooks linage 🧙 Author: @max-morrow on 2024-02-28 📝 Summary: Added support for the 'bnb' and 'zksync' blockchains. Introduced a new CTE named 't' that selects specific columns from pool_created_logs and creation_traces, with an optional incremental predicate. Merged this selection with data from '_optimism_ovm1_legacy'. Finally, filtered out duplicates based on certain criteria in the final select statement within CTE 't'.
🔧 PR: #5366, Added soswap dex to dex.trades 🧙 Author: @archie17277 on 2024-02-28 📝 Summary: A new row for 'soswap' with corresponding values was added to the existing list of rows in the model.
🔧 PR: #5366, Add rocketswap to dex.trades 🧙 Author: @intensodefi on 2024-02-27 📝 Summary: A new row for 'rocketswap' with values 'RocketSwap', 'Direct', and 'RocketSwap_Labs' was added to the temp_table.
🔧 PR: #5459, Add zkSync to tokens.nft 🧙 Author: @lgingerich on 2024-02-28 📝 Summary: A reference to a new model called 'tokens_zksync_nft' was added in the SQL query.
🔧 PR: #5487, Balances polygon 🧙 Author: @aalan3 on 2024-03-01 📝 Summary: This model creates a table called balances_daily that aggregates daily token balances starting from May 28, 2021. It enables data analysts to analyze and track the daily changes in token balances over time for Polygon tokens.
🔧 PR: #5487, Balances polygon 🧙 Author: @aalan3 on 2024-03-01 📝 Summary: This model creates an enriched version of daily aggregated token balances from a raw dataset. It enables data analysts to work with more comprehensive and detailed information regarding token balances on a daily basis.
🔧 PR: #5487, Balances polygon 🧙 Author: @aalan3 on 2024-03-01 📝 Summary: This SQL model creates a new table that aggregates daily token balances from the 'tokens_polygon' data source. It enables data analysts to easily access and analyze aggregated daily token balance information for Polygon tokens.
🔧 PR: #5486, Add Arbitrum balances 🧙 Author: @aalan3 on 2024-03-01 📝 Summary: This model creates a new table called balances_daily that enables data analysts to access aggregated daily token balances starting from May 28, 2021.
🔧 PR: #5486, Add Arbitrum balances 🧙 Author: @aalan3 on 2024-03-01 📝 Summary: This dbt SQL model creates an enriched version of daily token balances on the Arbitrum network. It enables data analysts to work with aggregated token balance data that has been enhanced for analysis and reporting purposes.
🔧 PR: #5486, Add Arbitrum balances 🧙 Author: @aalan3 on 2024-03-01 📝 Summary: This model creates a new table that aggregates daily balances data from the 'tokens_arbitrum' source. It enables data analysts to easily analyze and track daily balance changes for arbitrum tokens.
🔧 PR: #5485, Add more daily balances 🧙 Author: @aalan3 on 2024-03-01 📝 Summary: This new dbt SQL model creates a table called balances_daily that aggregates daily token base balances starting from July 15, 2023. It enables data analysts to analyze and track the daily balances of tokens in the database for reporting and further analysis.
🔧 PR: #5485, Add more daily balances 🧙 Author: @aalan3 on 2024-03-01 📝 Summary: This model creates an enriched version of daily token balances by merging raw balance data. It enables data analysts to easily access and analyze aggregated daily token balance information for further reporting and analysis.
🔧 PR: #5485, Add more daily balances 🧙 Author: @aalan3 on 2024-03-01 📝 Summary: This SQL model creates a new table that aggregates daily balances data. It enables data analysts to easily access and analyze summarized information on token balances on a daily basis.
🔧 PR: #5485, Add more daily balances 🧙 Author: @aalan3 on 2024-03-01 📝 Summary: This SQL model creates a new table called balances_daily that enables data analysts to access aggregated daily balance information starting from January 14, 2021.
🔧 PR: #5485, Add more daily balances 🧙 Author: @aalan3 on 2024-03-01 📝 Summary: This dbt SQL model creates an enriched version of daily balance data by joining it with raw token balances. It enables data analysts to work with aggregated and enhanced balance information for Optimism tokens on a daily basis.
🔧 PR: #5485, Add more daily balances 🧙 Author: @aalan3 on 2024-03-01 📝 Summary: This SQL model creates a new table that aggregates daily balances data from the 'balances_optimism' source table. It enables data analysts to easily access and analyze aggregated daily balance information for further reporting and analysis.
🔧 PR: #5464, Source identifiers for balances source 🧙 Author: @0xRobin on 2024-03-01 📝 Summary: The change made in this pull request updated the source table used in the balances_raw CTE from 'balances_arbitrum_0001' to just 'balances_arbitrum'.
🔧 PR: #5464, balances upgrade + daily aggregation with forward fill 🧙 Author: @0xRobin on 2024-03-01 📝 Summary: Added a CTE 'balances_raw' that sources data from 'tokens_arbitrum' and enriches it with the balances_enrich function. The logic was updated to use the new CTE instead of directly sourcing data in the balances_base parameter.
🔧 PR: #5464, Source identifiers for balances source 🧙 Author: @0xRobin on 2024-03-01 📝 Summary: The change made in this pull request updated the source table reference from 'balances_base_0001' to 'balances_base'.
🔧 PR: #5464, balances upgrade + daily aggregation with forward fill 🧙 Author: @0xRobin on 2024-03-01 📝 Summary: Added a CTE 'balances_raw' that calls a macro to fix the schema of a source table. The model now uses this CTE in the 'balances_enrich' call instead of directly referencing the source table and blockchain type.
🔧 PR: #5464, Source identifiers for balances source 🧙 Author: @0xRobin on 2024-03-01 📝 Summary: The change made in this pull request updated the source table being referenced in the dbt model from 'balances_bnb_0001' to 'balances_bnb'.
🔧 PR: #5464, balances upgrade + daily aggregation with forward fill 🧙 Author: @0xRobin on 2024-03-01 📝 Summary: Added a CTE balances_raw that fixes the schema of a source table and enriches it with additional data in the balances_enrich macro. Removed direct reference to the source table and replaced it with reference to the new CTE.
🔧 PR: #5464, Source identifiers for balances source 🧙 Author: @0xRobin on 2024-03-01 📝 Summary: The diff shows a change in the source table used for the balances_raw CTE in the dbt model. The source table 'balances_ethereum_0004' was replaced with 'balances_ethereum'.
🔧 PR: #5464, balances upgrade + daily aggregation with forward fill 🧙 Author: @0xRobin on 2024-03-01 📝 Summary: Added a CTE named 'balances_raw' that fixes the schema of a source table and specifies the blockchain as 'ethereum'. The main logic change is in the 'balances_enrich' macro call, where it now takes in 'balances_raw' instead of directly referencing a source table.
🔧 PR: #5464, Source identifiers for balances source 🧙 Author: @0xRobin on 2024-03-01 📝 Summary: The change made in the SQL model involves updating the source table reference from 'balances_ethereum_0004' to 'balances_ethereum'.
🔧 PR: #5464, balances upgrade + daily aggregation with forward fill 🧙 Author: @0xRobin on 2024-03-01 📝 Summary: Added a CTE named balances_raw that fixes the schema of a source table and references it. Renamed the model from balances_daily to balances_daily_agg, which now takes in the CTE as input instead of directly referencing a source table.
🔧 PR: #5464, balances upgrade + daily aggregation with forward fill 🧙 Author: @0xRobin on 2024-03-01 📝 Summary: Added a CTE named 'balances_raw' that sources data from 'tokens_optimism' and enriches it with the logic in the 'balances_enrich' macro using this new CTE. Removed direct sourcing of data within the balances_enrich macro, instead referencing the newly created CTE for balance calculations.
🔧 PR: #5464, balances upgrade + daily aggregation with forward fill 🧙 Author: @0xRobin on 2024-03-01 📝 Summary: Added a CTE named 'balances_raw' that calls a macro to fix the schema of a source table. The existing logic for enriching balances was updated to use the new CTE instead of directly referencing the source table.
🔧 PR: #5464, balances upgrade + daily aggregation with forward fill 🧙 Author: @0xRobin on 2024-03-01 📝 Summary: Removed the balances_enrich model and added a new balances_daily model that references tokens_ethereum_balances_daily_agg. The new model includes a start date parameter set to '2015-07-30'.
🔧 PR: #5464, balances upgrade + daily aggregation with forward fill 🧙 Author: @0xRobin on 2024-03-01 📝 Summary: This model creates an enriched version of daily Ethereum token balances by merging the raw balance data with additional information. It enables data analysts to work with more comprehensive and detailed Ethereum token balance data for their analysis and reporting purposes.
🔧 PR: #5438, Add Aave v3 to lending on Gnosis & BNB 🧙 Author: @tomfutago on 2024-02-28 📝 Summary: A new reference to a model named 'aave_v3_bnb_base_borrow' was added in addition to the existing reference to 'radiant_bnb_base_borrow'.
🔧 PR: #5438, Add Aave v3 to lending on Gnosis & BNB 🧙 Author: @tomfutago on 2024-02-28 📝 Summary: This dbt SQL model creates a table that enables data analysts to analyze borrowing activity on the Aave protocol version 3 for the Binance Smart Chain (BNB).
🔧 PR: #5438, Add Aave v3 to lending on Gnosis & BNB 🧙 Author: @tomfutago on 2024-02-28 📝 Summary: Two dbt models, 'agave_gnosis_base_borrow' and 'aave_v3_gnosis_base_borrow', were added to the list of models being referenced in this SQL model.
🔧 PR: #5438, Add Aave v3 to lending on Gnosis & BNB 🧙 Author: @tomfutago on 2024-02-28 📝 Summary: This dbt SQL model creates a table that enables data analysts to analyze borrowing activity on the Aave lending platform version 3, specifically focusing on data from the Gnosis blockchain.
🔧 PR: #5438, Add Aave v3 to lending on Gnosis & BNB 🧙 Author: @tomfutago on 2024-02-28 📝 Summary: A new reference to a model named 'aave_v3_bnb_base_flashloans' was added in addition to the existing reference to 'radiant_bnb_base_flashloans'.
🔧 PR: #5438, Add Aave v3 to lending on Gnosis & BNB 🧙 Author: @tomfutago on 2024-02-28 📝 Summary: This SQL model creates a table that enables data analysts to analyze lending Aave V3 compatible flashloans specific to the Binance Smart Chain (BNB) blockchain and the Aave project version 3.
🔧 PR: #5438, Add Aave v3 to lending on Gnosis & BNB 🧙 Author: @tomfutago on 2024-02-28 📝 Summary: Two dbt models, 'agave_gnosis_base_flashloans' and 'aave_v3_gnosis_base_flashloans', were added to the list of models being referenced in this SQL file.
🔧 PR: #5438, Add Aave v3 to lending on Gnosis & BNB 🧙 Author: @tomfutago on 2024-02-28 📝 Summary: This model creates a table that enables data analysts to analyze lending flashloans compatible with Aave version 3 on the Gnosis blockchain for their projects.
🔧 PR: #5438, Add Aave v3 to lending on Gnosis & BNB 🧙 Author: @tomfutago on 2024-02-28 📝 Summary: A reference to a model named 'aave_v3_bnb_base_supply' was added in addition to the existing reference to 'radiant_bnb_base_supply'.
🔧 PR: #5438, Add Aave v3 to lending on Gnosis & BNB 🧙 Author: @tomfutago on 2024-02-28 📝 Summary: This model creates a table that tracks compatible supply data for the Aave project on the Binance Smart Chain (bnb) using version 3 of their protocol. It enables data analysts to analyze and monitor lending activities specific to Aave on the Binance Smart Chain.
🔧 PR: #5438, Add Aave v3 to lending on Gnosis & BNB 🧙 Author: @tomfutago on 2024-02-28 📝 Summary: A reference to a model named 'aave_v3_gnosis_base_supply' was added in addition to the existing reference to 'agave_gnosis_base_supply'.
🔧 PR: #5438, Add Aave v3 to lending on Gnosis & BNB 🧙 Author: @tomfutago on 2024-02-28 📝 Summary: This new dbt SQL model creates a table called lending_aave_v3_compatible_supply that enables data analysts to analyze and track supply data specifically for the Aave project on the Gnosis blockchain version 3.
🔧 PR: #5454, ADDED ICECREAMSWAP TO BASE 🧙 Author: @sophie-analytics on 2024-02-28 📝 Summary: This model creates a table called uniswap_compatible_v2_trades that enables data analysts to track and analyze trades on the IceCreamSwap platform. It captures trade events from specific sources related to pair creation and swapping activities, allowing for in-depth analysis of trading behavior within the IceCreamSwap ecosystem.
🔧 PR: #5366, Add alienbase to dex.trades 🧙 Author: @intensodefi on 2024-02-28 📝 Summary: A reference to a new model called 'alienbase_base_base_trades' was added in the dbt SQL model.
🔧 PR: #5366, add swapbased to dex.trades 🧙 Author: @intensodefi on 2024-02-28 📝 Summary: A reference to a new model called 'swapbased_base_base_trades' was added to the existing list of references.
🔧 PR: #5366, Add rocketswap to dex.trades 🧙 Author: @intensodefi on 2024-02-27 📝 Summary: A reference to a new model called 'rocketswap_base_base_trades' was added to the existing list of references in the SQL model.
🔧 PR: #5460, Add alienbase to dex.trades 🧙 Author: @intensodefi on 2024-02-28 📝 Summary: This dbt SQL model creates a table called uniswap_compatible_v2_trades that enables data analysts to analyze Uniswap V2 trades from the 'alienbase' project in the 'base' blockchain. It sources data from events related to pair creation and swaps, allowing for further analysis of trading pairs within the Uniswap ecosystem.
🔧 PR: #5455, add swapbased to dex.trades 🧙 Author: @intensodefi on 2024-02-28 📝 Summary: This dbt SQL model creates a table called uniswap_compatible_v2_trades that enables data analysts to analyze and track trades on the UniswapV2 platform. It sources data from two tables, UniswapV2Pair_evt_Swap and UniswapV2Factory_evt_PairCreated, allowing for further analysis of trading activities within the specified blockchain project.
🔧 PR: #5448, ADDED GRIDEX TO BASE 🧙 Author: @sophie-analytics on 2024-02-28 📝 Summary: This dbt SQL model creates a table called uniswap_compatible_v3_trades that enables data analysts to analyze trades on the Uniswap V3 protocol. It extracts relevant information from specified sources related to swaps and pools, allowing for further analysis of trading activities within the Gridex project on the base blockchain.
🔧 PR: #5452, Added soswap dex to dex.trades 🧙 Author: @archie17277 on 2024-02-28 📝 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 protocol for the specified blockchain, project, and version. It sources data from events related to pair swaps and pair creations in the SOSwap Base contract.
🔧 PR: #5412, Add Zonic to nft.trades on Base 🧙 Author: @tomfutago on 2024-02-28 📝 Summary: A new reference to a dbt model called 'zonic_base_base_trades' was added to the list of models in the variable 'nft_models'.
🔧 PR: #5462, Add Zonic to nft.trades on Base 🧙 Author: @tomfutago on 2024-02-28 📝 Summary: This dbt SQL model creates a table called zonic_base_trades that filters data based on the blockchain being 'base', with a minimum block number of 2882386, and includes trades starting from August 20, 2023. This enables data analysts to analyze trade information specifically related to the base blockchain from this specified date onwards.
🔧 PR: #5411, Revert 'Revert 'Add Zonic to nft.trades on zkSync Era (#5411)'' 🧙 Author: @0xRobin on 2024-02-27 📝 Summary: Removed the initial setup of variables and logic to extract data from source tables based on certain conditions. Added a call to a macro zonic_base_trades with parameters for blockchain, minimum block number, and project start date to generate base trades data for the model.
🔧 PR: #5411, Revert 'Add Zonic to nft.trades on zkSync Era (#5411)' 🧙 Author: @jeff-dude on 2024-02-27 📝 Summary: Variables were added to set token addresses, fee address, minimum block number, and project start date. The logic was updated to select specific columns from a source table based on certain conditions. Two CTEs were added to process different types of royalties transactions. Another CTE was added to filter and rank the closest transaction by order. Finally, a new base trade table was created with additional columns derived from the processed data. A comment indicates that some logic will be removed once additional transaction data is available in the base event tables.
🔧 PR: #5411, Add Zonic to nft.trades on zkSync Era 🧙 Author: @tomfutago on 2024-02-27 📝 Summary: Removed the definition of variables and initial query logic. Added a call to a macro zonic_base_trades with parameters for blockchain, minimum block number, and project start date to generate base trades data for an Optimism blockchain project starting from a specific date.
🔧 PR: #5411, Revert 'Revert 'Add Zonic to nft.trades on zkSync Era (#5411)'' 🧙 Author: @0xRobin on 2024-02-27 📝 Summary: The logic for processing events and transfers related to trades in a marketplace was removed. Instead, a new macro zonic_base_trades is added to generate base trade data with specified parameters like blockchain type, minimum block number, and project start date. This macro replaces the previous complex logic for extracting trade-related information from events and transfers tables.
🔧 PR: #5411, Revert 'Add Zonic to nft.trades on zkSync Era (#5411)' 🧙 Author: @jeff-dude on 2024-02-27 📝 Summary: Variables were added to set token addresses, fee address, block number, and project start date. The logic was updated to select specific columns from a source table based on certain conditions. Two CTEs were added to process different types of royalties transactions for ETH and ERC20 tokens. Another CTE was added to filter and rank the closest transaction by order. Finally, a new base trade table was created with various attributes joined from the events_raw and transfers tables. A comment indicates that some code will be removed once additional data is available in the base event tables.
🔧 PR: #5411, Add Zonic to nft.trades on zkSync Era 🧙 Author: @tomfutago on 2024-02-27 📝 Summary: The logic for processing events and transfers related to trades in a marketplace was removed. Instead, a new macro zonic_base_trades is added to generate base trade data with specified parameters like blockchain type, minimum block number, and project start date. This macro replaces the previous complex logic for extracting trade-related information from events and transfers tables.
🔧 PR: #5401, Add Tevaera to nft.trades on zkSync Era 🧙 Author: @tomfutago on 2024-02-23 📝 Summary: This SQL model creates a unified view of NFT trade data from the specified base table. It enables data analysts to analyze and track various details related to NFT trades, such as blockchain information, project details, transaction specifics, buyer and seller identities, pricing details including fees and currency contracts used. The model consolidates this information for further analysis across different projects or versions in a structured format for reporting purposes.
🔧 PR: #5401, Revert 'Add Zonic to nft.trades on zkSync Era (#5411)' 🧙 Author: @jeff-dude on 2024-02-27 📝 Summary: A reference to a dbt model named 'zonic_zksync_base_trades' was removed from the list of nft_models, and a new reference to 'tevaera_zksync_base_trades' was added.
🔧 PR: #5401, Add Zonic to nft.trades on zkSync Era 🧙 Author: @tomfutago on 2024-02-27 📝 Summary: Two dbt models, 'zonic_zksync_base_trades' and 'tevaera_zksync_base_trades', were added to the list of nft_models.
🔧 PR: #5411, Revert 'Revert 'Add Zonic to nft.trades on zkSync Era (#5411)'' 🧙 Author: @0xRobin on 2024-02-27 📝 Summary: This SQL model creates a table named zonic_base_trades that focuses on trades from the ZKSync blockchain starting from block number 269129 and onwards. It also includes a project start date of March 27, 2023. This model enables data analysts to analyze and track trade data specifically from the ZKSync blockchain after the specified block number and date.
🔧 PR: #5411, Add Zonic to nft.trades on zkSync Era 🧙 Author: @tomfutago on 2024-02-27 📝 Summary: This new dbt SQL model creates a table called zonic_base_trades that focuses on trades from the ZKSync blockchain starting from block number 269129 and onwards. It also includes a project start date of March 27, 2023. This model enables data analysts to analyze and derive insights specifically related to trades on the ZKSync blockchain within the specified parameters.
🔧 PR: #5451, Revert 'Revert 'Add Zonic to nft.trades on zkSync Era (#5411)'' 🧙 Author: @0xRobin on 2024-02-27 📝 Summary: This dbt SQL model creates a base table for transfers data from the Scroll blockchain. It combines information from various sources such as traces, transactions, and ERC20 transfers to provide a comprehensive dataset for data analysts to analyze transfer activities on the Scroll blockchain. The model enables analysts to easily query and derive insights related to transfers involving the specified native contract address.
🔧 PR: #5451, Revert 'Revert 'Add Zonic to nft.trades on zkSync Era (#5411)'' 🧙 Author: @0xRobin on 2024-02-27 📝 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 related to ERC-20 tokens with USD prices starting from February 15, 2023 in the Scroll blockchain network.
🔧 PR: #5433, Openocean Base to Dex Trades and create Openocean Macro - Ready for review 🧙 Author: @henrystats on 2024-02-26 📝 Summary: This model creates a table named openocean_compatible_v2_trades that enables data analysts to analyze trades from the OpenOcean project version 2 on the base blockchain. It includes information such as swapped events, burn addresses, and native token addresses for further analysis.
🔧 PR: #5413, Add Element Optimism NFT Trades - Ready for Review 🧙 Author: @henrystats on 2024-02-26 📝 Summary: This model creates a base table for trades on the Optimism blockchain by extracting data from specific sources related to ERC721 and ERC1155 sell and buy orders. It also adds transaction data (tx_from and tx_to) to the base event tables, enabling analysts to analyze trade transactions more comprehensively.
🔧 PR: #5432, Add Fraxswap Optimism to dex trades - Ready for review 🧙 Author: @henrystats on 2024-02-26 📝 Summary: This model creates a table called uniswap_compatible_v2_trades that enables data analysts to analyze trades specific to the Optimism blockchain and the Fraxswap project version 1. It sources data from events related to pair swaps and pair creations in the FraxswapOptimism dataset.
🔧 PR: #5412, Add Element Base NFT Trades - Ready for Review 🧙 Author: @henrystats on 2024-02-27 📝 Summary: This model creates a base_trades table by extracting data from different sources related to ERC721 and ERC1155 trades on the blockchain. It also adds additional non-fungible token transaction data to the base_trades table, enabling data analysts to analyze and gain insights into NFT trading activities on the specified blockchain.
🔧 PR: #5446, Add rocketswap to dex.trades 🧙 Author: @intensodefi on 2024-02-27 📝 Summary: This model creates a table called uniswap_compatible_v2_trades that enables data analysts to analyze Uniswap V2 trades for the Rocketswap project. It sources data from events related to pair creation and swaps in the UniswapV2Pair_evt_Swap and UniswapV2Factory_evt_PairCreated tables, allowing for analysis of trading pairs within the Rocketswap platform.
🔧 PR: #5439, Add Tofu to nft.trades on Celo 🧙 Author: @tomfutago on 2024-02-27 📝 Summary: This model combines data from the 'tofu_celo_base_trades' table, providing a comprehensive view of NFT trades. It includes details such as blockchain info, trade specifics (category and type), buyer/seller information, pricing details, fees, and transaction identifiers. The model also incorporates duplicate protection based on transaction hash and trade ID to ensure data accuracy for analysts.
🔧 PR: #5439, Add Tofu to nft.trades on Celo 🧙 Author: @tomfutago on 2024-02-27 📝 Summary: This dbt SQL model creates a base table for trades on the Celo blockchain, enabling data analysts to analyze trade data related to NFTs. The model includes information such as market calls and inventory updates, with specific details like project start date and replacements for native ERC20 tokens and symbols.
🔧 PR: #5441, Add zkync to NFT wash trade model 🧙 Author: @lgingerich on 2024-02-27 📝 Summary: This dbt SQL model creates a table that identifies wash trades for NFT transactions on the Zksync blockchain. It enables data analysts to analyze and detect potential wash trading activities within the NFT market on Zksync.
🔧 PR: #5442, Add Magic Eden NFT's new trades on Ethereum & Polygon 🧙 Author: @hildobby on 2024-02-27 📝 Summary: This model creates a dataset of trades involving NFTs, including details like buyer, seller, price, and trade category. It also links these trades to fees paid to platform and royalty addresses. The model enables data analysts to analyze NFT transactions on the Ethereum blockchain within a specific project called 'magiceden,' providing insights into trading activities and associated fees for further analysis.
🔧 PR: #5442, Add Magic Eden NFT's new trades on Ethereum & Polygon 🧙 Author: @hildobby on 2024-02-27 📝 Summary: This model creates a dataset of trades involving NFTs, including buy listings and accepted offers. It also calculates platform and royalty fees associated with these trades. The model categorizes the trades by type, blockchain, project version, and trade date. Additionally, it links the trades to specific addresses involved in the transactions for further analysis by data analysts.
🔧 PR: #5430, Added Elk_finance dex to dex.trades 🧙 Author: @archie17277 on 2024-02-26 📝 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 project 'elk_finance'. It sources data from events related to pair swaps and pair creations in the Elk Finance base blockchain.
🔧 PR: #5423, Added elk_finance dex data to dex.trades 🧙 Author: @archie17277 on 2024-02-25 📝 Summary: This model creates a table called uniswap_compatible_v2_trades that enables data analysts to analyze trades compatible with Uniswap V2 on the Optimism blockchain for the Elk Finance project. It sources data from events related to pair swaps and pair creations in the Elk Finance Optimism dataset.
🔧 PR: #5422, Added oasisswap dex to dex.trades 🧙 Author: @archie17277 on 2024-02-25 📝 Summary: This dbt SQL model creates a table called uniswap_compatible_v2_trades that enables data analysts to analyze and track trades on the OasisSwap platform. It sources data from events related to pair swaps and pair creations in the OasisSwap base, allowing for further analysis of trading activities within this ecosystem.
🔧 PR: #5421, Added leetswap dex to dex.trades 🧙 Author: @archie17277 on 2024-02-25 📝 Summary: This SQL model creates a table called uniswap_compatible_v2_trades that enables data analysts to analyze trades compatible with Uniswap V2 on the blockchain. It pulls data from sources related to the LeetSwap project version 2, allowing for further analysis and insights into trading activities within this ecosystem.
🔧 PR: #5396, Updated OdosRouterV2 source table/name (odos_v2) 🧙 Author: @discochuck on 2024-02-23 📝 Summary: In this pull request, a section of the SQL model was removed and then added back. The section defines a common table expression (CTE) named base_union with specific attributes related to blockchain data from Avalanche C chain.
🔧 PR: #5396, Updated OdosRouterV2 source table/name (odos_v2) 🧙 Author: @discochuck on 2024-02-23 📝 Summary: A join with a source table odos_v2_avalanche_c was added, replacing the previous source table glacier_avalanche_c. The logic involves joining this new source on specific conditions related to transaction hashes and event indexes. Additionally, there is a selection of columns from the joined data.
🔧 PR: #5401, Add Tevaera to nft.trades on zkSync Era 🧙 Author: @tomfutago on 2024-02-23 📝 Summary: This model creates a base table for trade data related to the Tevaera project on the zksync blockchain. It includes information such as block time, block date, NFT details (contract address and token ID), buyer and seller details, trade category, price paid in WETH currency, transaction hash, and other relevant fields. The model enables data analysts to analyze secondary trades of NFTs within the Tevaera project on zksync blockchain starting from a specified date.
🔧 PR: #5366, Added Throne_exchange_v2 and Throne_exchange_v3 dexes to dex.trades 🧙 Author: @Jason4276 on 2024-02-23 📝 Summary: This dbt SQL model creates a table called uniswap_compatible_v2_trades that enables data analysts to analyze and query Uniswap V2 trades data from the Throne Exchange project in the base blockchain. The model sources information from events related to pair swaps and pair creations within the ThroneV2Pair_evt_Swap and ThroneV2Factory_evt_PairCreated tables, respectively.
🔧 PR: #5366, Added Throne_exchange_v2 and Throne_exchange_v3 dexes to dex.trades 🧙 Author: @Jason4276 on 2024-02-23 📝 Summary: This new dbt SQL model creates a table called uniswap_compatible_v3_trades that enables data analysts to analyze and track trades on the Uniswap V3 protocol within the specified blockchain, project, and version. It sources data from events related to swaps and pool creations in the Throne Exchange base.
🔧 PR: #5471, Update cow_protocol_ethereum_app_data.sql 🧙 Author: @olgafetisova on 2024-02-29 📝 Summary: Added columns for partner_fee, partner_fee_bps, and partner_recipient were introduced to the SQL model. The logic involves extracting data related to fees from different parts of the content metadata and assigning them specific names for further analysis.
🔧 PR: #5463, Update cow_protocol_ethereum_solvers.sql 🧙 Author: @fleupold on 2024-02-29 📝 Summary: A row with address, environment, and name values was added for a solver in the 'staging' environment named 'Seasolver2'.
🔧 PR: #5173, 1inch: AggregationRouterV6 to 1inch spellbooks linage 🧙 Author: @max-morrow on 2024-02-28 📝 Summary: Two rows were added to the contracts CTE for 'AggregationRouterV6' with different addresses and networks, along with another row for 'AggregationRouterV6' under a different address and network.
🔧 PR: #5173, 1inch: AggregationRouterV6 to 1inch spellbooks linage 🧙 Author: @max-morrow on 2024-02-28 📝 Summary: Added a new column 'flags' and removed columns 'fusion', '_call_trace_address', and logic related to them. Added a new CTE named 'final' with updated logic for flags, contracts_only, and second_side. The final select statement includes all columns from the previous model along with generating a unique key using dbt_utils.generate_surrogate_key function.
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
This is your weekly summary of 51 PRs merged from 23 wizards. Great job everyone! 🎉
We had 55 added models 🟢 and 135 modified models 🟠 for 19 Sectors.
SECTOR: dex
toggle to see all model updates
MODEL: dex_raw_pool_creations.sql
🟠 Modified by:
🔧 PR: #5417, 1inch: AggregationRouterV6 to 1inch spellbooks linage
🧙 Author: @max-morrow on 2024-02-28
📝 Summary: Added support for the 'bnb' and 'zksync' blockchains. Introduced a new CTE named 't' that selects specific columns from pool_created_logs and creation_traces, with an optional incremental predicate. Merged this selection with data from '_optimism_ovm1_legacy'. Finally, filtered out duplicates based on certain criteria in the final select statement within CTE 't'.
🔧 PR: #5417,
dex_raw_pool_creations
remove bnb due to duplicates🧙 Author: @jeff-dude on 2024-02-23
📝 Summary: Removed 'bnb' from the list of blockchains.
MODEL: dex_info.sql
🟠 Modified by:
🔧 PR: #5366, Add alienbase to dex.trades
🧙 Author: @intensodefi on 2024-02-28
📝 Summary: A new row for 'AlienBase' with corresponding values was added to the temporary table.
🔧 PR: #5366, add swapbased to dex.trades
🧙 Author: @intensodefi on 2024-02-28
📝 Summary: A new row for 'swapbased' with corresponding values was added to the temporary table.
🔧 PR: #5366, Added soswap dex to dex.trades
🧙 Author: @archie17277 on 2024-02-28
📝 Summary: A new row for 'soswap' with corresponding values was added to the existing list of rows in the model.
🔧 PR: #5366, Add rocketswap to dex.trades
🧙 Author: @intensodefi on 2024-02-27
📝 Summary: A new row for 'rocketswap' with values 'RocketSwap', 'Direct', and 'RocketSwap_Labs' was added to the temp_table.
🔧 PR: #5366, Added elk_finance dex data to dex.trades
🧙 Author: @archie17277 on 2024-02-25
📝 Summary: A new project called 'Elk Finance' was added to the list of projects in the temporary table.
🔧 PR: #5366, Added leetswap dex to dex.trades
🧙 Author: @archie17277 on 2024-02-25
📝 Summary: A new project called 'Leetswap' with corresponding details was added to the temporary table.
🔧 PR: #5366, Added Throne_exchange_v2 and Throne_exchange_v3 dexes to dex.trades
🧙 Author: @Jason4276 on 2024-02-23
📝 Summary: A new value for a cryptocurrency exchange called 'Throne_exchange' with the corresponding details was added to the existing list of exchanges in the SQL model.
MODEL: dex_solana_trades.sql
🟠 Modified by:
🔧 PR: #5420, add meteora v2 to dex_solana.trades
🧙 Author: @andrewhong5297 on 2024-02-25
📝 Summary: A reference to a model named 'meteora_v2_solana_trades' was added in the dbt SQL model.
SECTOR: tokens
toggle to see all model updates
MODEL: tokens_nft.sql
🟠 Modified by:
🔧 PR: #5459, Add zkSync to tokens.nft
🧙 Author: @lgingerich on 2024-02-28
📝 Summary: A reference to a new model called 'tokens_zksync_nft' was added in the SQL query.
SECTOR: prices
toggle to see all model updates
MODEL: prices_ethereum_tokens.sql
🟠 Modified by:
🔧 PR: #5437, add yup token to
prices_ethereum_tokens.sql
🧙 Author: @andrei0x309 on 2024-02-28
📝 Summary: The tokens that were added or removed are: 'YUP', 'rsETH'
🔧 PR: #5437, [EASY] add LST LRT price
🧙 Author: @GoodDataBadGuy on 2024-02-26
📝 Summary: The tokens that were added are: osETH, LsETH, OETH, ETHx, rsETH, pufETH
SECTOR: _sector
toggle to see all model updates
MODEL: tokens_polygon_balances_daily.sql
🟢 Added by:
🔧 PR: #5487, Balances polygon
🧙 Author: @aalan3 on 2024-03-01
📝 Summary: This model creates a table called
balances_daily
that aggregates daily token balances starting from May 28, 2021. It enables data analysts to analyze and track the daily changes in token balances over time for Polygon tokens.MODEL: tokens_polygon_balances_daily_agg.sql
🟢 Added by:
🔧 PR: #5487, Balances polygon
🧙 Author: @aalan3 on 2024-03-01
📝 Summary: This model creates an enriched version of daily aggregated token balances from a raw dataset. It enables data analysts to work with more comprehensive and detailed information regarding token balances on a daily basis.
MODEL: tokens_polygon_balances_daily_agg_base.sql
🟢 Added by:
🔧 PR: #5487, Balances polygon
🧙 Author: @aalan3 on 2024-03-01
📝 Summary: This SQL model creates a new table that aggregates daily token balances from the 'tokens_polygon' data source. It enables data analysts to easily access and analyze aggregated daily token balance information for Polygon tokens.
MODEL: tokens_arbitrum_balances_daily.sql
🟢 Added by:
🔧 PR: #5486, Add Arbitrum balances
🧙 Author: @aalan3 on 2024-03-01
📝 Summary: This model creates a new table called
balances_daily
that enables data analysts to access aggregated daily token balances starting from May 28, 2021.MODEL: tokens_arbitrum_balances_daily_agg.sql
🟢 Added by:
🔧 PR: #5486, Add Arbitrum balances
🧙 Author: @aalan3 on 2024-03-01
📝 Summary: This dbt SQL model creates an enriched version of daily token balances on the Arbitrum network. It enables data analysts to work with aggregated token balance data that has been enhanced for analysis and reporting purposes.
MODEL: tokens_arbitrum_balances_daily_agg_base.sql
🟢 Added by:
🔧 PR: #5486, Add Arbitrum balances
🧙 Author: @aalan3 on 2024-03-01
📝 Summary: This model creates a new table that aggregates daily balances data from the 'tokens_arbitrum' source. It enables data analysts to easily analyze and track daily balance changes for arbitrum tokens.
MODEL: tokens_base_balances_daily.sql
🟢 Added by:
🔧 PR: #5485, Add more daily balances
🧙 Author: @aalan3 on 2024-03-01
📝 Summary: This new dbt SQL model creates a table called
balances_daily
that aggregates daily token base balances starting from July 15, 2023. It enables data analysts to analyze and track the daily balances of tokens in the database for reporting and further analysis.MODEL: tokens_base_balances_daily_agg.sql
🟢 Added by:
🔧 PR: #5485, Add more daily balances
🧙 Author: @aalan3 on 2024-03-01
📝 Summary: This model creates an enriched version of daily token balances by merging raw balance data. It enables data analysts to easily access and analyze aggregated daily token balance information for further reporting and analysis.
MODEL: tokens_base_balances_daily_agg_base.sql
🟢 Added by:
🔧 PR: #5485, Add more daily balances
🧙 Author: @aalan3 on 2024-03-01
📝 Summary: This SQL model creates a new table that aggregates daily balances data. It enables data analysts to easily access and analyze summarized information on token balances on a daily basis.
MODEL: tokens_optimism_balances_daily.sql
🟢 Added by:
🔧 PR: #5485, Add more daily balances
🧙 Author: @aalan3 on 2024-03-01
📝 Summary: This SQL model creates a new table called
balances_daily
that enables data analysts to access aggregated daily balance information starting from January 14, 2021.MODEL: tokens_optimism_balances_daily_agg.sql
🟢 Added by:
🔧 PR: #5485, Add more daily balances
🧙 Author: @aalan3 on 2024-03-01
📝 Summary: This dbt SQL model creates an enriched version of daily balance data by joining it with raw token balances. It enables data analysts to work with aggregated and enhanced balance information for Optimism tokens on a daily basis.
MODEL: tokens_optimism_balances_daily_agg_base.sql
🟢 Added by:
🔧 PR: #5485, Add more daily balances
🧙 Author: @aalan3 on 2024-03-01
📝 Summary: This SQL model creates a new table that aggregates daily balances data from the 'balances_optimism' source table. It enables data analysts to easily access and analyze aggregated daily balance information for further reporting and analysis.
MODEL: tokens_arbitrum_balances.sql
🟠 Modified by:
🔧 PR: #5464, Source identifiers for balances source
🧙 Author: @0xRobin on 2024-03-01
📝 Summary: The change made in this pull request updated the source table used in the
balances_raw
CTE from'balances_arbitrum_0001'
to just'balances_arbitrum'
.🔧 PR: #5464, balances upgrade + daily aggregation with forward fill
🧙 Author: @0xRobin on 2024-03-01
📝 Summary: Added a CTE 'balances_raw' that sources data from 'tokens_arbitrum' and enriches it with the balances_enrich function. The logic was updated to use the new CTE instead of directly sourcing data in the balances_base parameter.
MODEL: tokens_base_balances.sql
🟠 Modified by:
🔧 PR: #5464, Source identifiers for balances source
🧙 Author: @0xRobin on 2024-03-01
📝 Summary: The change made in this pull request updated the source table reference from 'balances_base_0001' to 'balances_base'.
🔧 PR: #5464, balances upgrade + daily aggregation with forward fill
🧙 Author: @0xRobin on 2024-03-01
📝 Summary: Added a CTE 'balances_raw' that calls a macro to fix the schema of a source table. The model now uses this CTE in the 'balances_enrich' call instead of directly referencing the source table and blockchain type.
MODEL: tokens_bnb_balances.sql
🟠 Modified by:
🔧 PR: #5464, Source identifiers for balances source
🧙 Author: @0xRobin on 2024-03-01
📝 Summary: The change made in this pull request updated the source table being referenced in the dbt model from 'balances_bnb_0001' to 'balances_bnb'.
🔧 PR: #5464, balances upgrade + daily aggregation with forward fill
🧙 Author: @0xRobin on 2024-03-01
📝 Summary: Added a CTE
balances_raw
that fixes the schema of a source table and enriches it with additional data in thebalances_enrich
macro. Removed direct reference to the source table and replaced it with reference to the new CTE.MODEL: tokens_ethereum_balances.sql
🟠 Modified by:
🔧 PR: #5464, Source identifiers for balances source
🧙 Author: @0xRobin on 2024-03-01
📝 Summary: The diff shows a change in the source table used for the balances_raw CTE in the dbt model. The source table 'balances_ethereum_0004' was replaced with 'balances_ethereum'.
🔧 PR: #5464, balances upgrade + daily aggregation with forward fill
🧙 Author: @0xRobin on 2024-03-01
📝 Summary: Added a CTE named 'balances_raw' that fixes the schema of a source table and specifies the blockchain as 'ethereum'. The main logic change is in the 'balances_enrich' macro call, where it now takes in 'balances_raw' instead of directly referencing a source table.
MODEL: tokens_ethereum_balances_daily_agg_base.sql
🟠 Modified by:
🔧 PR: #5464, Source identifiers for balances source
🧙 Author: @0xRobin on 2024-03-01
📝 Summary: The change made in the SQL model involves updating the source table reference from 'balances_ethereum_0004' to 'balances_ethereum'.
🔧 PR: #5464, balances upgrade + daily aggregation with forward fill
🧙 Author: @0xRobin on 2024-03-01
📝 Summary: Added a CTE named
balances_raw
that fixes the schema of a source table and references it. Renamed the model frombalances_daily
tobalances_daily_agg
, which now takes in the CTE as input instead of directly referencing a source table.MODEL: tokens_optimism_balances.sql
🟠 Modified by:
🔧 PR: #5464, Source identifiers for balances source
🧙 Author: @0xRobin on 2024-03-01
📝 Summary: The change involves updating the source table name from 'balances_optimism_0001' to 'balances_optimism'.
🔧 PR: #5464, balances upgrade + daily aggregation with forward fill
🧙 Author: @0xRobin on 2024-03-01
📝 Summary: Added a CTE named 'balances_raw' that sources data from 'tokens_optimism' and enriches it with the logic in the 'balances_enrich' macro using this new CTE. Removed direct sourcing of data within the balances_enrich macro, instead referencing the newly created CTE for balance calculations.
MODEL: tokens_polygon_balances.sql
🟠 Modified by:
🔧 PR: #5464, Source identifiers for balances source
🧙 Author: @0xRobin on 2024-03-01
📝 Summary: The source table 'balances_polygon_0001' was replaced with 'balances_polygon' in the dbt SQL model.
🔧 PR: #5464, balances upgrade + daily aggregation with forward fill
🧙 Author: @0xRobin on 2024-03-01
📝 Summary: Added a CTE named 'balances_raw' that calls a macro to fix the schema of a source table. The existing logic for enriching balances was updated to use the new CTE instead of directly referencing the source table.
MODEL: tokens_ethereum_balances_daily.sql
🟠 Modified by:
🔧 PR: #5464, balances upgrade + daily aggregation with forward fill
🧙 Author: @0xRobin on 2024-03-01
📝 Summary: Removed the
balances_enrich
model and added a newbalances_daily
model that referencestokens_ethereum_balances_daily_agg
. The new model includes a start date parameter set to '2015-07-30'.MODEL: tokens_ethereum_balances_daily_agg.sql
🟢 Added by:
🔧 PR: #5464, balances upgrade + daily aggregation with forward fill
🧙 Author: @0xRobin on 2024-03-01
📝 Summary: This model creates an enriched version of daily Ethereum token balances by merging the raw balance data with additional information. It enables data analysts to work with more comprehensive and detailed Ethereum token balance data for their analysis and reporting purposes.
MODEL: lending_bnb_base_borrow.sql
🟠 Modified by:
🔧 PR: #5438, Add Aave v3 to lending on Gnosis & BNB
🧙 Author: @tomfutago on 2024-02-28
📝 Summary: A new reference to a model named 'aave_v3_bnb_base_borrow' was added in addition to the existing reference to 'radiant_bnb_base_borrow'.
MODEL: aave_v3_bnb_base_borrow.sql
🟢 Added by:
🔧 PR: #5438, Add Aave v3 to lending on Gnosis & BNB
🧙 Author: @tomfutago on 2024-02-28
📝 Summary: This dbt SQL model creates a table that enables data analysts to analyze borrowing activity on the Aave protocol version 3 for the Binance Smart Chain (BNB).
MODEL: lending_gnosis_base_borrow.sql
🟠 Modified by:
🔧 PR: #5438, Add Aave v3 to lending on Gnosis & BNB
🧙 Author: @tomfutago on 2024-02-28
📝 Summary: Two dbt models, 'agave_gnosis_base_borrow' and 'aave_v3_gnosis_base_borrow', were added to the list of models being referenced in this SQL model.
MODEL: aave_v3_gnosis_base_borrow.sql
🟢 Added by:
🔧 PR: #5438, Add Aave v3 to lending on Gnosis & BNB
🧙 Author: @tomfutago on 2024-02-28
📝 Summary: This dbt SQL model creates a table that enables data analysts to analyze borrowing activity on the Aave lending platform version 3, specifically focusing on data from the Gnosis blockchain.
MODEL: lending_bnb_base_flashloans.sql
🟠 Modified by:
🔧 PR: #5438, Add Aave v3 to lending on Gnosis & BNB
🧙 Author: @tomfutago on 2024-02-28
📝 Summary: A new reference to a model named 'aave_v3_bnb_base_flashloans' was added in addition to the existing reference to 'radiant_bnb_base_flashloans'.
MODEL: aave_v3_bnb_base_flashloans.sql
🟢 Added by:
🔧 PR: #5438, Add Aave v3 to lending on Gnosis & BNB
🧙 Author: @tomfutago on 2024-02-28
📝 Summary: This SQL model creates a table that enables data analysts to analyze lending Aave V3 compatible flashloans specific to the Binance Smart Chain (BNB) blockchain and the Aave project version 3.
MODEL: lending_gnosis_base_flashloans.sql
🟠 Modified by:
🔧 PR: #5438, Add Aave v3 to lending on Gnosis & BNB
🧙 Author: @tomfutago on 2024-02-28
📝 Summary: Two dbt models, 'agave_gnosis_base_flashloans' and 'aave_v3_gnosis_base_flashloans', were added to the list of models being referenced in this SQL file.
MODEL: aave_v3_gnosis_base_flashloans.sql
🟢 Added by:
🔧 PR: #5438, Add Aave v3 to lending on Gnosis & BNB
🧙 Author: @tomfutago on 2024-02-28
📝 Summary: This model creates a table that enables data analysts to analyze lending flashloans compatible with Aave version 3 on the Gnosis blockchain for their projects.
MODEL: lending_bnb_base_supply.sql
🟠 Modified by:
🔧 PR: #5438, Add Aave v3 to lending on Gnosis & BNB
🧙 Author: @tomfutago on 2024-02-28
📝 Summary: A reference to a model named 'aave_v3_bnb_base_supply' was added in addition to the existing reference to 'radiant_bnb_base_supply'.
MODEL: aave_v3_bnb_base_supply.sql
🟢 Added by:
🔧 PR: #5438, Add Aave v3 to lending on Gnosis & BNB
🧙 Author: @tomfutago on 2024-02-28
📝 Summary: This model creates a table that tracks compatible supply data for the Aave project on the Binance Smart Chain (bnb) using version 3 of their protocol. It enables data analysts to analyze and monitor lending activities specific to Aave on the Binance Smart Chain.
MODEL: lending_gnosis_base_supply.sql
🟠 Modified by:
🔧 PR: #5438, Add Aave v3 to lending on Gnosis & BNB
🧙 Author: @tomfutago on 2024-02-28
📝 Summary: A reference to a model named 'aave_v3_gnosis_base_supply' was added in addition to the existing reference to 'agave_gnosis_base_supply'.
MODEL: aave_v3_gnosis_base_supply.sql
🟢 Added by:
🔧 PR: #5438, Add Aave v3 to lending on Gnosis & BNB
🧙 Author: @tomfutago on 2024-02-28
📝 Summary: This new dbt SQL model creates a table called lending_aave_v3_compatible_supply that enables data analysts to analyze and track supply data specifically for the Aave project on the Gnosis blockchain version 3.
MODEL: icecreamswap_base_base_trades.sql
🟢 Added by:
🔧 PR: #5454, ADDED ICECREAMSWAP TO BASE
🧙 Author: @sophie-analytics on 2024-02-28
📝 Summary: This model creates a table called
uniswap_compatible_v2_trades
that enables data analysts to track and analyze trades on the IceCreamSwap platform. It captures trade events from specific sources related to pair creation and swapping activities, allowing for in-depth analysis of trading behavior within the IceCreamSwap ecosystem.MODEL: dex_base_base_trades.sql
🟠 Modified by:
🔧 PR: #5366, Add alienbase to dex.trades
🧙 Author: @intensodefi on 2024-02-28
📝 Summary: A reference to a new model called 'alienbase_base_base_trades' was added in the dbt SQL model.
🔧 PR: #5366, add swapbased to dex.trades
🧙 Author: @intensodefi on 2024-02-28
📝 Summary: A reference to a new model called 'swapbased_base_base_trades' was added to the existing list of references.
🔧 PR: #5366, Added soswap dex to dex.trades
🧙 Author: @archie17277 on 2024-02-28
📝 Summary: A reference to a new model called 'soswap_base_base_trades' was added.
🔧 PR: #5366, Openocean Base to Dex Trades and create Openocean Macro - Ready for review
🧙 Author: @henrystats on 2024-02-26
📝 Summary: A reference to a new model called 'openocean_base_base_trades' was added in the dbt SQL model.
🔧 PR: #5366, Add Wombat Exchange (Base) - Ready for review
🧙 Author: @henrystats on 2024-02-27
📝 Summary: A reference to a new model called 'wombat_exchange_base_base_trades' was added in the dbt SQL model.
🔧 PR: #5366, Add rocketswap to dex.trades
🧙 Author: @intensodefi on 2024-02-27
📝 Summary: A reference to a new model called 'rocketswap_base_base_trades' was added to the existing list of references in the SQL model.
🔧 PR: #5366, Added Elk_finance dex to dex.trades
🧙 Author: @archie17277 on 2024-02-26
📝 Summary: A reference to a new model named 'elk_finance_base_base_trades' was added in the dbt SQL model.
🔧 PR: #5366, Added oasisswap dex to dex.trades
🧙 Author: @archie17277 on 2024-02-25
📝 Summary: Added a reference to 'oasisswap_base_base_trades' in the dbt SQL model.
🔧 PR: #5366, Added leetswap dex to dex.trades
🧙 Author: @archie17277 on 2024-02-25
📝 Summary: A reference to a new model called 'leetswap_v2_base_base_trades' was added to the SQL query.
🔧 PR: #5366, Added Throne_exchange_v2 and Throne_exchange_v3 dexes to dex.trades
🧙 Author: @Jason4276 on 2024-02-23
📝 Summary: Two new references were added to the SQL model: 'throne_exchange_v2_base_base_trades' and 'throne_exchange_v3_base_base_trades'.
MODEL: alienbase_base_base_trades.sql
🟢 Added by:
🔧 PR: #5460, Add alienbase to dex.trades
🧙 Author: @intensodefi on 2024-02-28
📝 Summary: This dbt SQL model creates a table called
uniswap_compatible_v2_trades
that enables data analysts to analyze Uniswap V2 trades from the 'alienbase' project in the 'base' blockchain. It sources data from events related to pair creation and swaps, allowing for further analysis of trading pairs within the Uniswap ecosystem.MODEL: swapbased_base_base_trades.sql
🟢 Added by:
🔧 PR: #5455, add swapbased to dex.trades
🧙 Author: @intensodefi on 2024-02-28
📝 Summary: This dbt SQL model creates a table called
uniswap_compatible_v2_trades
that enables data analysts to analyze and track trades on the UniswapV2 platform. It sources data from two tables,UniswapV2Pair_evt_Swap
andUniswapV2Factory_evt_PairCreated
, allowing for further analysis of trading activities within the specified blockchain project.MODEL: gridex_base_base_trades.sql
🟢 Added by:
🔧 PR: #5448, ADDED GRIDEX TO BASE
🧙 Author: @sophie-analytics on 2024-02-28
📝 Summary: This dbt SQL model creates a table called uniswap_compatible_v3_trades that enables data analysts to analyze trades on the Uniswap V3 protocol. It extracts relevant information from specified sources related to swaps and pools, allowing for further analysis of trading activities within the Gridex project on the base blockchain.
MODEL: soswap_base_base_trades.sql
🟢 Added by:
🔧 PR: #5452, Added soswap dex to dex.trades
🧙 Author: @archie17277 on 2024-02-28
📝 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 protocol for the specified blockchain, project, and version. It sources data from events related to pair swaps and pair creations in the SOSwap Base contract.MODEL: nft_base_base_trades.sql
🟠 Modified by:
🔧 PR: #5412, Add Zonic to
nft.trades
on Base🧙 Author: @tomfutago on 2024-02-28
📝 Summary: A new reference to a dbt model called 'zonic_base_base_trades' was added to the list of models in the variable 'nft_models'.
🔧 PR: #5412, Add Element Base NFT Trades - Ready for Review
🧙 Author: @henrystats on 2024-02-27
📝 Summary: Two references to dbt models (
alienswap_base_base_trades
andelement_base_base_trades
) were added to the listnft_models
.MODEL: zonic_base_base_trades.sql
🟢 Added by:
🔧 PR: #5462, Add Zonic to
nft.trades
on Base🧙 Author: @tomfutago on 2024-02-28
📝 Summary: This dbt SQL model creates a table called zonic_base_trades that filters data based on the blockchain being 'base', with a minimum block number of 2882386, and includes trades starting from August 20, 2023. This enables data analysts to analyze trade information specifically related to the base blockchain from this specified date onwards.
MODEL: zonic_optimism_base_trades.sql
🟠 Modified by:
🔧 PR: #5411, Revert 'Revert 'Add Zonic to
nft.trades
on zkSync Era (#5411)''🧙 Author: @0xRobin on 2024-02-27
📝 Summary: Removed the initial setup of variables and logic to extract data from source tables based on certain conditions. Added a call to a macro
zonic_base_trades
with parameters for blockchain, minimum block number, and project start date to generate base trades data for the model.🔧 PR: #5411, Revert 'Add Zonic to
nft.trades
on zkSync Era (#5411)'🧙 Author: @jeff-dude on 2024-02-27
📝 Summary: Variables were added to set token addresses, fee address, minimum block number, and project start date. The logic was updated to select specific columns from a source table based on certain conditions. Two CTEs were added to process different types of royalties transactions. Another CTE was added to filter and rank the closest transaction by order. Finally, a new base trade table was created with additional columns derived from the processed data. A comment indicates that some logic will be removed once additional transaction data is available in the base event tables.
🔧 PR: #5411, Add Zonic to
nft.trades
on zkSync Era🧙 Author: @tomfutago on 2024-02-27
📝 Summary: Removed the definition of variables and initial query logic. Added a call to a macro
zonic_base_trades
with parameters for blockchain, minimum block number, and project start date to generate base trades data for an Optimism blockchain project starting from a specific date.MODEL: zonic_scroll_base_trades.sql
🟠 Modified by:
🔧 PR: #5411, Revert 'Revert 'Add Zonic to
nft.trades
on zkSync Era (#5411)''🧙 Author: @0xRobin on 2024-02-27
📝 Summary: The logic for processing events and transfers related to trades in a marketplace was removed. Instead, a new macro
zonic_base_trades
is added to generate base trade data with specified parameters like blockchain type, minimum block number, and project start date. This macro replaces the previous complex logic for extracting trade-related information from events and transfers tables.🔧 PR: #5411, Revert 'Add Zonic to
nft.trades
on zkSync Era (#5411)'🧙 Author: @jeff-dude on 2024-02-27
📝 Summary: Variables were added to set token addresses, fee address, block number, and project start date. The logic was updated to select specific columns from a source table based on certain conditions. Two CTEs were added to process different types of royalties transactions for ETH and ERC20 tokens. Another CTE was added to filter and rank the closest transaction by order. Finally, a new base trade table was created with various attributes joined from the events_raw and transfers tables. A comment indicates that some code will be removed once additional data is available in the base event tables.
🔧 PR: #5411, Add Zonic to
nft.trades
on zkSync Era🧙 Author: @tomfutago on 2024-02-27
📝 Summary: The logic for processing events and transfers related to trades in a marketplace was removed. Instead, a new macro
zonic_base_trades
is added to generate base trade data with specified parameters like blockchain type, minimum block number, and project start date. This macro replaces the previous complex logic for extracting trade-related information from events and transfers tables.MODEL: nft_zksync_base_trades.sql
🟢 Added by:
🔧 PR: #5401, Add Tevaera to
nft.trades
on zkSync Era🧙 Author: @tomfutago on 2024-02-23
📝 Summary: This SQL model creates a unified view of NFT trade data from the specified base table. It enables data analysts to analyze and track various details related to NFT trades, such as blockchain information, project details, transaction specifics, buyer and seller identities, pricing details including fees and currency contracts used. The model consolidates this information for further analysis across different projects or versions in a structured format for reporting purposes.
🟠 Modified by:
🔧 PR: #5401, Revert 'Revert 'Add Zonic to
nft.trades
on zkSync Era (#5411)''🧙 Author: @0xRobin on 2024-02-27
📝 Summary: Two references to dbt models were added: 'zonic_zksync_base_trades' and 'tevaera_zksync_base_trades'.
🔧 PR: #5401, Revert 'Add Zonic to
nft.trades
on zkSync Era (#5411)'🧙 Author: @jeff-dude on 2024-02-27
📝 Summary: A reference to a dbt model named 'zonic_zksync_base_trades' was removed from the list of nft_models, and a new reference to 'tevaera_zksync_base_trades' was added.
🔧 PR: #5401, Add Zonic to
nft.trades
on zkSync Era🧙 Author: @tomfutago on 2024-02-27
📝 Summary: Two dbt models, 'zonic_zksync_base_trades' and 'tevaera_zksync_base_trades', were added to the list of nft_models.
MODEL: zonic_zksync_base_trades.sql
🟢 Added by:
🔧 PR: #5411, Revert 'Revert 'Add Zonic to
nft.trades
on zkSync Era (#5411)''🧙 Author: @0xRobin on 2024-02-27
📝 Summary: This SQL model creates a table named
zonic_base_trades
that focuses on trades from the ZKSync blockchain starting from block number 269129 and onwards. It also includes a project start date of March 27, 2023. This model enables data analysts to analyze and track trade data specifically from the ZKSync blockchain after the specified block number and date.🔧 PR: #5411, Add Zonic to
nft.trades
on zkSync Era🧙 Author: @tomfutago on 2024-02-27
📝 Summary: This new dbt SQL model creates a table called
zonic_base_trades
that focuses on trades from the ZKSync blockchain starting from block number 269129 and onwards. It also includes a project start date of March 27, 2023. This model enables data analysts to analyze and derive insights specifically related to trades on the ZKSync blockchain within the specified parameters.MODEL: tokens_scroll_base_transfers.sql
🟢 Added by:
🔧 PR: #5451, Revert 'Revert 'Add Zonic to
nft.trades
on zkSync Era (#5411)''🧙 Author: @0xRobin on 2024-02-27
📝 Summary: This dbt SQL model creates a base table for transfers data from the Scroll blockchain. It combines information from various sources such as traces, transactions, and ERC20 transfers to provide a comprehensive dataset for data analysts to analyze transfer activities on the Scroll blockchain. The model enables analysts to easily query and derive insights related to transfers involving the specified native contract address.
MODEL: tokens_scroll_transfers.sql
🟢 Added by:
🔧 PR: #5451, Revert 'Revert 'Add Zonic to
nft.trades
on zkSync Era (#5411)''🧙 Author: @0xRobin on 2024-02-27
📝 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 related to ERC-20 tokens with USD prices starting from February 15, 2023 in the Scroll blockchain network.
MODEL: openocean_base_base_trades.sql
🟢 Added by:
🔧 PR: #5433, Openocean Base to Dex Trades and create Openocean Macro - Ready for review
🧙 Author: @henrystats on 2024-02-26
📝 Summary: This model creates a table named
openocean_compatible_v2_trades
that enables data analysts to analyze trades from the OpenOcean project version 2 on the base blockchain. It includes information such as swapped events, burn addresses, and native token addresses for further analysis.MODEL: nft_optimism_base_trades.sql
🟠 Modified by:
🔧 PR: #5413, Add Element Optimism NFT Trades - Ready for Review
🧙 Author: @henrystats on 2024-02-26
📝 Summary: A reference to a new model
element_optimism_base_trades
was added to the existing references in the SQL model.MODEL: element_optimism_base_trades.sql
🟢 Added by:
🔧 PR: #5413, Add Element Optimism NFT Trades - Ready for Review
🧙 Author: @henrystats on 2024-02-26
📝 Summary: This model creates a base table for trades on the Optimism blockchain by extracting data from specific sources related to ERC721 and ERC1155 sell and buy orders. It also adds transaction data (tx_from and tx_to) to the base event tables, enabling analysts to analyze trade transactions more comprehensively.
MODEL: dex_optimism_base_trades.sql
🟠 Modified by:
🔧 PR: #5423, Add Fraxswap Optimism to dex trades - Ready for review
🧙 Author: @henrystats on 2024-02-26
📝 Summary: A reference to a new model
fraxswap_optimism_base_trades
was added to the existing list of models being referenced.🔧 PR: #5423, Added elk_finance dex data to dex.trades
🧙 Author: @archie17277 on 2024-02-25
📝 Summary: A reference to 'elk_finance_optimism_base_trades' was added in the dbt SQL model.
MODEL: fraxswap_optimism_base_trades.sql
🟢 Added by:
🔧 PR: #5432, Add Fraxswap Optimism to dex trades - Ready for review
🧙 Author: @henrystats on 2024-02-26
📝 Summary: This model creates a table called
uniswap_compatible_v2_trades
that enables data analysts to analyze trades specific to the Optimism blockchain and the Fraxswap project version 1. It sources data from events related to pair swaps and pair creations in the FraxswapOptimism dataset.MODEL: element_base_base_trades.sql
🟢 Added by:
🔧 PR: #5412, Add Element Base NFT Trades - Ready for Review
🧙 Author: @henrystats on 2024-02-27
📝 Summary: This model creates a base_trades table by extracting data from different sources related to ERC721 and ERC1155 trades on the blockchain. It also adds additional non-fungible token transaction data to the base_trades table, enabling data analysts to analyze and gain insights into NFT trading activities on the specified blockchain.
MODEL: rocketswap_base_base_trades.sql
🟢 Added by:
🔧 PR: #5446, Add rocketswap to dex.trades
🧙 Author: @intensodefi on 2024-02-27
📝 Summary: This model creates a table called
uniswap_compatible_v2_trades
that enables data analysts to analyze Uniswap V2 trades for the Rocketswap project. It sources data from events related to pair creation and swaps in the UniswapV2Pair_evt_Swap and UniswapV2Factory_evt_PairCreated tables, allowing for analysis of trading pairs within the Rocketswap platform.MODEL: nft_celo_base_trades.sql
🟢 Added by:
🔧 PR: #5439, Add Tofu to
nft.trades
on Celo🧙 Author: @tomfutago on 2024-02-27
📝 Summary: This model combines data from the 'tofu_celo_base_trades' table, providing a comprehensive view of NFT trades. It includes details such as blockchain info, trade specifics (category and type), buyer/seller information, pricing details, fees, and transaction identifiers. The model also incorporates duplicate protection based on transaction hash and trade ID to ensure data accuracy for analysts.
MODEL: tofu_celo_base_trades.sql
🟢 Added by:
🔧 PR: #5439, Add Tofu to
nft.trades
on Celo🧙 Author: @tomfutago on 2024-02-27
📝 Summary: This dbt SQL model creates a base table for trades on the Celo blockchain, enabling data analysts to analyze trade data related to NFTs. The model includes information such as market calls and inventory updates, with specific details like project start date and replacements for native ERC20 tokens and symbols.
MODEL: nft_base_trades.sql
🟠 Modified by:
🔧 PR: #5401, Add Tofu to
nft.trades
on Celo🧙 Author: @tomfutago on 2024-02-27
📝 Summary: A reference to a new table
nft_celo_base_trades
was added to the model.🔧 PR: #5401, Add Tevaera to
nft.trades
on zkSync Era🧙 Author: @tomfutago on 2024-02-23
📝 Summary: A reference to a new dbt model called 'nft_zksync_base_trades' was added in this pull request.
MODEL: nft_zksync_wash_trades.sql
🟢 Added by:
🔧 PR: #5441, Add zkync to NFT wash trade model
🧙 Author: @lgingerich on 2024-02-27
📝 Summary: This dbt SQL model creates a table that identifies wash trades for NFT transactions on the Zksync blockchain. It enables data analysts to analyze and detect potential wash trading activities within the NFT market on Zksync.
MODEL: nft_wash_trades.sql
🟠 Modified by:
🔧 PR: #5441, Add zkync to NFT wash trade model
🧙 Author: @lgingerich on 2024-02-27
📝 Summary: A reference to a new model
nft_zksync_wash_trades
was added in the SQL query.MODEL: nft_ethereum_base_trades.sql
🟠 Modified by:
🔧 PR: #5442, Add Magic Eden NFT's new trades on Ethereum & Polygon
🧙 Author: @hildobby on 2024-02-27
📝 Summary: A reference to a new model
magiceden_ethereum_base_trades
was added to the existing references in the SQL model.MODEL: magiceden_ethereum_base_trades.sql
🟢 Added by:
🔧 PR: #5442, Add Magic Eden NFT's new trades on Ethereum & Polygon
🧙 Author: @hildobby on 2024-02-27
📝 Summary: This model creates a dataset of trades involving NFTs, including details like buyer, seller, price, and trade category. It also links these trades to fees paid to platform and royalty addresses. The model enables data analysts to analyze NFT transactions on the Ethereum blockchain within a specific project called 'magiceden,' providing insights into trading activities and associated fees for further analysis.
MODEL: nft_polygon_base_trades.sql
🟠 Modified by:
🔧 PR: #5442, Add Magic Eden NFT's new trades on Ethereum & Polygon
🧙 Author: @hildobby on 2024-02-27
📝 Summary: A reference to a new table
magiceden_v2_polygon_base_trades
was added to the model.MODEL: magiceden_v2_polygon_base_trades.sql
🟢 Added by:
🔧 PR: #5442, Add Magic Eden NFT's new trades on Ethereum & Polygon
🧙 Author: @hildobby on 2024-02-27
📝 Summary: This model creates a dataset of trades involving NFTs, including buy listings and accepted offers. It also calculates platform and royalty fees associated with these trades. The model categorizes the trades by type, blockchain, project version, and trade date. Additionally, it links the trades to specific addresses involved in the transactions for further analysis by data analysts.
MODEL: elk_finance_base_base_trades.sql
🟢 Added by:
🔧 PR: #5430, Added Elk_finance dex to dex.trades
🧙 Author: @archie17277 on 2024-02-26
📝 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 project 'elk_finance'. It sources data from events related to pair swaps and pair creations in the Elk Finance base blockchain.MODEL: elk_finance_optimism_base_trades.sql
🟢 Added by:
🔧 PR: #5423, Added elk_finance dex data to dex.trades
🧙 Author: @archie17277 on 2024-02-25
📝 Summary: This model creates a table called
uniswap_compatible_v2_trades
that enables data analysts to analyze trades compatible with Uniswap V2 on the Optimism blockchain for the Elk Finance project. It sources data from events related to pair swaps and pair creations in the Elk Finance Optimism dataset.MODEL: oasisswap_base_base_trades.sql
🟢 Added by:
🔧 PR: #5422, Added oasisswap dex to dex.trades
🧙 Author: @archie17277 on 2024-02-25
📝 Summary: This dbt SQL model creates a table called
uniswap_compatible_v2_trades
that enables data analysts to analyze and track trades on the OasisSwap platform. It sources data from events related to pair swaps and pair creations in the OasisSwap base, allowing for further analysis of trading activities within this ecosystem.MODEL: leetswap_v2_base_base_trades.sql
🟢 Added by:
🔧 PR: #5421, Added leetswap dex to dex.trades
🧙 Author: @archie17277 on 2024-02-25
📝 Summary: This SQL model creates a table called
uniswap_compatible_v2_trades
that enables data analysts to analyze trades compatible with Uniswap V2 on the blockchain. It pulls data from sources related to the LeetSwap project version 2, allowing for further analysis and insights into trading activities within this ecosystem.MODEL: dex_avalanche_c_base_trades.sql
🟠 Modified by:
🔧 PR: #5396, Updated OdosRouterV2 source table/name (odos_v2)
🧙 Author: @discochuck on 2024-02-23
📝 Summary: In this pull request, a section of the SQL model was removed and then added back. The section defines a common table expression (CTE) named base_union with specific attributes related to blockchain data from Avalanche C chain.
MODEL: pharaoh_avalanche_c_base_trades.sql
🟠 Modified by:
🔧 PR: #5396, Updated OdosRouterV2 source table/name (odos_v2)
🧙 Author: @discochuck on 2024-02-23
📝 Summary: A join with a source table
odos_v2_avalanche_c
was added, replacing the previous source tableglacier_avalanche_c
. The logic involves joining this new source on specific conditions related to transaction hashes and event indexes. Additionally, there is a selection of columns from the joined data.MODEL: tevaera_zksync_base_trades.sql
🟢 Added by:
🔧 PR: #5401, Add Tevaera to
nft.trades
on zkSync Era🧙 Author: @tomfutago on 2024-02-23
📝 Summary: This model creates a base table for trade data related to the Tevaera project on the zksync blockchain. It includes information such as block time, block date, NFT details (contract address and token ID), buyer and seller details, trade category, price paid in WETH currency, transaction hash, and other relevant fields. The model enables data analysts to analyze secondary trades of NFTs within the Tevaera project on zksync blockchain starting from a specified date.
MODEL: throne_exchange_v2_base_base_trades.sql
🟢 Added by:
🔧 PR: #5366, Added Throne_exchange_v2 and Throne_exchange_v3 dexes to dex.trades
🧙 Author: @Jason4276 on 2024-02-23
📝 Summary: This dbt SQL model creates a table called
uniswap_compatible_v2_trades
that enables data analysts to analyze and query Uniswap V2 trades data from the Throne Exchange project in the base blockchain. The model sources information from events related to pair swaps and pair creations within the ThroneV2Pair_evt_Swap and ThroneV2Factory_evt_PairCreated tables, respectively.MODEL: throne_exchange_v3_base_base_trades.sql
🟢 Added by:
🔧 PR: #5366, Added Throne_exchange_v2 and Throne_exchange_v3 dexes to dex.trades
🧙 Author: @Jason4276 on 2024-02-23
📝 Summary: This new dbt SQL model creates a table called
uniswap_compatible_v3_trades
that enables data analysts to analyze and track trades on the Uniswap V3 protocol within the specified blockchain, project, and version. It sources data from events related to swaps and pool creations in the Throne Exchange base.SECTOR: cow_protocol
toggle to see all model updates
MODEL: cow_protocol_ethereum_app_data.sql
🟠 Modified by:
🔧 PR: #5471, Update cow_protocol_ethereum_app_data.sql
🧙 Author: @olgafetisova on 2024-02-29
📝 Summary: Added columns for partner_fee, partner_fee_bps, and partner_recipient were introduced to the SQL model. The logic involves extracting data related to fees from different parts of the content metadata and assigning them specific names for further analysis.
MODEL: cow_protocol_ethereum_solvers.sql
🟠 Modified by:
🔧 PR: #5463, Update cow_protocol_ethereum_solvers.sql
🧙 Author: @fleupold on 2024-02-29
📝 Summary: A row with address, environment, and name values was added for a solver in the 'staging' environment named 'Seasolver2'.
SECTOR: oneinch
toggle to see all model updates
MODEL: oneinch_exchange_contracts.sql
🟠 Modified by:
🔧 PR: #5173, 1inch: AggregationRouterV6 to 1inch spellbooks linage
🧙 Author: @max-morrow on 2024-02-28
📝 Summary: Two rows were added to the
contracts
CTE for 'AggregationRouterV6' with different addresses and networks, along with another row for 'AggregationRouterV6' under a different address and network.MODEL: oneinch_swaps.sql
🟠 Modified by:
🔧 PR: #5173, 1inch: AggregationRouterV6 to 1inch spellbooks linage
🧙 Author: @max-morrow on 2024-02-28
📝 Summary: Added a new column 'flags' and removed columns 'fusion', '_call_trace_address', and logic related to them. Added a new CTE named 'final' with updated logic for flags, contracts_only, and second_side. The final select statement includes all columns from the previous model along with generating a unique key using dbt_utils.generate_surrogate_key function.
SECTOR: models
toggle to see all model updates
MODEL: tokens_ethereum_erc20.sql
🟠 Modified by:
🔧 PR: #5466, Add missing LSTs to tokens.erc20
🧙 Author: @viniabussafi on 2024-02-28
📝 Summary: [changes too large] The model tokens_ethereum_erc20.sql was modified.
SECTOR: paraswap
toggle to see all model updates
MODEL: paraswap_base_trades.sql
🟢 Adde
Beta Was this translation helpful? Give feedback.
All reactions