📰 2024-05-10: Weekly Prophet!

[andrewhong5297]

This is your weekly summary of 18 PRs merged from 11 wizards. Great job everyone! 🎉
We had 15 added models 🟢 and 55 modified models 🟠 for 9 Sectors.

Sector	🔧 # PRs	🟢 # Added	🟠 # Modified	🧙 # Authors
prices	4	0	10	3
_sector	5	4	17	3
oneinch	2	0	2	2
limitbreak	1	8	0	1
balancer	2	0	19	1
rollup_economics	2	0	3	2
opensea	2	0	4	1
orca_whirlpool	2	2	0	1
camelot	1	1	0	1

SECTOR: prices

toggle to see all model updates

MODEL: prices_arbitrum_tokens.sql

🟠 Modified by:

🔧 PR: #5883, Add missing tokens to prices.usd
🧙 Author: @viniabussafi on 2024-05-07
📝 Summary: The tokens that were added or removed are: ANKR, FOREX, SUSDE

🔧 PR: #5883, Add SPARTA on Arbitrum, DEAL on Ethereum and POPCAT on Solana
🧙 Author: @lydiapuspita on 2024-05-06
📝 Summary: SPARTA

🔧 PR: #5883, Added new tokens to Arbitrum prices model
🧙 Author: @yy-analytics on 2024-05-06
📝 Summary: PRY, NEXT, LILAI, HEGIC, MOLTEN, MOZ, SIZE,
WNT,SFUND,P0I$ON,CAP,BFR,AI,PET,TROVE,
USDV.OMNI.ROSNET,WOO.ARCHI,HOP.EMC.
EMP.USDS,XEND,RWA.Silo.XAI,VKA.UND.LEVI.LVL.PLX.OSAK.SIS.EQU.LNDX.WOM

MODEL: prices_ethereum_tokens.sql

🟠 Modified by:

🔧 PR: #5876, Add missing tokens to prices.usd
🧙 Author: @viniabussafi on 2024-05-07
📝 Summary: The token symbols that were added or removed are: SUSDE, PRISMA

🔧 PR: #5876, Add SPARTA on Arbitrum, DEAL on Ethereum and POPCAT on Solana
🧙 Author: @lydiapuspita on 2024-05-06
📝 Summary: The token symbols that were added or removed are: DEAL

🔧 PR: #5876, Add sUSDe (eth) and WEETH(base) to prices.usd
🧙 Author: @viniabussafi on 2024-05-03
📝 Summary: The tokens that were added or removed are: WOLF, SUSDE

MODEL: prices_gnosis_tokens.sql

🟠 Modified by:

🔧 PR: #5887, Add missing tokens to prices.usd
🧙 Author: @viniabussafi on 2024-05-07
📝 Summary: The tokens that were added or removed are: CRVUSD, SAFE

MODEL: prices_zkevm_tokens.sql

🟠 Modified by:

🔧 PR: #5887, Add missing tokens to prices.usd
🧙 Author: @viniabussafi on 2024-05-07
📝 Summary: The token symbols that were added or removed are: GYD

MODEL: prices_solana_tokens.sql

🟠 Modified by:

🔧 PR: #5868, Add SPARTA on Arbitrum, DEAL on Ethereum and POPCAT on Solana
🧙 Author: @lydiapuspita on 2024-05-06
📝 Summary: The token symbols that were added or removed are: POPCAT

MODEL: prices_base_tokens.sql

🟠 Modified by:

🔧 PR: #5876, Add sUSDe (eth) and WEETH(base) to prices.usd
🧙 Author: @viniabussafi on 2024-05-03
📝 Summary: WEETH

SECTOR: _sector

toggle to see all model updates

MODEL: labels_counterparty_activity_daily.sql

🟢 Added by:

🔧 PR: #5823, Label spells
🧙 Author: @0xRobin on 2024-05-10
📝 Summary: This model enables data analysts to calculate and track the number of transfers in and out, as well as the USD value transferred for different blockchain addresses. It combines data from token transfers with owner address information to provide insights into transaction volumes between counterparties. The model allows for analyzing transfer patterns, identifying active parties, and monitoring financial flows within a blockchain ecosystem.

MODEL: labels_transfer_summary.sql

🟢 Added by:

🔧 PR: #5823, Label spells
🧙 Author: @0xRobin on 2024-05-10
📝 Summary: This model creates a dataset that provides statistics on transfers involving blockchain addresses. It calculates the number of incoming and outgoing transfers, total USD amounts for both directions, as well as details such as the first and last transaction hashes and block times. The model enables data analysts to analyze transfer activities associated with specific addresses, including custody and account ownership information.

MODEL: labels_transfer_summary_daily.sql

🟢 Added by:

🔧 PR: #5823, Label spells
🧙 Author: @0xRobin on 2024-05-10
📝 Summary: This model creates a dataset that tracks the number of incoming and outgoing transfers, as well as the total USD value for each transfer, associated with specific blockchain addresses. It enables data analysts to analyze transaction activity by address, including custody and account ownership details. The model combines information from two separate datasets to provide a comprehensive view of transfer activities for these addresses.

MODEL: tokens_transfers.sql

🟢 Added by:

🔧 PR: #5823, Label spells
🧙 Author: @0xRobin on 2024-05-10
📝 Summary: This SQL model creates a union of tables for token transfers across various blockchain networks such as Ethereum, Polygon, Binance Smart Chain (BNB), Avalanche, and others. It enables data analysts to query and analyze token transfer data from multiple chains in a single consolidated view.

MODEL: eas_optimism_schemas.sql

🟠 Modified by:

🔧 PR: #5908, eas optimism: exclude troubled rows
🧙 Author: @jeff-dude on 2024-05-09
📝 Summary: Added a CTE named 'eas' that selects all columns from the 'eas_schemas' table with specific parameters. The query then filters out rows where the schema_uid is not in a list of specified values.

MODEL: nft_mints.sql

🟠 Modified by:

🔧 PR: #5836, Add is_creator_token to nft.trades, nft.mints
🧙 Author: @LB-thomasp on 2024-05-08
📝 Summary: A UNION ALL operation was added to combine the results of selecting all columns from two tables, project_mints and native_mints. The '-' sign indicates that there was a typo in the original model where 'FROM native_mints' was incorrectly marked for removal.

MODEL: opensea_v4_base_events.sql

🟠 Modified by:

🔧 PR: #5864, debug opensea_base
🧙 Author: @0xRobin on 2024-05-06
📝 Summary: Removed the tag 'prod_exclude' from the model.

🔧 PR: #5864, Quick seaport cleanup
🧙 Author: @0xRobin on 2024-05-03
📝 Summary: Added a tag 'prod_exclude' and changed the unique_key field in the dbt SQL model. Removed tags and some variables related to token addresses and symbols. Added a new variable for native currency contract address.

MODEL: opensea_solana_schema.yml

🟠 Modified by:

🔧 PR: #5864, Quick seaport cleanup
🧙 Author: @0xRobin on 2024-05-03
📝 Summary: [changes too large] The model opensea_solana_schema.yml was renamed.

MODEL: opensea_v3_arbitrum_events.sql

🟠 Modified by:

🔧 PR: #5864, Quick seaport cleanup
🧙 Author: @0xRobin on 2024-05-03
📝 Summary: Added incremental materialization with a merge strategy using Delta file format. Removed specific token addresses and symbols, while setting a start date for the model's logic. Two sources were defined within a common table expression (CTE) named 'fee_wallets'.

MODEL: opensea_v3_avalanche_c_events.sql

🟠 Modified by:

🔧 PR: #5864, Quick seaport cleanup
🧙 Author: @0xRobin on 2024-05-03
📝 Summary: Removed:

• Assignments for native_token_address, alternative_token_address, and native_token_symbol

MODEL: opensea_v3_ethereum_events.sql

🟠 Modified by:

🔧 PR: #5864, Quick seaport cleanup
🧙 Author: @0xRobin on 2024-05-03
📝 Summary: Removed:

• Definition of native_token_address, alternative_token_address, and native_token_symbol in the CTE

MODEL: opensea_v3_optimism_events.sql

🟠 Modified by:

🔧 PR: #5864, Quick seaport cleanup
🧙 Author: @0xRobin on 2024-05-03
📝 Summary: Removed the todo comment and some parameters related to token addresses and symbols. Added a parameter for native currency contract in the trades CTE.

MODEL: opensea_v3_polygon_events.sql

🟠 Modified by:

🔧 PR: #5864, Quick seaport cleanup
🧙 Author: @0xRobin on 2024-05-03
📝 Summary: Removed the definition of native_token_address, alternative_token_address, and native_token_symbol. Added a new variable called native_currency_contract with a specific address value.

MODEL: opensea_v4_arbitrum_events.sql

🟠 Modified by:

🔧 PR: #5864, Quick seaport cleanup
🧙 Author: @0xRobin on 2024-05-03
📝 Summary: In the SQL model, the lines specifying specific token addresses and symbols were removed. The logic for defining fee wallets from two different sources remains unchanged. Additionally, a start date parameter was added with a value of '2023-02-01'.

MODEL: opensea_v4_avalanche_c_events.sql

🟠 Modified by:

🔧 PR: #5864, Quick seaport cleanup
🧙 Author: @0xRobin on 2024-05-03
📝 Summary: In the SQL model, a native_currency_contract variable was added with a specific contract address value. Additionally, some variables related to token addresses and symbols were removed from the model. The start_date variable remains unchanged in this diff.

MODEL: opensea_v4_ethereum_events.sql

🟠 Modified by:

🔧 PR: #5864, Quick seaport cleanup
🧙 Author: @0xRobin on 2024-05-03
📝 Summary: In the SQL model, a CTE named fee_wallets was defined with sources from two tables. The lines setting values for native_token_address, alternative_token_address, and native_token_symbol were removed. A new line defining the variable start_date with a value of '2023-02-01' was added to the CTE.

MODEL: opensea_v4_optimism_events.sql

🟠 Modified by:

🔧 PR: #5864, Quick seaport cleanup
🧙 Author: @0xRobin on 2024-05-03
📝 Summary: Removed the definition of native token address, alternative token address, and native token symbol. Added a new definition for native currency contract with its corresponding value.

MODEL: opensea_v4_polygon_events.sql

🟠 Modified by:

🔧 PR: #5864, Quick seaport cleanup
🧙 Author: @0xRobin on 2024-05-03
📝 Summary: In this change, the model was updated to include a new variable native_currency_contract with its corresponding value. Additionally, some variables (native_token_address, alternative_token_address, and native_token_symbol) were removed from the model. The logic for selecting transactions based on certain criteria remains unchanged.

MODEL: opensea_v4_zora_events.sql

🟠 Modified by:

🔧 PR: #5864, Quick seaport cleanup
🧙 Author: @0xRobin on 2024-05-03
📝 Summary: Removed the definition of native and alternative token addresses, as well as the native token symbol from a common table expression.

MODEL: opensea_zora_schema.yml

🟠 Modified by:

🔧 PR: #5864, Quick seaport cleanup
🧙 Author: @0xRobin on 2024-05-03
📝 Summary: [changes too large] The model opensea_zora_schema.yml was renamed.

SECTOR: oneinch

toggle to see all model updates

MODEL: oneinch_arbitrum_ar.sql

🟠 Modified by:

🔧 PR: #5902, 1inch AR dup hotfix
🧙 Author: @grkhr on 2024-05-09
📝 Summary: The changes involve removing a common table expression (CTE) named 'ar' and replacing it with the same CTE defined in a dbt macro called 'oneinch_ar_macro'. The condition for filtering out specific rows based on the value of 'tx_hash' has been removed.

🔧 PR: #5902, 1inch arbitrum AR: exclude troubled tx
🧙 Author: @jeff-dude on 2024-05-09
📝 Summary: A Common Table Expression (CTE) named 'ar' was added, which uses a macro called 'oneinch_ar_macro'. The CTE is then selected from and filtered to exclude rows where the tx_hash is equal to a specific value.

SECTOR: limitbreak

toggle to see all model updates

MODEL: limitbreak_arbitrum_creator_tokens.sql

🟢 Added by:

🔧 PR: #5836, Add is_creator_token to nft.trades, nft.mints
🧙 Author: @LB-thomasp on 2024-05-08
📝 Summary: This model creates a table that enables data analysts to inspect contracts on the Arbitrum blockchain using creator tokens.

MODEL: limitbreak_avalanche_c_creator_tokens.sql

🟢 Added by:

🔧 PR: #5836, Add is_creator_token to nft.trades, nft.mints
🧙 Author: @LB-thomasp on 2024-05-08
📝 Summary: This dbt SQL model creates a table that enables data analysts to inspect contracts related to creator tokens on the Avalanche C blockchain.

MODEL: limitbreak_base_creator_tokens.sql

🟢 Added by:

🔧 PR: #5836, Add is_creator_token to nft.trades, nft.mints
🧙 Author: @LB-thomasp on 2024-05-08
📝 Summary: This dbt SQL model creates and enables data analysts to inspect contracts related to creator tokens on the base blockchain.

MODEL: limitbreak_bnb_creator_tokens.sql

🟢 Added by:

🔧 PR: #5836, Add is_creator_token to nft.trades, nft.mints
🧙 Author: @LB-thomasp on 2024-05-08
📝 Summary: This SQL model creates a table that enables data analysts to inspect contracts related to creator tokens on the Binance Smart Chain (bnb). It likely provides insights into token creation activities and contract details for analysis.

MODEL: limitbreak_ethereum_creator_tokens.sql

🟢 Added by:

🔧 PR: #5836, Add is_creator_token to nft.trades, nft.mints
🧙 Author: @LB-thomasp on 2024-05-08
📝 Summary: This dbt SQL model creates a table that enables data analysts to inspect contracts related to creator tokens on the Ethereum blockchain.

MODEL: limitbreak_optimism_creator_tokens.sql

🟢 Added by:

🔧 PR: #5836, Add is_creator_token to nft.trades, nft.mints
🧙 Author: @LB-thomasp on 2024-05-08
📝 Summary: This dbt SQL model creates a table that allows data analysts to inspect contracts related to creator tokens on the Optimism blockchain. It enables analysts to analyze and understand the details of these contracts for further insights and reporting purposes.

MODEL: limitbreak_polygon_creator_tokens.sql

🟢 Added by:

🔧 PR: #5836, Add is_creator_token to nft.trades, nft.mints
🧙 Author: @LB-thomasp on 2024-05-08
📝 Summary: This dbt SQL model creates and enables data analysts to inspect contracts related to creator tokens on the Polygon blockchain.

MODEL: limitbreak_creator_tokens.sql

🟢 Added by:

🔧 PR: #5836, Add is_creator_token to nft.trades, nft.mints
🧙 Author: @LB-thomasp on 2024-05-08
📝 Summary: This model creates a union of creator tokens from multiple blockchain sources. It enables data analysts to access and analyze information such as blockchain, token type, creation time, address, and other relevant details for creator tokens across different chains in one consolidated view.

SECTOR: balancer

toggle to see all model updates

MODEL: balancer_arbitrum_trades.sql

🟠 Modified by:

🔧 PR: #5886, add pool_type and pool_symbol to balancer.trades models
🧙 Author: @viniabussafi on 2024-05-06
📝 Summary: Added columns pool_symbol and pool_type to the SQL model.

MODEL: balancer_v2_arbitrum_trades.sql

🟠 Modified by:

🔧 PR: #5886, add pool_type and pool_symbol to balancer.trades models
🧙 Author: @viniabussafi on 2024-05-06
📝 Summary: Added columns pool_symbol and pool_type were included in the CTEs and SELECT statement. A JOIN condition was added to connect the two tables based on a specific column match.

MODEL: balancer_avalanche_c_trades.sql

🟠 Modified by:

🔧 PR: #5886, add pool_type and pool_symbol to balancer.trades models
🧙 Author: @viniabussafi on 2024-05-06
📝 Summary: Added columns for pool_symbol and pool_type to the SQL model.

MODEL: balancer_v2_avalanche_c_trades.sql

🟠 Modified by:

🔧 PR: #5886, add pool_type and pool_symbol to balancer.trades models
🧙 Author: @viniabussafi on 2024-05-06
📝 Summary: Added columns pool_symbol and pool_type were added to the SQL model in a merged pull request. These columns were included in the CTEs for both 'balancer_v2_avalanche_c_base_trades' and 'dex_trades'. Additionally, these new columns were selected in the final SELECT statement along with other existing columns.

MODEL: balancer_trades.sql

🟠 Modified by:

🔧 PR: #5886, add pool_type and pool_symbol to balancer.trades models
🧙 Author: @viniabussafi on 2024-05-06
📝 Summary: Added columns for pool_symbol and pool_type to the SQL model.

MODEL: balancer_base_trades.sql

🟠 Modified by:

🔧 PR: #5886, add pool_type and pool_symbol to balancer.trades models
🧙 Author: @viniabussafi on 2024-05-06
📝 Summary: Added columns pool_symbol and pool_type to the SQL model.

MODEL: balancer_v2_base_trades.sql

🟠 Modified by:

🔧 PR: #5886, add pool_type and pool_symbol to balancer.trades models
🧙 Author: @viniabussafi on 2024-05-06
📝 Summary: Added columns pool_symbol and pool_type to the SQL model, extracted from two different sources. Joined tables based on specific conditions and included these new columns in the final SELECT statement.

MODEL: balancer_ethereum_trades.sql

🟠 Modified by:

🔧 PR: #5886, add pool_type and pool_symbol to balancer.trades models
🧙 Author: @viniabussafi on 2024-05-06
📝 Summary: Added columns for pool_symbol and pool_type to the SQL model.

MODEL: balancer_v1_ethereum_trades.sql

🟠 Modified by:

🔧 PR: #5886, add pool_type and pool_symbol to balancer.trades models
🧙 Author: @viniabussafi on 2024-05-06
📝 Summary: A new CTE pool_labels was added to select address and name from a reference table. The column l.name AS pool_symbol was added to the existing CTE v1. A LEFT JOIN with the newly created CTE on matching addresses was also included in the logic. Additionally, pool_symbol and 'v1' AS pool_type were added to the final SELECT statement.

MODEL: balancer_v2_ethereum_trades.sql

🟠 Modified by:

🔧 PR: #5886, add pool_type and pool_symbol to balancer.trades models
🧙 Author: @viniabussafi on 2024-05-06
📝 Summary: Added columns pool_symbol and pool_type were included in the SELECT statement for both CTEs. These columns were also added to the base tables being referenced in each CTE.

MODEL: balancer_gnosis_trades.sql

🟠 Modified by:

🔧 PR: #5886, add pool_type and pool_symbol to balancer.trades models
🧙 Author: @viniabussafi on 2024-05-06
📝 Summary: Added columns for pool_symbol and pool_type to the SQL model.

MODEL: balancer_v2_gnosis_trades.sql

🟠 Modified by:

🔧 PR: #5886, add pool_type and pool_symbol to balancer.trades models
🧙 Author: @viniabussafi on 2024-05-06
📝 Summary: Added columns pool_symbol and pool_type were included in the SELECT statement for both CTEs. These columns were also added to the base tables of each CTE (balancer_v2_gnosis_base_trades and dex_trades) to be used in joining operations.

MODEL: balancer_optimism_trades.sql

🟠 Modified by:

🔧 PR: #5886, add pool_type and pool_symbol to balancer.trades models
🧙 Author: @viniabussafi on 2024-05-06
📝 Summary: Added columns pool_symbol and pool_type to the SQL model.

MODEL: balancer_v2_optimism_trades.sql

🟠 Modified by:

🔧 PR: #5886, add pool_type and pool_symbol to balancer.trades models
🧙 Author: @viniabussafi on 2024-05-06
📝 Summary: Added columns pool_symbol and pool_type were included in the SELECT statement and also added to the CTEs txs_base and dexs_base. These columns were then joined with other tables based on specific conditions.

MODEL: balancer_polygon_trades.sql

🟠 Modified by:

🔧 PR: #5886, add pool_type and pool_symbol to balancer.trades models
🧙 Author: @viniabussafi on 2024-05-06
📝 Summary: Added columns pool_symbol and pool_type to the SQL model.

MODEL: balancer_v2_polygon_trades.sql

🟠 Modified by:

🔧 PR: #5886, add pool_type and pool_symbol to balancer.trades models
🧙 Author: @viniabussafi on 2024-05-06
📝 Summary: Added columns pool_symbol and pool_type to the CTEs and SELECT statement. Joined on these new columns in the second CTE.

MODEL: balancer_v2_zkevm_trades.sql

🟠 Modified by:

🔧 PR: #5886, add pool_type and pool_symbol to balancer.trades models
🧙 Author: @viniabussafi on 2024-05-06
📝 Summary: Added columns pool_symbol and pool_type were included in the SELECT statements for both CTEs. Additionally, a column block_number was added to the first SELECT statement. The JOIN condition between tables was also modified to include these new columns in the ON clause.

MODEL: balancer_zkevm_trades.sql

🟠 Modified by:

🔧 PR: #5886, add pool_type and pool_symbol to balancer.trades models
🧙 Author: @viniabussafi on 2024-05-06
📝 Summary: Added columns for pool_symbol and pool_type to the SQL model.

MODEL: balancer_token_whitelist.sql

🟠 Modified by:

🔧 PR: #5888, Update balancer_token_whitelist
🧙 Author: @viniabussafi on 2024-05-06
📝 Summary: Added whitelist tokens for different networks and currencies: USDC, WSTETH on arbitrum network; WSTETH on arbitrum network; USDC on base network.

SECTOR: rollup_economics

toggle to see all model updates

MODEL: l1_data_fees.sql

🟠 Modified by:

🔧 PR: #5892, Update Rollup Economics for linea, scroll and polygon
🧙 Author: @Jam516 on 2024-05-07
📝 Summary: Added two new hexadecimal values to the filter condition for bytearray_substring(t.data, 1, 4) in the tx_batch_appends CTE. The first value is related to 'sequenceBatches' and the second one is related to 'submitBlobData'. Both additions are part of different conditions based on specific block times.

MODEL: l1_verification_fees.sql

🟠 Modified by:

🔧 PR: #5874, Update Rollup Economics for linea, scroll and polygon
🧙 Author: @Jam516 on 2024-05-07
📝 Summary: Added logic to filter transactions based on specific criteria including data substring and block time. Also added a new query using UNION ALL to select data from two different sources, calculating gas spent and USD value, with additional conditions for filtering.

🔧 PR: #5874, Add fields in rollup_economics
🧙 Author: @roylou on 2024-05-03
📝 Summary: Added columns gas_spent_usd, gas_used, and calldata_gas_used were included in the SELECT statement from the verify_txns table.

SECTOR: opensea

toggle to see all model updates

MODEL: opensea_ethereum_seaport_trades_samples.csv

🟠 Modified by:

🔧 PR: #5855, debug opensea_base
🧙 Author: @0xRobin on 2024-05-06
📝 Summary: [changes too large] The model opensea_ethereum_seaport_trades_samples.csv was modified.

MODEL: opensea_arbitrum_schema.yml

🟠 Modified by:

🔧 PR: #5864, Quick seaport cleanup
🧙 Author: @0xRobin on 2024-05-03
📝 Summary: [changes too large] The model opensea_arbitrum_schema.yml was removed.

MODEL: opensea_ethereum_schema.yml

🟠 Modified by:

🔧 PR: #5864, Quick seaport cleanup
🧙 Author: @0xRobin on 2024-05-03
📝 Summary: [changes too large] The model opensea_ethereum_schema.yml was removed.

MODEL: opensea_polygon_schema.yml

🟠 Modified by:

🔧 PR: #5864, Quick seaport cleanup
🧙 Author: @0xRobin on 2024-05-03
📝 Summary: [changes too large] The model opensea_polygon_schema.yml was removed.

SECTOR: orca_whirlpool

toggle to see all model updates

MODEL: orca_whirlpool_token_prices_hour.sql

🟢 Added by:

🔧 PR: #5884, Add orca price in hour
🧙 Author: @thanhlmm on 2024-05-06
📝 Summary: This model creates a dataset that calculates the average price of tokens bought and sold on the Solana blockchain per hour. It enables data analysts to analyze token trading patterns, including contract addresses, symbols, decimals, and block months. The model combines data from different sources to provide insights into token prices for further analysis and reporting.

MODEL: orca_whirlpool_token_prices.sql

🟢 Added by:

🔧 PR: #5863, Add solana orca price
🧙 Author: @thanhlmm on 2024-05-03
📝 Summary: This model creates a dataset that calculates the average price of tokens bought and sold on the Solana blockchain. It enables data analysts to analyze token prices at minute intervals, including details such as contract addresses, symbols, decimals, and block months. The model combines data from different sources to provide a comprehensive view of token trading activities on Solana for further analysis and insights.

SECTOR: camelot

toggle to see all model updates

MODEL: camelot_arbitrum_pair_fee_rates.sql

🟢 Added by:

🔧 PR: #5846, feat: add camelot pair fee rates spellbook
🧙 Author: @whalehunting on 2024-05-03
📝 Summary: This model creates a dataset that tracks fee rates for token pairs on the Arbitrum blockchain. It combines initial fee rates with updates over time, allowing data analysts to analyze and monitor changes in fees for trading pairs. The model also includes metadata such as version, tokens involved, and timestamps of trades or fee rate updates.