Methodology;

MarginFi's program ID is 'MFv2hWf31Z9kbCa1snEPYctwafyhdvnV7FZnsebVacA'. The analysis uses four tables from the solana.core schema: fact_events, fact_transactions, fact_transfers, and dim_labels. These tables contain information about the transactions, events, transfers, and labels on the Solana blockchain. The analysis identifies the lending and borrowing operations by using the TX_TO and TX_FROM columns in the fact_transactions table. These columns indicate the sender and receiver of each transaction. The analysis filters the transactions by the date using the BLOCK_TIMESTAMP column in the same table. This column shows the timestamp of each transaction. The analysis uses the CURRENT_DATE and INTERVAL keywords to limit the time period to the past six months. The analysis also specifies the contract addresses for the lending and borrowing operations using the IN operator. These are: - 'DD3AeAssFvjqTvRTrRAtpfjkBF8FpVKnFuwnMLN9haXD' - '3uxNepDbmkDNq6JhRja5Z8QwbTrfmkKP8AKZV5chYDGG' - '6YxGd65JbXzgFGWjE44jsyVeCnZp7Bb1wfL9jDia1n8w' - '26kcZkdjJc94PdhqiLiEaGiLCYgAVVUfpDaZyK4cqih3'

MarginFi: Growth and Performance Metrics Dashboard