📰 2023-10-13: Weekly Prophet! #4597
andrewhong5297
announced in
Prophet (Weekly Updates)
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
This is your weekly summary of 12 PRs merged from 10 wizards. Great job everyone! 🎉
We had 8 added models 🟢 and 48 modified models 🟠 for 10 Sectors.
SECTOR: dex
toggle to see all model updates
MODEL: dex_trades.sql
🟠 Modified by:
🔧 PR: #4555, add openxswap trades
🧙 Author: @ARDev097 on 2023-10-10
📝 Summary: The reference models that were added or removed in the diff are:
openxswap_optimism_trades
SECTOR: tokens
toggle to see all model updates
MODEL: tokens_ethereum_erc20.sql
🟠 Modified by:
🔧 PR: #4563, Revert 'revert token additions which are giving prod trouble (#4576)'
🧙 Author: @jeff-dude on 2023-10-11
📝 Summary: [changes too large] The model tokens_ethereum_erc20.sql was modified.
🔧 PR: #4563, revert token additions which are giving prod trouble
🧙 Author: @jeff-dude on 2023-10-10
📝 Summary: [changes too large] The model tokens_ethereum_erc20.sql was modified.
🔧 PR: #4563, [Easy] Add more missing erc20 tokens
🧙 Author: @harisang on 2023-10-10
📝 Summary: [changes too large] The model tokens_ethereum_erc20.sql was modified.
MODEL: tokens_polygon_erc20.sql
🟠 Modified by:
🔧 PR: #4560, Revert 'revert token additions which are giving prod trouble (#4576)'
🧙 Author: @jeff-dude on 2023-10-11
📝 Summary: The added token symbols are 'TRS', 'SHIBA', 'tigUSD', and 'DEV'.
🔧 PR: #4560, revert token additions which are giving prod trouble
🧙 Author: @jeff-dude on 2023-10-10
📝 Summary: The token symbols that were removed from the SQL model are: DEV
🔧 PR: #4560, [Update tokens_polygon_erc20.sql]: Add missing token
🧙 Author: @KukretiShubham on 2023-10-10
📝 Summary: The added token symbols are 'TRS', 'SHIBA', 'tigUSD', and 'DEV'.
SECTOR: prices
toggle to see all model updates
MODEL: prices_ethereum_tokens.sql
🟠 Modified by:
🔧 PR: #4534, prices_ethereum_tokens.sql: Add Worldcoin
🧙 Author: @0xWillRock on 2023-10-10
📝 Summary: The token symbols that were added or removed are: PEPE, WLD
SECTOR: solana_utils
toggle to see all model updates
MODEL: solana_utils_daily_balances.sql
🟠 Modified by:
🔧 PR: #4584, Solana balances fix again
🧙 Author: @andrewhong5297 on 2023-10-13
📝 Summary: The main logic added in this SQL model is to calculate the updated balances for token accounts. It selects distinct addresses from the 'account_activity' table where transactions were successful and token mint address is not null. Then, it calculates the sol balance and token balance for each address by joining with another table called 'solana_utils_token_accounts'. The result includes the day, month, address, sol_balance, token_mint_address, token_balance_owner columns along with an updated_at timestamp. Only the latest balances are selected based on a row number partitioned by address and date_trunc('day', block_time).
MODEL: solana_utils_token_accounts.sql
🟠 Modified by:
🔧 PR: #4584, Solana balances fix again
🧙 Author: @andrewhong5297 on 2023-10-13
📝 Summary: In this SQL model, the logic that was added includes selecting the
token_balance_ownerandaddresscolumns from theaccount_activitytable. The query also groups the results bytoken_mint_address,token_balance_owner, andaddress. Additionally, a new column called 'created_at' is created using the maximum value of 'block_time'. The logic that was removed includes an optional filter based on a date range for incremental updates. Finally, instead of including a column with current timestamp as 'updated_at', only selected columns are returned in the final result set.SECTOR: trader_joe
toggle to see all model updates
MODEL: trader_joe_arbitrum_trades.sql
🟢 Added by:
🔧 PR: #4433, Add Trader Joe on Arbitrum to dex.trades
🧙 Author: @pecio222 on 2023-10-10
📝 Summary: This SQL model combines data from two different Trader Joe versions and creates a unified table with information about trades. It includes details such as blockchain, project, version, block date and time, token symbols for bought and sold tokens, amounts in various formats (raw and USD), addresses of the tokens involved, taker/maker information, contract address of the project involved in the trade transaction hash details. This model enables data analysts to analyze trading activity across multiple versions of Trader Joe.
MODEL: trader_joe_arbitrum_trades_legacy.sql
🟢 Added by:
🔧 PR: #4433, Add Trader Joe on Arbitrum to dex.trades
🧙 Author: @pecio222 on 2023-10-10
📝 Summary: This SQL model creates a dummy table with a single column that contains the value 1. It is likely used as a placeholder or temporary table for testing purposes and will be removed in the near future.
MODEL: trader_joe_v2_1_arbitrum_trades.sql
🟢 Added by:
🔧 PR: #4433, Add Trader Joe on Arbitrum to dex.trades
🧙 Author: @pecio222 on 2023-10-10
📝 Summary: This SQL model creates a view that retrieves data from the 'trader_joe_v2_1_arbitrum' database and joins it with other tables to calculate various metrics related to token swaps. It includes information such as blockchain, project version, block date, token symbols, amounts of tokens bought and sold, USD value of the transaction, addresses involved in the swap, transaction details like hash and index. The model also allows for incremental updates based on specified time intervals.
MODEL: trader_joe_v2_1_arbitrum_trades_legacy.sql
🟢 Added by:
🔧 PR: #4433, Add Trader Joe on Arbitrum to dex.trades
🧙 Author: @pecio222 on 2023-10-10
📝 Summary: This SQL model creates a dummy table with a single column that contains the value 1. It is likely used as a placeholder or temporary table for testing purposes and will be removed in the near future.
MODEL: trader_joe_v2_arbitrum_trades.sql
🟢 Added by:
🔧 PR: #4433, Add Trader Joe on Arbitrum to dex.trades
🧙 Author: @pecio222 on 2023-10-10
📝 Summary: This SQL model creates a view that combines data from multiple sources to analyze trading activity on the Trader Joe project in the Arbitrum blockchain. It includes information such as block dates, token symbols, amounts bought and sold, USD values, addresses involved in transactions, and more. The model enables data analysts to easily query and analyze trading data for the Trader Joe project on Arbitrum.
MODEL: trader_joe_v2_arbitrum_trades_legacy.sql
🟢 Added by:
🔧 PR: #4433, Add Trader Joe on Arbitrum to dex.trades
🧙 Author: @pecio222 on 2023-10-10
📝 Summary: This SQL model creates a dummy table with a single column that contains the value 1. It is likely used as a placeholder or temporary table for testing purposes and will be removed in the near future.
MODEL: trader_joe_trades.sql
🟠 Modified by:
🔧 PR: #4433, Add Trader Joe on Arbitrum to dex.trades
🧙 Author: @pecio222 on 2023-10-10
📝 Summary: The diff shows that a new reference to the 'trader_joe_arbitrum_trades' model was added to the existing list of references in the 'trader_joe_models' variable.
SECTOR: airdrop
toggle to see all model updates
MODEL: airdrop_info.sql
🟢 Added by:
🔧 PR: #4464, Create
airdrop.info🧙 Author: @hildobby on 2023-10-10
📝 Summary: This SQL model creates a temporary table that includes information about various projects. The table includes columns for project name, eligible addresses, circulating supply on drop, maximum supply, total amount airdropped, token issued by protocol flag, x_username (presumably related to the project), and start/end dates for the airdrop. This model enables data analysts to query and analyze this information for further analysis or reporting purposes.
SECTOR: evms
toggle to see all model updates
MODEL: evms_blocks.sql
🟠 Modified by:
🔧 PR: #4517, Add Goerli to
evmstables🧙 Author: @hildobby on 2023-10-10
📝 Summary: In this SQL model, a new source called 'goerli' is added to the list of sources. The existing sources are 'arbitrum', 'celo', and 'base'. The SELECT statement remains unchanged.
MODEL: evms_blocks_legacy.sql
🟠 Modified by:
🔧 PR: #4517, Add Goerli to
evmstables🧙 Author: @hildobby on 2023-10-10
📝 Summary: In this SQL model, a new source called 'goerli' is added to the list of sources. This source is used to retrieve data from the 'blocks' table in the 'goerli' database. The SELECT statement remains unchanged and selects all columns from the specified sources.
MODEL: evms_contracts.sql
🟠 Modified by:
🔧 PR: #4517, Add Goerli to
evmstables🧙 Author: @hildobby on 2023-10-10
📝 Summary: In this diff, a new source named 'goerli' is added to the SQL model. This source is used to fetch data from the 'contracts' table in the 'goerli' database. The rest of the code remains unchanged.
MODEL: evms_contracts_legacy.sql
🟠 Modified by:
🔧 PR: #4517, Add Goerli to
evmstables🧙 Author: @hildobby on 2023-10-10
📝 Summary: In this diff, a new source called 'goerli' is added to the list of sources in the SQL model.
MODEL: evms_creation_traces.sql
🟠 Modified by:
🔧 PR: #4517, Add Goerli to
evmstables🧙 Author: @hildobby on 2023-10-10
📝 Summary: In this diff, a new source called 'goerli' with the table name 'creation_traces' is added to the SQL model. The existing sources are 'arbitrum', 'celo', and 'base'. The SELECT statement remains unchanged.
MODEL: evms_creation_traces_legacy.sql
🟠 Modified by:
🔧 PR: #4517, Add Goerli to
evmstables🧙 Author: @hildobby on 2023-10-10
📝 Summary: In this diff, a new source ('goerli') is added to the SQL model. This source is used to retrieve data from the 'creation_traces' table in the 'goerli' database.
MODEL: evms_erc1155_approvalsforall.sql
🟠 Modified by:
🔧 PR: #4517, Add Goerli to
evmstables🧙 Author: @hildobby on 2023-10-10
📝 Summary: In this SQL model, a new source called 'erc1155_goerli' with the event 'evt_ApprovalForAll' has been added. This source is being selected along with three other existing sources ('erc1155_arbitrum', 'erc1155_celo', and 'erc1155_base').
MODEL: evms_erc1155_approvalsforall_legacy.sql
🟠 Modified by:
🔧 PR: #4517, Add Goerli to
evmstables🧙 Author: @hildobby on 2023-10-10
📝 Summary: In this diff, a new source called 'goerli' with the event 'evt_ApprovalForAll' is added to the SQL model.
MODEL: evms_erc1155_transfersbatch.sql
🟠 Modified by:
🔧 PR: #4517, Add Goerli to
evmstables🧙 Author: @hildobby on 2023-10-10
📝 Summary: In this diff, a new source called 'goerli' is added to the SQL model. This source is used to retrieve data from the 'erc1155_goerli' table using the event type 'evt_transferbatch'. The rest of the code remains unchanged.
MODEL: evms_erc1155_transfersbatch_legacy.sql
🟠 Modified by:
🔧 PR: #4517, Add Goerli to
evmstables🧙 Author: @hildobby on 2023-10-10
📝 Summary: In this diff, a new source called 'goerli' is added to the SQL model. This source is used to retrieve data from the 'erc1155_goerli' table using the 'evt_transferbatch' event. The rest of the code remains unchanged.
MODEL: evms_erc1155_transferssingle.sql
🟠 Modified by:
🔧 PR: #4517, Add Goerli to
evmstables🧙 Author: @hildobby on 2023-10-10
📝 Summary: In this diff, a new source called 'goerli' is added to the SQL model. This source is used to retrieve data from the 'erc1155_goerli' table using the event type 'evt_transfersingle'. The rest of the code remains unchanged.
MODEL: evms_erc1155_transferssingle_legacy.sql
🟠 Modified by:
🔧 PR: #4517, Add Goerli to
evmstables🧙 Author: @hildobby on 2023-10-10
📝 Summary: In this diff, a new source called 'goerli' is added to the SQL model. This source is used to retrieve data from the 'erc1155_goerli' table using the event type 'evt_transfersingle'. The rest of the code remains unchanged.
MODEL: evms_erc20_approvals.sql
🟠 Modified by:
🔧 PR: #4517, Add Goerli to
evmstables🧙 Author: @hildobby on 2023-10-10
📝 Summary: In the given diff, a new source named 'goerli' with event type 'evt_approval' is added to the SQL model.
MODEL: evms_erc20_approvals_legacy.sql
🟠 Modified by:
🔧 PR: #4517, Add Goerli to
evmstables🧙 Author: @hildobby on 2023-10-10
📝 Summary: In this diff, a new source called 'goerli' with the event 'evt_approval' from the table 'erc20_goerli' is added to the existing list of sources ('optimism', 'arbitrum', and 'celo'). The SELECT statement remains unchanged.
MODEL: evms_erc20_transfers.sql
🟠 Modified by:
🔧 PR: #4517, Add Goerli to
evmstables🧙 Author: @hildobby on 2023-10-10
📝 Summary: In this diff, a new source called 'goerli' is added to the SQL model. This source is used to retrieve data from the 'erc20_goerli' table using the event type 'evt_transfer'.
MODEL: evms_erc20_transfers_legacy.sql
🟠 Modified by:
🔧 PR: #4517, Add Goerli to
evmstables🧙 Author: @hildobby on 2023-10-10
📝 Summary: In this diff, a new source called 'goerli' with the event type 'evt_transfer' is added to the SQL model. This means that data from the 'erc20_goerli' table will be included in the final result of this query along with data from other sources like 'optimism', 'arbitrum', and 'celo'.
MODEL: evms_erc721_approvals.sql
🟠 Modified by:
🔧 PR: #4517, Add Goerli to
evmstables🧙 Author: @hildobby on 2023-10-10
📝 Summary: In this diff, a new source called 'erc721_goerli' with the event 'evt_Approval' is added to the existing list of sources. The SELECT statement remains unchanged.
MODEL: evms_erc721_approvals_legacy.sql
🟠 Modified by:
🔧 PR: #4517, Add Goerli to
evmstables🧙 Author: @hildobby on 2023-10-10
📝 Summary: In this diff, a new source called 'erc721_goerli' with the event 'evt_Approval' is added to the existing list of sources. The SELECT statement remains unchanged.
MODEL: evms_erc721_approvalsforall.sql
🟠 Modified by:
🔧 PR: #4517, Add Goerli to
evmstables🧙 Author: @hildobby on 2023-10-10
📝 Summary: In this diff, a new source called 'erc721_goerli' with the event 'evt_ApprovalForAll' was added to the SQL model. This source is now included in the SELECT statement along with other existing sources.
MODEL: evms_erc721_approvalsforall_legacy.sql
🟠 Modified by:
🔧 PR: #4517, Add Goerli to
evmstables🧙 Author: @hildobby on 2023-10-10
📝 Summary: In this diff, a new source called 'goerli' with the event 'evt_ApprovalForAll' has been added to the SQL model.
MODEL: evms_erc721_transfers.sql
🟠 Modified by:
🔧 PR: #4517, Add Goerli to
evmstables🧙 Author: @hildobby on 2023-10-10
📝 Summary: In this diff, a new source called 'goerli' with the event type 'evt_transfer' is added to the SQL model.
MODEL: evms_erc721_transfers_legacy.sql
🟠 Modified by:
🔧 PR: #4517, Add Goerli to
evmstables🧙 Author: @hildobby on 2023-10-10
📝 Summary: In this diff, a new source called 'goerli' with the event type 'evt_transfer' is added to the SQL model. This means that data from the 'erc721_goerli' table will be included in the final result of this query along with data from other sources like 'optimism', 'arbitrum', and 'celo'.
MODEL: evms_logs.sql
🟠 Modified by:
🔧 PR: #4517, Add Goerli to
evmstables🧙 Author: @hildobby on 2023-10-10
📝 Summary: In this SQL model, a new source called 'goerli' with the table name 'logs' has been added. This source is being selected along with three other existing sources ('arbitrum', 'celo', and 'base') using the wildcard '*' to select all columns from these sources.
MODEL: evms_logs_decoded.sql
🟠 Modified by:
🔧 PR: #4517, Add Goerli to
evmstables🧙 Author: @hildobby on 2023-10-10
📝 Summary: In this diff, a new source named 'goerli' with the table 'logs_decoded' is added to the SQL model.
MODEL: evms_logs_decoded_legacy.sql
🟠 Modified by:
🔧 PR: #4517, Add Goerli to
evmstables🧙 Author: @hildobby on 2023-10-10
📝 Summary: In this diff, a new source named 'goerli' with the table name 'logs_decoded' is added to the SQL model. The existing sources include 'optimism', 'arbitrum', and 'celo'. The SELECT statement remains unchanged.
MODEL: evms_logs_legacy.sql
🟠 Modified by:
🔧 PR: #4517, Add Goerli to
evmstables🧙 Author: @hildobby on 2023-10-10
📝 Summary: In this diff, a new source called 'goerli' is added to the SQL model. This source is being used in conjunction with other sources like 'optimism', 'arbitrum', and 'celo'. The SELECT statement remains unchanged.
MODEL: evms_traces.sql
🟠 Modified by:
🔧 PR: #4517, Add Goerli to
evmstables🧙 Author: @hildobby on 2023-10-10
📝 Summary: The line '+ , ('goerli', source('goerli', 'traces'))' was added to the SQL model. This indicates that a new data source named 'goerli' with a table named 'traces' was included in the SELECT statement.
MODEL: evms_traces_decoded.sql
🟠 Modified by:
🔧 PR: #4517, Add Goerli to
evmstables🧙 Author: @hildobby on 2023-10-10
📝 Summary: The line that starts with '+' indicates that a new source named 'goerli' has been added to the SQL model. This source is being used in the SELECT statement along with other existing sources ('arbitrum', 'celo', and 'base').
MODEL: evms_traces_decoded_legacy.sql
🟠 Modified by:
🔧 PR: #4517, Add Goerli to
evmstables🧙 Author: @hildobby on 2023-10-10
📝 Summary: In this diff, a new source named 'goerli' is added to the SQL model. This source is being used in the SELECT statement along with other existing sources like 'optimism', 'arbitrum', and 'celo'.
MODEL: evms_traces_legacy.sql
🟠 Modified by:
🔧 PR: #4517, Add Goerli to
evmstables🧙 Author: @hildobby on 2023-10-10
📝 Summary: In this diff, a new source called 'goerli' is added to the list of sources in the SQL model.
MODEL: evms_transactions.sql
🟠 Modified by:
🔧 PR: #4517, Add Goerli to
evmstables🧙 Author: @hildobby on 2023-10-10
📝 Summary: In this SQL model, a new source called 'goerli' is added to the list of sources for transactions. The existing sources are 'optimism', 'celo', and 'base'. The SELECT statement remains unchanged.
MODEL: evms_transactions_legacy.sql
🟠 Modified by:
🔧 PR: #4517, Add Goerli to
evmstables🧙 Author: @hildobby on 2023-10-10
📝 Summary: In this diff, a new source called 'goerli' is added to the list of sources in the SQL model.
SECTOR: opensea
toggle to see all model updates
MODEL: opensea_arbitrum_events.sql
🟠 Modified by:
🔧 PR: #4549, SPE-143 Opensea Views
🧙 Author: @couralex6 on 2023-10-10
📝 Summary: The main logic of what was added or removed in this SQL model is the removal of the 'block_date' column from both SELECT statements.
MODEL: opensea_ethereum_events.sql
🟠 Modified by:
🔧 PR: #4549, SPE-143 Opensea Views
🧙 Author: @couralex6 on 2023-10-10
📝 Summary: The logic added in this SQL model is the selection of columns 'blockchain', 'project', 'version', 'block_time', 'token_id' and 'collection' from a table. The lines with '-' indicate that the column named 'block_date' was removed from the selection.
MODEL: opensea_optimism_events.sql
🟠 Modified by:
🔧 PR: #4549, SPE-143 Opensea Views
🧙 Author: @couralex6 on 2023-10-10
📝 Summary: The main logic of what was added or removed in this SQL model is the removal of the 'block_date' column from both SELECT statements.
MODEL: opensea_polygon_events.sql
🟠 Modified by:
🔧 PR: #4549, SPE-143 Opensea Views
🧙 Author: @couralex6 on 2023-10-10
📝 Summary: The main logic of what was added or removed in this SQL model is the removal of the 'block_date' column from three SELECT statements. The rest of the columns remain unchanged.
SECTOR: openxswap
toggle to see all model updates
MODEL: openxswap_optimism_trades.sql
🟢 Added by:
🔧 PR: #4555, add openxswap trades
🧙 Author: @ARDev097 on 2023-10-10
📝 Summary: This SQL model creates a table that combines data from multiple sources to analyze swaps made on the OpenXSwap project on the Optimism blockchain. It includes information such as block time, token symbols, amounts bought and sold, USD value of the swap, addresses involved in the swap, transaction details, and more. The model enables data analysts to perform various analyses and calculations related to swaps on OpenXSwap.
SECTOR: contracts
toggle to see all model updates
MODEL: contracts_optimism_contract_creator_address_list.sql
🟠 Modified by:
🔧 PR: #4557, Add contract deployer addresses on Optimism
🧙 Author: @Chomtana on 2023-10-10
📝 Summary: In the given SQL model, several rows were added to the 'curated_list' CTE. Each row represents a contract project with its corresponding creator address. The new rows include projects such as Bored Town (Campaigns and Launchpad), Opti.domains, SCRY, Oppa Bear NFT, Tripster, ENS Wildcard Domains, OptiChads NFT, Aragon, dm3 Protocol and RedStone.
Beta Was this translation helpful? Give feedback.
All reactions