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.

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.

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.

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.