Maple Finance | KPI dashboard

    Maple is the only on-chain marketplace focused exclusively on serving Institutional and Individual Accredited Investors with high-quality lending opportunities which suit their liquidity, risk and return requirements.

    Introduction
    Maple Finance
    methodology
    db_img
    Solana

    Solana is a blockchain platform designed to host decentralized, scalable applications. Founded in 2017, it is an open-source project currently run by Solana Foundation based in Geneva, while the blockchain was built by San Francisco-based Solana Labs

    Solana is much faster in terms of the number of transactions it can process and has significantly lower transaction fees than rival blockchains like Ethereum. The cryptocurrency that runs on the Solana blockchain—also named Solana (SOLUSD) and using the ticker symbol SOL—soared almost 12,000% in 2021 and at one point had a market capitalization of over $66 billion, making it the fifth-largest cryptocurrency by this measure at the time.

    Despite its popularity, SOL did not escape the cryptocurrency bloodbath of 2022. By Oct. 3, 2022, SOL had dropped to about $11.71 billion in market capitalization. It also fell to ninth place in market capitalization.3 Learn more about Solana and what makes it unique among thousands of imitators.

    Data : investopedia

    db_img

    Maple Finance, an on-chain, institutional credit marketplace that’s aspiring to fill a gap left behind by the collapses of crypto lending heavyweights like BlockFi and Celsius, has its sights set on Asia as financial hubs like Hong Kong and Singapore provide more regulatory clarity around digital assets.

    Maple, which falls under the decentralized finance (DeFi) category, differs from centralized finance or CeFi platforms like BlockFi in that it allows lenders to see loan operations on the blockchain, promising to offer more transparency. Cumulatively, the three-year-old startup has issued $2.2 billion in loans, and currently it has around $50 million deposited on the platform.

    To fuel its expansion eastward, Maple recently closed a $5 million strategic investment from a group of crypto-focused investors. The round was led by BlockTower Capital and Tioga Capital, with participation from Cherry Ventures, Spartan Capital, GSR Ventures, and Veris Ventures, as well as past investors Maven 11 and Framework Ventures.

    Data : techcrunch

    db_img

    Used the solana.core.fact_events table and idenfitified to program_id as 5D9yi4BKrxF8h65NkVE1raCCWFKUs5ngub2ECxhvfaZe for Maple Finance and pulled data since its launch in April 2022. In addition, join the solana.core.fact_transfers table for looking at the amount of tokens transferred and also bring it to join the solana.core.fact_transactions table for finding the actions that are inside the log_messages of this as well.

    However, some transactions have a token address that is not uncategorized on Solana. So joined the solana.core.dim_tokens table to pull the true token and found that there is only one token, which is USDC.

    Also added a field named period for changing movement on charts to create this dashboard, which is comprised of month, week, and day.


    Shout out to h4wk and appreciate your work that taught me how to use Livequery.