📰 2024-05-03: Weekly Prophet!

[andrewhong5297]

This is your weekly summary of 24 PRs merged from 15 wizards. Great job everyone! 🎉
We had 49 added models 🟢 and 38 modified models 🟠 for 14 Sectors.

Sector	🔧 # PRs	🟢 # Added	🟠 # Modified	🧙 # Authors
dex	1	0	1	1
nft	1	0	1	1
labels	1	2	2	1
prices	9	0	11	6
_sector	5	9	5	4
balancer	1	12	10	1
cex	1	0	1	1
chainlink	1	8	0	1
lido	1	1	2	1
omen	1	2	0	1
staking	1	0	2	1
oneinch	1	12	0	1
opensea	3	3	2	2
cow_protocol	1	0	1	1

SECTOR: dex

toggle to see all model updates

MODEL: dex_info.sql

🟠 Modified by:

🔧 PR: #5840, Add Linea to dex.trades
🧙 Author: @tomfutago on 2024-04-29
📝 Summary: Four new entries were added to the values being inserted into the temporary table: 'secta', 'echodex', 'lynex', and 'nile'.

SECTOR: nft

toggle to see all model updates

MODEL: nft_marketplaces_info.sql

🟠 Modified by:

🔧 PR: #5866, Add mintsquare metadata
🧙 Author: @hildobby on 2024-05-02
📝 Summary: A new project called 'Mint Square' with corresponding details has been added to the existing list of projects in the SQL model.

SECTOR: labels

toggle to see all model updates

MODEL: labels_balancer_v2_gauges.sql

🟠 Modified by:

🔧 PR: #5811, Add Balancer zkevm spells
🧙 Author: @viniabussafi on 2024-05-03
📝 Summary: A reference to 'labels_balancer_v2_gauges_gnosis' was added, and a reference to 'labels_balancer_v2_gauges_zkevm' was also added.

MODEL: labels_balancer_v2_gauges_zkevm.sql

🟢 Added by:

🔧 PR: #5811, Add Balancer zkevm spells
🧙 Author: @viniabussafi on 2024-05-03
📝 Summary: This model creates a dataset that enables data analysts to track and analyze information related to addresses, names, categories, contributors, sources, timestamps (created_at and updated_at), model names, and label types in the context of Balancer V2 gauges on the zkEVM blockchain. The data is sourced from specific tables ('balancer_ethereum' and 'balancer_zkevm') with additional references for pool labels.

MODEL: labels_balancer_v2_pools.sql

🟠 Modified by:

🔧 PR: #5811, Add Balancer zkevm spells
🧙 Author: @viniabussafi on 2024-05-03
📝 Summary: A new SELECT statement was added to include data from a different table, and a UNION clause was added to combine the results of this new query with the existing ones.

MODEL: labels_balancer_v2_pools_zkevm.sql

🟢 Added by:

🔧 PR: #5811, Add Balancer zkevm spells
🧙 Author: @viniabussafi on 2024-05-03
📝 Summary: This model creates a dataset that provides information on different types of pools in the Balancer protocol. It includes details such as pool ID, token addresses, normalized weights, symbols, and pool types like weighted, LBP (Liquidity Bootstrapping Pool), stable pools, and various linear pools. Additionally, it fetches settings for each pool including token symbols and their corresponding weights to enable data analysts to analyze and understand the composition of these pools effectively.

SECTOR: prices

toggle to see all model updates

MODEL: prices_avalanche_c_tokens.sql

🟠 Modified by:

🔧 PR: #5869, Added YAK token to prices on avalanche_c
🧙 Author: @yy-analytics on 2024-05-02
📝 Summary: YAK, KIMBO, GEC, HEC

MODEL: prices_ethereum_tokens.sql

🟠 Modified by:

🔧 PR: #5842, add new tokens to price list - Ethereum
🧙 Author: @RantumBits on 2024-05-01
📝 Summary: The token symbols that were added are: STONE, REZ, PEPE, BOOE, ZERO and WOLF.

🔧 PR: #5842, Adding STONE
🧙 Author: @thecaptncrunch on 2024-04-26
📝 Summary: STONE

MODEL: prices_tokens.sql

🟠 Modified by:

🔧 PR: #5856, prices on linea
🧙 Author: @ppclunghe on 2024-05-01
📝 Summary: The reference model prices_linea_tokens was added.

🔧 PR: #5856, Polygon ZkEVM prices
🧙 Author: @viniabussafi on 2024-05-01
📝 Summary: prices_zkevm_tokens

MODEL: prices_arbitrum_tokens.sql

🟠 Modified by:

🔧 PR: #5850, Add jitoSOL on ARB to tokens.erc20 and prices.usd
🧙 Author: @viniabussafi on 2024-04-30
📝 Summary: The tokens that were added or removed are: SOL, JITOSOL

🔧 PR: #5850, Add missing tokens to prices.usd
🧙 Author: @viniabussafi on 2024-04-29
📝 Summary: The token symbols that were added are: AURA, AURABAL The token symbol that was removed is: GSWIFT

MODEL: prices_base_tokens.sql

🟠 Modified by:

🔧 PR: #5852, [base] add tokens to price list
🧙 Author: @RantumBits on 2024-04-30
📝 Summary: BONK, BENTO, PEPE, BENI, BUNNY, BRITT, NORMIE1,
BSHIB2,MFERCOIN ,BSB,BASE ,CCC,FUNGI

MODEL: prices_native_tokens.sql

🟠 Modified by:

🔧 PR: #5851, Update prices_native_tokens.sql
🧙 Author: @lydiapuspita on 2024-04-29
📝 Summary: The token symbols that were added are: AR, GLMR, KLAY

MODEL: prices_gnosis_tokens.sql

🟠 Modified by:

🔧 PR: #5850, Add missing tokens to prices.usd
🧙 Author: @viniabussafi on 2024-04-29
📝 Summary: The token symbols that were added or removed are: stETH, CRVUSD

MODEL: prices_optimism_tokens_curated.sql

🟠 Modified by:

🔧 PR: #5850, Add missing tokens to prices.usd
🧙 Author: @viniabussafi on 2024-04-29
📝 Summary: One token ('BEETS') with its details was added to the model, while another token ('AXLUSDC') was removed.

SECTOR: _sector

toggle to see all model updates

MODEL: dex_zkevm_base_trades.sql

🟠 Modified by:

🔧 PR: #5811, Add Balancer zkevm spells
🧙 Author: @viniabussafi on 2024-05-03
📝 Summary: In this change, a base model reference was updated from 'pancakeswap_v2_zkevm_base_trades' to 'balancer_v2_zkevm_base_trades', and the order of models in the list was adjusted. Additionally, there is a modification in the SQL query where 'FROM' clause formatting was changed.

MODEL: balancer_v2_zkevm_base_trades.sql

🟢 Added by:

🔧 PR: #5811, Add Balancer zkevm spells
🧙 Author: @viniabussafi on 2024-05-03
📝 Summary: This model creates a table that focuses on trades compatible with Balancer version 2 on the ZK-EVM blockchain. It enables data analysts to analyze and track trading activities specifically related to Balancer protocol version 2 within the specified blockchain environment.

MODEL: dex_zora_base_trades.sql

🟠 Modified by:

🔧 PR: #5847, add uniswap v3 zora
🧙 Author: @andrewhong5297 on 2024-05-01
📝 Summary: Two base models, 'uniswap_v2_zora_base_trades' and 'uniswap_v3_zora_base_trades', were added to the list of base models.

MODEL: uniswap_v3_zora_base_trades.sql

🟢 Added by:

🔧 PR: #5847, add uniswap v3 zora
🧙 Author: @andrewhong5297 on 2024-05-01
📝 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 version 3 on the Zora blockchain project. It sources swap events from 'UniswapV3Pool_evt_Swap' and pool creation events from 'UniswapV3Factory_evt_PoolCreated'.

MODEL: nft_old_base_trades.sql

🟠 Modified by:

🔧 PR: #5745, Add Opensea Avalanche Trades - Ready for review
🧙 Author: @henrystats on 2024-04-30
📝 Summary: Two new references were added to the SQL model: 'opensea_v3_avalanche_c_events' and 'opensea_v4_avalanche_c_events'.

MODEL: nft_avalanche_c_base_trades.sql

🟠 Modified by:

🔧 PR: #5654, Add Joepegs avalanche NFT trades - Ready for review
🧙 Author: @henrystats on 2024-04-30
📝 Summary: A new dbt SQL model reference joepegs_avalanche_c_base_trades was added, and the order of references in the list was changed.

MODEL: joepegs_avalanche_c_base_trades.sql

🟢 Added by:

🔧 PR: #5654, Add Joepegs avalanche NFT trades - Ready for review
🧙 Author: @henrystats on 2024-04-30
📝 Summary: This model creates a dataset that combines information on NFT trades, including buy and sell events with details such as trade category, seller, buyer, price, currency contract. It also includes royalty payment data associated with the trades. The model enables data analysts to analyze and track NFT transactions on the Avalanche blockchain for the Joepegs project version 1.

MODEL: dex_base_trades.sql

🟠 Modified by:

🔧 PR: #5840, Add Linea to dex.trades
🧙 Author: @tomfutago on 2024-04-29
📝 Summary: A reference to a new model called 'dex_linea_base_trades' was added in the SQL code.

MODEL: dex_linea_base_trades.sql

🟢 Added by:

🔧 PR: #5840, Add Linea to dex.trades
🧙 Author: @tomfutago on 2024-04-29
📝 Summary: This model combines trade data from multiple sources into a single dataset for analysis. It creates a unified view of trades across different blockchains and projects, including details such as token amounts, addresses, transaction hashes, and event indices. Additionally, it adds specific columns related to transactions like 'from', 'to', and 'index' to enhance the dataset for data analysts.

MODEL: echodex_linea_base_trades.sql

🟢 Added by:

🔧 PR: #5840, Add Linea to dex.trades
🧙 Author: @tomfutago on 2024-04-29
📝 Summary: This model creates a table called uniswap_compatible_v2_trades that enables data analysts to analyze and track trades on the Uniswap decentralized exchange for the specified blockchain, project, and version. It sources data from EchodexPair_evt_Swap and EchodexFactory_evt_PairCreated tables in the database.

MODEL: lynex_linea_base_trades.sql

🟢 Added by:

🔧 PR: #5840, Add Linea to dex.trades
🧙 Author: @tomfutago on 2024-04-29
📝 Summary: This model creates a table called uniswap_compatible_v2_trades that enables data analysts to analyze and track trades compatible with Uniswap V2 on the blockchain 'linea' for the project 'lynex'. It sources data from two specific events, namely Pair_evt_Swap and Factory_evt_PairCreated, to provide insights into trading activities within this ecosystem.

MODEL: nile_linea_base_trades.sql

🟢 Added by:

🔧 PR: #5840, Add Linea to dex.trades
🧙 Author: @tomfutago on 2024-04-29
📝 Summary: This new dbt SQL model creates a table called uniswap_compatible_v3_trades that enables data analysts to analyze and work with Uniswap V3 trades data from the 'linea' blockchain in the 'nile' project. It specifically sources information related to swap events and pool creation events, allowing for deeper insights into trading activities on Uniswap V3.

MODEL: secta_linea_base_trades.sql

🟢 Added by:

🔧 PR: #5840, Add Linea to dex.trades
🧙 Author: @tomfutago on 2024-04-29
📝 Summary: This dbt SQL model creates a table called uniswap_compatible_v2_trades that enables data analysts to analyze and track trades on the Uniswap V2 platform for the specified blockchain and project. It sources data from events related to pair swaps (Pair_evt_Swap) and pair creations (Factory_evt_PairCreated) in order to provide insights into trading activities within the specified context.

MODEL: sushiswap_v2_linea_base_trades.sql

🟢 Added by:

🔧 PR: #5840, Add Linea to dex.trades
🧙 Author: @tomfutago on 2024-04-29
📝 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 Linea blockchain. It sources data from specific events related to swaps and pool creation in UniswapV3Pool and UniswapV3Factory tables.

SECTOR: balancer

toggle to see all model updates

MODEL: balancer_bpt_prices.sql

🟠 Modified by:

🔧 PR: #5811, Add Balancer zkevm spells
🧙 Author: @viniabussafi on 2024-05-03
📝 Summary: A reference to a new model balancer_v2_zkevm_bpt_prices was added, while a reference to the model balancer_v2_base_bpt_prices was removed.

MODEL: balancer_bpt_supply.sql

🟠 Modified by:

🔧 PR: #5811, Add Balancer zkevm spells
🧙 Author: @viniabussafi on 2024-05-03
📝 Summary: Two references were added ('balancer_v2_base_bpt_supply' and 'balancer_v2_zkevm_bpt_supply') to the SQL model.

MODEL: balancer_flashloans.sql

🟠 Modified by:

🔧 PR: #5811, Add Balancer zkevm spells
🧙 Author: @viniabussafi on 2024-05-03
📝 Summary: A reference to a new dbt SQL model called 'balancer_v2_zkevm_flashloans' was added in the merged pull request.

MODEL: balancer_liquidity.sql

🟠 Modified by:

🔧 PR: #5811, Add Balancer zkevm spells
🧙 Author: @viniabussafi on 2024-05-03
📝 Summary: A reference to a new model called 'balancer_v2_zkevm_liquidity' was added to the existing list of references in this dbt SQL model.

MODEL: balancer_pools_fees.sql

🟠 Modified by:

🔧 PR: #5811, Add Balancer zkevm spells
🧙 Author: @viniabussafi on 2024-05-03
📝 Summary: A reference to a new model balancer_v2_zkevm_pools_fees was added, while the reference to balancer_v2_polygon_pools_fees was removed.

MODEL: balancer_pools_tokens_weights.sql

🟠 Modified by:

🔧 PR: #5811, Add Balancer zkevm spells
🧙 Author: @viniabussafi on 2024-05-03
📝 Summary: A reference to a new dbt SQL model balancer_v2_zkevm_pools_tokens_weights was added, while the reference to balancer_v2_polygon_pools_tokens_weights was removed.

MODEL: balancer_protocol_fee.sql

🟠 Modified by:

🔧 PR: #5811, Add Balancer zkevm spells
🧙 Author: @viniabussafi on 2024-05-03
📝 Summary: A new reference to 'balancer_v2_zkevm_protocol_fee' was added in the SQL model.

MODEL: balancer_token_whitelist.sql

🟠 Modified by:

🔧 PR: #5811, Add Balancer zkevm spells
🧙 Author: @viniabussafi on 2024-05-03
📝 Summary: A whitelist of tokens with their addresses, names, and chains was updated in the SQL model. Tokens for 'WSTETH' on 'arbitrum', 'USDC' on 'zkevm', 'DAI' on both polygon and zkevm, as well as additional tokens were added. The query to select all data from the whitelist_token table remained unchanged.

MODEL: balancer_trades.sql

🟠 Modified by:

🔧 PR: #5811, Add Balancer zkevm spells
🧙 Author: @viniabussafi on 2024-05-03
📝 Summary: A reference to a model named 'balancer_polygon_trades' was removed, and references to models named 'balancer_polygon_trades' and 'balancer_zkevm_trades' were added.

MODEL: balancer_transfers_bpt.sql

🟠 Modified by:

🔧 PR: #5811, Add Balancer zkevm spells
🧙 Author: @viniabussafi on 2024-05-03
📝 Summary: A reference to a model named 'balancer_v2_zkevm_transfers_bpt' was added in addition to the existing references.

MODEL: balancer_v2_zkevm_bpt_prices.sql

🟢 Added by:

🔧 PR: #5811, Add Balancer zkevm spells
🧙 Author: @viniabussafi on 2024-05-03
📝 Summary: This SQL model creates a macro called 'balancer_bpt_prices_macro' that enables data analysts to retrieve and analyze Balancer pool token prices for a specific blockchain (in this case, 'zkevm') and version ('2').

MODEL: balancer_v2_zkevm_bpt_supply.sql

🟢 Added by:

🔧 PR: #5811, Add Balancer zkevm spells
🧙 Author: @viniabussafi on 2024-05-03
📝 Summary: This dbt SQL model creates a macro called balancer_bpt_supply_macro that enables data analysts to calculate the total supply of Balancer Pool Tokens (BPT) for a specific blockchain and version.

MODEL: balancer_v2_zkevm_flashloans.sql

🟢 Added by:

🔧 PR: #5811, Add Balancer zkevm spells
🧙 Author: @viniabussafi on 2024-05-03
📝 Summary: This model creates a view that combines data from the Balancer V2 ZK-EVM Vault_evt_FlashLoan table and the Tokens ERC20 table. It calculates various metrics related to flash loans on the ZK-EVM blockchain, such as loan amounts in both raw and USD values, fees, currency details, and block information. The model also joins price data from the Prices USD table to convert loan amounts into USD. This enables analysts to analyze flash loan activity on Balancer V2 in terms of value transacted and fees incurred in a specific time frame on the ZK-EVM blockchain.

MODEL: balancer_v2_zkevm_liquidity.sql

🟢 Added by:

🔧 PR: #5811, Add Balancer zkevm spells
🧙 Author: @viniabussafi on 2024-05-03
📝 Summary: This SQL model creates a macro called 'balancer_liquidity_macro' that enables data analysts to retrieve liquidity information from the Balancer protocol for a specific blockchain (in this case, 'zkevm') and version ('2').

MODEL: balancer_v2_zkevm_pools_fees.sql

🟢 Added by:

🔧 PR: #5811, Add Balancer zkevm spells
🧙 Author: @viniabussafi on 2024-05-03
📝 Summary: This model creates a SQL query that selects data from a source related to Balancer V2 on the ZK-EVM blockchain. It filters for specific event signatures and registered pool addresses, extracting information such as contract address, transaction hash, block time, and swap fee percentage. The model allows data analysts to analyze swap fees within registered pools starting from a specified project start date or within the last 7 days incrementally.

MODEL: balancer_v2_zkevm_pools_tokens_weights.sql

🟢 Added by:

🔧 PR: #5811, Add Balancer zkevm spells
🧙 Author: @viniabussafi on 2024-05-03
📝 Summary: This model creates a dataset that combines information about Balancer v2 pools, tokens, and their weights. It enables data analysts to analyze the registered pools along with their corresponding token addresses and normalized weights. The model also includes filters for incremental updates within a specified timeframe.

MODEL: balancer_v2_zkevm_protocol_fee.sql

🟢 Added by:

🔧 PR: #5811, Add Balancer zkevm spells
🧙 Author: @viniabussafi on 2024-05-03
📝 Summary: This model creates a macro called 'balancer_protocol_fee_macro' that takes parameters for blockchain and version. It enables data analysts to calculate protocol fees specific to the Balancer protocol on the specified blockchain with version 2.

MODEL: balancer_v2_zkevm_trades.sql

🟢 Added by:

🔧 PR: #5811, Add Balancer zkevm spells
🧙 Author: @viniabussafi on 2024-05-03
📝 Summary: This model combines data from different sources to provide detailed information on decentralized exchange trades, including token amounts, prices in USD, pool IDs, and swap fees. It enables analysts to track trade details such as tokens bought/sold, addresses involved in the transactions, and specific project contracts. Additionally, it allows for the calculation of trade values in USD based on token amounts and corresponding prices at specific block dates.

MODEL: balancer_v2_zkevm_transfers_bpt.sql

🟢 Added by:

🔧 PR: #5811, Add Balancer zkevm spells
🧙 Author: @viniabussafi on 2024-05-03
📝 Summary: This dbt SQL model creates a macro called balancer_transfers_bpt_macro that enables data analysts to analyze and track transfers of Balancer Pool Tokens (BPT) on the specified blockchain using version 2 of the macro.

MODEL: balancer_zkevm_pools_tokens_weights.sql

🟢 Added by:

🔧 PR: #5811, Add Balancer zkevm spells
🧙 Author: @viniabussafi on 2024-05-03
📝 Summary: This SQL model selects specific columns from a table called 'balancer_v2_zkevm_pools_tokens_weights'. It retrieves data related to blockchain, version, pool ID, token address, and normalized weight. This model enables data analysts to access and analyze information about the weights of tokens in pools within the Balancer protocol on ZK-EVM blockchains.

MODEL: balancer_zkevm_schema.yml

🟢 Added by:

🔧 PR: #5811, Add Balancer zkevm spells
🧙 Author: @viniabussafi on 2024-05-03
📝 Summary: [changes too large] The model balancer_zkevm_schema.yml was added.

MODEL: balancer_zkevm_trades.sql

🟢 Added by:

🔧 PR: #5811, Add Balancer zkevm spells
🧙 Author: @viniabussafi on 2024-05-03
📝 Summary: This model combines data from the 'balancer_v2_zkevm_trades' table, allowing analysts to access information on blockchain trades including token symbols, amounts, addresses involved, transaction details like hash and participants (taker/maker), pool ID, swap fee, and more. The UNION ALL operation merges data from multiple sources for comprehensive analysis of Balancer decentralized exchange transactions.

SECTOR: cex

toggle to see all model updates

MODEL: cex_addresses.sql

🟠 Modified by:

🔧 PR: #5861, Add chains to cex.addresses
🧙 Author: @hildobby on 2024-05-02
📝 Summary: The diff shows that a set of references to different tables was added. The SELECT statement was changed to select all columns from each table in the list using UNION ALL, with some casting and aliasing adjustments.

SECTOR: chainlink

toggle to see all model updates

MODEL: chainlink_arbitrum_ccip_tokens_transferred.sql

🟢 Added by:

🔧 PR: #5845, add tokens transferred spell
🧙 Author: @AnonJon on 2024-05-02
📝 Summary: This SQL model creates a CTE (Common Table Expression) called 'transferred' that retrieves data on tokens transferred in the Arbitrum blockchain using Chainlink CCIP. The model then selects all columns from the 'transferred' CTE, enabling data analysts to access and analyze information about token transfers on the Arbitrum blockchain through Chainlink CCIP.

MODEL: chainlink_avalanche_c_ccip_tokens_transferred.sql

🟢 Added by:

🔧 PR: #5845, add tokens transferred spell
🧙 Author: @AnonJon on 2024-05-02
📝 Summary: This SQL model creates a Common Currencies In Payments (CCIP) dataset by querying token transfers on the Avalanche blockchain. It enables data analysts to access and analyze information about transferred tokens within the specified blockchain network for further insights and reporting.

MODEL: chainlink_base_ccip_tokens_transferred.sql

🟢 Added by:

🔧 PR: #5845, add tokens transferred spell
🧙 Author: @AnonJon on 2024-05-02
📝 Summary: This SQL model creates a CTE (Common Table Expression) called 'transferred' that retrieves data on tokens transferred in the base blockchain using the Chainlink CCIP integration. The model then selects and outputs all columns from this CTE, enabling data analysts to analyze and work with information related to token transfers in the specified blockchain.

MODEL: chainlink_bnb_ccip_tokens_transferred.sql

🟢 Added by:

🔧 PR: #5845, add tokens transferred spell
🧙 Author: @AnonJon on 2024-05-02
📝 Summary: This SQL model creates a CTE (Common Table Expression) called 'transferred' that retrieves data on tokens transferred in the Binance blockchain using Chainlink's CCIP. The model then selects all columns from this CTE, enabling data analysts to analyze and work with information related to token transfers on the Binance blockchain.

MODEL: chainlink_ccip_tokens_transferred.sql

🟢 Added by:

🔧 PR: #5845, add tokens transferred spell
🧙 Author: @AnonJon on 2024-05-02
📝 Summary: This model creates a unified view of token transfers across different blockchains by combining data from multiple Chainlink models. It enables data analysts to analyze and compare token transfer information such as blockchain, transaction hash, total tokens transferred, destination blockchain, token details (symbol and price) in a single query result set.

MODEL: chainlink_ethereum_ccip_tokens_transferred.sql

🟢 Added by:

🔧 PR: #5845, add tokens transferred spell
🧙 Author: @AnonJon on 2024-05-02
📝 Summary: This SQL model creates a Common Currencies in Projects (CCIP) table that tracks token transfers on the Ethereum blockchain. It enables data analysts to access and analyze data related to transferred tokens within projects using Chainlink, providing insights into transaction volumes and patterns for further analysis.

MODEL: chainlink_optimism_ccip_tokens_transferred.sql

🟢 Added by:

🔧 PR: #5845, add tokens transferred spell
🧙 Author: @AnonJon on 2024-05-02
📝 Summary: This SQL model creates a CTE (Common Table Expression) called 'transferred' that retrieves data on tokens transferred on the Optimism blockchain using Chainlink's CCIP. The model then selects all columns from the 'transferred' CTE, enabling data analysts to analyze and work with information related to token transfers on the Optimism blockchain.

MODEL: chainlink_polygon_ccip_tokens_transferred.sql

🟢 Added by:

🔧 PR: #5845, add tokens transferred spell
🧙 Author: @AnonJon on 2024-05-02
📝 Summary: This SQL model creates a Common Currencies in Projects (CCIP) tokens transferred table for the Polygon blockchain. It enables data analysts to access and analyze data on token transfers within the CCIP ecosystem on the Polygon network.

SECTOR: lido

toggle to see all model updates

MODEL: lido_liquidity.sql

🟠 Modified by:

🔧 PR: #5833, lido-linea-syncswap
🧙 Author: @ppclunghe on 2024-05-02
📝 Summary: A reference to a new pool called 'lido_liquidity_linea_syncswap_pools' was added. Additionally, a project start date variable was set to '2020-12-15'.

MODEL: lido_liquidity_linea_syncswap_pools.sql

🟢 Added by:

🔧 PR: #5833, lido-linea-syncswap
🧙 Author: @ppclunghe on 2024-05-02
📝 Summary: This SQL model creates a comprehensive dataset for data analysts that includes information on pools, tokens, prices, events (minting, burning, swapping), liquidity balances with historical changes and projections. It also calculates trading volumes and various metrics related to token pairs in the context of blockchain projects like SyncSwap on the Linea network. The model enables analysis of pool performance over time including fee structures and token reserves in USD value.

MODEL: lido_liquidity_zksync_syncswap_pools.sql

🟠 Modified by:

🔧 PR: #5833, lido-linea-syncswap
🧙 Author: @ppclunghe on 2024-05-02
📝 Summary: Added logic to change the project name from 'synkswap' to 'syncswap'. Updated table sources and joins from SyncSwapAquaPoolFactory_v2_evt_PoolCreated to SyncSwapClassicPoolFactory_evt_PoolCreated for various events (Mint, Burn, Swap). Adjusted conditions based on token addresses. Grouped results by specific columns and calculated wsteth_amount based on different token amounts. Added a condition related to the project start date if not incremental.

SECTOR: omen

toggle to see all model updates

MODEL: omen_gnosis_liquidity.sql

🟢 Added by:

🔧 PR: #5685, Omen models. First attempt.
🧙 Author: @hdser on 2024-05-02
📝 Summary: This model creates a dataset that tracks funding added and removed from a fixed product market maker (FPMM). It enables data analysts to analyze liquidity additions and removals, including details such as shares minted/burnt, collateral added/removed from the fee pool, outcome tokens amounts, and actions taken (add or remove). The dataset includes information on block time, involved parties (tx_from/to), transaction hash, FPMM contract address, funder details.

MODEL: omen_gnosis_trades.sql

🟢 Added by:

🔧 PR: #5685, Omen models. First attempt.
🧙 Author: @hdser on 2024-05-02
📝 Summary: This model processes trade data from a source to calculate reserves delta for buy and sell actions. It identifies trades, assigns outcome slots, calculates outcome tokens amount, and determines the change in reserves based on the action type (buy or sell). The final output includes various trade details along with the calculated reserves delta.

SECTOR: staking

toggle to see all model updates

MODEL: staking_ethereum_entities_bitcoin_suisse.sql

🟠 Modified by:

🔧 PR: #5865, Add ETH stakers
🧙 Author: @hildobby on 2024-05-02
📝 Summary: A new row with a depositor address and first transaction date was added to the hardcoded CTE.

MODEL: staking_ethereum_entities_depositor_addresses.sql

🟠 Modified by:

🔧 PR: #5865, Add ETH stakers
🧙 Author: @hildobby on 2024-05-02
📝 Summary: In the first section, several new entries were added for 'Renzo' with different identifiers and descriptions under 'Liquid Restaking'. In the second section, a new entry was added for 'P2P.org' with a different identifier and description under 'Staking Pool'.

SECTOR: oneinch

toggle to see all model updates

MODEL: oneinch_mapped_contracts.sql

🟢 Added by:

🔧 PR: #5818, 1inch: project swaps & some linage updates & cleaning
🧙 Author: @max-morrow on 2024-05-01
📝 Summary: [changes too large] The model oneinch_mapped_contracts.sql was added.

MODEL: oneinch_mapped_methods.sql

🟢 Added by:

🔧 PR: #5818, 1inch: project swaps & some linage updates & cleaning
🧙 Author: @max-morrow on 2024-05-01
📝 Summary: This model creates a dataset that enables data analysts to analyze blockchain contracts by providing information on project methods, signatures, namespaces, names, tags, inputs and outputs. It categorizes the contracts based on flags like 'swap', 'limits', 'intents', 'multi' and whether they belong to certain main projects. The output is sorted by project name, blockchain type, creation date of contract etc., allowing for detailed analysis of various aspects related to blockchain contracts.

MODEL: oneinch_arbitrum_project_swaps.sql

🟢 Added by:

🔧 PR: #5818, 1inch: project swaps & some linage updates & cleaning
🧙 Author: @max-morrow on 2024-05-01
📝 Summary: This dbt SQL model creates a macro called oneinch_project_swaps_macro that enables data analysts to analyze and query swap data related to the OneInch project on the Arbitrum blockchain.

MODEL: oneinch_avalanche_c_project_swaps.sql

🟢 Added by:

🔧 PR: #5818, 1inch: project swaps & some linage updates & cleaning
🧙 Author: @max-morrow on 2024-05-01
📝 Summary: This SQL model creates a macro called 'oneinch_project_swaps_macro' that takes in a parameter for the blockchain. It enables data analysts to analyze and query data related to swaps on the OneInch project specifically for the Avalanche C blockchain.

MODEL: oneinch_base_project_swaps.sql

🟢 Added by:

🔧 PR: #5818, 1inch: project swaps & some linage updates & cleaning
🧙 Author: @max-morrow on 2024-05-01
📝 Summary: This SQL model creates a macro called oneinch_project_swaps_macro that enables data analysts to analyze and track swaps related to the OneInch project on the specified blockchain.

MODEL: oneinch_bnb_project_swaps.sql

🟢 Added by:

🔧 PR: #5818, 1inch: project swaps & some linage updates & cleaning
🧙 Author: @max-morrow on 2024-05-01
📝 Summary: This SQL model creates a macro called oneinch_project_swaps_macro that takes a parameter blockchain. This macro likely enables data analysts to analyze and track swaps related to the OneInch project on the specified blockchain (in this case, 'bnb').

MODEL: oneinch_ethereum_project_swaps.sql

🟢 Added by:

🔧 PR: #5818, 1inch: project swaps & some linage updates & cleaning
🧙 Author: @max-morrow on 2024-05-01
📝 Summary: This SQL model creates a macro called 'oneinch_project_swaps_macro' that takes in a parameter for the blockchain (in this case, set to 'ethereum'). This macro likely generates data related to swaps made on the OneInch platform within the specified blockchain, enabling data analysts to analyze and gain insights into swap activities specifically for Ethereum on OneInch.

MODEL: oneinch_fantom_project_swaps.sql

🟢 Added by:

🔧 PR: #5818, 1inch: project swaps & some linage updates & cleaning
🧙 Author: @max-morrow on 2024-05-01
📝 Summary: This dbt SQL model creates a macro called oneinch_project_swaps_macro that enables data analysts to analyze and track swaps related to the OneInch project on the Fantom blockchain.

MODEL: oneinch_gnosis_project_swaps.sql

🟢 Added by:

🔧 PR: #5818, 1inch: project swaps & some linage updates & cleaning
🧙 Author: @max-morrow on 2024-05-01
📝 Summary: This dbt SQL model creates a macro called 'oneinch_project_swaps_macro' that enables data analysts to analyze and query swap data related to the specified blockchain (in this case, 'gnosis').

MODEL: oneinch_optimism_project_swaps.sql

🟢 Added by:

🔧 PR: #5818, 1inch: project swaps & some linage updates & cleaning
🧙 Author: @max-morrow on 2024-05-01
📝 Summary: This dbt SQL model creates a macro called oneinch_project_swaps_macro that enables data analysts to analyze and report on swap transactions related to the OneInch project on the specified blockchain (in this case, 'optimism').

MODEL: oneinch_polygon_project_swaps.sql

🟢 Added by:

🔧 PR: #5818, 1inch: project swaps & some linage updates & cleaning
🧙 Author: @max-morrow on 2024-05-01
📝 Summary: This SQL model creates a macro called oneinch_project_swaps_macro that takes in a parameter for the blockchain (in this case, set to 'polygon'). This macro likely generates data related to swaps on the OneInch platform specifically for the Polygon blockchain. It enables data analysts to easily query and analyze swap information within the specified parameters.

MODEL: oneinch_zksync_project_swaps.sql

🟢 Added by:

🔧 PR: #5818, 1inch: project swaps & some linage updates & cleaning
🧙 Author: @max-morrow on 2024-05-01
📝 Summary: This dbt SQL model creates a macro called 'oneinch_project_swaps_macro' that enables data analysts to analyze and track swaps related to the specified blockchain (in this case, 'zksync').

SECTOR: opensea

toggle to see all model updates

MODEL: opensea_avalanche_c_events.sql

🟢 Added by:

🔧 PR: #5745, Add Opensea Avalanche Trades - Ready for review
🧙 Author: @henrystats on 2024-04-30
📝 Summary: This model combines data from two tables to create a unified dataset with additional columns. It enables data analysts to analyze blockchain transactions related to token trades, including details such as trade type, seller and buyer information, fees involved, contract addresses, and more. The merged table provides a comprehensive view of events happening on the blockchain for further analysis and insights.

MODEL: opensea_v3_avalanche_c_events.sql

🟢 Added by:

🔧 PR: #5745, Add Opensea Avalanche Trades - Ready for review
🧙 Author: @henrystats on 2024-04-30
📝 Summary: This model creates a view that pulls data from different sources related to trades on the Avalanche blockchain. It includes information about fulfilled orders, matched advanced orders, and matched orders. The model also filters the data based on specific criteria such as fee wallet name and hash values. This enables data analysts to analyze trade activities involving a particular fee wallet ('opensea') or with specific hash values within the specified timeframe starting from September 6th, 2022.

MODEL: opensea_v4_avalanche_c_events.sql

🟢 Added by:

🔧 PR: #5745, Add Opensea Avalanche Trades - Ready for review
🧙 Author: @henrystats on 2024-04-30
📝 Summary: This model creates a CTE called 'fee_wallets' with wallet addresses and names. It then uses the Seaport plugin to extract trade data from Avalanche blockchain, filtering by specific criteria like token addresses and start date. The final query selects all columns from the 'trades' CTE where the fee wallet name is 'opensea' or a certain hash value matches. This model enables analysts to analyze trade data on Avalanche blockchain involving specified wallets and tokens starting from a particular date.

MODEL: opensea_v4_base_events.sql

🟠 Modified by:

🔧 PR: #5843, Exclude opensea_v4_base_events.sql
🧙 Author: @couralex6 on 2024-04-28
📝 Summary: Added a tag 'prod_exclude' to the dbt SQL model.

🔧 PR: #5843, Hot fix opensea_v4_base_events.sql
🧙 Author: @couralex6 on 2024-04-26
📝 Summary: A condition was added to the SQL query to filter out rows where 'tx_hash' is not equal to a specific value.

SECTOR: cow_protocol

toggle to see all model updates

MODEL: cow_protocol_gnosis_solvers.sql

🟠 Modified by:

🔧 PR: #5838, [CoW Protocol] Add new Gnosis Chain solvers
🧙 Author: @harisang on 2024-04-29
📝 Summary: Rows were added to the known_solver_metadata model for different addresses, environments, and solver names.